Timetable Microsoft Account

The openeducat_timetable_microsoft_account module bridges the OpenEduCat Timetable application with Odoo’s Microsoft Calendar Integration. Once installed, confirmed and done class sessions are automatically synchronized as calendar events on the assigned faculty member’s connected Microsoft Outlook account. This ensures seamless scheduling and automatic calendar updates.

Key Features

  • Automatic Calendar Event Creation: When a timetable session enters a synchronized state (e.g., Confirmed or Done), an event is automatically created in the assigned faculty member’s Microsoft Outlook calendar.

  • Bi-directional State Synchronization: * Session Updates: If the name, subject, start/end time, classroom, or assigned faculty of a session is modified in OpenEduCat, the remote Outlook event is automatically updated. * Faculty Re-assignment: Changing the faculty of a session automatically deletes the event from the previous faculty’s Outlook calendar and creates a new event on the new faculty’s calendar. * Session Cancellation / Deletion: Setting a session to Draft or Cancelled, or deleting it, automatically removes the corresponding event from the faculty’s Outlook calendar.

  • Remote Deletion Tracking: If a faculty member deletes a synchronized timetable event directly from their Microsoft Outlook calendar, the next synchronization cycle automatically marks the session as Cancelled in OpenEduCat and posts an audit chatter notification explaining the cancellation.

Prerequisites

To enable Microsoft Outlook Calendar synchronization for timetable sessions, ensure the following configuration is in place:

  1. System Integration Setup: * Configure Microsoft OAuth credentials (Client ID and Client Secret) under Settings ‣ General Settings ‣ Integrations ‣ Microsoft Calendar.

  2. Faculty User Assignment: * The faculty member’s Employee record (linked on the Faculty form) must be associated with an active Odoo User account (res.users).

  3. Microsoft Account Authorization: * The faculty member must link and authorize their Microsoft Outlook calendar by clicking the Sync with Microsoft link on their personal Odoo Calendar view or User Preferences page.

How Sync Works

The synchronization runs automatically in the background via the scheduled sync cron or whenever a user performs a manual calendar synchronization action.

Nota

If any of the prerequisites (such as authorization or user linkage) are missing, the synchronization is safely bypassed. The timetable session save will succeed normally within Odoo, and the sync will attempt to run on the next successful connection cycle once the credentials are authorized.