AnsweredAssumed Answered

How to import excel  data in this case?

Question asked by funfun167 on Apr 3, 2010
Latest reply on Apr 4, 2010 by pault

Title

How to import excel  data in this case?

Post

Suppose an excel file is created by my shopping cart every day, the file contains order details on that day.

 

The excel file contains 3 fields, namely

1: order number

2: first name

3: last name

 

I will upload the excel file every morning

When the file is imported to filemaker, it is expected to do the following:

1: if the order number in the excel files exists in one of the existing filemaker record, filemaker will UPDATE that record

2: if the order number in the excel files doesn’t exist in any filemaker record, a new record is CREATED

 

May I know how I can do this?

 

Thank you

 

 ---------------------------------------------------------------------

Right now, when I import the excel file by: File---Imports Records----File

The records in that excel file are imported into filemaker while the old records are deleted…..this is not what I want…


Outcomes