From what you've just described, it sounds like this will be an annual event. Since there is no plugin that exist that will download each individual students assignment submissions + acquire their grade for every course, have a suggestion ...
since you are moving from Linux to Windows, this would be the perfect time to test that migration. Once one gets a dev site migrated to the other platform, think you'll see that platform makes no difference ... student files are in the sea of files called 'filedir' and not stored by any humanly recognizable name. Someone will still have to query the DB to find the contenhashed file names and their humanly recognizable names and script a way to extract those files while one might also have to change the file names so that their are re-cognized as belonging to the student. You'll also have to query the DB for a grade. Once you have both, the files you can store again but what of the meta data ... the grade/assignment title, details to the assignment, the teacher involved, etc..
Even if one programmed all that, one ends up with a specialized mini-moodle site just for the purpose of archiving.
Seems like a lot time and expense there.
Might be easier to clone active site and archive it ... set it up so that it's internal to private network only, read only, no student access any longer, no teacher access any longer, only admins .... access when needed.
How many request for such information does your entity get in one year?
There's a college on the west coast that spins up a new moodle every academic year ... the previous year is still on line but in an 'archived' setup/state. Teachers and Students can still access for one year but cannot change anything. Site then restricted even more after that one year ... no teacher/student access ... only admins. Am guessing at the end of 10 years, they can finally delete.
And to throw a real monkey wrench into the mix .... got any students from the EU in there?
my 2 cents! ;)
'spirit of sharing', Ken
it was an annual event and I'm trying to kill it because Moodle is now too large to be doing that sensibly and the assignment tool too popular.
So basically not a migration - brand new install instead. An opportune time to get rid of the clutter!
I have seen the idea - new year new Moodle, which if we stay on windows would be doable, but really how much data can we support? At the minute we tend to keep live and the last academic year and that's it, but should we have more?
Now looking to the future what I would dearly like to know is what is everybody else doing to meet the needs of keeping assessment data that went into Moodle for the unspecified length of time that an awarding body might want it for and just to top it off - yes currently we are in the EU and have signed up to GDPR. This however is a question for a whole new post and a different forum I suspect!
I think it will have to be visit each and every assignment for this year and have a better plan for next.
Do you have enough space to setup an automated backup run saving course backups as full (including users, assignments, etc.) to a designated area .... NOT the sea of files in moodledata/filedir/ Designated area could be a mount point to some large archival server you have internally.
When a student/or whomever request info concerning a course/grades/assignments info etc. restore the course to a locally installed Windows version that's the same as current on the linux box.
Just in case of the unfortunate event you cannot kill this practice, think it would be an exercise for the Windows IT staff supporting you to see what could be done on that platform.
The reason I mentioned GDPR, one could use that, I think, to generate what you might need for an individual student. Right now that exports into json files, but, according to Moodle HQ and brief discussion on outputs that any student could use, working on that in future updates to 3.5.
Best of luck!
'spirit of sharing', Ken
thank you. Hadn't thought about the GDPR tool for extracting. Might be useful in the future.
I do have space and I have used Moosh to run backups of all the courses, so I have that.