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

Export groups/grouping to excel/ods/text files

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9.8, Future Dev
    • 4.1
    • Groups
    • MOODLE_19_STABLE
    • MOODLE_401_STABLE
    • MDL22570_master
    • Hide
      1. Create at least 5 users, filled with extra fields (like ID Number)
      2. Go to "Site Administration">"Users">"User Policies">"Show User Identity" and select one or more extra fields (same fields as step 1)
      3. Create a new course
      4. Add at least 5 participants to the course
      5. Create a number of groups and a number of groupings
      6. Assign some groups to the groupings created
      7. Add participants to one or more groups
      8. Navigate to Participants>Groups>Overview
      9. Check: The "Export users as" dropdown and button exist on the bottom of the page
      10. Select a format and click the button.
      11. Check: The contents of the file match the contents of the overview page.
      12. Apply grouping and/or group filters on the top of the overview page.
      13. Select a format and click the button.
      14. Check: The contents of the file match the filtered contents of the overview page
      Show
      Create at least 5 users, filled with extra fields (like ID Number) Go to "Site Administration">"Users">"User Policies">"Show User Identity" and select one or more extra fields (same fields as step 1) Create a new course Add at least 5 participants to the course Create a number of groups and a number of groupings Assign some groups to the groupings created Add participants to one or more groups Navigate to Participants>Groups>Overview Check: The "Export users as" dropdown and button exist on the bottom of the page Select a format and click the button. Check: The contents of the file match the contents of the overview page. Apply grouping and/or group filters on the top of the overview page. Select a format and click the button. Check: The contents of the file match the filtered contents of the overview page

    Description

      This feature was requested by some of our lecturers in my university, hopefully it can help some moodle users in the community too.

      Teachers can exporting list of groups/grouping into an excel/ods/text file after they create groups.

      As it not only download group information, but also contains student id/username/email, it can be used as an alternative way to extract student information.

      To use this feature, click on groups in administration and choose Overview tab.

      Attachments

        1. groupexport.diff
          6 kB
        2. image-2021-12-10-21-00-07-269.png
          image-2021-12-10-21-00-07-269.png
          24 kB
        3. image-2022-03-03-09-44-30-868.png
          image-2022-03-03-09-44-30-868.png
          23 kB
        4. MDL-22570_Screenshot1.png
          MDL-22570_Screenshot1.png
          246 kB
        5. Overview.php.patch
          10 kB

        Issue Links

          has a QA test

          Functional Test - A test of a single Moodle feature MDLQA-16744 An administrator can export groups/groupings to multiple formats

          • Minor - Minor loss of function where workaround is possible
          • Open

          Functional Test - A test of a single Moodle feature MDLQA-17358 CLONE - An administrator can export groups/groupings to multiple formats

          • Minor - Minor loss of function where workaround is possible
          • Passed

          Functional Test - A test of a single Moodle feature MDLQA-17910 CLONE - An administrator can export groups/groupings to multiple formats

          • Minor - Minor loss of function where workaround is possible
          • Passed

          Functional Test - A test of a single Moodle feature MDLQA-18407 CLONE - An administrator can export groups/groupings to multiple formats

          • Minor - Minor loss of function where workaround is possible
          • Passed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-79325 Group overview export doesn't correctly format group names

          • Minor - Minor loss of function where workaround is possible
          • Waiting for peer review

          Improvement - An enhancement to an existing Moodle feature. MDL-32304 add groups and cohorts information to Grade export

          • Minor - Minor loss of function where workaround is possible
          • Development in progress
          will be (partly) resolved by

          Improvement - An enhancement to an existing Moodle feature. MDL-69908 Provide option for Participants list download to include group info

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              tasosb Anastasios Bithas
              lei.zhang Lei Zhang
              Brendan Heywood Brendan Heywood
              Jun Pataleta Jun Pataleta
              Gladys Basiana Gladys Basiana
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              33 Vote for this issue
              Watchers:
              25 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                28/Nov/22

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 31 minutes
                  2h 31m