Export list of values of local option set

(0) Share

Report

Posted on by Mohsin Ali

3,634

Hi, I've a local option set at contact form. It contains almost more than 100 values. For some reasons I need these values.

Is there any suggested way to export/obtain all these values into excel/csv?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hi,

You can use XrmToolBox to extract optionset metata, Download it from codeplex and connect to your CRM system, then select metadata generator->your entity and export it to excel.

xrmtoolbox.codeplex.com

Thanks

Was this reply helpful? Yes No
Suggested answer

Royal King 27,686 on at

Like (0)

Report

One easy way to get all the labels and values of optionset is, in IE browser Press F12 and select the optionset control and copy the HTML of the select control and save as XML and open it in the excel that will give you title and values of all options.

Was this reply helpful? Yes No
Mohsin Ali 3,634 on at

Like (0)

Report

I'm getting error while connecting with the XRM Tool Box for Dynamics CRM the error details are:

An error occured while retrieving organizations: Metadata contains a reference that cannot be resolved: 'disco.crm.dynamics.com/.../Discovery.svc;.

Inner Exception: The operation has timed out

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Please share screenshots, Are you connecting to online or onpremise ??

Was this reply helpful? Yes No
Suggested answer

Abed Haniyah 4,287 on at

Like (0)

Report

Dear Mohsin,

If on-premise CRM, then you can make a query on FilteredStringMap view by entity and attribute name for getting the option set values.

Hope this helps,

Abed.

Was this reply helpful? Yes No
Abed Haniyah 4,287 on at

Like (0)

Report

Then copy the query result and paste it into excel sheet :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi there Chitrarasan,

Could you please explain in a little bit more detail how I could that?

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

[quote user="Chitrarasan Duraisamy"]

One easy way to get all the labels and values of optionset is, in IE browser Press F12 and select the optionset control and copy the HTML of the select control and save as XML and open it in the excel that will give you title and values of all options.

[/quote]Thanks for this solution, it worked fine and saved me a lot of time. I copied the values into a text file which I imported into Excel. From there, I was able to easily extract the actual values from the option set.

Was this reply helpful? Yes No