Importing data to an OptionSet field

(0) Share

Report

Posted on by SBeal

Hi,

I am importing data to Dynamics on a daily basis.

Part of my dataset I want to import, I want to map to a field that is an OptionSet. The labels in the optionset are the same as the source data.
However, when I import this data it fails with a formatting error (i.e. the data is not in the correct format).

When testing a little, if I use the numeric value instead of the label, the data imports perfectly. This wouldn't be simple to add to my pre-import processing, but if necessary could be added.

Is there any other way to force dynamics to compare an import value with the optionset label rather than underlying value?

Thanks!

I have the same question (1)

All responses (1)

Answers (0)

Suggested answer

SBeal 50 on at

Like (0)

Report

I resolved this by importing a file which had all the various Options stored in it (with no blanks), selected the correct values on a modified datamap and then saved that. Previously Dynamics would not give the option to select options other than the first few before a blank.

Was this reply helpful? Yes No