AnsweredAssumed Answered

Importing CSV with Pipe Delimiters

Question asked by ScarletteMoore on Apr 30, 2015
Latest reply on May 1, 2015 by philmodjunk

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?

Outcomes