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

Gradebook export is empty when calculation error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.3.7, 2.4.4
    • 2.2, 2.3.6
    • Gradebook
    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • MOODLE_23_STABLE, MOODLE_24_STABLE
    • brokencalc
    • Hide

      You'll need a course with at least one student and at least two gradeable activities.

      Setup

      1. Create a new calculated grade item. Set it to be equal to the sum of two other grade items ie =[[itemA]]+[[itemB]]
      2. Go to the user report (in the gradebook) and check that you can select individual students from the drop down.
      3. Export the course grades and check that you can export the grades without error. Make sure that both your activities and your users have an ID number set (http://docs.moodle.org/23/en/Grade_export#XML_file_export).

      Check its broken

      1. Delete one of the activities that is relied upon by the calculated grade item.
      2. Now, the user report should give you an error. The error message should tell you that there is a circular reference or broken calculation formula.
      3. Similarly grade export should give you an error.

      Student still works

      1. Log in as a student and check that you can access the user report and that you don't see the exception message. Within the user report the calc grade item will report an error but the report itself should load.

      Check its fixable

      1. Log back in as teacher/admin, go to the categories and items screen and remove the reference to the deleted grade item by editing the calculation. The missing grade item name in the calculation will have been replaced with a token.
      2. Check that the user report now loads for the teacher/admin.
      Show
      You'll need a course with at least one student and at least two gradeable activities. Setup Create a new calculated grade item. Set it to be equal to the sum of two other grade items ie =[ [itemA] ]+[ [itemB] ] Go to the user report (in the gradebook) and check that you can select individual students from the drop down. Export the course grades and check that you can export the grades without error. Make sure that both your activities and your users have an ID number set ( http://docs.moodle.org/23/en/Grade_export#XML_file_export ). Check its broken Delete one of the activities that is relied upon by the calculated grade item. Now, the user report should give you an error. The error message should tell you that there is a circular reference or broken calculation formula. Similarly grade export should give you an error. Student still works Log in as a student and check that you can access the user report and that you don't see the exception message. Within the user report the calc grade item will report an error but the report itself should load. Check its fixable Log back in as teacher/admin, go to the categories and items screen and remove the reference to the deleted grade item by editing the calculation. The missing grade item name in the calculation will have been replaced with a token. Check that the user report now loads for the teacher/admin.

      1.Test requires a course set up with more than one assignment
      2.In the gradebook, create a category
      3.Add at least two assignments to the gradebook category
      4.Navigate to the Categories and Items tab in the gradebook
      5.Click on the 'Edit Calculation' icon under the 'Actions' heading for the category
      6.Creating a calculation for the total which uses at least two assignments
      7.Return to the course front page and delete one of the assignments used in the calculation

      Any gradebook export will now be empty of students and no error is displayed

            andyjdavis Andrew Davis
            amanda.doughty Amanda Doughty
            Tim Hunt Tim Hunt
            Dan Poltawski Dan Poltawski
            Mark Nelson Mark Nelson
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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