Tuesday, 25 August 2015

A duplicate lookup reference was found while importing data to CRM 2011/2013/2015


Today I got the below error when I imported a contact csv file.

"A duplicate lookup reference was found"

In the .csv file there are only two columns FirstName and Account Lookup. Opened CRM and checked in Account and found that multiple accounts has the same name  and CRM while creating the records was unable to find the exact record and failing by throwing an error.

The fix for it is very simple, we need to find out one value which is unique. When I say unique, the one that comes to our mind is GUID of the record. Well, we can use this too but most of the cases we won't be having the GUID while importing then we can consider Account Number field or some other field which is unique.

After finding the unique field, fill the .csv with the respective values and import it using the wizard. In the wizard while mapping the fields we have a chance of the changing the mapping criteria. Map the unique field and we are done.

Hope this helps.

Happy CRM'ing

No comments:

Post a Comment