AnsweredAssumed Answered

eliminating duplicates on import (FM6)

Question asked by webguy262 on May 27, 2009
Latest reply on May 28, 2009 by LaRetta_1

Title

eliminating duplicates on import (FM6)

Post

We are getting duplicate records when importing from a MsSQL dbase, even though I have set the import to overwrite the record if three fields match.

 

We have a file of youth basketball players from around the country.  When we run tournaments, we get updated info in our website dbase from any players who play in the tournament.

 

We connect to the dbase and import the player records, setting FM to match FIRST NAME, LAST NAME and ZIP.  If these match, the record should be overwritten with the imported data.

 

But we are getting new records on some imports, even though the existing record and the import record have the same FIRST NAME, LAST NAME and ZIP.

 

Any suggestions? 

Outcomes