I have been troubled by importing simple data into CRM 2011 Online.
Currently I'm trying to import both accounts and contacts in 1 zip file.
Supposedly CRM is able to use the lookup fields this way.
However, this is not working for me.
The (only) error in CRM 2011 Online:
Incorrect syntax near ')'.
-----
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147204784</ErrorCode>
<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2012-04-25T11:49:49.6273941Z</Timestamp>
<InnerFault>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #73516AD9</Message>
<Timestamp>2012-04-25T11:49:49.6273941Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
<TraceText i:nil="true" />
</OrganizationServiceFault>
----
My files only contain the following
Account.csv
Account Name,Address 1: City,Primary Contact,Main Phone,Category
test,test,test2,3333333333,Eindklant
Contact.csv
Last Name,Parent Customer,Business Phone,E-mail
test2,test,44444444,test@test2.be
I am aware that I have to use the , delimiter in this example.
Every file mapped correctly.
It just gives a generic error before completion.
Last thing to note is that importing a 1700 record file of accounts did work, but then the lookup value is empty.
I guess the problem should have something to do with the lookup fields.
Note that I can't import one at a time because they reference eachother...
Solutions to this problem will be highly appreciated...
Thanks,
Gert