Microsoft Dynamics CRM (Archived)

Getting Error in import "A duplicate lookup reference was found.".

(0) Share

Report

Posted on by Community Member

Hi,

I have requirement to import data, single record can be identify by the combination of 4 columns/attributes as below.

1. Name

2. ID(it can be multiple- so i can not dependent only on it)

3. Language

4. Lookup Field

- Data In Current Entity

Name	Id	Language	Lookup
Abc	1	1033	Text1

- Data In Lookup Entity

Name	Language
Text1	1033
Text1	1031

So while Inserting Data with Lookup field getting error, as lookup entity having same name.

Here is the issue with mapping of the Lookup field of current entity and Name field with lookup entity, but i have required the mapping of multiple columns.

Eg.

Id,Language and Lookup filed of current entity

with

Name and language

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

M I Mostafa 4,257 on at

Like (1)

Report

Hi,

If there is a duplicate lookup value in the sheet, that record will not be uploaded as CRM cannot decide which record to select out of 2 records with same value. You should use some unique field and map accordingly while importing.

In other words, "Text1" exists twice as per your data, so CRM doesn't know which one to pick. You need to select a field with unique value.

If you found my response helpful, please mark "yes" to confirm it helped you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for reply.

It is possible to mapping of combination of the 2 field(name and language - as in my base data it has the same name for different language).

also please share the step, from where i can configure that mapping.

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (1)

Report

Hi,

This is because multiple lookups have the same name and CRM while creating the records was unable to find the exact record and failing by throwing an error.

Please see the links below.

exploringxrm.wordpress.com/.../resolving-duplicate-lookup-references-in-import-process

mscrmtechie.blogspot.in/.../a-duplicate-lookup-reference-was-found.html

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Venkatesh Ekkaluri 150 on at

Like (0)

Report

Hi Krutesh,

Instead of going with Name column try with GUID(Primary key). This may solve the issue.

Regards,

-- Venkatesh Ekkaluri

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In my CRM instance i am not getting review mapping summary in import wizard.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So in that case i need to add GUID in Excel?

Was this reply helpful? Yes No
Suggested answer

Venkatesh Ekkaluri 150 on at

Like (0)

Report

Yes, Krutesh.

So, that system will not find it as duplicate. While mapping Use 'Entity Primarykey' column.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Is there any way to create rule to identify lookup value based on multiple columns values of excel.?

Was this reply helpful? Yes No
Suggested answer

Mostafaali93 10 on at

Like (0)

Report

I had the same issue also when I tried to import some records in this entity (Bookable Resource Booking) the issue was in the booking status lookup as I found that there is 2 Completed status 1 inactive and the other one is active so the system got confussed about which one will be updated

kindly check the attachment that contains the values that exists in this lookup (Booking Status)

Was this reply helpful? Yes No