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
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
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (