Error message when you import data into Microsoft Dynamics CRM 4.0 by using the Data Import Wizard or start a new data migration by using Data Migration Manager: "Mismatched data delimiter: only one delimiter was found"

Article translations Article translations
Article ID: 948987 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Symptom 1

You import data into Microsoft Dynamics CRM 4.0 by using the Data Import Wizard. All the steps in the wizard are completed. However, the data is not imported. In the Imports area under Workplace, you may see the import job and errors. The error rows may contain the following error message:
Mismatched data delimiter: only one delimiter was found.

Symptom 2

You use the Data Migration Manager for Microsoft Dynamics CRM 4.0 to start a new data migration. If you select a .csv file that contains new line characters in a data field, the Verify Delimiters page will be displayed incorrectly. If you click OK on the Validating Files page, you receive the following error message:
Mismatched data delimiter: only one delimiter was found.

Symptom 3

You create an import map through the Microsoft Dynamics CRM 4.0 Software Development Kit (SDK). You use nonprintable characters, such as newline (\n) or return (\r) characters, as delimiters for the field values. You receive an error message that resembles the following:
<crmerror> <ErrorId>80040345</ErrorId> <ManagedErrorName>DataColumnsNumberMismatch</ManagedErrorName> <ErrorMessage>The number of fields differs from the number of column headings.</ErrorMessage> </crmerror>
The rows of data that contain nonprintable field delimiter characters are not imported.

RESOLUTION

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

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 948987 - Last Review: January 20, 2012 - Revision: 2.2
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kbexpertiseinter kbfix kbautohotfix kbmbsmigrate kbqfe kbhotfixserver KB948987

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com