Complex interface programming for a Swiss education institute
The Project
Three predefined systems, a Swiss educational institute and the highest data protection standards. For IfFP, a complex interface solution synchronises data on students, events and learning content losslessly between Tocco, Silverstripe and ActiveCampaign.
Mappings at application level homogenise the data formats, while a terminal application with cron jobs keeps the exchange running on schedule. Previously separate systems now work together as if they were one.
The Challenge
Tocco, Silverstripe and ActiveCampaign each follow their own data models and formats. Student records, course dates and learning content nevertheless had to travel between them without loss, while strictly maintaining data protection and without manual intermediate steps. Every change in one system was to reach the others automatically and traceably.
Our Technologies
The synchronisation runs via a terminal application with cron jobs based on PHP and Laravel. Mappings at application level translate between the data formats of the three systems and ensure lossless, privacy-compliant exchange. The application logs error cases traceably so that no record is left behind unnoticed, and new fields can be added via the mappings without touching the connected systems.