Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Error while re-import on custom entity

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dear Experts,

I have a custom entity called "department" which has a lookup field on another custom entity called "BUDGET". I have all the budget records in place. I need to mention the appropriate budget for the department for which I exported all the department names for re-import and entered the correct budget names on the xml files. But when I try to import this back I am getting "Lookup reference not found" error on budget lookup field of department during the transform phase. But if I manually try to enter the budget by opening the department record, it resolves. Once thing I noticed as a difference though is that when I type in the full name of the budget record on the lookup field and press tab for a split second it says the error "You must specify a value" (as if I entered an non existing record) but it immediately resolves and the error goes away.

This is how my two custom entities looks like.

Entity (Department):

Department Name (Primary Key)

Budget (Lookup)

Entity (Budget):

Budget Name (Primary Key)

Budget Amount

Budget Consumed

Error Log during re-import

8831.err2.png

When tried to enter the department name manually (this appears for a split second, normally this comes when we partially enter a name, but here I entered the full name and it does exist.)

2555.err1.png

and then resolves:

0245.err2.png

any help appreciated.

Regards

AbD

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while re-import on custom entity

    Anyways, got it worked by "removing" and re-creating the department records. This way I get access to the mapping and did as you suggested. Should have tried using the second field's name during the re-import

    Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while re-import on custom entity

    Thanks Nadeeja for the reply.

    This mapping is possible only while importing and not during a re-import where it just takes the file and start importing. Is there any way to select mapping while re-importing?

  • Verified answer
    Nadeeja Bomiriya Profile Picture
    Nadeeja Bomiriya 6,804 on at
    RE: Error while re-import on custom entity

    Hi Abu,

    When you import, please double check your mappings.  For example, if you are importing contact records which has a lookup to accounts, you need to make sure the lookup mapping is configured for the "Primary Key" as well as the "Primary Name". They are two different fields. You can select both in the lookup.  See the screenshot below.

    Data-Import-_2D00_-Data-Mapping.png

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans