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

Robust previewing + update dry running for importing grade CSVs

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.8
    • Fix Version/s: BACKEND
    • Component/s: Gradebook
    • Labels:
    • Story Points:
      40

      Description

      Integrate UCSB's CSV file preview functionality - gives preview of parsed file input and allows mapping of data from file to Moodle fields. When submitted, it provides diagnosis data about:

      • "potential updates", i.e. when importing a CSV will change existing grades
      • errors and underlying reasons
        It should also skip duplicate scores.

      Further detail - these are the strings being introduced for further detail:

      • '{$a->name} not found in system mapped to {$a->key}'
      • 'student {$a->name} not found in group {$a->key}'
      • 'invalid grade for {$a}'
      • 'missing grade for {$a}'
      • 'invalid scale value for {$a}'
      • 'invalid grade value for {$a}'
      • 'grade exceeds item max ({$a->name}) for {$a->key}'
      • 'duplicate grade for {$a->name} from {$a->key} to {$a->key2}'
      • 'changing grade for {$a->name} from {$a->key} to {$a->key2}'
      • 'adding grade for {$a->name} as {$a->key}'
      • 'Warning: Accepted grade exceeds Item Maximum'
      • 'Error: Grade exceeds Item Maximum'
      • 'Error: Grade score bypassed - Locked grade'
      • 'Error: Grade score bypassed - No grade'
      • 'Error: Grade score bypassed - Invalid grade'
      • 'Error: Grade score bypassed - Invalid group'
      • 'Error: Grade score bypassed - Invalid student'
      • 'Warning: Grade score bypassed - Duplicate score skipped'

      Other messages

      • likely used the wrong delimiter
      • Non numeric grade value supplied, possibly mapped wrong column.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jethac Jetha Chan
                Participants:
                Component watchers:
                Jake Dallimore, Jun Pataleta
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: