TechNote (Archived)

Migration from Breeze 4.1 to Breeze 5.1 loses max score

Issue

When a course is taken in Breeze 4.1, then migrated to Breeze 5.1 and included in a curriculum, the cumulative score stops being reported correctly.

Solution

This is currently an issue in Breeze and Engineering is researching the issue.

To workaround the issue, two queries need to be run to migrate the scores correctly.

Hosted: These scripts are run when the account is migrated, no action should need to be taken.

Licensed: The queries below, need to be run once, to migrate the scores. (Note: Not all presentations have quizzes so some blank scores may still exist.)

1. Query 1 - Identify 4.1 Breezos:

    select s.sco_id, s.name, a.asset_id, a.physical_path from breeze5..pps_scos s,      breeze5..pps_assets a,      breeze5..pps_sco_assets sa where s.disabled is null and s.sco_id = sa.sco_id and sa.asset_type = 0 and sa.asset_id = a.asset_id and physical_path like '%/flash/' 

2. Migrate the max score for the quizzes:

    INSERT INTO breeze5..pps_acl_fields (acl_id, field_id, value) SELECT s.sco_id, 117, sum(sq.score) FROM breeze5..pps_scos s, breeze..pps_sco_questions sq WHERE s.sco_id = sq.sco_id AND sq.disabled is null AND s.sco_id IN (select s.sco_id from breeze5..pps_scos s,      breeze5..pps_assets a,      breeze5..pps_sco_assets sa where s.disabled is null and s.sco_id = sa.sco_id and sa.asset_type = 0 and sa.asset_id = a.asset_id and physical_path like '%/flash/') GROUP BY s.sco_id 

   Where:
   Breeze5 - is your upgraded 5.x DB
   Breeze - is your non-migrated 4.x DB
3. Query 2 - Fix all existing Transcripts:

    UPDATE pps_transcripts SET max_score = (SELECT value from pps_acl_fields where field_id=117 and acl_id = pps_transcripts.sco_id) WHERE max_score IS null 

This content requires Flash

To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.

Download the free Flash Player now!

Search Support