Extracting a Course Catalog

Extracting a Course Catalog

by Birgit Scott -
Number of replies: 3

I'm part of a group that uses Moodle 3.2.2 to administer a library of courses in the form of media files, audio and video.

My problem is that the courses' recordings span many languages and are therefore also used by for example Greeks, Tibetans and Chinese, who very often, due to their different alphabets, have a hard time reading English. The course descriptions are all in English.

I wonder if it's possible to extract and download a formal course catalog, stating for example the category, course name and course description, which then could be translated into all these languages. 

I could then link to these catalogs on the front page.

Thank you so much, 

Birgit

Average of ratings: -
In reply to Birgit Scott

Re: Extracting a Course Catalog

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

As nobody else has answered... I would just point out that most if the info you want is quite simply contained in the 'mdl_course' table in the database.

Average of ratings: -
In reply to Howard Miller

Re: Extracting a Course Catalog

by Marcus Green -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

If you know a little sql (or know someone who does) These diagrams may help explain how to extract the course information. One way of doing this is to install the Ad-Hoc query plugin which allows the creation of queries through the web interface but prevents any updates.

http://www.examulator.com/er/

http://www.examulator.com/er/components/course.html

This may also help

https://docs.moodle.org/33/en/ad-hoc_contributed_reports


(Though as Howard says, all/almost all the important information may be in that one table)


Average of ratings: -
In reply to Marcus Green

Re: Extracting a Course Catalog

by Birgit Scott -

Thank you so much.

Unfortunately, I don't know sql, so I'll have to look into that.

So much to learn...

Average of ratings: -