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

Provide option for Participants list download to include group info

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 4.0
    • 3.8.5
    • User management
    • MOODLE_38_STABLE
    • MOODLE_400_STABLE
    • Hide

      Setup

      1. Login as admin
      2. Create 3 users: teacher, student1 & student2
      3. Create a new course
        • Group mode: Visible groups
      4. Enrol the teacher account as a teacher
      5. Enrol both student accounts as students
      6. Create two groups/memberships as follows
        • Group A (add student1 & student2)
        • Group B (add student2)
      7. Log out

      Export participants as teacher

      1. Login as teacher
      2. Navigate to course
      3. View course participants
      4. Select all users
      5. Choose With selected users... > Download table date as > Microsoft Excel (.xlsx)
      6. Confirm Groups column is present in the exported file, with content like:
        Student One Group A
        Teacher One  
        Student Two Group A, Group B
      1. Log out

      Export participants as teacher where "groups" is a hidden field that teacher can see

      1. Login as admin
      2. Navigate to Users > Permissions > User policies in site administration
      3. Select "Groups" under Hide user fields and press Save changes
      4. Log out
      5. Repeat all steps from Export participants as teacher section above

      Export participants as teacher where "groups" is a hidden field that teacher cannot see

      1. Login as admin
      2. Navigate to test course participants
      3. From Actions menu click on Permissions
      4. Remove the Teacher role from Roles with permission for the "moodle/course:viewhiddenuserfields" capability
      5. Log out
      6. Repeat all steps from Export participants as teacher section above, except Confirm that the Groups column is not present in the exported file

      Automated tests for grouplib API

      1. Run the following on each supported DB (MySQL, Oracle, Postgres, SQLServer), confirm passes

         $ vendor/bin/phpunit --testsuite core_testsuite --filter test_groups_get_names_concat_sql
        

      Show
      Setup Login as admin Create 3 users: teacher, student1 & student2 Create a new course Group mode: Visible groups Enrol the teacher account as a teacher Enrol both student accounts as students Create two groups/memberships as follows Group A (add student1 & student2) Group B (add student2) Log out Export participants as teacher Login as teacher Navigate to course View course participants Select all users Choose With selected users... > Download table date as > Microsoft Excel (.xlsx) Confirm Groups column is present in the exported file, with content like: Student One Group A Teacher One   Student Two Group A, Group B Log out Export participants as teacher where "groups" is a hidden field that teacher can see Login as admin Navigate to Users > Permissions > User policies in site administration Select "Groups" under Hide user fields and press Save changes Log out Repeat all steps from Export participants as teacher section above Export participants as teacher where "groups" is a hidden field that teacher cannot see Login as admin Navigate to test course participants From Actions menu click on Permissions Remove the Teacher role from Roles with permission for the "moodle/course:viewhiddenuserfields" capability Log out Repeat all steps from Export participants as teacher section above, except Confirm that the Groups column is not present in the exported file Automated tests for grouplib API Run the following on each supported DB (MySQL, Oracle, Postgres, SQLServer), confirm passes $ vendor/bin/phpunit --testsuite core_testsuite --filter test_groups_get_names_concat_sql

      The participants table download tools added in https://tracker.moodle.org/browse/MDL-59454 are nice but in courses with groups applied, that information is omitted from the download. It is definitely possible to filter the table to a group, download, and then add a column for a group manually but this becomes unfeasible in high enrollment courses.

       

      The use case is to have a spreadsheet splittable on the group column.

            pholden Paul Holden
            vandaleh Dave Laurie
            David Carrillo David Carrillo
            Andrew Lyons Andrew Lyons
            Gladys Basiana Gladys Basiana
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours, 40 minutes
                3h 40m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.