AnsweredAssumed Answered

Importing data without duplicating records

Question asked by weedonpaul on Mar 12, 2012
Latest reply on Mar 13, 2012 by weedonpaul

Title

Importing data without duplicating records

Post

Hi

I'm trying to inport some data from excel. some records already excist and some don't. I want to create new records for those that don't excist and append the ones that do.

I have:

1)gone to import records>files and selcted the excel spread sheet

2)matched the fields up that are to be added/appended

3)under import action i selected "update matching records in a found set

4)on field mapping i have matched records based on email address

5)pressed import

6)preformed auto enter was ticked

It then created all of the entries as new records. I know for a fact that quite a number of them are duplicates with the same email.

 

What am i doing wrong???

Outcomes