Customer experience | Sales, Customer Insights,...

Mapping D365 CRM optionset with KingswaySoft for data migration

(0) Share

Report

Posted on by A Verma

Hello Experts,

Need a quick help/guidance in resolving an issue. I an having an optionset(Role) whose datatype is int.

When I use OptionSet Mapping Editor in KingswaySoft. Under Input column it populated only those value which are of nvarchar type not int.

Please find the below screenshot. Need insight on how to mapp int Optionset in KingswaySoft.

Thanks In Advance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Hi

Please visit the following link if you havent already done so to see how you can map the option-set values

www.kingswaysoft.com/.../optionset-mapping

Was this reply helpful? Yes No
A Verma 55 on at

Like (0)

Report

Hi Kokulan,

May be I was not clear in my query.

I have already gone through the provide link. Thanks for the link.

In the screenshot provided by me, I am able to retrieve only those attributes which are on nvarchar type under Input column field. But the optionset has values which is of integer type.

I am not sure why optionset attribute is not populating in CRM Optionset Mapping Editor.

Need help in retrieving the optionset attribute in Input column field which comes under CRM Optionset Mapping Editor.

Regards,

Verma

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

If you are doing an integer to integer mapping, you do not need to use the CRM Optionset Mapping Editor.

If your source is an integer and your target is an optionset, you will have to make sure the values match. That means that you will have to transform the data before putting it in the optionset field. If your source is a string, you can use the Dynamics CRM Optionset Mapping.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

This might help

nishantrana.me/.../

Was this reply helpful? Yes No
Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

The input is your source, which is having varchar.

The CRM optionset field will appear in target crm optionset field section.

Next in the mapping editor you will map the varchar source to the corresponding int of optionset field.

nishantrana.me/.../

Was this reply helpful? Yes No