Importing groups and group members without creating duplicates

[Cinlin]

Since the groups and group members do not come up in the update set, what is the best way to import the users into the groups in bulk?  Also is there a way to automatically set the type field as well for each group?

[Allen Andreas]

Hi,

If you have the groups created in another instance, you can export them via XML and then import them in to the other instance. That would retain the type setting, etc. Then just export/import the users the same way?

[Cinlin]

Thank you for the quick response, will this create duplicate users if the users are a part of multiple groups?  Also which table is best to export from?

[Allen Andreas]

Hi, no, it shouldn't.

I'd go to the sys_user_group.list, click the contextual menu next to any column header, Export > XML. Go to your target instance, any list, anywhere, click contextual menu next to any column header, Import XML.

Then go back and repeat for the sys_user.list

I believe with that, it would carry their membership to those groups. So you're inserting them ONCE and it creates the users AND places them in groups.

We personally do LDAP here, but this should work.

[Cinlin]

We also use LDAP so the users are already there but they are not in any groups, how do I get the users into the correct groups?  Not sure the sys_user_group.list will bring over that info it has not in the past.