In this webinar, our experts showcase a variety of demo use cases of how different components of the...
The out-of-the-box Dynamics CRM data import feature provides some great functionality, such the ability to create records, update existing records, and create attributes for an entity on the fly.
For many of us, getting clean data in CRM upon import is very important for user adoption. Many users' accounts and contacts come from either another CRM system or an accounting program, and many of these systems have duplicate data. This can happen for a variety of reasons. Maybe the old system won't let users associate multiple accounts together. Maybe additional fields may have been used to make the record unique. Or perhaps they simply just have bad data. With these scenarios, it can become very difficult to associate a related entity record to another entity.
Today we'll show you an example where we'll focus on creating contacts and populating the parent customer field. Since we have multiple accounts with the same name, we'll use the Account Number field as the unique value. When we import the accounts, the Account Number field is populated in the account entity.
When importing the contacts, you'll go through your mapping process of your source data to the contact values in CRM. When you are ready to associate the contact to the parent account, you will select the Parent Account field in CRM and select the Account Number field in your source file. By default, this will try to look up the account by the account name.
If we have multiple account records in CRM with the same name, the import will fail since it does not know which account record to associate to the contact. In this case, we can use a different value to look these records up in CRM. Since I have the account number available to me in the account and contact spreadsheets, I can use this unique value to look the account. Here's how:
1. Select the look up icon next to the Account Name.
2. Uncheck the Account Name field. We do not want to look up the parent account by this value.
3. Now check off the Account Number field. This field will be used to search for the Parent Account record instead of the Account Name.
By using a unique value during the import, you are less likely to run into duplicate reference errors during this process.
Happy CRM'ing!
For creating relationship with another entity, unique field should be used as many occurs with the same name. Thanks for sharing the information.
This doesn't seem to work for me?
Hi Joe, in our business Contacts are linked to multiple Accounts. I can define the Primary but how do "upload" the relationships that aren't Primary? Is this gonna be a plugin?
I guess what I'm looking for is how to create Contact associations to Accounts without using Parent/Child relationship in the upload. If I use the lookup to Accounts it's automatically creates duplicate Contacts - one for every Account where the Contact could work. Our Clients work out of multiple Locations/Accounts without a traditional Parent Child relationship. Any thoughts?
RG