Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / XRMToolbox importing N...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

XRMToolbox importing N:N data - how can I find what the unique identifier is?

(0) ShareShare
ReportReport
Posted on by QNACRM 50

I'm brand new to XRMToolbox and have no idea how to use it so bear with me here. I am trying to import a list of data that is inaccessible to be imported into via the native import tool so I was told to use XRM toolbox. I have a file set up to import a set of data but when it comes time to select a unique identifier I cannot figure out what to use since those data points don't exist on the table I am trying to import. Has anyone had any luck using this tool or can you offer resources on where to look to learn about N:N relationships? I cannot find any good videos or resources out there.  TIA!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: XRMToolbox importing N:N data - how can I find what the unique identifier is?

    Hi Partner,

    Has the problem been solved? Any updates?

    Please click Yes under "Did this answer your question?" to close this thread.

     pastedimage1629446354512v1.png

    Thanks. 

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Verified answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: XRMToolbox importing N:N data - how can I find what the unique identifier is?

    Hi,

    If you are trying to use XrmToolBox for N:N association, you need to make sure both side entity data is already imported in CRM first, after that you can use that tool to associated both entity records, for example you want to associate entity A and entity B records so first import entity A record and then entityB record, after that you need to export those records so that you have guid from the excel file and then you can import them for the association.

    Long process :)

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: XRMToolbox importing N:N data - how can I find what the unique identifier is?

    Hi Partner,

    It can be difficult to work with unique identifiers, so you can select Entity with Specific attribute as alternate Key.

    You can refer following links for more details:

    How to import N:N relationships in Microsoft Dynamics CRM (lbmc.com)

    Data Migration for Many to Many Relationship Entities in D365 PSA | CloudFronts

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans