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

    XMLWordPrintable

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

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.
    • 12 status:
      Resolved

      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

          Zeplin

            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 Integration