Using Data Migration Manager to inport Contacts and link them to existing Accounts.

• Question

• 

  

  0

  Sign in to vote

  I am using CRM 4.0 Microsoft Dynamics CRM Data Migration Manager.

  I have successfully used the Migration Manager to load The Accounts entity.  I used SQL to generate guids for my Account records and the import went fine.  The resulting accounts contain the accountId's I expected that I generated.  But when I went to import the Contacts, I created a file containing the accountId to link the contact to, but using the wizard, there was no way to link the Contact to the Account.  After doing some digging in the Contact entitiy, I discovered that there was an N:1 relationship from Contact to Account, but that relationship had no attribute name!  There was no way to give it a name either.  So I had the Migration tool make an Export Map, then modified the Map manually to include a LookupMaps node to map the accountId field I am inporting to the existing accountId in the Account entity.  When I imported the Map file, all went well.  When I imported the data, all seemed to go well in that I got no errors and all my contacts were imported, however they were not associated to their Accounts.  When I then went directly to the Database, the accountId field in the ContactBase Table was empty. 

  Does anyone know a trick to successfully import Contacts and have thier relationship to their Owning Accounts maintained?  All of our Contacts are owned by Accounts and it is very important that I maintain referential integrity.

  below is a snipet of the map code I have included in my ContactsMap

   

  <AttributeMap>

  <SourceAttributeName>AccountID</SourceAttributeName>

  <TargetAttributeName>accountid</TargetAttributeName>

  <ProcessCode>Process</ProcessCode>

  <LookupMaps>

  <LookupMap>

  <LookupType>System</LookupType>

  <LookupEntityName>account</LookupEntityName>

  <LookupAttributeName>accountid</LookupAttributeName>

  <ProcessCode>Process</ProcessCode>

  </LookupMap>

  </LookupMaps>

  </AttributeMap>

  Monday, March 17, 2008 5:55 PM