External database enrolment: Difference between revisions
From MoodleDocs
Helen Foster (talk | contribs) (when enrolment happens) |
(Added roles and synchronization information) |
||
| Line 1: | Line 1: | ||
You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, | You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, a field containing a user ID, and optionally a field containing a role. These are compared against fields that you choose in the local course, user tables, and role tables. | ||
Supported data sources | Supported data sources | ||
| Line 32: | Line 32: | ||
External database enrolment happens at the moment when a user logs into Moodle. An easy way of checking how it's working is to try logging in as a student. External database enrolment also manages unenrolment. | External database enrolment happens at the moment when a user logs into Moodle. An easy way of checking how it's working is to try logging in as a student. External database enrolment also manages unenrolment. | ||
You may synchronize all enrolments by executing the enrol_database_sync.php script. This assumes that you have already synchronized all users from your authorization plugin. | |||
==See also== | ==See also== | ||
Revision as of 19:42, 8 December 2006
You may use a external database (of nearly any kind) to control your enrolments. It is assumed your external database contains a field containing a course ID, a field containing a user ID, and optionally a field containing a role. These are compared against fields that you choose in the local course, user tables, and role tables.
Supported data sources
- access
- ado
- mssql
- borland_ibase
- csv
- db2
- fbsql
- firebird
- ibase
- informix72
- informix
- mysql
- mysqlt
- oci805
- oci8
- oci8po
- odbc
- odbc_mssql
- odbc_oracle
- oracle
- postgres64
- postgres7
- postgres
- proxy
- sqlanywhere
- sybase
- vfp
External database enrolment happens at the moment when a user logs into Moodle. An easy way of checking how it's working is to try logging in as a student. External database enrolment also manages unenrolment.
You may synchronize all enrolments by executing the enrol_database_sync.php script. This assumes that you have already synchronized all users from your authorization plugin.
See also
- Using Moodle MySQL enrolment plugin doesn't seem to work forum discussion
