Jump to content
Sign in to follow this  
mikemccloskey

find new

Recommended Posts

Can someone help me out with a simple way to finding new records. I was using the "update" feature of importing records but is it intolerably slow. I want to find new records in one database and import them into an identical database. Thanks for your help. Mike

Share this post


Link to post
Share on other sites

There are probably a few ways. The thing that comes to mind is to create a relationship between the two files based on a unique identifer field (ie, whatever you previously used as the match field). Then search in the modified file for an empty related field (ie, the same match field again) that should normally contain some data. The records that are found should be the new ones.

Share this post


Link to post
Share on other sites

A low tech but effective way is to do the following:

Make two field that auto enter date and time created. Do a find on the set of records that are new since your last update (best to keep track of this in a simple log) and then import the found set into the identical database.

Of course, you can script all of this or even just most of this to make it easier.

I hope this helps,

Cael.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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