Moodle 3.5 Student table update

Moodle 3.5 Student table update

by Peter Koel -
Number of replies: 1

Hello,

     I have about 648 students in a spreadsheet, organized by their Moodle user ID (the email of the student). I want to updated the Department field for all of these students. We are using SQL Server as the Moodle database. Is there a better way than going into each profile and editing the Department field? Can I do an SQL Update? If so, how?

Thanks,

Peter

Average of ratings: -
In reply to Peter Koel

Re: Moodle 3.5 Student table update

by AL Rachels -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

Hi Peter,

Since you already have the  data in a spreadsheet, save the spreadsheet as a .csv and then upload it to your Moodle site with the the upload set to update existing users.

You will need to make sure the column headings are those mentioned in the directions for uploading: https://docs.moodle.org/37/en/Upload_users#File_formats_for_upload_users_file

Average of ratings: Useful (1)