While migrating data from a legacy system to Microsoft Dynamics CRM, you might run into a situation where you need to migrate dropdown values from a source system to CRM using Scribe. This task may take some time given the fact that in Scribe, you can use “if” conditions to accomplish the task. It can become tedious to write “if” statements for a long list of dropdown values.
To overcome this, you can use the DBLOOKUP2 formula. You can query on the stringmap table which stores all the mapping between dropdown text and values.
Here are the steps to accomplish this:
- You need to use Scribe Workbench.
- Open up the Scribe package.
- Configure the target as CRM.
- Place the following code in the formula and click Ok: DBLOOKUP2( “Your CRM SchemaName of optionset attribute “, ” Your Source Field (S11)”, “Your Connection Name”, “StringMap”, “AttributeName”, “Value”, “AttributeValue” )
- Now you can test the Scribe job.
Scribe is a powerful tool to migrate /integrate data to Microsoft Dynamics CRM and make your migrations a lot less cumbersome. If you found this blog valuable, check out our other blogs about migrating data into CRM with Scribe!