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

Grades import: auto-mapping of grade items and user identifier field

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Create a new course and enroll some students in it.
      2. Add 1 assignment in the course named "Assignment 1" and 1 new grade item named "Grade item 1" in "Grade administration > Categories and items > Simple view", "Add grade item" button.
      3. Export grades to CSV file (Plain text file with comma separator).
      4. Import grades from the exported CSV file : go to "Grade administration > Import > CSV file", upload file and click on "Upload grades" button.
      5. Assert that the lists from "Identify user by" section contain the following values:
        • Map from = "ID Number"
        • Map to = "ID Number"
      6. Assert that the lists from "Grade item mappings" section contain the following values and that the others are set to "Ignore":
        • Assignment: Assignment 1 = "Assignment: Assignment 1"
        • Grade item 1 = "Grade item 1"
      7. Manually update the CSV file to add 2 columns with the following header names:
        • "Assignment: Assignment 1 (Feedback)"
        • "Grade item 1 (Feedback)"
      8. Import grades from the modified CSV file.
      9. Assert that the lists from "Grade item mappings" section contain the following values and that the others are set to "Ignore":
        • Assignment: Assignment 1 = "Assignment: Assignment 1"
        • Assignment: Assignment 1 (Feedback) = "Assignment: Assignment 1 (Feedback)"
        • Grade item 1 = "Grade item 1"
        • Grade item 1 (Feedback) = "Grade item 1 (Feedback)"
      10. Manually update the CSV file so that none of the header columns could be mapped (Add a random number at the end would do the trick)
      11. Import grades from the CSV file.
      12. Assert that the lists from "Identify user by" section contain the following values:
        • Map from = (The first header column name from the CSV file)
        • Map to = "User ID"
      13. Assert that the value from all the lists from "Grade item mappings" section are set to "Ignore".
      Show
      Create a new course and enroll some students in it. Add 1 assignment in the course named "Assignment 1" and 1 new grade item named "Grade item 1" in "Grade administration > Categories and items > Simple view", "Add grade item" button. Export grades to CSV file (Plain text file with comma separator). Import grades from the exported CSV file : go to "Grade administration > Import > CSV file", upload file and click on "Upload grades" button. Assert that the lists from "Identify user by" section contain the following values: Map from = "ID Number" Map to = "ID Number" Assert that the lists from "Grade item mappings" section contain the following values and that the others are set to "Ignore": Assignment: Assignment 1 = "Assignment: Assignment 1" Grade item 1 = "Grade item 1" Manually update the CSV file to add 2 columns with the following header names: "Assignment: Assignment 1 (Feedback)" "Grade item 1 (Feedback)" Import grades from the modified CSV file. Assert that the lists from "Grade item mappings" section contain the following values and that the others are set to "Ignore": Assignment: Assignment 1 = "Assignment: Assignment 1" Assignment: Assignment 1 (Feedback) = "Assignment: Assignment 1 (Feedback)" Grade item 1 = "Grade item 1" Grade item 1 (Feedback) = "Grade item 1 (Feedback)" Manually update the CSV file so that none of the header columns could be mapped (Add a random number at the end would do the trick) Import grades from the CSV file. Assert that the lists from "Identify user by" section contain the following values: Map from = (The first header column name from the CSV file) Map to = "User ID" Assert that the value from all the lists from "Grade item mappings" section are set to "Ignore".
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_28_STABLE, MOODLE_38_STABLE
    • Pull Master Branch:
      MDL-40529_master

      Description

      It would be a great improvement, for ease of use and ergonomic purpose, to auto-map the grade items, when possible, when importing grades from csv or xml file. The user wouldn't have to waste time re-selecting to right fields when when importing from an already exported file (columns should be the same).

      Even better would be to be able to also map the user identifier column, although this one would be a bit more difficult because the fields name are different between import form and exported files (for example, username/useridnumber in the import form is set as "ID Number" in exported files)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              levemar Marie-Eve Lévesque
              Reporter:
              gaudreaj Jean-Philippe Gaudreau
              Peer reviewer:
              Rex Lorenzo Rex Lorenzo
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              9 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated: