I'm seeing a problem with the Rollover process in version 8. I created a demo school with only 2 students enrolled for the 2022-2023 school year. My demo school year started in August 2022 and ends in June 2023.
I rolled over the school into a new year (2023-2024). After the rollover was completed I saw in the success confirmation message that two students were rolled over; "Students (2)". I logged in and I can see my two students with either school year selected. I checked the database table student_enrollment and confirmed that a record for each student was created for each year (see screenshot). The original record for the 2022-2023 school year contained the "syear" value of "2022" and a second row per student was listed with the "syear" value of "2023".
I change the student retention option (under Students > Enrollment Info) to "do not enroll" on the next rollover and to move the other student to the next grade level.
On the second rollover attempt, the process completed BUT failed to rollover the student records. The rollover completion screen showed "Students (0)". I checked the database table "student_enrollment" and confirmed that the process failed to generate a new row for the new year. (see screen shot).
Can someone help me understand why the rollover process would fail to create a new record for a student in the student_enrollment table?
Update: I solved the problem. There is nothing wrong with the Rollover process. It is working as designed. This issue was caused by user error.
The issue was that I was attempting a rollover before the school year began. For example, in August 2022 I rolled over to a school year that begins in August 2023. This won't be a problem in a production environment because no one will ever need to rollover a school year before it begins or ends. Rather it was an issue that I found during testing.
The rollover process works for future years, but when it gets to setting up new student enrollment entries in the database (table: student_enrollment) the date on which the rollover is initiated (in my case August 2022) is used in a query to search for student enrollment from the school year being rolled. If today's date is less than the start date of the school year being rolled over or it does not fall between the start and end date of the year being rolled, then all of the students will be dropped from the new year because the DB query won't see them.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm seeing a problem with the Rollover process in version 8. I created a demo school with only 2 students enrolled for the 2022-2023 school year. My demo school year started in August 2022 and ends in June 2023.
I rolled over the school into a new year (2023-2024). After the rollover was completed I saw in the success confirmation message that two students were rolled over; "Students (2)". I logged in and I can see my two students with either school year selected. I checked the database table student_enrollment and confirmed that a record for each student was created for each year (see screenshot). The original record for the 2022-2023 school year contained the "syear" value of "2022" and a second row per student was listed with the "syear" value of "2023".
I change the student retention option (under Students > Enrollment Info) to "do not enroll" on the next rollover and to move the other student to the next grade level.
On the second rollover attempt, the process completed BUT failed to rollover the student records. The rollover completion screen showed "Students (0)". I checked the database table "student_enrollment" and confirmed that the process failed to generate a new row for the new year. (see screen shot).
Can someone help me understand why the rollover process would fail to create a new record for a student in the student_enrollment table?
Update: I solved the problem. There is nothing wrong with the Rollover process. It is working as designed. This issue was caused by user error.
The issue was that I was attempting a rollover before the school year began. For example, in August 2022 I rolled over to a school year that begins in August 2023. This won't be a problem in a production environment because no one will ever need to rollover a school year before it begins or ends. Rather it was an issue that I found during testing.
The rollover process works for future years, but when it gets to setting up new student enrollment entries in the database (table: student_enrollment) the date on which the rollover is initiated (in my case August 2022) is used in a query to search for student enrollment from the school year being rolled. If today's date is less than the start date of the school year being rolled over or it does not fall between the start and end date of the year being rolled, then all of the students will be dropped from the new year because the DB query won't see them.