Test Case Description: I created a new blank installation of Moodle on Windows 2003 Server, IIS 6, MSSQL 2005 and Moodle 1.9.5+ Build: 20090930. I have 2 users: Admin & Student. I have 1 course with just 1 quiz in it. I want to test this: IMPORT some quiz results. Then attempt to write the quiz in Moodle. Does the gradebook show the result of the attempt that was done in Moodle? Result: The Grader Report does NOT display the result of the ONLINE attempt - it still shows the CPS result! Is this a bug? --------------------------------------------------- Status: Added a Student user, created a course and a quiz. Now I'm ready to import CPS results from a CSV file. At this stage there are no submissions and no CPS data has been imported. The database tables have this data in them: SELECT * FROM mdl_grade_grades * EMPTY * SELECT * FROM mdl_grade_grades_history * EMPTY * SELECT * FROM mdl_quiz_grades * EMPTY * SELECT * FROM mdl_quiz_attempts * EMPTY * SELECT * FROM mdl_grade_items_history id action oldid source timemodified loggeduser courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder hidden locked locktime needsupdate 1 1 1 system 1254228069 NULL 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 1 2 1 2 NULL 1254228130 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 10.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 3 2 2 NULL 1254232465 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 SELECT * FROM mdl_grade_items id courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder display decimals hidden locked locktime needsupdate timecreated timemodified 1 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 NULL 0 0 0 0 1254228069 1254228069 2 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 NULL 0 0 0 0 1254228130 1254232465 SELECT * FROM mdl_quiz_feedback id quizid feedbacktext mingrade maxgrade 1 1 0 66 SELECT * FROM mdl_quiz_question_instances id quiz question grade 1 1 1 10 2 1 2 20 3 1 3 30 SELECT * FROM mdl_grade_outcomes * EMPTY * SELECT * FROM mdl_grade_outcomes_history * EMPTY * SELECT * FROM mdl_quiz_question_versions * EMPTY * SELECT * FROM mdl_quiz id course name intro timeopen timeclose optionflags penaltyscheme attempts attemptonlast grademethod decimalpoints review questionsperpage shufflequestions shuffleanswers questions sumgrades grade timecreated timemodified timelimit password subnet popup delay1 delay2 1 2 TestQuiz This is a Test Quiz used to debug the CPS import issue. 0 0 0 0 0 0 4 0 4652015 0 0 1 1,2,3,0 60 60 0 1254228130 0 0 0 0 SELECT * FROM mdl_grade_settings * EMPTY * SELECT * FROM mdl_grade_outcomes_courses * EMPTY * SELECT * FROM mdl_grade_letters * EMPTY * SELECT * FROM mdl_grade_import_values * EMPTY * SELECT * FROM mdl_grade_import_newitem * EMPTY * SELECT * FROM mdl_grade_categories_history id action oldid source timemodified loggeduser courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats 1 1 1 system 1254228069 NULL 2 NULL 0 NULL ? 11 0 0 1 0 0 2 2 1 system 1254228069 NULL 2 NULL 1 /1/ ? 11 0 0 1 0 0 SELECT * FROM mdl_grade_categories id courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats timecreated timemodified 1 2 NULL 1 /1/ ? 11 0 0 1 0 0 1254228068 1254228069 SELECT * FROM mdl_data * EMPTY * SELECT * FROM mdl_user id auth confirmed policyagreed deleted mnethostid username password idnumber firstname lastname email emailstop icq skype yahoo aim msn phone1 phone2 institution department address city country lang theme timezone firstaccess lastaccess lastlogin currentlogin lastip secret picture url description mailformat maildigest maildisplay htmleditor ajax autosubscribe trackforums timemodified trustbitmask imagealt screenreader 1 manual 1 0 0 1 guest 084e0343a0486ff05530df6c705c8bb4 Guest User root@localhost 0 en_utf8 99 0 0 0 0 0 This user is a special user that allows read-only access to some courses. 1 0 2 1 1 1 0 1254227653 0 NULL 0 2 manual 1 0 0 1 admin 21232f297a57a5a743894a0e4a801fc3 Admin User luis.devasconcelos@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 1254381227 1254318805 1254372926 163.202.46.187 0 1 0 1 1 1 1 0 1254227676 0 0 3 ldap 1 0 0 1 ldv2602 not cached Luis de Vasconcelos luis.devasconcelos@liberty.co.za 0 +27114083388 0721018732 Liberty Life Grp Employe Solution & Design LIB0826WEST ZA en_utf8 99 0 1254308760 0 1254308760 163.202.46.187 0 Liberty Corporate Benefits 1 0 2 1 1 1 0 1254308759 0 NULL 0 4 manual 1 0 0 1 student cd73502828457d15655bbd7a63fb0bc8 Moodle Student moodle.student@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 0 0 0 0 1 0 2 1 0 1 0 1254308891 0 0 --------------------------------------------------- Status: I've now imported the CPS results into Test Course using the .CSV file. I used these grade item mappings: Map from - username Map to - username username - ignore grade - TestQuiz The database tables now have this data in them: SELECT * FROM mdl_grade_grades WAS: * EMPTY * NOW: id itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat timecreated timemodified 1 2 4 NULL 100.00000 0.00000 NULL 2 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 NULL 1254382877 2 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL ************************************************************************************ NOTE: SHOULD rawgrademax be 100? Or should it be the actual MAX GRADE for the quiz? The way I understand it, it should be the actual MAX GRADE for the quiz. But this is a different bug/problem which I need to investigate separately... ************************************************************************************ SELECT * FROM mdl_grade_grades_history WAS: * EMPTY * NOW: id action oldid source timemodified loggeduser itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat 1 1 1 import 1254382877 NULL 2 4 NULL 100.00000 0.00000 NULL 2 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 2 1 2 system 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL NULL 0 0 0 0 0 0 NULL 0 NULL 0 3 2 2 aggregation 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 SELECT * FROM mdl_quiz_grades WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz_attempts WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz_feedback WAS: id quizid feedbacktext mingrade maxgrade 1 1 0 66 NOW: unchanged SELECT * FROM mdl_quiz_question_instances WAS: id quiz question grade 1 1 1 10 2 1 2 20 3 1 3 30 NOW: Unchanged SELECT * FROM mdl_grade_items_history WAS: id action oldid source timemodified loggeduser courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder hidden locked locktime needsupdate 1 1 1 system 1254228069 NULL 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 1 2 1 2 NULL 1254228130 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 10.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 3 2 2 NULL 1254232465 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 NOW: Unchanged SELECT * FROM mdl_grade_items WAS: id courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder display decimals hidden locked locktime needsupdate timecreated timemodified 1 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 NULL 0 0 0 0 1254228069 1254228069 2 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 NULL 0 0 0 0 1254228130 1254232465 NOW: Unchanged SELECT * FROM mdl_grade_outcomes WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_outcomes_history WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz_question_versions WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz WAS: id course name intro timeopen timeclose optionflags penaltyscheme attempts attemptonlast grademethod decimalpoints review questionsperpage shufflequestions shuffleanswers questions sumgrades grade timecreated timemodified timelimit password subnet popup delay1 delay2 1 2 TestQuiz This is a Test Quiz used to debug the CPS import issue. 0 0 0 0 0 0 4 0 4652015 0 0 1 1,2,3,0 60 60 0 1254228130 0 0 0 0 NOW: Unchanged SELECT * FROM mdl_grade_settings WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_outcomes_courses WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_letters WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_import_values WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_import_newitem WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_categories_history WAS: id action oldid source timemodified loggeduser courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats 1 1 1 system 1254228069 NULL 2 NULL 0 NULL ? 11 0 0 1 0 0 2 2 1 system 1254228069 NULL 2 NULL 1 /1/ ? 11 0 0 1 0 0 NOW: Unchanged SELECT * FROM mdl_grade_categories WAS: id courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats timecreated timemodified 1 2 NULL 1 /1/ ? 11 0 0 1 0 0 1254228068 1254228069 NOW: Unchanged SELECT * FROM mdl_data WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_user WAS: id auth confirmed policyagreed deleted mnethostid username password idnumber firstname lastname email emailstop icq skype yahoo aim msn phone1 phone2 institution department address city country lang theme timezone firstaccess lastaccess lastlogin currentlogin lastip secret picture url description mailformat maildigest maildisplay htmleditor ajax autosubscribe trackforums timemodified trustbitmask imagealt screenreader 1 manual 1 0 0 1 guest 084e0343a0486ff05530df6c705c8bb4 Guest User root@localhost 0 en_utf8 99 0 0 0 0 0 This user is a special user that allows read-only access to some courses. 1 0 2 1 1 1 0 1254227653 0 NULL 0 2 manual 1 0 0 1 admin 21232f297a57a5a743894a0e4a801fc3 Admin User luis.devasconcelos@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 1254381227 1254318805 1254372926 163.202.46.187 0 1 0 1 1 1 1 0 1254227676 0 0 3 ldap 1 0 0 1 ldv2602 not cached Luis de Vasconcelos luis.devasconcelos@liberty.co.za 0 +27114083388 0721018732 Liberty Life Grp Employe Solution & Design LIB0826WEST ZA en_utf8 99 0 1254308760 0 1254308760 163.202.46.187 0 Liberty Corporate Benefits 1 0 2 1 1 1 0 1254308759 0 NULL 0 4 manual 1 0 0 1 student cd73502828457d15655bbd7a63fb0bc8 Moodle Student moodle.student@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 0 0 0 0 1 0 2 1 0 1 0 1254308891 0 0 NOW: Unchanged --------------------------------------------------- Status: After importing the CPS results I logged in as the "student" user and tried to write the quiz in Moodle: My result: 56 out of a maximum of 60 (93%) So, the CPS file contained a grade of 50% and I got 93% for the Quiz attempt in Moodle. But, after submitting the quiz attempt the Gradebook still shows the CPS result instead of the quiz attempt result. First name / Surname TestQuiz Course total Moodle Student 30.00 50.00 Overall average 30.00 50.00 The Quiz results screen only displays the ONLINE attempt: 56/60 93% The database tables now have this data in them: SELECT * FROM mdl_grade_grades WAS: id itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat timecreated timemodified 1 2 4 NULL 100.00000 0.00000 NULL 2 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 NULL 1254382877 2 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL NOW: id itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat timecreated timemodified 1 2 4 56.00000 60.00000 0.00000 NULL 4 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 1254383775 1254382877 2 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL SELECT * FROM mdl_grade_grades_history WAS: id action oldid source timemodified loggeduser itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat 1 1 1 import 1254382877 NULL 2 4 NULL 100.00000 0.00000 NULL 2 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 2 1 2 system 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL NULL 0 0 0 0 0 0 NULL 0 NULL 0 3 2 2 aggregation 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 NOW: id action oldid source timemodified loggeduser itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat 1 1 1 import 1254382877 NULL 2 4 NULL 100.00000 0.00000 NULL 2 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 2 1 2 system 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL NULL 0 0 0 0 0 0 NULL 0 NULL 0 3 2 2 aggregation 1254382877 NULL 1 4 NULL 100.00000 0.00000 NULL NULL 50.00000 0 0 0 0 0 0 NULL 0 NULL 0 4 2 1 mod/quiz 1254383776 NULL 2 4 56.00000 60.00000 0.00000 NULL 4 30.00000 0 0 0 0 1254382877 0 NULL 0 NULL 0 SELECT * FROM mdl_quiz_grades WAS: * EMPTY * NOW: id quiz userid grade timemodified 1 1 4 56 1254383776 SELECT * FROM mdl_quiz_attempts WAS: * EMPTY * NOW: id uniqueid quiz userid attempt sumgrades timestart timefinish timemodified layout preview 1 1 1 4 1 56 1254383660 1254383775 1254383775 1,2,3,0 0 SELECT * FROM mdl_quiz_feedback WAS: id quizid feedbacktext mingrade maxgrade 1 1 0 66 NOW: Unchanged SELECT * FROM mdl_quiz_question_instances WAS: id quiz question grade 1 1 1 10 2 1 2 20 3 1 3 30 NOW: Unchanged SELECT * FROM mdl_grade_items_history WAS: id action oldid source timemodified loggeduser courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder hidden locked locktime needsupdate 1 1 1 system 1254228069 NULL 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 1 2 1 2 NULL 1254228130 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 10.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 3 2 2 NULL 1254232465 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 NOW: id action oldid source timemodified loggeduser courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder hidden locked locktime needsupdate 1 1 1 system 1254228069 NULL 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 1 2 1 2 NULL 1254228130 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 10.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 3 2 2 NULL 1254232465 NULL 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 1 4 2 2 NULL 1254384430 NULL 2 1 TestQuiz mod quiz 1 0 NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 0 5 2 2 NULL 1254384430 NULL 2 1 TestQuiz mod quiz 1 0 NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 0 6 2 2 NULL 1254384430 NULL 2 1 TestQuiz mod quiz 1 0 NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 0 7 2 2 NULL 1254384430 NULL 2 1 TestQuiz mod quiz 1 0 NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 0 0 0 8 2 1 NULL 1254384443 NULL 2 NULL course NULL 1 NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 0 9 2 1 NULL 1254384443 NULL 2 NULL course NULL 1 NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 0 10 2 1 NULL 1254384443 NULL 2 NULL course NULL 1 NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 0 11 2 1 NULL 1254384443 NULL 2 NULL course NULL 1 NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 0 0 0 SELECT * FROM mdl_grade_items WAS: id courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder display decimals hidden locked locktime needsupdate timecreated timemodified 1 2 NULL NULL course NULL 1 NULL NULL NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 0 NULL 0 0 0 0 1254228069 1254228069 2 2 1 TestQuiz mod quiz 1 0 NULL NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 0 NULL 0 0 0 0 1254228130 1254232465 NOW: id courseid categoryid itemname itemtype itemmodule iteminstance itemnumber iteminfo idnumber calculation gradetype grademax grademin scaleid outcomeid gradepass multfactor plusfactor aggregationcoef sortorder display decimals hidden locked locktime needsupdate timecreated timemodified 1 2 NULL course NULL 1 NULL NULL 1 100.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 1 12 NULL 0 0 0 0 1254228069 1254384443 2 2 1 TestQuiz mod quiz 1 0 NULL 1 60.00000 0.00000 NULL NULL 0.00000 1.00000 0.00000 0.00000 2 12 NULL 0 0 0 0 1254228130 1254384430 SELECT * FROM mdl_grade_outcomes WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_outcomes_history WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz_question_versions WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_quiz WAS: id course name intro timeopen timeclose optionflags penaltyscheme attempts attemptonlast grademethod decimalpoints review questionsperpage shufflequestions shuffleanswers questions sumgrades grade timecreated timemodified timelimit password subnet popup delay1 delay2 1 2 TestQuiz This is a Test Quiz used to debug the CPS import issue. 0 0 0 0 0 0 4 0 4652015 0 0 1 1,2,3,0 60 60 0 1254228130 0 0 0 0 NOW: Unchanged SELECT * FROM mdl_grade_settings WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_outcomes_courses WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_letters WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_import_values WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_import_newitem WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_grade_categories_history WAS: id action oldid source timemodified loggeduser courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats 1 1 1 system 1254228069 NULL 2 NULL 0 NULL ? 11 0 0 1 0 0 2 2 1 system 1254228069 NULL 2 NULL 1 /1/ ? 11 0 0 1 0 0 NOW: Unchanged SELECT * FROM mdl_grade_categories WAS: id courseid parent depth path fullname aggregation keephigh droplow aggregateonlygraded aggregateoutcomes aggregatesubcats timecreated timemodified 1 2 NULL 1 /1/ ? 11 0 0 1 0 0 1254228068 1254228069 NOW: Unchanged SELECT * FROM mdl_data WAS: * EMPTY * NOW: * EMPTY * SELECT * FROM mdl_user WAS: id auth confirmed policyagreed deleted mnethostid username password idnumber firstname lastname email emailstop icq skype yahoo aim msn phone1 phone2 institution department address city country lang theme timezone firstaccess lastaccess lastlogin currentlogin lastip secret picture url description mailformat maildigest maildisplay htmleditor ajax autosubscribe trackforums timemodified trustbitmask imagealt screenreader 1 manual 1 0 0 1 guest 084e0343a0486ff05530df6c705c8bb4 Guest User root@localhost 0 en_utf8 99 0 0 0 0 0 This user is a special user that allows read-only access to some courses. 1 0 2 1 1 1 0 1254227653 0 NULL 0 2 manual 1 0 0 1 admin 21232f297a57a5a743894a0e4a801fc3 Admin User luis.devasconcelos@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 1254381227 1254318805 1254372926 163.202.46.187 0 1 0 1 1 1 1 0 1254227676 0 0 3 ldap 1 0 0 1 ldv2602 not cached Luis de Vasconcelos luis.devasconcelos@liberty.co.za 0 +27114083388 0721018732 Liberty Life Grp Employe Solution & Design LIB0826WEST ZA en_utf8 99 0 1254308760 0 1254308760 163.202.46.187 0 Liberty Corporate Benefits 1 0 2 1 1 1 0 1254308759 0 NULL 0 4 manual 1 0 0 1 student cd73502828457d15655bbd7a63fb0bc8 Moodle Student moodle.student@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 0 0 0 0 1 0 2 1 0 1 0 1254308891 0 0 NOW: id auth confirmed policyagreed deleted mnethostid username password idnumber firstname lastname email emailstop icq skype yahoo aim msn phone1 phone2 institution department address city country lang theme timezone firstaccess lastaccess lastlogin currentlogin lastip secret picture url description mailformat maildigest maildisplay htmleditor ajax autosubscribe trackforums timemodified trustbitmask imagealt screenreader 1 manual 1 0 0 1 guest 084e0343a0486ff05530df6c705c8bb4 Guest User root@localhost 0 en_utf8 99 0 0 0 0 0 This user is a special user that allows read-only access to some courses. 1 0 2 1 1 1 0 1254227653 0 NULL 0 2 manual 1 0 0 1 admin 21232f297a57a5a743894a0e4a801fc3 Admin User luis.devasconcelos@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 1254383628 1254318805 1254372926 163.202.46.187 0 1 0 1 1 1 1 0 1254227676 0 0 3 ldap 1 0 0 1 ldv2602 not cached Luis de Vasconcelos luis.devasconcelos@liberty.co.za 0 +27114083388 0721018732 Liberty Life Grp Employe Solution & Design LIB0826WEST ZA en_utf8 99 0 1254385114 1254308760 1254383813 163.202.46.187 0 Liberty Corporate Benefits 1 0 2 1 1 1 0 1254308759 0 NULL 0 4 manual 1 0 0 1 student cd73502828457d15655bbd7a63fb0bc8 Moodle Student moodle.student@liberty.co.za 1 Johannesburg ZA en_utf8 99 0 1254383775 0 1254383643 163.202.46.187 0 1 0 2 1 0 1 0 1254308891 0 0 Just the TIMES have changed. SUMMARY ~~~~~~~ The following tables have changed between the import of the CPS results and the submission of the online attempt: SELECT * FROM mdl_grade_grades : Has various differences: - the rawgrade value of the FIRST record has changed from a NULL to 56 - the rawgrademax value of the FIRST record has changed from 100 to 60 - the usermodified value of the FIRST record has changed from 2 to 4 - the timecreated value of the FIRST record has changed from NULL to 1254383775 SELECT * FROM mdl_grade_grades_history : Has 1 new record. SELECT * FROM mdl_quiz_grades : Has 1 new record. SELECT * FROM mdl_quiz_attempts : Has 1 new record. SELECT * FROM mdl_grade_items_history : has 8 new records. SELECT * FROM mdl_grade_items : All NULLS are now BLANKS, DISPLAY column value changed from 0 to 12 in both records, timemodified changed in both records. SELECT * FROM mdl_user : Just the TIMES have changed. --------------------------------------------------- Status: Next I created another user, student2 and wrote the ONLINE exam. Then I imported CPS results into the same exam. What happens? SELECT * FROM mdl_grade_grades : BEFORE: id itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat timecreated timemodified 1 2 4 60.00000 60.00000 0.00000 NULL 4 30.00000 0 0 0 0 1254398407 0 NULL 0 NULL 0 1254398560 1254398407 2 1 4 NULL 100.00000 0.00000 NULL NULL 30.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL 3 2 5 40.00000 60.00000 0.00000 NULL 5 40.00000 0 0 0 0 0 0 NULL 0 NULL 0 1254398737 1254398737 4 1 5 NULL 100.00000 0.00000 NULL NULL 40.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL AFTER: id itemid userid rawgrade rawgrademax rawgrademin rawscaleid usermodified finalgrade hidden locked locktime exported overridden excluded feedback feedbackformat information informationformat timecreated timemodified 1 2 4 60.00000 60.00000 0.00000 NULL 4 30.00000 0 0 0 0 1254398407 0 NULL 0 NULL 0 1254398560 1254398407 2 1 4 NULL 100.00000 0.00000 NULL NULL 30.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL 3 2 5 40.00000 60.00000 0.00000 NULL 3 20.00000 0 0 0 0 1254399339 0 NULL 0 NULL 0 1254398737 1254399339 4 1 5 NULL 100.00000 0.00000 NULL NULL 20.00000 0 0 0 0 0 0 NULL 0 NULL 0 NULL NULL DIFFERENCES: usermodified value of record 3 changed from 5 to 3. finalgrade value of records 3 and 4 changed from 40 to 20. overridden value of record 3 changed from 0 to 1254399339. timemodified value of record 3 changed from 1254398737 to 1254399339 SELECT * FROM mdl_grade_grades_history : Has 2 new records: 11 2 3 import 1254399339 NULL 2 5 40.00000 60.00000 0.00000 NULL 3 20.00000 0 0 0 0 1254399339 0 NULL 0 NULL 0 12 2 4 aggregation 1254399339 NULL 1 5 NULL 100.00000 0.00000 NULL NULL 20.00000 0 0 0 0 0 0 NULL 0 NULL 0 SELECT * FROM mdl_quiz_grades : No changes SELECT * FROM mdl_quiz_attempts : No changes SELECT * FROM mdl_grade_items_history : No changes SELECT * FROM mdl_grade_items : No changes