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

XLS gradebook export times out on courses with large enrollments

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 3.1.4
    • Gradebook
    • None
    • MOODLE_31_STABLE

      Issue: The XLS gradebook export is timing out when generating an export for courses that have thousands of student enrollments, and numerous grade items. 

      When we took a look at what is going on through our monitoring tools, the database query for the information takes seconds to resolve but the /grade/export/xls/index.php process has to build each and every cell of the XLS spreadsheet to be exported, and this is where its timing out. 

      By contrast running the "Plain Text Format" (CSV) export (/grade/export/txt/index.php) takes only a few seconds, and the output file looks identical to what is shown when opening a XLS file. This is currently the workaround we have the client using.

       

      Possible suggestions as to what can be done:
      1) Remove the XLS option and rename "Plain Text Format" to CSV/XLS export

      2) Make it such that when the XLS export is called its just running a CSV export

            Unassigned Unassigned
            kmccarthy Kevin McCarthy
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.