Creating the CSV
Open a blank spreadsheet, and create the CSV.
Note: Fields MUST ALWAYS be in lowercase.
- When adding a user to multiple groups in the same course, put them on a seperate line with the same details apart from group1, which has the new group like in the sample.
- Multiple courses can be added on the same line using course1,course2 etc. This also works with cohorts using the same method.
- Usernames should only be either lowercase or numerical
Uploading the CSV
Once you have created the CSV, go to Administration > Site administration > Users > Accounts > Upload users and add the file into the upload field.
check the settings and default user profile settings
The User type dropdown: The main way that determines how and which users are affected.
Add new and skip existing users: Will only add new users on the CSV that aren’t in the system
Add all and append usernames as needed: Adds all users and will make any changes to their username.
Add new and update existing users: Adds new users to the system and also updates existing users with new information you add
Update exisiting users only: Only updates existing users with the new information and skips new users.
New user password dropdown: Affects passwords
Field Required in File: Requires a “password” heading on the CSV containing the user’s password
Create password if needed: Creates a temporary password and sends the users a welcome email (Only works when adding new users)
Existing user details: Affects the details of existing users being updated
No Changes: No changes made to existing users
Override with file: The CSV overrides the details of the existing user
Override with defaults: Overrides existing user’s data with default data
Fill in missing with file with defaults: Fills existing user data with the CSV files and default information
Existing password: Affects the password of the existing user if set to Update
Allow reanames: Allows renaming of existing users if the CSV contains the oldusername and newusername fields, which contain the old and new usernames
Allow suspending and activating of accounts: Suspends or activates users if set to yes and the file contains a suspended field containing a 0 (No) or 1 (Yes)
Prevent email address duplicates: If set to no and you have set your system up to allow users with the same email address, this will allow the same email address.
Standardise username: If set to yes, the username will be converted to the default standard (lowercase and numbers only). Is it not recommended you don’t do this.
To upload the users, click "Continue"
An example CSV file can be found attached: demoaccounts.csv