I will try to clarify (in writing it takes longer than explaining by word, so my apologies for the long answer)
The external partners giving the webinars for which the students registered in the schedulers do not have access to our Moodle, and we do not ask them to grade attendance. It is not the attendance that needs to be graded. It is what students do with the info they receive during these webinars that is graded at the end of the year, based on what the students documented and reported on in their portfolios. A portfolio is a document reporting on all the company-led activities students participated in. And it also contains own research students did after being triggered by new info they glean from these webinars.
We as teachers contact companies and see to it that at least once a week, during the entire year there are activities on the workfloor at companies. Due to Covid, this was all replaced with webinars. The Moodle course contains nothing more than schedulers for all of these events. There is a mandatory minimum of webinars the students must attend, but this varies on the type of student (regular day-time students, evening students with a full time job, students with learning difficulties and a less intensive curriculum spread over more years, ...)
We as teachers (one course, 5 teachers, 5 different class groups, mix of regular day-time students and working students taking the evening classes) are usually but not always present in ALL the webinars (sometimes we are teaching another group at the same moment when a company decides to organise a webinar that might be of interest to our students or sometimes at the same time there are two companies having hosting different webinars).
Day time regular students need to participate in at least 10 webinars over the course of the entire year, working students need to participate in at least 5 webinars.
Which webinars are attended, is entirely up to the students. At the end of the academic year (right about now) we as teachers need to check and confirm that these requirements are met, and we need to know which student registered for which event so that we can check if the portfolio they submitted with their reports on each of these webinars is complete and true.
Only students that registered in the schedulers received the webinar info.
We need the info on which student registered for which webinar in order to grade their portfolios. I would prefer to have the info of ALL schedulers in the course in 1 Excell sheet so that I can open the portfolio of student X, also filter the spreadsheet so that all webinars for which student X registered on Moodle are filtered out and thus check if his/her portfolio is consistent and check if student X met the minimum attendance requirements (different on whether student X is a regular daytime student, a working evening student, or has some hybrid curstom-made curriculum with exceptions to the rules).
This would also make it possible to cross-check the report on webinar Y that student X put in their portfolio with the reports of other students that attended webinar Y.
Maybe we should have organised it differently in retrospect, but we needed to make changes fast due to ever-changing Covid restrictions. I cannot change the way it was organised now, nor can I integrate with the gradebook after the facts. I counted on the ability of Moodle export functionality. But alas I have come to the conclusion I need to do an export in each of the schedulers separately and then recombine all these different Excell into one master by hand. Unless I am missing something ....
Yesterday evening, I developed a curl script containing all the id's and session keys to automatically extract all the spreadsheets of each scheduler separately. I guess today I will be busy combining all these spreadheets together into one master file ....