Adding/Deleting Users from Group via Workbook

[former_member207877]

Hi Friends,

I want to add/delete the users from the group via workbook.

Please provide me the workbook.

Appreciate your quick help.

Thanks,

Raj.

[Former Member]

Hi, you can use the collumn groups in the account's sheet from workbook.

For example:

• include the user in the groups A, B and C

• Exclude the user int the group B

Francisco

[former_member207877]

Hi Francisco,

What we have is just username of user account  and EXTERNAL_ID of the purchasing group.

We dont have any security profile information of User.

Requirement is to add/delete user from group.

Thanks,

Raj.

[Former Member]

Raj,

you  update all the user groups filling the column GROUPS with the external ids of the purchasing groups separated by '~'.  

Francisco.

[former_member207877]

Francisco,

If the user is having the groups A,B,C and if you want to add the groups D,E to the same profile and through

workbook if you give D~E then the groups A,B,C will be removed from the user security profile and one of the groups from D will be set as default group

In order to perform the activity mentioned by you we have to know the prior groups of the user.

Here in our case we don't have any info of user except username and the groups to be added

Thanks,

Raj.

[Former Member]

Raj, you can combine extension fields and import script:

• create a extension field of type String in user account for the groups that will be deleted and another for groups that will be added.
• Include this fields in workbook with the values of external ids of the groups(delimited by ~) that will be deleted or added.
• So create a import script (Process row) for user account:

groupsDel = doc.getExtensionField("GROUPS_DEL").get();

if(hasValue(groupsDel)) {
       id_groups = groupsDel.split("~");
       for(id_gr: id_groups) {
       doc.removeFromGroup(id_gr);
       }
}

groupsAdd = doc.getExtensionField("GROUPS_ADD").get();

if(hasValue(groupsAdd)) {
       id_groups = groupsAdd.split("~");
       for(id_gr: id_groups) {
       doc.addToGroup(id_gr);
       }
}

• If default group will be deleted, it's necessary to define other default group after this code.

Francisco

[Former Member]

Hi,

This is possible and the steps are available in SAP Note 1092321_Delete Collaborators. Please let me know if you are unable to fetch it and I can send the mass update file to delete users.

Hope this is helpful.

Thank you,

Vikram

[former_member207877]

Hi Vikram,

Workbook which you are referring to is to delete users from documents.

What we need is to delete a user from group.

Deleting multiple users form group through workbook.

Please let us know if you have any suggestions.

Thanks,

Raj.

[Former Member]

Hi,

So you mean to say that from a Security standpoint various users were added to a group and now you want to delete some of the users from that group? And without having to login to the application for deleting users manually, correct?

In the Users import workbook, there are 2 columns for Inactive and Can_Login. Maybe if you are looking to prevent these users from logging into the system, you can use these 2 fields for this purpose.

Thanks,

Vikram

[former_member207877]

Vikram - Hi!

Requirement is just deleting multiple users from the group with the help of Workbook without disabling him from logging into the CLM application.

Thanks,

Raj.