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

Exporting feedback responses to Excel fails with many users

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.3, 2.6.1, 2.8.8, 2.9, 3.0
    • Fix Version/s: 3.1
    • Component/s: Feedback
    • Testing Instructions:
      Hide
      1. Create a moodle with a large number of students
      2. Make 2 feedback activities with lots of feedback, > 1000 responses (including some anon), one in a course and another at the site level
      3. Add different types of questions to make sure each type displays properly later in the export
      4. In the course feedback Analysis tab, try each of the download formats and make sure they work with feedback data. Check the column names are correct and in the right order, and the data matches the columns
      5. Confirm any anon data is correctly redacted.
      6. Repeat from a site level feedback instance using analysis tab (look similar but is different url)
      7. Repeat with groups mode selected, and confirm the file name show the group, and an extra group column has been added and is correctly populated
      8. Test exporting multiple large feedback downloads at the same time, and also browsing the site somewhere else at the same time, the report download should not block other pageviews.

      In my test box I'm downloading an export with 1000 responses x 12 questions = 193kb file in < 2 seconds and only using peak of 7M of php memory

      Show
      Create a moodle with a large number of students Make 2 feedback activities with lots of feedback, > 1000 responses (including some anon), one in a course and another at the site level Add different types of questions to make sure each type displays properly later in the export In the course feedback Analysis tab, try each of the download formats and make sure they work with feedback data. Check the column names are correct and in the right order, and the data matches the columns Confirm any anon data is correctly redacted. Repeat from a site level feedback instance using analysis tab (look similar but is different url) Repeat with groups mode selected, and confirm the file name show the group, and an extra group column has been added and is correctly populated Test exporting multiple large feedback downloads at the same time, and also browsing the site somewhere else at the same time, the report download should not block other pageviews. In my test box I'm downloading an export with 1000 responses x 12 questions = 193kb file in < 2 seconds and only using peak of 7M of php memory
    • Workaround:
      Hide

      Extending the execution time to 300 seconds in php.ini.

      Show
      Extending the execution time to 300 seconds in php.ini.
    • Affected Branches:
      MOODLE_23_STABLE, MOODLE_26_STABLE, MOODLE_28_STABLE, MOODLE_29_STABLE, MOODLE_30_STABLE
    • Fixed Branches:
      MOODLE_31_STABLE
    • Pull Master Branch:
      MDL-51603-dataformat-MDL-37132-feedback-data

      Description

      Referring to Klaus Steitz' post in the forum (https://moodle.org/mod/forum/discuss.php?d=217727):

      The Export-to-excel function of the feedback modul does not work with many answers.

      In our case: 400 participants, 39 questions, mainly of type "Multiple choice - single answer allowed (dropdownlist)".

      Trying exporting to excel of this Feedback the browser is "connecting" almost endless (more than half an hour), but no excel-file is generated. Reducing the number of submitted answers from 400 to 200 leads the export to work after about half a minute loading. The export also works for just one questions with 400 submitted answers (but not with 15 or more questions).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brendanheywood Brendan Heywood
              Reporter:
              pegenau Steffen Pegenau
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              9 Vote for this issue
              Watchers:
              19 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                23/May/16