Missing Display Names For Picklists In Microsoft Dynamics 365 / CRM Replication

Missing Display Names For Picklists In Microsoft Dynamics 365 / CRM Replication

book

Article ID: KB0078387

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

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:
  1. Navigate to the TIBCO Scribe® Online Connections pane.
  2. Select a Microsoft Dynamics 365 / CRM Connection name to open the Edit Connection dialog.
  3. Enable the checkbox to Include Picklist Display Names.
  4. 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.