Hi there,
Our school admin system is built on MySQL. I've created a view in MySQL that creates a table based on the pupil's username, their role and the course, and a field indicated by a subject short-code and the grade and class description, e.g. "Mat9B". These are the only three fields that can be mapped.
How can I map a description to the course name ("Grade 9B Mathematics") and set other course variables? For example, I would be nice to set the course description to "Welcome to the course page for Grade 9B Mathematics. Your teacher is Mr John Smith. This class is taught in venue A1." -- all of which I can build up in my database view quite easily.
I can also get the admin system to determine whether a course is currently running or not and thus show/hide it based on that -- in theory.
I assume that this is not currently possible? I have not programmed any Moodle modules before, but I'd be keen to give it a go: can anyone point me in the right direction?
Thanks!
Philip
In reply to Philip Norton
Re: Mapping other fields from a DB when courses are created
by Iñaki Arenaza -
There is a patch for the database enrolment plugin that offers a couple of additional fields to map: shortname, fullname, summary and category.
You can get the patch from http://orodruin.escomposlinux.org/~iarenaza/moodle/enrol_db/
Saludos. Iñaki.