web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Importing Option Sets: local & global

(2) ShareShare
ReportReport
Posted on by

Hi,

Because I don't want to start a blog ... and because I'm extremely lazy (good for my clients because I don't waste their time/money).

If anyone is looking for a solution to import option sets, there is a very easy way, but at least currently in CRM 2016 online, you need to trick the system to make it work.

1) Create an optionset field in the entity you want

2) Go to advanced find and export a simple list from the entity where the new optionset was created. Doesn't matter which columns.

3) In the exported list, add a NEW COLUMN, with a title that does NOT match an existing field in your CRM.

4) In the new column, add all the options for your option set. In the other columns, just add random something which you easily find afterwards in the system to delete. Save the file.

5) Go to settings - data management - import & import your file

6) Because the column is new, the system will give you the ability to map it to an existing field. Here you select the optionset field you initially created. It will show all your option set values nicely below one another. Click ok & go.

7) If you have a lot items in your optionset (like all ISO countries), you may see this for a long time:

" Creating custom record types and fields in Microsoft Dynamics CRM..."

... and then get the following error:

Error
An error has occurred. 

Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support.
=> Don't worry, got to your newly created option set field in customizations and you will find a large amount of options have been added, but unfortunately not all. Check until which option value was imported, go to your excel, deleted all rows where were allready uploaded and simply follow step 5 again.
That's it.
How to convert it to a global option set? - After the above ...
1) use XRMtoolbox and open Attribute Manager
2) select the entity where the optionset can currently be found and select the (local) option set
3) Check convert to global option set ....
DONE.
PS: I found multiple source on the web and tried a few with creating data maps through the SDK, ... some explain the above but forget to mention a few critical things in order for it to work ... so there you go.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Importing Option Sets: local & global

    Is there any work around of making account address country field an option set?

  • Community Member Profile Picture
    on at
    RE: Importing Option Sets: local & global

    Could you clarify the steps you did in XRMtoolbox. I have also read the various sources across the web, and I am able to convert the optionset from local to global, but none of the data from the local one gets passed to the global, even when I am clicking the migrate data box as well.

    Any help would be great.

    Thanks

  • Suggested answer
    Adrian Suteu Profile Picture
    on at
    RE: Importing Option Sets: local & global

    One of the easiest methods of accomplishing this is to use a record import to indirectly create the required Option Set values at local level. If you don't mind using Local Option Sets and you have a large number of options this might be more efficient than creating a Global Option Set and manually input those values.

    A complete guide for this workaround can be accessed here: www.tkisolutions.com/msdyncrm-tip-quickly-create-values-for-option-sets

  • Community Member Profile Picture
    on at
    RE: Importing Option Sets: local & global

    This workaround might be helpful 

    https://community.dynamics.com/crm/f/117/t/288066

  • Community Member Profile Picture
    on at
    RE: Importing Option Sets: local & global

    The Attribute Manager just changes your field attribute from local option set to global option set.  It doesn't copy the values of the local option set to the global option set.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
UllrSki Profile Picture

UllrSki 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MM-22011143-0 Profile Picture

MM-22011143-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans