Re-importing

[lrcarey]

Hi,

Is there a way to only import information if it is newer than information in the existing records?

The users of the database I'm making want to import a set of records from another office periodically - say every three months. They will be constantly be re-importing from the same set of records with whatever additions and updates have been entered since the last import. I understand how to create the match so existing records get updated, not reimported, but if the users of the new database have updated information, I don't want to reimport the old information. There is a modification date in each file, so I figure there must be some way to compare them, but I can't figure out how.

Also, I want to script the import so it doesn't have to get set up again each time, but I can only find instructions in the manual for importing scripts, not scripting imports! Any suggestions?

Thank you in advance,

Leah

[The Bridge]

The secret here is that FileMaker will only import the Found Set from the other database, so you will have to call a script in the file you're importing from to find only those records whose modification date is equal to or later than the last update, then import those records.