Before this commit, when the first synchronization with Outlook Calendar was done or when the synchronization was restarted, all events previously created in Odoo (before synchronizing) were being synced with Outlook, triggering lots of emails and notifications for attendees. Additionaly, all microsoft credentials information were concentrated within the res_users file, difficulting updates in this file. After this commit, only events created or updated after the synchronization starts (or restarts) are synced with Outlook Calendar, with 5 minutes of time acceptance for avoiding network delay issues. Moreover, a Microsoft Credentials module was added for gathering microsoft credentials in one place. closes odoo/odoo#128150 Task-id: 3410651 Related: odoo/upgrade#5047 Signed-off-by: Arnaud Joset (arj) <arj@odoo.com>
10 lines
286 B
SQL
10 lines
286 B
SQL
-- neutralization of Microsoft calendar
|
|
UPDATE res_users
|
|
SET microsoft_calendar_token = NULL,
|
|
microsoft_calendar_rtoken = NULL;
|
|
|
|
UPDATE microsoft_calendar_credentials
|
|
SET calendar_sync_token = NULL,
|
|
synchronization_stopped = True,
|
|
last_sync_date = NULL;
|