Odoo Office365 Calendar

by
Odoo

215.52

v 11.0 v 12.0 Third Party 47
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Calendar (calendar)
Discuss (mail)
Community Apps Dependencies
Lines of code 2965
Technical Name ks_office365_calendar
LicenseOPL-1
Websitehttps://store.ksolves.com/
Versions 13.0 11.0 14.0 12.0 15.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Calendar (calendar)
Discuss (mail)
Community Apps Dependencies
Lines of code 2965
Technical Name ks_office365_calendar
LicenseOPL-1
Websitehttps://store.ksolves.com/
Versions 13.0 11.0 14.0 12.0 15.0
ksolves-logo
Community Enterprise

Odoo Office365 Calendar Connector

Ksolves Office 365 Calendar offers a two way synchronization to sync your schedules, meetings and events in Odoo and Office 365 accounts through a simple click. Combined with Ksolves Office 365 Base features, it provides a way to comprehensively manage your schedules and recurrent meetings without any miss.


Problems/Solutions

PROBLEM:

Since Office 365 Calendar is widely used in the business environment, its connection to Odoo becomes a must. A user had to thrive for maintaining schedules, meetings and events at two places i.e. Odoo calendar and Outlook calendar.

SOLUTION:

Ksolves Office 365 Calendar provides a bidirectional synchronization to manage your schedules and recurrent meetings in Odoo and Office 365 account. The user can select which way to sync through a simple click and can even configure and restrict syncing options.

PROBLEM:

After syncing, the user at times wish to see the status, sync time, direction in which sync happened etc to ensure that nothing is missed out.

SOLUTION:

Ksolves Office 365 Calendar gives the feature of detailed logs with multiple fields for all the syncing operations done along with the Advanced search and filter mechanisms for logs analysis.

PROBLEM:

User may wish to sync only latest events.

SOLUTION:

Ksolves Office 365 Calendar gives the feature to sync events X days old only.

PROBLEM:

If user wish to continue syncing events where it was left before.

SOLUTION:

Ksolves Office 365 Calendar gives the feature to continue syncing from the last synced event where he left. User can manage the syncing and keep track of how many records have been successfully processed in Jobs menu.


DEMO AVAILABLE
FREE 90 DAYS SUPPORT

Key Features

  • arrow
    Support for recurring events in Office 365 and Odoo
  • arrowr
    Configure and restrict syncing options
  • arrowr
    Advanced search and filter mechanisms for logs analysis
  • arrowr
    Manageable through a single console along with other Ksolves Office 365 apps
  • arrow
    User can sync according to their choice with the help of filters
  • arrow
    Makes use of powerful features of Office 365 Base
  • arrow
    Easily sync new items in Office 365 to Odoo and vice versa
  • arrow
    Ability to select which way to sync through a simple click
  • arrowr
    Ability to sync only latest events
  • arrowr
    Ability to continue the sync process where you left last time.

Setup

Authentication
arrow Visit portal.azure.com and login with your Microsoft account 365_1.0
arrow Click on Azure Active Directory > App registrations > New Registration 365_1.0
arrow Now, you will be asked to enter name, redirect uri for you App. Redirect uri must be http://your-base-url/office365/callback ( this will be used for authentication ) and now click Register 365_1.2
arrow Now, Go to Certificate & secret and create a new client secret. Copy the value of the Client Secret ( this will be used for authentication ) 365_1.3
365_1.4
arrow Go to Overview and copy value of Application ID (this will be used for authentication) woo_4
arrow Click on View API Permissions > Microsoft Graph > Delegated Permissions and choose required permissions and then click on Add permissions at the bottom, as shown below woo_4
woo_4
woo_4
arrow Provide ReadWrite permission for Office 365 apps woo_4
arrow This is how the permissions will look like: woo_4
arrow Once you installed the Base module now go to Settings > Users > your-admin-account. In Access Rights, set ‘Office365 Rights’ to ‘Office365 Manager’, save and refresh the page. (Only manager has the right to authenticate the connector, other users will just sync their record) arrow
arrow Access Rights must be given according to the User access. Manager level access can access Office 365 settings and authentication arrow
arrow User with office365 User can only allowed for syncing arrow
arrow Go to Users & Companies > Office365 Settings and set Client ID, Client Secret and Redirect URL ( all these are already generated from the azure portal just paste them here ) and click save. arrow
arrow
arrow Manager level access(Odoo Admin) can access the office 365 utilities from settings as well as from the side menu arrow arrow Click on the Generate Token button as shown below - arrow
Users will be asked to give permission to read and write to Microsoft Contact. Click on the Yes button in order to proceed further arrow
Click on the office365 menu > Logs menu , It will display as Token generated successfully. arrow Now you are good to go for syncing
Office 365 Calendar Features and Working
arrow Click on the Office 365 menu. arrow arrow Click on Office365 Calendar tab. arrow arrow You will have multiple filters to sync the events, there will be two options to sync events on both sides. Firstly you have to choose the key fields to sync, it is highly recommended to choose those fields that uniquely identify each event.
arrow
If you wish to sync only latest events, then you need to input the days in order to sync those events.
arrow
Further, if you wish to filter your events then you can choose a domain filter to view your results. This is only applicable from Odoo to Office 365.
arrow
You have an option to sync deleted events from Odoo and Outlook Calendar, this will deleted any event from Odoo Calendar if its deleted in Outlook Calendar and vice-versa.
arrow
Further, you can choose to sync meetings from desired categories only. arrow
Next you can choose appropriate syncing direction.
arrow
Creating & Syncing Odoo - Outlook Calendar Events
arrow You must set your timezone in order to match the timings of calendar events. You can do so by clicking on your Profile > Preference. Then you can set your timezone and then click on the Save button. arrow arrow arrow If you click on Sync Office365 Calendar to Odoo, your outlook events will be synced with odoo events. arrow arrow arrow You will be redirected to the logs with details of all the events that are synced. arrow arrow If you click on Sync Odoo Calendar to Office365, your odoo events will be synced with outlook events. arrow arrow arrow You will be redirected to the logs with details of all the events that are synced. arrow
Job Processes Working
arrow User can keep an eye of their previously successful or unsuccessful jobs by visiting Jobs menu on the top.
arrow
For any unsuccessful job, you can see how many records are processed and the corresponding reasons for the failures.
arrow
arrow
Syncing will resume from the last record processed, and if you want to sync all over again you can delete the entry and start syncing.
arrow
Automatic Syncing
arrow You can manually sync your calendar events or you can activate cron to do syncing automatically.
To activate cron follow the following steps -
Go to Settings, and then Activate the developer mode
arrow
arrow Now go to Technical > Scheduled Actions
arrow
You will see two crons 'Run Office 365 Calendar Import Cron' and 'Run Office 365 Calendar Export Cron' for importing and exporting respectively.
If you wish to export Odoo calendar events to Microsoft calendar automatically, click on Run Office 365 Calendar Export Cron.
arrow
You can activate the cron by clicking the Off button, as shown below
arrow
If you wish to import Microsoft calendar events to Odoo calendar automatically, click on Run Office 365 Calender Import Cron.
arrow
You can activate the cron by clicking the Off button, as shown below
arrow
Now syncing for all the users will be performed after the given interval.

User Guide

User can find the complete User Guide of Office 365 Calendar inside ks_office365_calendar/documentation/ user_guide folder.

Our Releases

27th July, 2021

Latest Release 2.2.8

Feature - Filters added to handle reminder syncing from Outlook to Odoo.

26th May, 2021

Release 2.2.7

Fix - Code optimised to handle the error if multiple Contacts having same Email.

3rd February, 2021

Release 2.2.6

Fix - Introduced new fields for the Scope functionality on the dashboard.

08th December, 2020

Release 2.2.5

Fix - Non-English language issue while syncing using cron.

Fix - Issue while exporting meeting with negative timezone.

25th June, 2020

Release 2.2.4

Fix - Private meetings cannot be update/deleted using cron.

08th June, 2020

Release 2.2.3

Fix - Code optimised to handle the error if API does not return meeting list with the response.

05th June, 2020

Release 2.2.2

Enhancement - User has the ability to restrict creation of invitation mail while creating or updating meeting at the time of syncing.

29th May, 2020

Release 2.2.1

Fix - Only 255 description character are imported from Outlook.

Fix - Meeting "show as" is set to busy if it is other than free or busy in Outlook.

07th May, 2020

Release 2.2.0

Fix - Meeting responsible user not found.

14th April, 2020

Release 2.1.9

Enhancement - Realtime syncing optimized.

27th March, 2020

Release 2.1.8

Fix - Duplicate invitation email for the attendees are generated while import and export meeting.

13th March, 2020

Release 2.1.7

Enhancement - Added Category functionality in Calendar module in which user can sync only selected Events.

11th February, 2020

Release 2.1.6

Fix - Meeting is not imported if Show as is set other than free or busy.

Enhancement - Code Improvement

3rd February, 2020

Release 2.1.5

Fix - Leaves are not syncing from Odoo to Office

28th January, 2020

Release 2.1.4

Fix - Private meetings visible to other users

Fix - Attendees receiving multiple emails while syncing meetings

2nd January, 2020

Release 2.1.3

Fix - Syncing recurring events with no end date

Fix - Portal user able to sync while syncing through cron

28th December, 2019

Release 2.1.2

Fix - User able to sync meetings that he is not attending

11th December, 2019

Release 2.1.1

Feature - Sync deleted events from Odoo and Outlook Calendar

28th November, 2019

Release 2.1.0

Fix - Monthly and Yearly recurrent meeting having one extra occurrence.

Fix - Minor bug fixes and code optimization.

Fix - Created separate cron for importing and exporting contacts.

24th October, 2019

Release 2.0.0

Feature - Ability to sync only latest events.

Feature - User can sync according to their choice with the help of filters.

Feature - Ability to continue the sync process where you left last time.

Feature - Ability to sync event as soon as they are created in odoo.

Frequently Asked Question

Is this app compatible with Odoo Enterprise?
Yes, our app works with Odoo Enterprise as well as Community.
Need some customization in this app, whom to contact?
Please drop email at sales@ksolves.com or raise a ticket through Odoo store itself.
Do you provide any free support?
Yes, we do provide free support for 90 days for any queries or any bug/issue fixing.
FREE 90 DAYS SUPPORT

Ksolves will provide FREE 90 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.

Note:

Extensively Tested on Odoo Vanilla with Ubuntu OS

Ksolves Odoo Services

ksolves
support
Odoo Implementation
apps
Odoo Community Apps
support2
Odoo Support & Maintenance
custom
Odoo Customization
integrated
Odoo Integration Services
develop
Odoo Developer Outsourcing
sales@ksolves.com
+91 120-4299799‬
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
by
muhammed noufal
on 6/22/23, 9:11 AM

i saw a warning in odoo documentation , is it addressed in the module ?

If the user has any past, present, or future events on their Odoo calendar before syncing their Outlook calendar, Outlook will treat the events pulled from Odoo’s calendar during the sync as new events, causing an email notification to be sent from Outlook to all the event attendees.


Even after synchronizing the Odoo Calendar with the Outlook calendar, Outlook will still send a notification to all event participants every time an event is edited (created, deleted, unarchived, or event date/time changed), with no exceptions. This is a limitation that cannot be fixed from Odoo’s side.

After one user syncs their Outlook calendar to the Odoo database, unwanted email notifications are unavoidable because the first synchronized user’s events will be in the Odoo Calendar. If the Odoo database is shared amongst multiple users, and another user wants to sync their Outlook calendar with Odoo Calendar, Outlook will again pull the existing Odoo Calendar events during the sync and treat them as new events, causing Outlook to send email invitations to all event attendees.

Unfortunately, this limitation cannot be fixed from Odoo's side since it is related to Outlook's behavior.

Re:
by
Ksolves
on 6/22/23, 12:35 PM Author

Hello Muhammed

Thanks for reaching out to us,

When any event gets created in Outlook, then it's the Outlook functionality and behaviour to send the email to all the attendees. 

And as the Office 365 Calendar is an Odoo-based module so we cannot modify or change the Outlook functionality to restrict sending email to the attendees for past events.

But in the Office 365 Calendar module we have given the feature of a date filter using, which you can sync the latest mail only from Odoo to Outlook. So using this filter, your past events will not get exported to Outlook.

If you have any other concerns or queries, please feel free to reach out to us odoo.helpdesk@ksolves.in.

Thanks,

Team Ksolves!