Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40366

Roster > improve format of group membership in export file

    Details

    • Type: Feature Request
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.5 [Tentative], 12.2, 19.0
    • Fix Version/s: 12.4, 19.0
    • Component/s: Roster
    • Labels:
      None
    • 12 status:
      Resolved
    • Test Plan:
      Hide
      1. Create three sites, all with the "Roster" tool: two project sites, and one course site (which contains at least one roster)
      2. In project site #1, create a group and assign yourself to the group
      3. In project site #1, go to the "Roster" tool and click "Export"
      4. Verify the file downloaded contains a second spreadsheet titled "Groups", and also verify the data in both sheets
      5. In project site #2, go to the "Roster" tool and click "Export"
      6. Verify the file downloaded contains only one sheet: "Roster" and verify the data within
      7. In the course site, go to "Site Info" and create several groups containing students (auto groups for the student role is sufficient)
      8. Go to the "Roster" tool, click "Export"
      9. Verify the file downloaded contains two sheets, and verify the data within
      10. Click the "Enrollment Status" tab, then click "Export" again
      11. Verify the file downloaded contains two sheets; verify that there are different columns displayed on both sheets compared to the previous export, and that the data within both sheets is accurate
      Show
      Create three sites, all with the "Roster" tool: two project sites, and one course site (which contains at least one roster) In project site #1, create a group and assign yourself to the group In project site #1, go to the "Roster" tool and click "Export" Verify the file downloaded contains a second spreadsheet titled "Groups", and also verify the data in both sheets In project site #2, go to the "Roster" tool and click "Export" Verify the file downloaded contains only one sheet: "Roster" and verify the data within In the course site, go to "Site Info" and create several groups containing students (auto groups for the student role is sufficient) Go to the "Roster" tool, click "Export" Verify the file downloaded contains two sheets, and verify the data within Click the "Enrollment Status" tab, then click "Export" again Verify the file downloaded contains two sheets; verify that there are different columns displayed on both sheets compared to the previous export, and that the data within both sheets is accurate

      Description

      The linked PR alters the format of the export file in the following ways:

      • removes the 'Group' column from sheet 1
      • renames 'sheet1' to 'Roster'
      • if groups are present and user has permission to view groups, a second worksheet is added titled 'Groups'
      • 'Groups' sheet is a list of memberships per group, and include the same fields that would be included in the 'Roster' sheet (varies depending on selected tab, "Overview" vs. "Enrollment Status")

      See attached screenshots for examples.

      Test plan uses separate sites to avoid the caching issue reported in SAK-40365.

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code