Home > Dynamics CRM 2011 > Resolving Duplicate Lookup References in Import Process

Resolving Duplicate Lookup References in Import Process

Normally when we import records which has a related entity, import process will resolve the lookup reference if it finds single record in the parent entity otherwise, it will stop processing the record and ends in fail.

Ex: When we are importing a Contact (Contact1) with Parent Account (Account1) and system has two accounts with same name then Import process gives error when processing Contact1

To resolve these types of records we need to make a small tweak before submitting the import job. Here we go

Click on Edit in the mapping dialog

Go to Parent Account field in the list of mappings and click on Lookup

Set the unique field as the reference

Now in the import file add the data as Account Number for Parent Account field.

Hope this helps πŸ™‚

Advertisements
  1. February 21, 2013 at 3:19 AM

    I have “tweeked” every conceivable selection in the drop down menu to resolve this error while importing products Actually Two Days worth of trial and error codes. While your post makes sense I am still having a problem!.
    I have gone so far as to export existing hand keyed items and then added the new items to the list. The existing items go with out failure however the new items always error out.
    Any other “new ideas” would be most helpful as it seems

  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: