search

forcedotcom / SFDX-Data-Move-Utility

SFDMU is a cutting-edge Salesforce data migration tool for seamless org population from other orgs or CSV files. It handles all CRUD operations on multiple related objects in one go.
BSD 3-Clause "New" or "Revised" License
434 stars 73 forks source link

[QUESTION] - Ability to load GroupMember records using SFDMU #811

Closed twardegaSFDC closed 1 week ago

twardegaSFDC commented 3 weeks ago

Is your feature request related to a problem? Please describe. After I load User records and Group records using Data Loader (since User and Group records cannot be loaded using SFDMU), I would like to load GroupMember records using a CSV file, or directly from another environment.

Describe the solution you'd like I would like to be able to specify external Id as in the section below, and load GroupMember records after I load Group and User records using Data Loader: { "query": "SELECT Id, GroupId, UserOrGroupId FROM GroupMember", "operation": "Upsert", "externalId": "UserOrGroup.Name;Group.Name" }

At present loading of GroupMembers does not appear to use extern Id as specified - Groups and Users with matching names have been created in target environment using the Data Loader.

hknokh commented 3 weeks ago

Hello, @twardegaSFDC

Thank you for your feature request. I will review it as soon as possible and provide updates as they become available.

Cheers

github-actions[bot] commented 2 weeks ago

This case has been marked as 'to-be-closed', since it has no activity for the 3 days.
It will be automatically closed in another 3 days of inactivity.

twardegaSFDC commented 2 weeks ago

Hi, Looks that the case will be closed in the next 3 days. If you have some advice how to load GroupMember records using external ids from Group and User tables (e.g. Name field), instead of depending on Salesforce record ids I will really appreciate it. Tom

hknokh commented 2 weeks ago

Hi,

Thank you for your feature request. I am closing this issue for now. I will review the feature request at a later time, but please note that there is no guarantee that this update will be implemented. I will provide further updates if there are any developments.

Meanwhile, in your specific case, you can try to adapt columns generated by the DataLoader to import with SFDMU. Note that the Data Loader does not support relationships. I suggest you use SFDMU both for import and export.

Regards.

hknokh commented 2 weeks ago

After double-checking the issue:

Group members can already be loaded by SFDMU. However, you still need to adapt your CSV to align with the format supported by SFDMU for loading related records. You must add an extra lookup or external ID column linked to the existing Group records.

degnoskeVA commented 2 weeks ago

Just to save you some time @twardegaSFDC, as I also recently had a similar question. It's worth noting that GroupMember records are currently only supported for Queues, not Public Groups. Feature Request: https://github.com/forcedotcom/SFDX-Data-Move-Utility/issues/778

github-actions[bot] commented 1 week ago

This case has been marked as 'to-be-closed', since it has no activity for the 3 days.
It will be automatically closed in another 3 days of inactivity.

github-actions[bot] commented 1 week ago

This case has been closed, since it has no activity for the last 6 days. Feel free to reopen it, if you need more help.