Upload
- Vladyslav Zacharko (Unlicensed)
Making bulk add/remove changes via CSV file upload
You can upload a CSV (comma separated values) formatted file in order to add or remove large numbers of users in one operation. To use this feature, first navigate to the "Upload" tab of the PUM project administration view.
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 with the delimiter (how you want to separate the data), click the "browse" button to select a CSV file from your file system.
PUM 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:
pum-example.csv
ajones,project-group1
fsmith,project-group1
tjenkins,project-group2
dharris,project-group2
nprice,project-group3When 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.
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 |