Importing Lookup Values Using CRM 2011 Data Import Wizard????

(0) Share

Report

Posted on by Ramakanta

2,715

Hi All, I have three Look up field in Case form when i import records with Similar Lookup Value i get Duplicate Lookup reference Error........Is there any way around /customization devlopement to import records with similar lookup Value....

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Deepesh161 6,317 on at

Like (1)

Report

Try putting a unique field in your import file in lookup reference.

Refer this link for details: exploringxrm.wordpress.com/.../resolving-duplicate-lookup-references-in-import-process

Was this reply helpful? Yes No
Ramakanta 2,715 on at

Like (0)

Report

Hi Deepesh,thanks for your reply,i have tried with unique field but ,i am getting error "The Lookup Reference Can't be Resolved",can we do any other Trick??

Was this reply helpful? Yes No
Deepesh161 6,317 on at

Like (0)

Report

Had you changed import file to have values in lookup columns from this field?

Was this reply helpful? Yes No
Ramakanta 2,715 on at

Like (0)

Report

Yes,i changed my Import File and include the unique field in lookup columns but i am getting the Error "The Lookup Reference Can't be Resolved

Was this reply helpful? Yes No
Deepesh161 6,317 on at

Like (0)

Report

Can you check failure rows in your import and correct them than. Probably they do not resolve to any entity.

Was this reply helpful? Yes No
Ramakanta 2,715 on at

Like (0)

Report

Thanks for your reply

Hi ,I have below lookup in case entity

Category---->Let say A,B

Type---->let say X

1st Recor---->X with Categoty A(lookup in type)

2nd Record---->X with Category B(lookup in type)

When i import record i got duplicate lookup reference error.

Can you please suggest me the way i can import the record with same Type(X)

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report

Hi Ramakanta,

As Deepesh mentioned you need to use unique field / column for your lookup.

Duplicate lookup reference is coming because you have some records with same name / primary attribute..

if have any unique column for record type X then you can use that or try to get GUID of lookups from database.

Then when creating mapping, you need to specify that unique column..

In my case I have Address entity, and I am mapping Address (Primary key, Name, Address Line) with my csv column field.

In you CSV file, you should have unique value for that column, either custom ID, or you can use CRM guid.

Hope this explanation will help you to import records.

Was this reply helpful? Yes No
Ramakanta 2,715 on at

Like (0)

Report

Hi Deepesh/Mahadeo,Thanks a ton for your help....now i am able to Import Records with same name.........

Was this reply helpful? Yes No