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=, 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">
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Generic SQL error.</Message>
        <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>
        <InnerFault i:nil="true" />
        <TraceText i:nil="true" />
      <TraceText i:nil="true" />


    My files only contain the following


    Account Name,Address 1: City,Primary Contact,Main Phone,Category


    Last Name,Parent Customer,Business Phone,E-mail

    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...



    Wednesday, April 25, 2012 12:10 PM


  • 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.


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