Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Import data process does not work using csv file in Microsoft Dynamics CRM

Import data process does not work using csv file in Microsoft Dynamics CRM

Symptoms

You export an Excel file with static data, modify the content and try to import the file back to the Microsoft Dynamics CRM by using the Imports entity with the enrich data option. You cannot import the .csv file. The following error message is shown on the Failures menu item from the Imports entity.

"Import has encountered an error and has been canceled. Your system has been restored to its original state. At least one attribute mapping has its IsSystem attribute set to 1".

Additionally, the following information is registered on the CrmAsyncService-bin Platform log:

[2010-11-11 20:35:06.4] Process:CrmAsyncService |Organization:a1c55001-82e2-df11-942f-00155df07913 |Thread: 18 |Category: Platform.Import |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | ImportOperationTransform.ExecuteImportOperation
at ImportOperationTransform.ExecuteImportOperation(Guid organizationId, Guid importId, Int32 operationType, AsyncEvent asyncEvent)
at ImportOperation.InternalExecute(AsyncEvent asyncEvent)
at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>There are some headers which do not have names as those of attributes display names, can not continue with this ImportFile id = {13DC08CD-E3ED-DF11-AD24-00155DF07913}

↑ Back to the top

Cause

The Entity´s name has been changed, but the Entity´s Primary Key attribute display name not. Therefore, the Excel Primary Key column does not match the Entity´s Primary Key display name, this column must match what is in the .csv file. When the System Map attempts to match columns it does so based on the display name. Since the display name for the Primary Key column does not match the column name in the .csv file, it will report the error.

↑ Back to the top

Resolution

Change the Primary Key Attribute Display name on the Entity:

1) Start Microsoft Dynamics CRM as System Administrator.
2) Click Settings, and then click Customization.
3) Click Customize Entities.
4) Double-click the Entity involved on the Import process.
5) Click Attributes.
6) Double-click the Primary Key type attribute.
7) Change the Display Name to match what is in the .csv file.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, vkball, kb

↑ Back to the top

Article Info
Article ID : 2467301
Revision : 1
Created on : 1/8/2017
Published on : 8/3/2011
Exists online : False
Views : 115