locked
CRM 2011 Online Data Import RRS feed

  • Question

  • 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

    Wednesday, April 25, 2012 12:10 PM

Answers

  • Turns out the lookup of Primary Contact is always Full Name.

    Even though the last name is part of the full name, this created a problem in the lookup.

    I solved it by dividing the full name into first and last name for the contact.
    The primary contact still contains the full name.

    Gert

    • Marked as answer by Cogn-IT Wednesday, April 25, 2012 2:10 PM
    Wednesday, April 25, 2012 2:10 PM