User Tools

Site Tools


outlookintegration

This is an old revision of the document!


Outlook Integration

This feature provides one-way synchronization of events between System Five appointments and the Outlook 365 calendar. Events are sent/updated from one side to the other, so it's 2 way in that regard, but if you edit an event that was synced, the changes will not be sent back.

Rules

Events / tasks are only synced when the user has open and is logged into the calendar event sync web application.

Customer & Delivery Tasks created / updated in System5 are sent to Outlook if flagged to sync (There is a new Sync Checkbox in the appointment edit UI); they will be flagged with an Outlook Colour Category of Received From System5. They will only be sent if the Start time is greater than the time of the sync.

Tasks with customers attached will have a Google maps link embedded in the body for the Bill To, or Ship to address (as applicable)

Tasks synced to Outlook will:

  • not be removed from Outlook if the source is deleted in System5
  • Unordered List Itemnot be updated in System5 if changed in Outlook

Unless you were to add the [sync] to the subject in Outlook, but you will likely see odd behaviour with address links (this is not a supported usage, but isn't prevented)

  • have previously synced values in Outlook overwritten if the source is updated in S5 (start / end / alarm / title / body / categories)

Tasks created / updated in Outlook with the word [sync] in the Subject will be flagged for import to System Five. They will only be sent if the Start time is greater than the time of the sync and the End time is less than or equal to 2 weeks past the current sync time. Only single instance events are synced from Outlook; Events that are part of a recurrence are not synced.

Tasks synced to System5 will:

  • not be deleted in S5 if the source is deleted in Outlook
  • have synced values in S5 overwritten if the source is updated in Outlook (start/end/alarm/title/body)
  • be skipped if they are part of a recurrence; only single instance tasks are synced
  • be flagged as needing review and when first opening System 5, if the option to show Today’s Tasks is enabled will show up in the list of tasks in light green. Regardless of what date is selected for display, these tasks needing review will show up listed under all dates until they have been opened and saved (if the Start Date has passed they’ll still be green, but won’t show up under all dates).

Components

Calendar Event Sync Web Application

  • When the web app is open and the onboarded user logged in, every 10 minutes Outlook 365 and System Five will be checked for new calendar items to sync.
  • Reads / writes user and tenant config information in the CALENDAREVENT database. Also tracks the Id mapping of synchronized events (Outlook event ID to System Five Task Id) to prevent duplicate event creation and to allow for updates.
  • Hosted in Azure
outlookintegration.1599874444.txt.gz · Last modified: 2020/09/11 18:34 (4 years ago) by jbalasabas