If you just need to import, why first insert it into a container? Why not just import to begin with?
I had (what I think) is a similar problem a couple years back. The URL of the CSV, in my case, did not provide direct access to the contents, just the ability to download the file, so the data couldn't be imported directly.
I set up an externally stored container field. This has the effect of uploading the file to a folder on the server. I could then do an import of the file as it was in a known place. IIRC, I had to use the additional database folder and container location option in Server.
I can't just import because the csv file is in webserver. I don't want to download and then import. I would like to import directly using the url.
Is this possible with shared filemaker server?
1 of 1 people found this helpful
How are you downloading the File?
If you use "Insert From URL()" and choose a Text field, or in FM16 a variable, as the destination you should get the content of the file. I have a system that does this. It depends on the source's Web Server setup if this works.
Then you can parse each line into the appropriate fields.
Insert from URL ["$my_data" ; $url]
set var ["$line_num" ; $line_num + 1]
set var ["$line_data" ; GetValue ( $my_data ; $line_num )
//either parse each value into a separate variable or use set fields to load each field directly from the $line_data variable.
Exit loop if [ IsEmpty ( $line_data ) ]