Advice using import, update existing

[fmsavey]

When importing using update existing and the source file has less records then the target file (error 727) what can I do to identify the records that did not get updated so that I can delete them.  I am updating only some of the records in my database.  I know I can delete the found set and then use "add new records" when importing but I am trying to update two hundred thousand records and it takes 10 times longer to delete the records then it does to import them.  My database has a couple of million records.  Filemaker shows me how may records were updated with import dialogue on but is that information accessible using a get() function?    If it were I could omit records for 1 to update# and delete the rest.

[rwoods]

Hi There, what about querying a field that holds the last modification in your target records? You could record a timestamp just before starting the import, do the import, and then find all records with a modification timestamp less than the timestamp you recorded at the beginning.

Then just delete that found set.

Does that work for you?

[fmsavey]

Thanks for the idea.  I will give that a try.

[fmsavey]

As our London office employees would say...brilliant, that worked rather well. 

Thanks again.