asked on

FM - Tracking Changes from an Update Import

Thought I could easily track new records added via a Filemaker Import ("Update matching records in found set" and "add new records"). However, our tenants can not only add a record via our website, but they can delete one too. Thus, my script method of compariing the old vs. the new found record set will not work.

Am I going to have to export from the current to a a backup database first in the script and then compare records? Any in the old and not in the current have been deleted and any in the current and not in the old are new records. Is that the way you all would do it?

ASKER CERTIFIED SOLUTION

slinkygn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rvfowler2

ASKER

Currently (and most commonly), I am importing data from a tab delimited file. I looked once again and see no way that an import can recognize when a record does not exist in the source and so deletes the record. My current method is to first go to a backup table, delete all records, import all records from the current table, then go back to the current table, delete all records and import all records from the tab delimited file. I then compare the two tables to check for new or deleted records and flag them. How would you all do it? (If it wasn't for the deletions, I could simply do a matching records import and add new records, but I can't do it this way.)

rvfowler2

ASKER

Thanks, I like this solution for certain tables where lost info is really damaging. Thanks.