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

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

XMLWordPrintable

    • MOODLE_26_STABLE, MOODLE_28_STABLE, MOODLE_38_STABLE
    • MDL-40529_master
    • 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".

      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)

            Unassigned Unassigned
            gaudreaj Jean-Philippe Gaudreau
            Rex Lorenzo Rex Lorenzo
            Votes:
            11 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h

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