Import over network creates duplicates

[Satish]

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.

[IdealData]

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.

[LaRetta]

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:

[Charlih Chen]

Hello Satish:

Can you show me the script.

I am trying to have such script to dupicate one record from one fileName1.fm7 to the other fileName2.fm7

Thank you.