...
Delimiters
You can choose to use a comma, semi-colon, colon or vertical bar as the delimiter between a specified User and Space Group for CSV File import/Export.
File Import
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
| Code Block |
|---|
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:
...
The Delegated group actions permitted field can be found within the CSUM Configuration.
| Info |
|---|
Space groups that are set to be manipulated within the CSV must already exist within the current Space that the bulk operation is set to take place |
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 |
File Export
Supported from version 4.0.6, a CSV (comma separated values) formatted file can be exported to analyse Space groups and their users.
| Info |
|---|
Only Space Groups with users will appear within the File Export CSV |
As long as the process is successful, a CSV file will be downloaded for you to observe which will appear in the same format as the File Import requires, for example:
csum-example.csv
| Code Block |
|---|
ajones,space-group1
fsmith,space-group1
tjenkins,space-group2
dharris,space-group2
nprice,space-group3 |
This allows you remove certain users and their associated groups, seperated by the chosen delimiter, and then use the resulting CSV to directly perfom a CSV import task to add or remove users and the associated group within the CSV, if desired.