The Schoolbox/SchoolPro integration is a direct database integration that requires SchoolPro to create stored procedures for Schoolbox to connect to.
These are:
sbGetDayNumber sbGetEnrolledStudents sbGetGuardianAccounts sbGetParent sbGetPeriodNumber sbGetPortraitFile sbGetPortraitLastUpdated sbGetStaffAccounts sbGetStaffDayTimetable sbGetStaffSubjectList sbGetStudent sbGetStudentAccounts sbGetStudentContact sbGetStudentDayTimetable sbGetStudentMedicalConditions sbGetStudentSubjectList sbGetStudents sbGetTeacherName sbGetTimetableDefinition
To set up the SchoolPro connection in Schoolbox navigate to Administration -> Settings -> External DB and :
- Select SchoolPro as Connector
- Enter SchoolPro database name
- Enter Database Host
- Enter Database User
- Enter Database Password
Be careful when configuring your Data cache time-out as this may impact the performance of your system during peak times.
If you are finding issues with your SchoolPro connector clicking on the health check will show you if the correct permissions have been set up within SchoolPro.