How to Add a List of Users
For users with administrator permission.
While users can be added manually one at a time, you can also import spreadsheets of users to save time on user entry.
Preparing the User Import CSV File
To prepare your import, download a sample CSV user file or use Excel or another program to create a CSV document in the following format. CSV stands for Comma Separated Values. It is a standard spreadsheet/database file type for exchanging information.
File Type: CSV
Format: Header row followed by data values rows with user details
Header Row: Organize your data into the following column headers in this exact order:
username, first_name, last_name, role_group, send_email
- username: The email address of the user you wish to add.
- first_name: First name of the user.
- last_name: Last name of the user.
- role_group: (administrator or user) Role you would like to assign this user.
- Administrators will be added to Scorecard and Compyle with Administrator permission
- Users will be added to Scorecard with Presenter access
- Users will be added to Compyle with Creator access
-
Any additional permissions or restrictions for users in Scorecard or Compyle will need to be set in user management tool for the appropriate application.
- send_email: (true or false) Send user a welcome email with login instructions.
You will have the option to individually send welcome/password reset emails to users after import.
To import users
- Open Control.
- Expand the Users menu.
- Select the Import Users option.
- When the Import Users page opens, click the Download Sample File button.
- Open the sample file.
- Enter the users in the sample file or use a previously prepared CSV file in the correct format.
- Choose your file.
- Run the import.
- When the import completes you will be prompted to download an Excel spreadsheet with the new users' passwords and IDs (usernames).
Troubleshooting Tips
- File format MUST be .CSV
- The column names and order must match exactly for the import to work
- Be sure to include the header row