I have an external MS SQL registration database that I would like to use to create new users in Moodle and enroll them in their proper courses. I have read-only access.
I've tried using the external database enrollment plug in, but it appears that it can only pull data from a single table. Is that really true, or am I missing something? My registration database uses multiple tables and I need Moodle to import data from several of them. There must be a way to do this. Can I use the external enrolment plug-in, or do I need to go another route?
Not everyone in my external database should be imported to Moodle. For example, I want only students who have already paid their tuition and who are enrolled only in certain courses. Should I try to write a script that creates a single table populated only with students who meet a certain criteria, and use the new table to enroll users in Moodle? How would I go about doing that? I have read-only access to the external database, so would I need to create a new MySQL database to create the single table?
I'm a front end web developer with only a basic understanding of database connections and queries, but I'm willing to learn. If someone wouldn't mind giving me some guidance or walking me through the process, I'd be SO grateful!
Kimber