Migrating data with Many to Many relationships

When providing client solutions with CRM, majority of the time clients want to migrate their existing data. The purpose of this article is to provide a comprehensive guide to migrate data with many to many relationships. As we all know support for many to many relationships is one of the coolest features in Dynamics CRM.

For instance, let’s assume a client wants to upload the accounts(companies) with the primary contact intact. In this scenario, accounts has a reference to contacts and contacts has reference to accounts (company). You can see the references in the below images.

crm14_1

crm14_2

Remember, you cannot upload these individually, because the migration will fail. So, before uploading, make sure these files are converted to csv files. And one simple thing you have to do is to combine these files together as a ZIP file.  This will enable you to import data with cross references. Dynamics CRM will internally map the many to many relationship in this case.

crm14_4

crm14_5

Once this is done, navigate to data migration option of the target CRM environment. Here I am using a trial Dynamics 365 account.

crm14_8

elect the ZIP file from the folder and when you hit on next, the system will detect there are two entities within the ZIP file. Navigates through the data import wizard. Make sure you map the data correctly.

crm14_9

If you map data correctly, you will see the following screen.

crm14_13

Click Next and review the data import settings. If you are ok with it, you can hit submit.

crm14_14

Once submitted, the data import process will commence.

crm14_15

If the process successfully completed you can see the results on the system. In this scenario the process completed successfully.

crm14_16

Now you can see the imported data has been referenced correctly. On the Accounts (Companies) list, the primary contact field is updated.

crm14_17

On the Contacts list, you can see the Company name (Account) is updated.

crm14_18

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s