Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Data Migration Wizard Conversion Error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    When attempting to import from one CRM 4.0 system to another CRM 4.0 system, I get an error:

     

    "The lookup reference could not be resolved"

     

    For example in the Account  table, for Primary contact, I get this error, and I have verified that this value exist in the correct column on the Customers table that is being imported.

     

    How come it could not be resolved?

     

    Thank you

    Thursday, July 17, 2008 5:22 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    The client import tool has a bug where it can't lookup values in other tables. The simplest way around it is to get the import to automap the fields. You do this by ensuring the headings in your source file exactly map the labels on the CRM forms. You'll know if it has worked because you will not need to specify a mapping after selecting the entity; it will simply say 'automatic'. With automapping, the lookup works fine.

    Leon Tribe
    Friday, July 18, 2008 12:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Will give it a try.

     

    Much Appreciated

     

    Friday, July 18, 2008 6:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    I found that the import is looking at the actual database, and not on the other files that are being imported as well.

     

    How can I import files that have references to each other?

    Friday, July 18, 2008 7:29 PM