Script Dynamics CRM OptionSet Transformation

Overview

Data flow transformation to handle translation and creation (if needed) of Dynamics CRM OptionSet values.

Setup

The script has the following parameters:

• CrmConnection - selects Dynamics CRM Connection.
• Global - specifies global OptionSet usage.
• Entity - selects Dynamics CRM entity type.
• Attribute - select OptionSet attribute you want to manage.
• LabelColumn - select input column containing OptionSet label.
• ValueColumn - select input column containing OptionSet value.
• Mapping - select variable containing optional label mapping dictionary. The dictionary can be a string, ADO Recordset object or ADO.NET DataSet object.
• Action - select action to perform when input OptionSet label doesn't match existing values. The following options are available:
  • Create - specifies to create new OptionSet. The value for OptionSet is retrieved from ValueColumn.
  • Replace - specifies to replace ValueColumn with the value provided in ReplaceValue parameter.
  • Nullify - specifies to nullify ValueColumn.
  • Ignore - specifies to ignore no match value.
  • RaiseError - specifies to raise error.
• StateCodeColumn - select input column containing state code. This parameters only if No Match Action is set to Create and the OptionSet attribute is set to statuscode.
• ReplaceValue - specifies replace value when No Match Action is set to Replace.