Hi I'm pretty new to FileMaker and am struggling to find the best way to do this. I have several tables that need updating via data from a csv/xls that gets exported from JIRA (what we use for our project management and sales tracking solution). It takes the form of the below:personquantityproductclientorder date
1 3 1 A 12/01/2017 1 12 3 A 17/01/2017 1 9 5 B 09/02/2017 2 15 3 A 03/03/2017
Each line in the csv represents an order
So if the next csv was listing a client C that doesn't exist in the client table, it would add a client C. Same behaviour for person and product.
Not sure how to de-duplicate the entries, or stop it creating a record if it matches an existing one.
You need to import the orders in the CSV first and then manipulate the data via a script after that.
Step 1) import the csv into the orders table then
Step 2) Loop through all the newly imported records and
- Use your own logic to delete duplicates
- Test if the client, person, or product already exists and if not then add that client, person or product to the relevant tables