Microsoft Dynamics CRM (Archived)

The lookup reference could not be resolved

(0) Share

Report

Posted on by happyman

565

Hi,

I want to import records (appointments), the entity has lookup fields (contact, account and lead).

I have sommes records have the same name e.g (Lead=Exemple1 account=Exemple1), when i try to import the CSV file, i got this error message:
The lookup reference could not be resolved.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

David Jennaway 14,065 on at

Like (0)

Report

Just to clarify, do you have custom lookup fields on the appointment for each entity type, or a custom customer field, or are you just using the system fields ?

With the data import, a lookup field can only be resolved if there is a unique record to match it to

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

What field are you using to the lookup? Regarding Object Id?

If that is the case, the values must be unique or the system will not recognize it during import.

If you have separate lookup fields for account, contact and lead (which I don't think is the case), you should not have a problem.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi,

When you are trying to import related record and if you are not maintain order of the reference data import then its obvious that reference will not found when its dependent on other lookup or records.

For example if you are trying import a contact with country United Sates and the country United Sates does not exists in the CRM then Dynamics CRM will not create country first and then the contact. So in that case you have to import country data first and then contact with respective country. Exactly same thing happening here in your scenario.

So ideally when you are importing any related data , need to make sure the related lookup is exists in the database.

Hope this helps.

Was this reply helpful? Yes No
Philj 4 on at

Like (0)

Report

Hi,

I am having the same issue and I understand what you are saying however if you can't tell what the source field is that's giving the error how do you know what to import into Dynamics?

Sorry I may just be missing something here but getting very confused

Was this reply helpful? Yes No