Information System for a Dance School
About the project:
MT Stuudio, a children's dance school, approached us with an interesting challenge. The school conducted classes in several kindergartens and educational institutions across the city - the school had many branches, each with several student groups. All of this needed to be tracked and organized somehow.
What needed to be done:
The client needed a system that could:
- Track all students and their parents across different branches and groups
- Automatically generate and send invoices to parents for tuition
- Account for individual children's absences
- Mark cases when classes in a group were cancelled
- Send email reminders about overdue payments
- Import payment data from bank statements
- Solve many other organizational issues
How we solved it:
We developed an information system based on Drupal that automated the entire school management process. The system tracks each group's schedule, monitors attendance, and automatically generates invoices accounting for missed classes.
We set up regular invoice mailings to parents and automatic reminders about overdue payments. We added a bank statement import function - no more manual marking of who paid.
Project development:
Over time, the system needed updating - the old system ran on Drupal 7, which was no longer supported. The task was to migrate everything to modern versions - first to Drupal 9, then to 10 and 11.
This was a challenging task: Drupal 7's architecture differs significantly from subsequent versions. Essentially, we needed to rewrite a significant portion of the functionality. But we succeeded and along the way added new features, including exporting student data to the external register of the Estonian education system (EHIS).
What we achieved:
The dance school has been using a convenient system for many years now, saving administrators tons of time. Invoices are generated automatically, payments are tracked without manual work, and all student data is always at hand. The system continues to evolve along with the school's needs.
Technologies:
Drupal 7/9/10/11, PHP, MySQL