Support "student group" field of lesson #58

New issue

Open

opened 2022-10-28 11:54:14 +02:00 by nik · 4 comments

nik commented

2022-10-28 11:54:14 +02:00

Owner

Untis has a StudentGroups table, containing an Untis-style composite key, Name, SUBJECT_ID and comma-separated ClassIds:

+-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+
| SCHOOL_ID | SCHOOLYEAR_ID | VERSION_ID | STUDENTGROUP_ID | Counter | USER_ID | Deleted | Name      | StatisticCodes | Longname | ForeignKey | OldName | SUBJECT_ID | ClassIds | BASE_STUDENTGROUP_ID |
+-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+
|     65535 |      20222023 |          1 |             176 |       4 |       1 |       0 | PH_Q1_MOE | NULL           | NULL     | NULL       | NULL    |         46 | ,8,      |                    0 |
+-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+

In the Lesson table, we find the string in the LessonElement column as well, e.g.:

54~0~46~51;~0;~0~0~83906~~~~~"PH1"~~~n~~;8;~"PH_Q1_MOE"~~176~0~154800~0~0~~70800~

I am unsure whether we should only use the string in the Lesson table, or actually go and import the StudentGroups first into AlekSIS. They seem to have helpful information, because they carry the parent group IDs as ClassIds. I have no idea how that can be matched back to Qi or whatever…

Untis has a `StudentGroups` table, containing an Untis-style composite key, `Name`, `SUBJECT_ID` and comma-separated `ClassIds`: ```plain +-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+ | SCHOOL_ID | SCHOOLYEAR_ID | VERSION_ID | STUDENTGROUP_ID | Counter | USER_ID | Deleted | Name | StatisticCodes | Longname | ForeignKey | OldName | SUBJECT_ID | ClassIds | BASE_STUDENTGROUP_ID | +-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+ | 65535 | 20222023 | 1 | 176 | 4 | 1 | 0 | PH_Q1_MOE | NULL | NULL | NULL | NULL | 46 | ,8, | 0 | +-----------+---------------+------------+-----------------+---------+---------+---------+-----------+----------------+----------+------------+---------+------------+----------+----------------------+ ``` In the `Lesson` table, we find the string in the `LessonElement` column as well, e.g.: `54~0~46~51;~0;~0~0~83906~~~~~"PH1"~~~n~~;8;~"PH_Q1_MOE"~~176~0~154800~0~0~~70800~` I am unsure whether we should only use the string in the `Lesson` table, or actually go and import the `StudentGroup`s first into AlekSIS. They seem to have helpful information, because they carry the parent group IDs as `ClassIds`. I have no idea how that can be matched back to `Qi` or whatever…

nik commented

2022-10-28 11:54:15 +02:00

Author

Owner

assigned to @hansegucker

hansegucker commented

2022-12-09 13:12:45 +01:00

Owner

created branch 58-support-student-group-field-of-lesson to address this issue

created branch [`58-support-student-group-field-of-lesson`](/AlekSIS/official/AlekSIS-App-Untis/-/compare/master...58-support-student-group-field-of-lesson) to address this issue

hansegucker commented

2022-12-09 13:24:07 +01:00

Owner

mentioned in merge request !239