Hi Gabi...
It sounds I'm in need of the same as yourself. extra data being what course they are in and the trainers / groups name. Have you had any luck.?
It is weird that if you upload a file, you can put in the additional fields like course1, Group1 etc.. but the download doesn't contain these.
It sounds I'm in need of the same as yourself. extra data being what course they are in and the trainers / groups name. Have you had any luck.?
It is weird that if you upload a file, you can put in the additional fields like course1, Group1 etc.. but the download doesn't contain these.
In reply to Mark Fellowes
Ri: Re: Ri: Re: Ri: Re: Download list of all students in a course
由Gabri Z發表於
In reply to Gabri Z
Re: Ri: Re: Ri: Re: Ri: Re: Download list of all students in a course
由Rick Jerz發表於
By the way, the Configurable Reports plugin helps you "manage" SQL queries. Someone still needs to "create" the queries.
I find Moodle's built reporting and the ability to download data quite good, perhaps extensive when you compare it to other popular LMSs, like Canvas and Blackboard. And the ability to access the data with custom SQL gives me far more power than with either Canvas or Blackboard. My school uses Canvas, which is extremely weak at reporting data (can't even sort a list of participants by first name, last access, etc.)
I find Moodle's built reporting and the ability to download data quite good, perhaps extensive when you compare it to other popular LMSs, like Canvas and Blackboard. And the ability to access the data with custom SQL gives me far more power than with either Canvas or Blackboard. My school uses Canvas, which is extremely weak at reporting data (can't even sort a list of participants by first name, last access, etc.)
In reply to Gabri Z
Re: Ri: Re: Ri: Re: Ri: Re: Download list of all students in a course
由Mark Fellowes發表於
Gabri...
I received this query which does exactly what I need and may also help you.. just remove the hardcoded userid to get a list of all the students in each of the groups..
SELECT DISTINCT usr.id, usr.username, usr.email, usr.firstname, usr.lastname, c.id as idnumber, c.shortname as course1, groups.name as group1
FROM course_course AS c
INNER JOIN course_context AS cx ON c.id = cx.instanceid
AND cx.contextlevel = '50'
INNER JOIN course_role_assignments AS ra ON cx.id = ra.contextid
INNER JOIN course_role AS r ON ra.roleid = r.id
INNER JOIN course_user AS usr ON ra.userid = usr.id
INNER JOIN course_groups AS groups ON c.id = groups.courseid
INNER JOIN course_groups_members AS members ON groups.id = members.groupid
WHERE members.userid = usr.id
and usr.id = 8912
ORDER BY `c`.`id` ASC
I received this query which does exactly what I need and may also help you.. just remove the hardcoded userid to get a list of all the students in each of the groups..
SELECT DISTINCT usr.id, usr.username, usr.email, usr.firstname, usr.lastname, c.id as idnumber, c.shortname as course1, groups.name as group1
FROM course_course AS c
INNER JOIN course_context AS cx ON c.id = cx.instanceid
AND cx.contextlevel = '50'
INNER JOIN course_role_assignments AS ra ON cx.id = ra.contextid
INNER JOIN course_role AS r ON ra.roleid = r.id
INNER JOIN course_user AS usr ON ra.userid = usr.id
INNER JOIN course_groups AS groups ON c.id = groups.courseid
INNER JOIN course_groups_members AS members ON groups.id = members.groupid
WHERE members.userid = usr.id
and usr.id = 8912
ORDER BY `c`.`id` ASC