3 Replies Latest reply on May 1, 2015 11:20 AM by philmodjunk

    Importing CSV with Pipe Delimiters

    ScarletteMoore

      Title

      Importing CSV with Pipe Delimiters

      Post

      Hi,

      I'm trying to figure out how to make FMP 13 talk to my new Woocommerce website via csv.

      When a customer places an order I can log into the website and download the order via csv. The problem is that the order is formatted in a single row in the csv file, with the different items ordered in a single filed separated by a pipe. My FMP database has an invoice table linked to an item table (one to many) for each customer order. How do I extract the items ordered from the csv so that I can import them as separate item records for my invoice?