1. Create the CSV file:
- Open a spreadsheet program (like Excel or Google Sheets).
- Include the following headers in the first row:username, email, and additional columns for the information you want to update (e.g., course1 for course enrollment).Example: If you want to enroll users in a course, add the short course name under the course1 column.Ensure that all details (e.g., usernames, course names) are correct and match the Moodle system data.
- Once all user information is added, save the file as a .csv file.
2. Upload to Moodle:
- Navigate to Site administration.
- Click on Users.
- Under Accounts, select Upload users from the options.
- Click Choose a file, select the .csv file you created, and click Upload users.
3. Map CSV Fields:
- Ensure that the fields from your .csv file are correctly mapped to Moodle fields (username, email, course1).
4. Adjust Upload Settings:
- In the settings, under Upload type, choose "Update existing users only".
- For matching criteria, set Match on email address to "Yes".
5. Complete the Update:
- Click Upload users to start the process.
- Moodle will process the CSV and update user accounts as specified in the file.