Uploading Users into Moodle for Placement Tests

File Template

You must populate the following file template before uploading users into Moodle:

moodle user upload template

209 Byte

The following columns exist in the file template:

Column Name	Description
username	Student’s username
firstname	Student’s first name (preferred is fine)
lastname	Student’s last name
email	Student’s email address
password	Value provided in file - no need to change.
course1	Value provided in file - no need to change.
group1	Value provided in file - no need to change.
course2	Value provided in file - no need to change.
group2	Value provided in file - no need to change.
auth	Value provided in file - no need to change.

Copy and paste the student’s username, firstname, lastname and email address (will be the same as username) from another spreadsheet.

Save the spreadsheet.

Click “Login” in the upper-right corner.

Click “Site Administration” > “Users” > “Upload users”.

Drag and drop the moodle user upload template.csv from your computer into the highlighted box and click “Upload users”.

Check the preview rows to verify the data will be entered correctly.

Change the Settings to the following:

Setting Name	Value
Upload type	Add new and update existing users
New user password	Field required in file
Existing user details	Fill in missing from file and defaults
Force password change	None
Match on email address	No
Allow renames	No
Allow deletes	No
Allow suspending and activating of accounts	Yes
Standardize usernames	Yes
Select for bulk user actions	No

Click “Upload users”.