AnsweredAssumed Answered

Importing from CSV when a Container field contains a URL.

Question asked by PaulRosen on Feb 12, 2014
Latest reply on Feb 12, 2014 by PaulRosen

Title

Importing from CSV when a Container field contains a URL.

Post

     I have a CSV that I'd like to import into my existing database. Most fields work well, but one of the fields is a "Container" type field.

     In my CSV, that field points to a file on the internet, that is, the field contains a URL.

     When I import the CSV, I'd like the file that is pointed to to be imported into FMP, not the URL. Is there a way to do that?

     I don't mind writing a script if I have to.

     Here's a simple example of what the CSV might contain:

     -------------------

     Name,Email,Proposal

     John Doe,jdoe@aol.com,http://mysite.com/wp-content/uploads/2014/01/myproposal.pdf

     -------------------

      

     Thanks!

      

Outcomes