This article has been archived. It is offered "as is" and will no longer be updated.
When you try to import data that involves a picklist attribute that has more than 100 optional values in Microsoft Dynamics CRM 4.0, you receive the following error message:
Transform parse data.
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes
To work around this problem, you must manually increase the ImportPickListBatchSize column to a number that is large enough to accommodate your picklist. For examle, you can use the following code to manually increase the ImportPickListBatchSize column:
update DeploymentProperties set IntColumn = 1000 where ColumnName = 'ImportPickListBatchSize'
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards