how to export groups along with roles and group members

[eashwar]

I am trying to export groups along with Roles and Group members to import into another instance but it doesnt import Roles and Group members.

Any suggestions ?

[nick702]

Thanks Chris! I will try this now. I was trying as .xls, however, name fields were missing. I have 2 fields, name and u_name which may be messing something up...that and Sys ID is not there so I have to manually add that in and it doesnt seem right. Ill give this xml a go.

[nick702]

Chris, I was able to import using xml, however, the group members are not populating into the groups? What I am doing in bringing full copies of each group from one instance to the other so they have the same data.

[pratulagarwal]

Hi Nick,

I n addition to the groups , you will have to import data from the sys_user_grmember table as well.

Try to filter out the records pertaining to the groups that you need from sys_user_grmember.LIST, and then export them as XML.

Import the file exported in the previous step into the other system.

Regards

Pratul Agarwal

[nick702]

Thank you Pratul, I did this and the groups are missing from each user after import. They are there when i export to xml. How can this happen?

[Les1]

Remarkably Helpful! This should be added to official documentation if it isnt already!