Transferring Groups & Group Memberships between instances

shane_holland
Mega Contributor

Hello,

 

I noticed when I was working in an update set I created, one of the things I did was create a new Group and add new users/members to it. However, when I moved the update set over to our production instance, the new Group did not come with it. By exporting the Group table via XML and importing it to production, this brought over the new group but did not bring with the group members. In order to get the group memberships to transfer over, must you also do an XML export of the User table and then import it to production?

 

It seems like an odd way to move these changes over, is there another way or is this best practice/how it works?

 

Thanks,

Shane

1 ACCEPTED SOLUTION

Jay_Ford
Kilo Guru

You actually want to export from the 'sys_user_grmember' table. Filter the list on just the group you want to get the members for before exporting. This will keep you from overwriting groups that may be out of sync between your instances.


View solution in original post

6 REPLIES 6

Hi Johnson,


I was doing same thing in my own instance but didn't import any group and group member in "sys_user_grmember" table.


I followed same procedure as you mention in above chain.



Please suggest where can i lack this process.


You'll need to Active Elevated Privileges / security_admin to use the Import XML from header capability from any list view.



find_real_file.png


Click the Padlock on the top left.



Then click the 'security_admin' checkbox.



find_real_file.png