Upload

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-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.

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