Hi,
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
Gopinath
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
Gopinath
Hello, I tried to import a GUID into the regarding field and it still gave a duplicate error, even after I removed the duplicate detection setting. No idea what is causing the duplicate error.
ReplyDelete