AnsweredAssumed Answered

Importing from File with duplicates records

Question asked by tonymak on Jun 19, 2014
Latest reply on Jun 19, 2014 by tonymak

I have a question on importing from a csv file.

I have a dump from an appointment system that contains appointment records as well as the contact information (Name Address etc).

the file contains a record for each appointment (Type, Date, etc) so naturally this file contains multiple record for each contact, it also contains records for contacts that are not yet in a contacts Table. (I'm updating two tables from this appointment file)


I have no issues updating using the import routine into the appointment table as I'm checking against matched records for First, Last Name and appointment date and type, and updating those records and adding any new entries. Works fine.


My problem which I can't wrap my head around is I'm using this same csv file to then add into the contacts table any New Contacts. But no matter what i do The import routine creates a contact for each instance in the appointment csv resulting in duplicate entries now into the contact file, I am testing for matched records I thought.


When FileMaker does an import and if I'm testing for matches on Name, city, and what ever, does the import routine not check against newely imported records or only looks at the base found set (Show all records specified prior to import)


If filemaker doesn't look at the new records to match what would the suggestion be to import into my contact table a single record and not the duplicates because of the multi matching name, address etc records from the appointment csv file?