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}
Symptoms
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.
Cause
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.
