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?