search

UniversityOfHelsinkiCS / oodikone

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

Changing course code mayhem #4225

Open mluukkai opened 1 year ago

mluukkai commented 1 year ago

Courses are missing, eg 015165781 has several courses missing. eg GEOK_2011

the reason is that oodikone has GEOK2011 in hops but the real code is without _

the root cause

image image

so a solution must be found...

valtterikantanen commented 5 months ago

Another case from #4530:

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.

This issue is very likely to have the same cause so I combined these two issues.