2 Replies Latest reply on Feb 12, 2014 10:59 AM by PaulRosen

    Importing from CSV when a Container field contains a URL.

    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!