I know I can access each teacher profile directly using a URL such as http://bsschool.org/moodle/user/view.php?id=15 but is there a page that lists all teachers and courses?
I've using version 1.8.2
Is this an option if I upgrade? I tried to upgrade but when I access the /moodle/admin/ page it was blank after the upgrade.
Did you find a solution ?
I'm also looking for a functionality allowing to list all teachers.
In our system, we have not assigned the roles at the system level but in each course.
It works very well in the 1.9 version of Moodle. As an administrator, you can go to Accounts, Bulk user actions, Advanced, click on the roles and chose teacher from the dropdown and all categories in the categories box... the search will list all the accounts that are listed as teachers in any class in the site.... then you can move the list into the selected window and go to the bottom of the screen and click on "With selected users " window and select either download or show on screen.
I've tried the steps you outlined and it does output a list of all users assigned the Teacher role.
Alas, it does not also display the list of courses where the user is assigned as Teacher in.
Might anyone know of a solution?
Thanks in advance
If you have access to the database you can run this query, I use it quite often:
SELECT distinct c.id, c.fullname, u.username, u.firstname, u.lastname FROM mdl_course as c, mdl_role_assignments AS ra, mdl_user AS u, mdl_context AS ct WHERE c.id = ct.instanceid AND ra.roleid =3 AND ra.userid = u.id AND ct.id = ra.contextid;This assumes your Teacher role id is '3'.
I hope this helps