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

Provide option for Participants list download to include group info

    XMLWordPrintable

    Details

    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_400_STABLE
    • Pull Master Branch:

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              pholden Paul Holden
              Reporter:
              vandaleh Dave Laurie
              Peer reviewer:
              David Matamoros David Matamoros
              Integrator:
              Andrew Lyons Andrew Lyons
              Tester:
              Gladys Basiana Gladys Basiana
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                8/Nov/21

                  Time Tracking

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