AnsweredAssumed Answered

Trying to import contacts but avoid duplications.

Question asked by weedonpaul on Jul 18, 2012
Latest reply on Jul 18, 2012 by weedonpaul

Title

Trying to import contacts but avoid duplications.

Post

I have a excel list with 93 contacts.

the fields in the list are: First Name, Last name, JobTitle, Company, Phone number, Email

I would like to import this list into filemaker. However, some of these contacts I may have and I don't want to overwrite them as i may have notes against their name. I only want the contacts that I don't have already.

the list is from a trade show.

After I have all the names in the database I would like to add to each of their notes that they are at the trade show without overwritting any other information that may be in the notes. 

How can I do this, I have tried so many ways but always end up with duplications or replacing contacts that i had and losing their notes.

Many thanks

Paul.

PS using filemaker pro 11

Outcomes