Course Data Extraction

Course Data Extraction

Richard Beazley發表於
Number of replies: 4
Hi all.

I am performing a 'content audit' before we move to a new platform to see what needs to be migrated and what can be archived as it has not been used/accessed in some time.

Is there a report or log that lists the files and modules that are used within each course.  I don't have ready access to SQL so ideally something already available in the system would be most helpful.

Thank you.
評比平均分數: -
In reply to Richard Beazley

Re: Course Data Extraction

Mary Cooch發表於
Documentation writers的相片 Moodle HQ的相片 Particularly helpful Moodlers的相片 Testers的相片 Translators的相片
Just moving your post to the Analytics and reporting forum where you'll hopefully get more specialised help 微笑
評比平均分數:Useful (1)
In reply to Richard Beazley

Re: Course Data Extraction

Shirley Gregorczyk發表於
Particularly helpful Moodlers的相片
Are you on Moodle 4.+? Report Builder module, in Site Admin>Reports menu has some of the items you seek. But maybe not everything.
Kind Regards
In reply to Shirley Gregorczyk

Re: Course Data Extraction

Richard Beazley發表於
Hi Shirley.

Open LMS EDU 4.1 MP4 (Build: 20240208)

I have tried looking into Reports and Logs and while I can extract course details and a complete list of files within our system I can't find anything that provides the name of the course to which a file is linked.

Hope that makes sense.
In reply to Richard Beazley

Re: Course Data Extraction

Ken Task發表於
Particularly helpful Moodlers的相片
Moodle files can be used in multiple courses.
They are owned by a user.

mysql -u $mddbuser -p$mddbpass -e "use $mddbname;select id,userid,contenthash,filename,filearea,filesize from mdl_files" > moodlefiles.txt

contenthash value is really the location in moodledata/filedir/ as well as
the name of the file.

'SoS', Ken