find new

[mikemccloskey]

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

[BobWeaver]

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.

[CaelC]

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.