Gradebook

I'm beginning this thread to discuss how we ought to move toward migrating the GBPv2 data from Moodle 1.8 to 1.9. I have started to play with some SQL queries and figured that sharing my thoughts (I would not call it progress yet) might be helpful as we work toward this. Please keep in mind that these queries are intended to only show the relationship beween the tables so that we can work out a migration plan. They are not intended to be run on a production site. My typical warning of using it in so far as it is helpful and avoiding it in so far as it is not certainly applies. With that said, I see the migration as involving 2 steps. Migrating the grade events (1.8) to grade items (1.9) and grade event grades (1.8) to grade grades. What may complicate things or what I am least clear on at this point is moving from grade category (1.8) to grade categories (1.9). For now, I am ignoring the issue of categories.

To move the grade events to grade items I am thinking of doing something like:

INSERT INTO mdl_grade_items (courseid, categoryid, itemname, itemtype, iteminfo, idnumber, grademax, grademin, timecreated, timemodified)
SELECT gi.courseid as courseid, gi.category as categoryid, ge.name as itemname, 'manual' as itemtype, ge.description as iteminfo, concat ('GBP-',ge.id) as idnumber, ge.grade as grademax, 0 as grademin, ge.timemodified as timecreated, ge.timemodified as timemodified
FROM mdl_grade_item as gi, mdl_grade_events as ge
WHERE gi.courseid=ge.course AND gi.modid=0 AND gi.cminstance=ge.id;

n.b. - We need to make sure that the categoryid is correct - I have not looked to see how the data is getting mapped in the 1.8 to 1.9 upgrade.

I have used the grade event (1.8) id field concatenated with the GBP- string as the id number to easily identify the item as a GBP item and to provide a way to easily link the items (1.9) and assign the grades.

INSERT INTO mdl_grade_grades (itemid, userid, usermodified, finalgrade, timecreated, timemodified)
SELECT gi.id as itemid, geg.userid as userid, geg.teacher as usermodified, geg.grade as finalgrade, geg.timemarked as timecreated, geg.timemarked as timemodified)
FROM mdl_grade_events_grades as geg, mdl_grade_items as gi
WHERE replace(gi.idnumber,'GBP-','')=geg.event;

I have not tested these queries out yet but wanted to get some conversation and ideas out there as I know that some folks are chomping at the bit to get started. I appreciate any feedback, questions, critiques, etc. Peace - Anthony