Tech Support > Microsoft Windows > Windows CRM > Piclicks values and Migration tool
Piclicks values and Migration tool
Posted by Edwin Jongsma on April 28th, 2004


hi there

I do have a question about the migration tool. I do use this tool to migrate thousands of records and it all goes ok as long as i do not try to migrate picklists which i have added myself. When running the InitializeCDF tool, it is loading all the picklist values to the cdf_StringmapCRM table, except the values for the picklists which i have added to CRM

As long as the values are not in there, i cannot map other values and i do have a huge problem

Does anybody recognize this problem and know how to solve it

Kind regards
Edwin

Posted by Olga Beatty on May 6th, 2004


Hello Edwin,
I hope you are well. Here is a TechKnowledge which may answer you question:


Document ID: 30706
Date Created: 5/11/2003
Date Last Modified: 5/20/2003
Language: English - United States
Country: USA
Product: Microsoft CRM
Versions: 1.0
Modules: Microsoft CRM Data Migration

Issue

Can Microsoft® Business Solutions CRM Data Migration Framework be used to
migrate data into custom fields that have been added after migrating data
for the core entities and standard attributes of Microsoft CRM?

Resolution

No. If you are using the Microsoft® Business Solutions CRM Data Migration
Framework to migrate records into Microsoft CRM, incremental migrations are
NOT currently possible (nor supported). Before the data is brought into
the Common Data Format (CDF) database, we recommend you complete the steps
below to properly populate your custom attributes within the CDF database.

For each customizable entity in Microsoft CRM, you can create your own
custom attributes. After creating them, you must extend the schema of the
CDF database by running the CDF Initialization Tool. For each custom
attribute you create in Microsoft CRM, this creates a corresponding
attribute in the appropriate cdf<entity>_ext table to hold your source data.

The following steps are recommended. Complete procedures for these steps
can be found in chapters 4 and 5 of the Microsoft® Business Solutions CRM
Data Migration Framework Guide.

1. In Microsoft CRM Schema Manager, create the new attributes.

2. In Microsoft CRM Deployment Manager, publish the changes, and then run
IISRESET on the CRM Server.

3. In the Microsoft CRM Web application, add each attribute to a form,
define its properties, etc.

4. Run the CDF Initialization Tool to extend the CDF database schema.

5. Load your source data into the corresponding attribute in the
cdf_<entity>_ext table.

6. Cleanse your data as needed.

7. Run the CDF Migration Tool to load data into Microsoft CRM.

Thank you,
Olga Beatty
Microsoft Business Solutions Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2003 Microsoft Corporation. All rights
reserved.


Similar Posts