Making bulk add/remove changes via CSV file upload
Supported from version 3.0.12, a CSV (comma separated values) formatted file can be used to add/remove users in bulk:
Usage
Choose which type of bulk operation you want to perform. Currently there are two choices; add members to groups, or delete members from groups. Once the desired operation type has been selected, click the "browse" button to select a CSV file from your file system.
CSUM expects a specific format for the CSV file. Each line of the file represents one operation and contains two fields. The first field is the user-name of the user. The second field is the name of the group that the user is to be added to or removed from. Here is a small example CSV file:
csum-example.csv
ajones,space-group1 fsmith,space-group1 tjenkins,space-group2 dharris,space-group2 nprice,space-group3
When the processing of a file is completed (successfully or not), the file is removed from its storage location (the shared-home folder). Whenever a processing task is submitted, old task records (submitted over 7 days ago) are removed. If an associated file is still present for the task, it is removed also.
Conditions
Without any unexpected issues arising, a bulk add/remove will take place and complete under these conditions:
If the current user completing the CSV bulk change is a space admin, they can only make bulk changes to groups that are in the space that they are currently in and that they are a space admin of, or any of this users delegated groups if Delegated group actions permitted is set to yes.
If the current user is a completing the CSV bulk change is a system admin, they can make bulk changes to any group from any space unless a group being altered is one of their delegated groups and Delegated group actions permitted is set to no.
The Delegated group actions permitted field can be found within the CSUM Configuration.
Performance
CSV upload
Users to process | Time till completion |
1,000 | ~ 45 seconds |
2,000 | ~ 1 minute |
5,000 | ~ 3 minutes |
10,000 | ~ 5 minutes |
50,000 | ~ 30 minutes |
100,000 | ~ 1.5 hours |
200,000 | ~ 4 hours |