Revolutionary API Integration: Transforming Academic Scheduling

Introduction

The Faculty of Engineering of the University of Porto (FEUP), one of the largest and most prestigious educational institutions in Portugal, manages a vast and complex network of timetables for its over 8,000 students and 700 faculty members, spread across numerous courses and buildings.

For years, timetabling at FEUP was an essentially manual process. A dedicated team relied on spreadsheets and paper documents to construct the semester schedules. While familiar, this approach was extremely time-consuming and prone to errors.

The complexity of managing engineering programs — with their diverse laboratory requirements, specialized equipment needs, and varying class sizes — made manual scheduling increasingly difficult as the institution grew. Most critically, timetables were not automatically synchronized with SIGARRA, FEUP's main academic management system, so the most up-to-date information was not readily accessible to the academic community.

The challenge

• Frequent conflicts: Avoiding timetable overlaps for students, teachers, and classrooms was a major challenge. Conflicts were common and required extensive manual intervention to resolve.
• Complex change management: Any change requested by academic staff or students demanded additional manual work, consuming valuable time and resources.
• Inefficiency and high costs: The manual process resulted in significant wasted time and high costs. Overlapping classroom bookings were frequent, requiring constant conflict resolution.
• Lack of system integration: Timetables were not automatically synchronized with SIGARRA, so the most up-to-date information was not readily accessible to the academic community.

The transformative solution: Bullet Solutions software

To modernize and optimize its timetable management, FEUP decided to implement Bullet Solutions software. A cornerstone of this transformation was the Bullet Solutions API (Application Programming Interface), which enabled automation and data integration with SIGARRA.

The implementation was tailored to FEUP's specific needs, accounting for the complexity of engineering courses and the management of diverse spaces.

• Phase 1 — Analysis and customization: Software tailored to FEUP's specific engineering course requirements.
• Phase 2 — Automated timetable generation: Advanced algorithms optimize classroom and laboratory usage.
• Phase 3 — Dynamic timetable management: A centralized system for adjustments and last-minute changes.
• Phase 4 — System integration: Seamless real-time synchronization with SIGARRA.

The crucial link: integration with SIGARRA

One of the most significant achievements of this implementation was the seamless integration between Bullet Solutions and SIGARRA, FEUP's academic management system, enabled through a dedicated API endpoint: /api/Events/all/{startDate}/{endDate}.

The integration works in three steps:

1. SIGARRA sends a request to the API, specifying a time range (start and end date).
2. After secure authentication, the API returns a list of all events — class schedules, exams, and more — for that period.
3. SIGARRA receives the data and automatically updates the timetables in its database, making them instantly visible to students, faculty, and administration.

Results and impact

The adoption of Bullet Solutions software, particularly the API integration, brought substantial and measurable improvements that exceeded expectations across multiple operational areas.

• Massive operational efficiency: Time required to create and manage timetables reduced by over 80% — from more than five months to less than one month.
• Conflict elimination: Automated timetable generation virtually eliminated all overlaps for classrooms, students, and academic staff.
• Data consistency and reliability: Automatic integration ensures SIGARRA always reflects the most current and accurate timetable data.
• Improved user experience: Students and faculty benefit from centralized, reliable, real-time access to their timetables.
• Resource optimization: Classroom and laboratory occupancy aligned with student numbers, ensuring efficient use of spaces.
• Adaptability and rapid response: FEUP gained the ability to manage and respond quickly to timetable changes and updates.

The API acts as a digital "bridge," allowing timetables — once generated and optimized in Bullet Solutions software — to flow automatically and accurately into the system used daily by the academic community. This initiative not only boosted operational efficiency to unprecedented levels, but also significantly enhanced the overall academic experience for the entire community.

Challenges and considerations for continued success

Despite the clear benefits, maintaining the integration requires attention to a few areas:

• Integration security: Secure API authentication (OAuth2) is essential to protect sensitive data.
• Data volume: For long academic periods, the volume of timetable data transferred can be significant, requiring efficient processing and storage on the SIGARRA side.
• Error handling: The integration must gracefully handle potential API errors so that synchronization remains robust and uninterrupted.
• Data mapping: Ensuring that timetable data from Bullet Solutions is correctly interpreted and adapted to SIGARRA's structure is an ongoing task.

"Implementing the Bullet solution transformed our scheduling process. It significantly reduced the time and effort needed to create and manage timetables, allowing us to focus on providing a better academic experience for our students and all faculty members."

— Susana Gaio, IT Manager, FEUP