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

Make grade item mappings automatic

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Reopened
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5.2, 3.6, 3.6.3, 3.7.1, 3.8.1, 3.9
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:
    • Database:
      Any
    • Testing Instructions:
      Hide
      1. From a course with multiple grade items, export those grade items to an Excel Sheet by using Grades → Export → Excel spreadsheet. When exporting, do tick the "Include feedback in export" checkbox in the "Export format options" section.
      2. Change grades in the Excel sheet. Do change some feedbacks, too.
      3. Copy the all the table cells so that they are in the clipboard.
      4. Go to Grades → Import → Import from Spreadsheet.
      5. Paste the content of the clipboard (the previously copied cells) to the 'Data' textarea and click the "Upload grades" button.
      6. Make sure all the grade items are automatically mapped.
      Show
      From a course with multiple grade items, export those grade items to an Excel Sheet by using Grades → Export → Excel spreadsheet. When exporting, do tick the "Include feedback in export" checkbox in the "Export format options" section. Change grades in the Excel sheet. Do change some feedbacks, too. Copy the all the table cells so that they are in the clipboard. Go to Grades → Import → Import from Spreadsheet. Paste the content of the clipboard (the previously copied cells) to the 'Data' textarea and click the "Upload grades" button. Make sure all the grade items are automatically mapped.
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
    • Pull 3.7 Branch:
    • Pull 3.8 Branch:
    • Pull Master Branch:
      MDL-63475-master

      Description

      Right now, there are multiple formats to export grades from the gradebook, and multiple ways to import.

      However, the process of importing grades is made very tiresome by the inability of moodle to automatically map columns to grade items, even when those columns are named exactly as the grade items.

      It would greatly improve the workflow of teachers that want to export grades to excel, edit them there, and re-import them into Moodle, if the grade item mapping could be made automatic.

      This patch automates mapping of identifier fields and grade items by defaulting the dropdown menus to the matching items.

      Both grades and feedbacks are automatically mapped. In order to do so, /grade/export/lib.php has also be adjusted to use the lang string grade/feedback instead of core/feedback. Since those two lang strings are not necessarily the same in all language packs, export should use the same as import, to make auto-mapping of feedback items possible.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              technikum-wien Stefan Weber
              Peer reviewer:
              Luca Bösch
              Integrator:
              Jun Pataleta
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              4 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours
                  3h