Mass import: Connect users

Updated 2 years ago by Olivier

If you have many users to create at once, you can import them directly into Connect to save time.

The file must be a CSV file format (in excel save as ‘CSV’)
- A template has been provided as an example on Connect.
The users list must be the first worksheet (Sheet 1).
- A CSV will only have one sheet.
- If converted from an excel file there might be more worksheets
The users list must contains:
- User name
- Full name
- Email
- Role Name
- Group Name
The sample file contains a top (header) row in the CSV. You should not remove this row. Place your first user in the row below.

Select ‘Import’ in the Users page
Then click on "Browse" (1) in the import Users page
Browse for the correct file
Once you have chosen a file to import, you will need to specify the web user settings (2)
Click on "Import" button (3)

Once the import is complete the summary shows:

Total records contained in the file
Total records imported
Total invalid records
There is also a section dealing with invalid records. Pressing the button highlighted below enables you to download the records that have failed.

This import method only allows the creation of users that do not currently exist on the system. Therefore it is assumed only new users will be added.