Drop-Down List Correlation Tables
Data in drop-down lists must be valid Microsoft CRM values. You must transform or cleanse your source data in the entity tables to ensure that only valid drop-down list values are used. This allows the CDF Migration Tool to migrate your drop-down lists.
To make the process of cleansing drop-down lists easier, there are two correlation tables provided in the CDF database to help organize drop-down list data:
- cdf_StringMapCrm
When you run the CDF Initialization Tool, the cdf_StringMapCrm table is populated with values and default values for drop-down lists in Microsoft CRM entities that can be migrated with the CDF Migration Tool. It serves as the reference list against which to check your data.
Important Do not enter data directly in the cdf_StringMapCrm table, because data from this table will not be migrated into Microsoft CRM. If you find an error or omission in the table, fix the drop-down list in Microsoft CRM and then rerun the CDF Initialization Tool.
- cdf_StringMap
The cdf_StringMap table is a temporary table that is populated by a stored procedure with all the values used in your drop-down list attributes in any of your entity tables. Stored procedures are used to cleanse the data in the cdf_StringMap table and to update your entity base and extension tables with valid drop-down list data. For information about the stored procedures used to cleanse drop-down list data, see Appendix A, "CDF Database Stored Procedures" in the Microsoft Business Solutions CRM Data Migration Framework Guide.
The following table shows the attributes in the cdf_StringMapCrm table.
| cdf_StringMapCrm attribute |
Description of attribute |
| StringMapId | The unique identifier for each record. |
| ObjectTypeCode | The number that Microsoft CRM uses for the entity in which the drop-down list is located. To find the entity name or EntityId that is associated with an ObjectTypeCode value, see ObjectTypeCode Values. |
| AttributeName | The name of the drop-down list attribute. |
| AttributeValueInt | The index value Microsoft CRM uses for the drop-down list item that is specified in AttributeName. |
| AttributeValueStr | The string Microsoft CRM uses for the drop-down list item that is specified in AttributeValueInt. |
| IsDefault | Specifies whether the value is the default for the drop-down list. |
The following table shows the attributes in the cdf_StringMap table.
| cdf_StringMap attribute | Description of attribute |
| StringMapId | Attribute that maps to the associated StringMapId attribute in the cdf_StringMapCrm table. It links the values coming from the entity tables (your source data) to Microsoft CRM values. |
| ObjectTypeCode | The number that Microsoft CRM uses for the entity in which the drop-down list is located. To find the entity name or EntityId that is associated with an ObjectTypeCode value, see ObjectTypeCode Values. |
| AttributeName | The name of the drop-down list attribute. |
| AttributeValueStr | The string value in your data for the drop-down list item that is specified in AttributeName.
The data in this attribute must match a valid AttributeValueStr attribute in the cdf_StringMapCrm table. |