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

(0) Share

Report

Posted on by QNACRM

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!

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

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 :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

Has the problem been solved? Any updates?

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

Thanks.

Regards,

Leah Ju

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

Was this reply helpful? Yes No