Skip to main content

Notifications

Dynamics 365 general forum
Answered

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

Posted on by 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!

Categories:
  • 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,041 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: Exception has been thrown by the target of an invocation.