Changing the settings for every assignment in a course

Changing the settings for every assignment in a course

by Richard Pinner -
Number of replies: 1

Hi there - is there a way to batch change the settings for assignmnets. I have over 100 assignments spread over 5 courses and I need to change them all from "email teachers" to "don't email teachers" and I was hoping there is a quick way to do this without having to go into each one individually.

Many thanks in advance!

Average of ratings: -
In reply to Richard Pinner

Re: Changing the settings for every assignment in a course

by Eduardo Hernandez -

By using Moodle interface I don't think so. You can do it by manipulating the Moodle database directly (handle with care!).

If you want to change this setting for all of the assignments, you could do execute the following SQL statement:

UPDATE mdl_assignment SET emailteachers=0 WHERE course IN (23,45,26)

23,45,26 are examples of courses id, you can change them with your own courses id.

This instruction will set emailteachers to "NO" for all of the assignments belonging to courses in the list.