Calendar synchronization

Calendar Synchronization Setup – User

You can use the calendar synchronization function to let WorkBook import your calendar appointments and place the tasks that has been assigned to you in your calendar. We currently support Gmail and Exchange calendars.

Note: When using Outlook / Exchange calendar sync, it reserves the several categories that each uses the word “WorkBook”. As such, you cannot have any other custom made categories that contains the word “WorkBook”, and you are not allowed to rename or move exported workbook tags outside of that category.

The exchange server must run one of the following versions:
1.a. Microsoft Exchange server 2007 requires the use of the address
1.b. Microsoft Exchange server 2010 requires the use of the address
1.c. Microsoft Exchange server 2013 requires the use of the address
1.d. Exchange Online / Office 365 requires none.

Once you have this URL, you can set it as the server for calendar synchronization under “My Settings”.

Remember to check URL for typos and misspelling.

Once this is done, each user can set their login information and other settings through the “My settings” sidebar. Here it is also possible to override the calendar server if relevant.

Skærmbillede 2015-10-22 kl. 15.35.15

These same settings can be accessed by administrators for all employees through a centralized administration view, accessed through “Settings” -> “Advanced tools” -> “Calendar sync”.

Once all settings have been configured, synchronization should take place automatically depending on how the calendar is set to synchronize.


If it does not, or if you need assistance, please do not hesitate to contact us.

1.   For Google Calendar Synchronization setup please follow this guide.



   Text pattern for calendar sync to target job

When calendar synchronization is importing tasks from an external calendar, it will look for the text pattern in this setting, followed by a job number.

If the pattern is found, the task will be imported to the job number that follows.


  • The job is closed
  • Is an absence/holiday
  • Does not have an active plan

Here is an example, I changed it to (Import # ) Keep in mind the space between hashtag
Skærmbillede 2015-10-22 kl. 15.38.24

Now I created an appointment in my calendar saying Import # 1008 Meeting about the website design
Skærmbillede 2015-10-22 kl. 15.39.53

After the synchronization you would be able to see it in your personal calendar or on your task list on the correct job, which in this case is 1008
Skærmbillede 2015-10-22 kl. 15.48.57


Handling private events

Private events must be marked as such in Outlook/Google calendar. System variable 630 determines what WorkBook will do with private events.

Screen Shot 2016-03-17 at 9.27.58 AM


Deleting all synced events

If you want to start from scratch and purge everything that has been synced, it can be done from the calendar sync settings. Simply change the action and wait for the agent to run (or run the agent manually).


Calendar Synchronization Setup – Administrator

To set up calendar synchronization, the relevant system variables must first be set. All system variables pertaining to calendar synchronization can be found in the system variable group “Calendar Syncronisation (Microsoft Exchange & Gmail)”. Below are the most important system settings that must be set in order for calendar synchronization to function.

System variable 295

Calendar synchronization: appointment default job

This system variable points to the default job ID which imported calendar events will be added to. Each resource using calendar sync will have their own phase on the job for their tasks. Imported calendars can be reassigned to other tasks afterwards, or they can be specified with the job tag in system variable 932 to add it directly to that job. Make sure that your default appointment job is opened and that the end date hasn’t been exceeded.

System variable 630

Private appointments

This system variable shows how private user events should be handled when imported into WorkBook. It is possible to  set them to use the title “Private”, and to only transfer bookings inside the resource’s working hours.

System variable 862

Default time zone offset for calendar synchronization

If the majority of your resources are not in the same time zone as the one in which the WorkBook server is located, you may wish to set a default time zone offset that will be used as default and suggested to the users. Users will be able to override this value themselves in case their calendar do not use the same time zone.

If using Microsoft Exchange

System variable 878

Calendar sync default server value

This system value should link to the location of the Microsoft Exchange server used. If you are using office365 and are not hosting your own exchange server, it should be set to

System variable 879

Calendar Sync Default Version

If you are hosting your own version of the Microsoft Exchange server, specificy which version here. If you are using a newer version, selected the most recent one from the drop down.

If using Google Calendar

System variable 936

Google calendar API, clientId

System variable 937

Google calendar API, ClientSecret

These two user variables allows your WorkBook to link with the Google Calendar services. Follow the guide in to properly set this up.


Was this article helpful? Useful Useless 1/1 found this article helpful.