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


    • 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:
    • Test Plan:

      Please add a Test Plan here.

      Please add a Test Plan here.
    • 12 status:


      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



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

              Issue Links



                  bjones86 Brian Jones
                  bjones86 Brian Jones
                  0 Vote for this issue
                  2 Start watching this issue



                      Git Integration