exporting a list of courses in csv format

Re: exporting a list of courses in csv format

by Peter Bowen -
Number of replies: 0
If you have direct access to the database, you can get the info from the mdl_courses table. Otherwise, try the configurable reports block, which can assist here.
For example, I have the following in my arsenal of reports which has exactly this.

Select c.id, c.fullname, c.shortname, c.idnumber, cc.name as category, c.enablecompletion

FROM prefix_course AS c
INNER JOIN prefix_course_categories AS cc
ON cc.id = c.category



Cheers
Peter
Average of ratings: Useful (6)