book
Article ID: KB0078387
calendar_today
Updated On:
Description
You run a replication from Microsoft Dynamics 365 / CRM and one of the fields is an Option Set in Microsoft Dynamics 365 / CRM. The replication database only shows the numeric values, not the labels.
Resolution
To show these labels/names of your picklist value:
- Navigate to the TIBCO Scribe® Online Connections pane.
- Select a Microsoft Dynamics 365 / CRM Connection name to open the Edit Connection dialog.
- Enable the checkbox to Include Picklist Display Names.
- Test and save your Connection.
Note: By default, this setting is enabled.
The next time you run your replication, TIBCO Scribe® adds the corresponding field (x_picklistname) with the labels. Any newly inserted or updated records will have data in the
x_picklistname field. If this record is not updated by RS, that field will be NULL and you will need to update it via a SQL query or re-replicate it.
For more information see the following in the Scribe Online Help:
TIBCO Scribe® Online Connector For Microsoft Dynamics 365 / CRM
Issue/Introduction
If your Microsoft Dynamics 365 / CRM Connection is not configured correctly, you may not see picklist names in your Replication.