Extracting a Course Catalog

Extracting a Course Catalog

由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

評比平均分數： -
In reply to Birgit Scott

Re: Extracting a Course Catalog

由Howard Miller發表於
Core developers的相片 Documentation writers的相片 Particularly helpful Moodlers的相片 Peer reviewers的相片 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.

評比平均分數： -
In reply to Howard Miller

Re: Extracting a Course Catalog

由Marcus Green發表於
Core developers的相片 Particularly helpful Moodlers的相片 Plugin developers的相片 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)


評比平均分數： -
In reply to Marcus Green

Re: Extracting a Course Catalog

由Birgit Scott發表於

Thank you so much.

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

So much to learn...

評比平均分數： -