We have installed Moodle for many high schools and we handle course creation and enrollment using external database plugin.
Here is what we try to do with this plugin:
1) Entrollment should add/remove students from courses of the current year
2) Students should have access to their courses from past year
Here is the problem. During the firsts weeks of the year, many students are moved from one course to the other. So if a student is moved from cours A to course B, we would like to unenroll this student from course B. Since the external DB only contains enrollment of the current year, if we specify to delete enrollment that are not in the external DB anymore, it will completely wipe all enrollments from past years.
The only solution I see is to modify the enrol/database plugin to "import by year". Not sure how to implement that.
Am I the only one looking for something like that? I sometime feel like I'm the only one importing a huge number of course and student over many years. If not, I would appreciate you share you setup