Jump to content

Advice using import, update existing


This topic is 2254 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 2254 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.