Removing a repeated schedule in student profile

[danfelbm]

Hello there,

I've accidentally assigned the same course period to the same student two times, this didn't throw a error message; yet, it did create two entries in the Database. Schedule table doesn't have an index, so I can't remove the repeated entry, or can I?

In RosarioSIS, if I edit one entry, it modifies the other... I already have grades assigned to that student, is there any way I can remove the double entry?

Regards

[francoisjacquet]

Hello @danfelbm

Thank you for reporting the problem.

Do you think it would be better to simply prevent the admin to add a repeated course in a student's schedule?

[danfelbm]

Hello,

Actually yes, that would be very useful; unfortunately it was not the first time that happened.
However we do have some classes that share a course (Critical Reading and Spanish are both in the same Course: Spanish) so it would be better to prevent repeated classes

Regards

[francoisjacquet]

Looking at the code itself, the SQL statements which check if the student is already enrolled in a class search the student's schedule for:

• the course period
• in combination with the start / end / enrollment dates.

See for example: https://github.com/francoisjacquet/rosariosis/blob/mobile/modules/Scheduling/MassSchedule.php#L72

So it seems we here have the possibility to add the same course twice, if and only if the student has already been dropped.