- Download the CSV template .
- Open the CSV file in your preferred spreadsheet program.
Enter the External Users' details – for example:
Usercode Password First Name Last Name Department Group Name xx_akurten wordpass1 email@example.com Anette Kurten IT Services Green Festival Guest Speakers xx_jdasilva wordpass2 firstname.lastname@example.org John Da Silva IT Services Green Festival Guest Speakers xx_abamagh wordpass3 email@example.com Alfred Abamagh IT Services Green Festival Guest Speakers
- The naming convention for Usercode is your two-letter department code followed by an underscore, first initial and surname – for example, cu_akurten. To avoid clashes with student and staff University IDs, it must contain at least eight characters.
- In the Department column, enter the name of the department the External User works for or, if applicable, the group or project they're involved in. This field helps you identify your External Users.
- To add the External Users to an existing group, the Group Name in your CSV file must match the group name in the External Users system. Alternatively, if you want to create these External Users in a new group, leave the Group Name column blank; you can create a new group during the upload.
- Go to the External Users system at https://ext-users.warwick.ac.uk.
- Under Actions, click Upload users in bulk.
- Click the Browse/Choose file button and select your CSV file.
- In the Department box, enter the default department name. Any External Users in the CSV file with no value for Department use the default name.
- Specify the expiry date for the External User codes.
Select one of the following radio buttons to specify a group to upload the External Users to:
- Use an existing group – select the group from the Add to drop-down menu
- Use groups in a CSV template – upload to the groups defined in your CSV file
- Create a new group – type a name for the new group
- Once you have finished entering the options, click the Upload button.
On the Import users screen, you see a preview of the CSV file contents. If the data is accurate, click the Import button; otherwise, click Back, amend your CSV file and repeat steps 6-10.
Email webteam at warwick dot ac dot uk