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

Export groups/grouping to excel/ods/text files

XMLWordPrintable

    • 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

      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.

        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

            tasosb Anastasios Bithas
            lei.zhang Lei Zhang
            Brendan Heywood Brendan Heywood
            Jun Pataleta Jun Pataleta
            Gladys Basiana Gladys Basiana
            Votes:
            33 Vote for this issue
            Watchers:
            25 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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