Three days - three tasks in support of my moode site

Its Wednesday, and these are the  things have happened this week in support of my moodle site.  This site uses 3rd party commercial vendor software.  AccelerateU.org - student courses.

1 - "James, we have a student, little missy sue who is claiming to her teacher and coach that she has taken Unit exams but the results must to have saved."

2 - "James, there is a course that seems to be missing content, Unit 2 content to be specific.  this was pointed out by a student"

3 - "James can we remove the enrollment for jimmy jam in course xyz, he has dropped"

For the first request.  I logged into the site as admin, browsed the course and checked the exams - of which there are a lot and verified which little missy sue had completed.  As advertised, there was no result for 3 of the Unit exams.  I used the Site Admin | Reports | logs and drilled down into the course in question and the student in question.  I generated a 500 page report of all the actions missy sue had taken in the course.  then I exported the report to Excel and used it to filer the 500 records to only show quiz attempts - which was very helpful.

For  # 2.  I browsed to the course, verified what was described to me, missing content link for unit 1.  Restored a back up of that course - so I could copy paste the URL value, then added a new URL resource/activity to the course - using the link provided and problem solved.

For # 3.  We have an external system where enrollments are managed from.  The system does not have an automatic push into the moodle side for enrollments - because my customer has made mistakes in the past with removal of the wrong records.  I manually go into the integration_enrollments table and remove the record - then run the cron script that does a pull from the integration table - and when it does not find the record - removed it from the moodle course.  I will probably turn this automation on once we do our site upgrade from moodle 2.2 - 2.6.10 next month.  There is an option in moodle 2.6 that says re-enroll student and keep grades.  If that does what I think it will, when the automation is on and my customer removes an enrollment and then says "oh wait, wrong one" - I can simply add the enrollment back, using my backup of the integration_enrollment table, and the progress should be fine.  Hope that makes sense to somebody other than me.

James - signing off.