Jump to content

Import over network creates duplicates


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

Recommended Posts

  • Newbies

Hi,

I am importing records using a script from Contacts.fp5 to Contacts Clone.fp5 over the network based on the last modified time every hour. Duplication of records happens and the more than one record is created in Contacts Clone.fp5

for Eg., Record ID12345 update time 14:00:00

Record ID12345 update time 14:30:00

I have checked the Import Action as

Update matching records in current found set and Add remaining records.

I am not sure even then why is the duplication happening.

I would appreciate help.

Link to comment
Share on other sites

Bear in mind that your SOURCE file also has a current found set. If these records fall outside the match criteria then they will be added to the TARGET file.

Link to comment
Share on other sites

I'm unsure, but I think Mark means the TARGET file (called Destination in v5) but his point is valid regardless. Do you have a 'Show All Records' at the beginning of your script in the clone file? Because after an import, you clone will be left with a found set (and only the found set will be updated next time). So the clone should have all records showing. :wink2:

Link to comment
Share on other sites

  • 4 weeks later...

This topic is 6499 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.