9 Replies Latest reply on Mar 13, 2012 11:06 AM by weedonpaul

    Importing data without duplicating records

    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???