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

    Importing CSV with Pipe Delimiters



      Importing CSV with Pipe Delimiters



      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?