Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-34233

SCORM Activities Not Restoring Correctly - data is reversed in backup

    XMLWordPrintable

Details

    • MOODLE_23_STABLE
    • MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • master_MDL-34233
    • Hide

      Create a course with a SCORM package and back it up.
      Open the scorm.xml file in the backup and look at the order of the <scoes> items
      the ids listed should be in ascending order as stored in the db. eg 1, 2, 3, not in descending order (3, 2, 1)

      Restore that backed up course and check the order of the fields stored in the db for the scorm_scoes table is the same as the order in the original course. (ping me on jabber if you need more info)

      eg data from scorm_scoes looks like this:

      id scorm manifest
      3 24 name
      4 24 name
      5 24 name

      but when backed up it reverses the order of the records in the xml like this:
      5 24 name
      4 24 name
      3 24 name

      Show
      Create a course with a SCORM package and back it up. Open the scorm.xml file in the backup and look at the order of the <scoes> items the ids listed should be in ascending order as stored in the db. eg 1, 2, 3, not in descending order (3, 2, 1) Restore that backed up course and check the order of the fields stored in the db for the scorm_scoes table is the same as the order in the original course. (ping me on jabber if you need more info) eg data from scorm_scoes looks like this: id scorm manifest 3 24 name 4 24 name 5 24 name but when backed up it reverses the order of the records in the xml like this: 5 24 name 4 24 name 3 24 name

    Description

      When restoring a course backup, SCORM activities do not display content without opening up the settings for that activity and then clicking "Save and Display". Inspecting 'mdl_scorm_scoes' revealed that each of the newly created scoes have two records, one for the "_ORG" element (Articulate) and one for the "_SCO". When first restored, the "_SCO" record is always created first, with the "_ORG" record immediately following. Moodle doesn't seem to like that as it will not load the content without the "_ORG" record being first and "_SCO" second. Manually switching the ids of these two records in the DB for an affected SCO fixes the issue, as does opening up the SCO's settings page and then clicking "Save and Display".

      Attachments

        Issue Links

          Activity

            People

              danmarsden Dan Marsden
              clperkins Chris Perkins
              Ankit Agarwal Ankit Agarwal
              Sam Hemelryk Sam Hemelryk
              Adrian Greeve Adrian Greeve
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan, Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Sep/12