Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Bulk import error

Posted on by 680

Hello,

   we have 1700 records to import for our custom entity in our production. I have created a data import file and mapped all the data correctly but failing while importing with error 'lookup can not be resolved'.

The lookup is referencing to a virtual entity.

The import works fine if i do import 20 records at a time but fails for anymore records with the same error.

i'm having to divide these and import 20 at a time.

Anyone else having the same issue? Any suggestions?

  • csrinjoy Profile Picture
    csrinjoy 2 on at
    Bulk import error
    I have seen this issue as well. However I do not think the sheet has any extra commas, since in the second attempt using same exact sheet I saw it went through. Most of the times I did it in batches like 30% 30 % and the rest. Any idea on how to fix it ? If its a configuration or a bug on microsofts end.
  • Suggested answer
    RE: Bulk import error

    Hello Partner,

    'Lookup could not be resolved' usually happens when you are importing child records associated with a parent record, and the parent record doesn't exist or there are two parent records with the same value in the primary field. For example, if you import a contact with the Parent Customer value of 'Acme Inc' then you'll get this error if there is no Acme Inc or more than one.

    Can you check  your import file and ensure there are no extra commas or other characters. Extra commas will cause errors.  You can open your file in Excel and do a Find to see if there are any extra commas.  Since some of the records are importing, I suspect some data anomaly like an extra comma, a special character or some other data point that is causing an issue.

    Regards,

    Mohamed Sanuj Basheer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans