UniversityOfHelsinkiCS / oodikone

An application for analyzing university data
https://oodikone.helsinki.fi
MIT License
14 stars 6 forks source link

Attainments with a new course code are sometimes saved with the old one #4530

Closed valtterikantanen closed 5 months ago

valtterikantanen commented 5 months ago

Check sis-importer-db's attainments table for id otm-4052e391-857a-415d-bb5b-fc96e685f195. This attainment has the course_unit_id otm-7ae23fb5-57e1-40f5-af6a-392ecea5d303. If we look this code from course_units table, we can see that the corresponding code is ML-T001. However, in sis-db's credit table this cas the course_code of 50099. The correct code is ML-T001, this has been checked from Sisu.

This might have something to do with the group_id. Group_id hy-CU-37277047 has both codes: 50099 and ML-T001. Currently the course code ML-T001 is not used anywhere in Oodikone, even though it should be.