Customer Engagement & Dynamics CRM Forum

I am trying to import some data to update existing contacts but keep getting the error "A record was not created or updated because a duplicate of the current record already exists."

If i import with selecting allow duplicates it create new records any ideas on how i can get the record to update. 

------------------------------
Ravi Mistry
Countryside Alliance
London
------------------------------

It sounds like you are trying to update a contact that has a dupe (defined as two or more contacts with the same email address).
Try this - create a chart in contacts as below.
Any contact that returns more than one is a duplicate, and you need to either eliminate the dupes or remove them from your import.



------------------------------
Donal McCarthy
BrightWork 365 Solution Architect
BrightWork
Galway
------------------------------

Original Message:
Sent: Jan 26, 2023 07:28 AM
From: Ravi Mistry
Subject: Import not updating existing contact

I am trying to import some data to update existing contacts but keep getting the error "A record was not created or updated because a duplicate of the current record already exists."

If i import with selecting allow duplicates it create new records any ideas on how i can get the record to update. 

------------------------------
Ravi Mistry
Countryside Alliance
London
------------------------------

Original Message:
Sent: 1/26/2023 7:29:00 AM
From: Ravi Mistry
Subject: Import not updating existing contact

I am trying to import some data to update existing contacts but keep getting the error "A record was not created or updated because a duplicate of the current record already exists."

If i import with selecting allow duplicates it create new records any ideas on how i can get the record to update. 

------------------------------
Ravi Mistry
Countryside Alliance
London
------------------------------

Hello Ravi,

Try to filter the contact you want to update in Advanced Find and export it.

Make sure you include the column you want to update for that contact.

Then work on the spreadsheet and add your edits and reupload. The hidden columns include the GUID of that contact and you should be able to update it.

------------------------------
Thanks,
Cristall Amurao
Solutions Architect
ON, Canada
------------------------------

Original Message:
Sent: Jan 26, 2023 07:28 AM
From: Ravi Mistry
Subject: Import not updating existing contact

I am trying to import some data to update existing contacts but keep getting the error "A record was not created or updated because a duplicate of the current record already exists."

If i import with selecting allow duplicates it create new records any ideas on how i can get the record to update. 

------------------------------
Ravi Mistry
Countryside Alliance
London
------------------------------

Hello Ravi,
The best way I have found to update existing records is to export your list of contacts as a "Dynamic Worksheet".
Be sure to add the column(s) for the fields you want to update data for.

This will add 3 columns to the exported file which are helpful for updates.  (Guid, modified on date, modified by) It's important to leave these columns, they are hidden as A, B, C.   

Once this is exported, you can leave only the hidden columns and the columns of data you are updating.

Simply import that list back in and it will not give you any errors based on duplicates or unable to reference because you have the unique ID for each contact in the spreadsheet.

Hope this helps, thanks!

------------------------------
Tim Dailey
Sr Marketing CRM Administrator
Starkey Hearing Technologies
The CRM Dude (freelance consultant)
Victoria MN
------------------------------

Original Message:
Sent: Jan 26, 2023 07:28 AM
From: Ravi Mistry
Subject: Import not updating existing contact

I am trying to import some data to update existing contacts but keep getting the error "A record was not created or updated because a duplicate of the current record already exists."

If i import with selecting allow duplicates it create new records any ideas on how i can get the record to update. 

------------------------------
Ravi Mistry
Countryside Alliance
London
------------------------------