Jump to content

Importing CSV from Google Drive


tylertul
 Share

This topic is 2781 days old. Please don't post here. Open a new topic instead.

Recommended Posts

FileMaker 11 and it doesn't have import from URL.   What works fine is file menu > import > past the url into field that asks for location of file > open button (or maybe it says import) 

it it will import the data from google drive into a table just fine. If you try and do the same through a url script step it complains about the url not being a valid location (or says something similar)

Link to comment
Share on other sites

It's not possible to import CSV files (or any other type of files, except XML) from outside of your network. What you describe is probably a result of something that happens between your OS and the Google Drive application. You could test this by using the same method to insert a file into a container field (as reference only) then see what the actual path to the file, as stored in the container field, is.

Link to comment
Share on other sites

Thanks LaRetta!  I just updated my profile as you suggested. 

Comment.  I think you just nailed it.  That makes sense.  I bet Windows 7 is doing it and storing the file that it retrieves in a temp folder them somehow Filemaker is being told that location by the OS and bam it imports.  Same thing is NOT happening as a scripted import.

Thanks for the suggestion.  Does someone have a link to a post or a suggestion for the simplest way to script an import from a web-based .CSV file into Filemaker? I imagine it is the same for and excel file as well.  I'll keep digging for sure.  Just thought I would ask in case someone could paste a link or something.  Really appreciate your help over the past 11 years when I have needed it!

Link to comment
Share on other sites

Does someone have a link to a post or a suggestion for the simplest way to script an import from a web-based .CSV file into Filemaker?!

​I just said it's not possible. What you can do is download the file, using a plugin or OS-level scripting (or, in version 12 or higher, the Insert From URL script step), then import the resulting local file. Alternatively, if you have any control over the web server, use XML.

Link to comment
Share on other sites

This topic is 2781 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.