This software was built for a very prominent private school. The school already used an accounting and time table generation software with some excellent feature. But the user interface was complex and it did not provide certain important features or integration needed by the school. We developed a set of applications to work on data form the accounting software and also incorporate many additional modules to fulfill the requirements.
The project started with these objectives:
Though the objectives were pretty straight forward, the project had many challenges
A detailed study of 3rd party database was done by profiling and observing behavior of data against functions in the software. Based on this a sync mechanism was designed to fetch necessary data into application database and also push required data back.
So as to host the solution in SharePoint portal, a generic web part was created to render ASP.NET user controls. This was needed to reduce the cost of development and debugging of the application.
The project lead met with members of departments to understand the data they were managing in excel files and how to best create features to give and much better and integrated user experience.
Exchange integration was done using EWS and the client library Microsoft provides. A sync application was created which reads lesson and other schedules from the database and created, updated and removed entries for Exchange calendars. A “control panel” was provided to monitor and manage both sync services.
Data migration was done in two steps. First all data from all files of each department was gathered in an intermediate database table and verified. Then the same was transformed and imported into system database through an application written specifically for the job.
The system was built on these technologies: