Up: Open Administration for Schools
Previous: Maintenance
Subsections
OA can integrate with Moodle in several ways:
- It can authenticate students for login using their OA
credentials (student number and password).
- It can automatically enrol students into their courses in Moodle
when enrolled in the matching course in OA.
It can do this by using the 'External Database' option for both
authorization and enrollment. The authorization process can use the
student table directly. The eval table which holds student
report card marks indicates their subject-section enrollment however
cannot be used since it has a record for every term and no 'role'
field. A new table called ext_moodle is used for the external
program Moodle to read. It is maintained by the enrolment script in
OA. The next section outlines how to set this up in Moodle.
Authorization is setup in Moodle by:
- Login as administrator.
- Under Site Administration, choose Users, Authentication, Manage
Authentication.
- Turn on the Eyecon for 'External Database', and move it up as
far as possible using the up arrow beside the eyecon.
- Configure the external database by clicking on 'Settings'.
- Set DB Name, DB User, and Password to the values used by your
school's OA database.
- Set Table to 'student', Username field to 'studnum', Password
field to 'password', Password format to 'Plain Text' (default).
- In the lower 'Data Mapping' section, more fields may be set
also.
- Set First Name to 'firstname', Surname to 'lastname', Email to
'email', City/town to 'city1', ID Number to 'studnum'. Others may be
set also, as desired.
- Click on 'Save Changes', to save these values.
Enrolment is setup in Moodle by:
- Login as administrator.
- Under Site Administration, click Courses, then Enrolments.
- Click 'Enable' for the External Database.
- Configure the external database by clicking on 'Edit' in the
settings column.
- In the first section called External Database Server Settings,
set the following to allow Moodle to connect to your school database
and the ext_moodle table.
enrol_dbtype: |
mysql |
enrol_dbhost: |
localhost |
enrol_dbuser: |
Your Server user |
enrol_dbpass: |
Your Server password |
enrol_dbname: |
Your School Database name |
enrol_dbtable: |
ext_moodle |
- In the next section called Enrolment (remote) Database Fields,
set the following values:
enrol_localcoursefield:idnumber |
|
enrol_localuserfield:username |
|
enrol_db_localrolefield:shortname |
|
enrol_remotecoursefield:subjsec |
|
enrol_remoteuserfield:studnum |
|
enrol_db_remoterolefield:role |
|
- The rest of the values may remain as is (or as desired).
- Click on 'Save Changes', to save these values.
Up: Open Administration for Schools
Previous: Maintenance
2016-06-02