WueCampus - Anleitung

Teilnehmerlisten filtern und exportieren

Filtering and exporting participant lists

In your source course, open the Participants tab. There you will see the participant list.

1. You can pre-filter the display using the filter box at the top. For example, if you only want to export the students but not the course instructors or lecturers, select the option "Any" under Match and then "Roles". Another input field appears. Select Student there and click Apply filters.
2. If you only have a few participants, select all of them using the checkbox at the top of the table. Otherwise, scroll all the way down and click the button Select all XX users on the left. This selects all users displayed after filtering.
3. Scroll all the way down. The dropdown field With selected users ... is now active. Open it and select Microsoft Excel (.xlsx) under "Download table data as".
4. Save the file to your computer.

You have now filtered and exported the participant list. If you also need the list with matriculation numbers, read the entry linked below in our FAQ book. If you want to export the list in order to import the participants again later, continue as described on this page.

Teilnehmerliste zum Import vorbereiten

Preparing the participant list for import

For the import, you need a CSV file with one email address per line. Here is how to create it from the exported participant list:

1. Open the downloaded participant list with Excel.
2. Delete all columns except the Email address column (right-click the column header → Delete). The email column should now be the first column of your spreadsheet.
3. Delete the first row so that there is no header row and the spreadsheet starts directly with the first email address.
4. Select Save as and choose CSV (UTF-8) as the file type at the bottom right. In Excel Online, use File → Export → Download as CSV UTF-8.

If you open the CSV file in a text editor, it should contain only a long list of email addresses without commas and without a header row. You have now created a valid import file for the next step.

CSV-E-Mail-Liste in den Zielkurs importieren

Importing the CSV email list into the target course

1. Use the button below to open the bulk enrolment page and enter the course ID of your target course. You can find the course ID at the end of the address bar when you open the course room. For example, the course URL https://wuecampus.uni-wuerzburg.de/moodle/course/view.php?id=<ABC> has the course ID <ABC>.
2. In the next window, upload the prepared email list.
3. Optionally, you can select a target group if it already exists and you want the participants to be added to it. Otherwise, leave the selection at "None".
4. Click Save. The participants are now enrolled.

At the end, you will receive a summary showing who was enrolled and whether there were problems with certain email addresses. You have now successfully imported a participant list.