Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-33838 GBNG: improve Import/Export processes
  3. SAK-33849

GBNG: Improve error handling/reporting and information messaging around the Import/Export process

    Details

    • Type: Sub-task
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.4
    • Fix Version/s: 12.1, 19.0
    • Component/s: Gradebook
    • Labels:
      None
    • 12 status:
      Resolved
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      This PR is a group of improvements around the Import/Export process in GBNG:

      • Improve instructional messaging about the Import process:
      • Only enable the 'Continue' button when a valid file has been selected:
      • Role detection for the Import/Export page ('Student' role gets forwarded to the StudentPage, 'None' role gets forwarded to the AccessDeniedPage)
      • Front end validation; validate as much as possible as soon as the user uploads a file and clicks the 'Continue' button, rather than having them move through the entire wizard and presenting errors after the fact, when something fails to be imported, etc.
        • Invalid grade detection:
        • Duplicate column detection:
        • Invalid column detection:
        • Blank heading detection:
        • No valid student(s) detection (must have at least one row containing a student in the Gradebook):
        • Duplicate student entry detection:
        • Orphaned comment column detection:
        • No changes compared to existing Gradebook data detection:
      • Fixed a bug when importing a new Gradebook Item with comments: if any of the cells for the comment column do not have a value, the status for the column will end up being Update rather than New (assigned status of New initially, then status gets overwritten to Skip when it detects empty value in a cell, then the check for status != New passes, and the status gets overwritten with Update)
      • All new validations are cumulative; if the uploaded file has more than one validation problem, all relevant messages will be displayed to the user:

        Gliffy Diagrams

          Attachments

          1. screenshot1.png
            screenshot1.png
            252 kB
          2. screenshot10.png
            screenshot10.png
            157 kB
          3. screenshot11.png
            screenshot11.png
            238 kB
          4. screenshot2.png
            screenshot2.png
            161 kB
          5. screenshot3_dataView.png
            screenshot3_dataView.png
            25 kB
          6. screenshot3.png
            screenshot3.png
            218 kB
          7. screenshot4_dataView.png
            screenshot4_dataView.png
            9 kB
          8. screenshot4.png
            screenshot4.png
            172 kB
          9. screenshot5_dataView.png
            screenshot5_dataView.png
            9 kB
          10. screenshot5.png
            screenshot5.png
            170 kB
          11. screenshot6.png
            screenshot6.png
            150 kB
          12. screenshot7_dataView.png
            screenshot7_dataView.png
            16 kB
          13. screenshot7.png
            screenshot7.png
            151 kB
          14. screenshot8_dataView.png
            screenshot8_dataView.png
            12 kB
          15. screenshot8.png
            screenshot8.png
            176 kB
          16. screenshot9_dataView.png
            screenshot9_dataView.png
            9 kB
          17. screenshot9.png
            screenshot9.png
            180 kB

            Issue Links

              Activity

                People

                • Assignee:
                  bjones86 Brian Jones
                  Reporter:
                  bjones86 Brian Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code