update group member using excel file

[shiva_gupta]

I have a excel file with the below info :

Group Name	User name	User id
User 1	Group 1	1
User 2	group 2	2
User 3	group 3	3

all the listed "users"   and "group" are present in the user table and group table, ex(User1, user2, user3 are there in sys_user table and gropu1, group2 , group3 are present in sys_user_group)

i just want to add the user to the corresponding group mention in the excel.

Can anyone suggest how to automate this in service now by any means because the excel file contains larger no of data and manually it is not possible.

[sachin_namjoshi]

Hi Shiva,

You can create data source, transform maps to group and group member table so that you can bulk import group memberships.

OR

you can use easy import functionality where platform creates data source and transform after uploading data and then use same transform.

Regards,

Sachin

[Pradeep Sharma]

Hello Shiva,

sys_user_grmember is the table which holds user to group relationship. You can import to this table via import sets. Also make sure coalesce is defined on both group and user fields under transformation map so that duplicate entries are not created.

More info here.

http://wiki.servicenow.com/index.php?title=Import_Sets#gsc.tab=0

[shiva_gupta]

thanks for your help...

[shiva_gupta]

thanks for your help it work for the addition of user.

can you please help to remove the user from the corresponding group mention in the excel.