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

Scorm report improvement

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.7
    • Fix Version/s: 2.0
    • Component/s: SCORM
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      I've added some changes to the scorm report, the modified files are attached.

      The modifications includes :
      Complete recoding of the report.php based on mod/quiz/report/overview/report.php, this enable the following features :

      • group select box
      • sortable table
      • collapsable table
      • download in Excel, ODS and text format
      • report preferences : number of elements per page, show scorm details or not, show all students, only attempted or not attempted results
      • tabs navigation to switch between the sco info page and report page. In the scorm/view.php i get rid of the top link "show xxx users"

      Two new files :

      • tabs.php for the tabs
      • reportsettings_form.php for the preference form (based on MDL-18836)

      Solution for this MDL-21421 and an improvement of MDL-16184 :
      The problem is in scorm_get_sco_runtime (locallib.php), because it takes all scoes track ordered by timemodified, and then select the scoes track again but ordered by scoid to take the first one (which is not necessarily the first accessed).
      For me, the changes i've made give more relevant results (the first access is really the first access and the last really the last).
      By using x.start.time, the previous patch takes in facts the last opening of the first sco and not really the first access.

      Sorry but my patch also includes this one : MDL-18835, because it's not included in Moodle 1.9.7

      And sorry for my bad english,

        Attachments

        1. delete_attempt_v2.patch
          2 kB
        2. delete_attempt_v3.patch
          3 kB
        3. delete_attempt.patch
          2 kB
        4. lang_en_utf8.patch
          3 kB
        5. lang_fr_utf8.patch
          4 kB
        6. report.php
          34 kB
        7. report.zip
          13 kB
        8. reportsettings_form.php
          1 kB
        9. scorm_report.patch
          6 kB
        10. tabs.php
          1 kB

          Issue Links

            Activity

              People

              • Assignee:
                danmarsden Dan Marsden
                Reporter:
                valerian valerian
                Tester:
                Nobody
                Participants:
                Component watchers:
                Damyon Wiese, Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Mihail Geshoski, Peter Dias
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  24/Nov/10