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.
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.
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.
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.
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.
User may wish to sync only latest events.
Ksolves Office 365 Calendar gives the feature to sync events X days old only.
If user wish to continue syncing events where it was left before.
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.
Login to your Microsoft account and visit portal.azure.com
Click on Azure Active Directory > App registrations > New Registration.
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.
Now, Go to Certificate & secret and create a new client secret. Copy the value of the client secret (this will be used for authentication).
Go to Overview and copy value of Application ID (this will be used for authentication).
Go to View API Permissions > Add permission > Microsoft Graph > Delegated Permissions and choose required permissions and click Add permissions at the bottom.
In order to switch the permission, chose the permissions as per you choice.
Note: You must provide both Read and ReadWrite permission for your apps.
This is how the permissions will look like:
Once you installed the Base module, now go to Settings > Users & Companies > your-admin-account. In Access Rights set ‘Office365 Rights’ to ‘Office365 Manager’ and refresh the page. (Only manager has the right to authenticate the connector, other users will just sync their record).
Access Rights must be given according to the User access. Manager level access can access Office 365 settings and authentication.
User with office365 User can only allowed for syncing.
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.
Manager level access (Odoo Admin) can access the office 365 utilities from settings as well as from the side menu.
Click on the generate token button as shown below -
You will be asked to give permission for the apps you have installed with this base module. Click on the Yes button in order to proceed further.
Click on the office365 menu > Logs menu , It will display as Token generated successfully.
- 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.
- Click on the Office 365 menu.
- Click on Office365 Calendar tab.
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.
If you wish to sync only latest events, then you need to input the days in order to sync those events.
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.
If you wish to sync deleted meetings as well you can choose the below checkbox.
You can also sync meeting from a perticular category using below feature.
Next you can choose appropriate syncing direction.
- If you click on Sync Office365 Calendar to Odoo, your outlook events will be synced with odoo events. You will be redirected to the logs with details of all the events that are synced.
- If you click on Sync Odoo Calendar to Office365, your odoo events will be synced with outlook events. You will be redirected to the logs with details of all the events that are synced.
User can keep an eye of their previously successful or unsuccessful jobs
by visiting Jobs menu on the top.
For any unsuccessful job, you can see how many records are processed and the corresponding reasons for the failures. 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.
You can manually sync your calendar events or you can activate cron to do
syncing automatically. Automatic syncing will first sync your odoo events to
Microsoft events and then vice-versa.
To activate cron follow the following steps -
Go to Settings, and then Activate the developer mode.
Now go to Technical > Scheduled Actions.
You will see two crons 'Run Office 365 Import Cron' and 'Run Office 365 Export Cron' for importing and exporting respectively.
If you wish to export Odoo calendar events to Microsoft calendar automatically, click on 'Run Office 365 Export Cron'.
You can activate the cron by clicking the Off button, as shown below
If you wish to import Microsoft calendar events to Odoo calendar automatically, click on 'Run Office 365 Import Cron'.
You can activate the cron by clicking the Off button, as shown below
Now syncing for all the users will be performed after the given interval.
Ksolves Suggested Apps
Ksolves Odoo Services
Odoo Community Apps
Odoo Support & Maintenance
Odoo Integration Services
Odoo Developer Outsourcing
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.