AnsweredAssumed Answered

Update large amount of data from excel sheet

Question asked by user2147901 on Dec 2, 2018
Latest reply on Dec 4, 2018 by fmpdude

Hi I am new to filemaker. I am going to update database records using excel sheet. However I have to satisfy the rules before I update the records.

 

For example,

customer id of database(d) = customer id of excel sheet(e) and customer name(d) = customer name(e),

customer id of database(d) = customer id of excel sheet(e) and tel(d) = tel(e),

customer id of database(d) = customer id of excel sheet(e) and address(d) = address(e),

 

The problem is the data in database is the most updated and my client would like to update the fields that is empty in database.

 

Is there any approach to this issue?

 

I have an idea that importing excel records to temporary table and set variable of the items according to the rule and find records in the database table.

 

However, there are too many records in the excel files, I am wondering is there other good approach to this issue?

if I create a script to looping through all records, it may take at least a day or more to finish the process.

 

Note that I have to sort out the records that are not passing the rules list above.

Outcomes