You’re offline. This is a read only version of the page.
Hi
I need to set up a data map for importing for a particular type of case records in Dynamic CRM Online 2016.
Case entity have a Lookup field named Counsel.
The Counsel Entity's primary key is a Guid - Counsel ID (which cannot be used for data import).
Counsel have Counsel name and Country column whose Combination is unique (i.e. Counsel Name can repeat , Country name can also repeat, but combination of both makes a unique record and cannot repeat.)
Client provided data sheet that contains Counsel name and Country name as separate columns (as expected). Mapping has been done for source Counsel Name to Destination entity counsel name. But while importing it fails with a message "A duplicate lookup reference was found." (Because it contains duplicate Counsel Names with different country).
The option, I have is to create another column with combination of the Name-Country (auto generate using java script while creating records and keep it hidden ) and ask the client to include a column with same format and map it to the Name-Country column in entity lookup and then Import.
Is there a better solution to this problem ?
*This post is locked for comments
You should be able to map the non-primary field while importing like explained in this blog.
Hi Satyan, I followed using combination field. Can you please tell how to map combination field
Hi Urvi,
Sorry to come back late.
I end up adding a new column which is the combination of counselName - Country ( Type - Single Line text and Field Type : calculated field) in look up field entity. In data sheet , provided a new column with same name (counselName - Country) and using Excels formula + drag option , filled the data manually.
Data map file modified to accomodate this field. while importing, mapped new field and ignore the Lookup field.
I feel this is not a good solution, but worked for me .I couldnt find any better option yet.
Hope it helps.
Thanks
Sathyan
Thank you Gopalan for your suggestion.
In my case, I am importing to case entity and Counsel is an Look up field. As you said, if I make Counsel Name and Country as Alternate keys in Counsel Entity, while mapping which field should I map to ? Even if I select both Counsel Name and Country of lookup field, how country which is another column in data sheet , will get mapped to Counsel Country?
Hi
You can use alternate key. It would help to resolve this issue.
Counsel name and Country as alternate keys
Please refer this:
www.powerobjects.com/.../utilizing-alternate-keys-in-dynamics-crm-integrations
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (