Select the product you need help with

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 ID: 948987 - View products that this article applies to.

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.

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/949256/ )

Microsoft Dynamics CRM 4.0 updates and hotfixes

Back to the top | Give Feedback

STATUS

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

Back to the top | Give Feedback

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684

(http://support.microsoft.com/kb/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

(http://support.microsoft.com/kb/887283/ )

Microsoft Business Solutions CRM software hotfix and update package naming standards

Back to the top | Give Feedback