Changing the Date Range

Last update:
Created :
Written by Support InfoBridge

Overview

Please be cautious when changing the number of days in the past/future!

Incorrect usage of changing the synchronization days in the past/future could result in duplicate appointments in SuperOffice and Microsoft Outlook!

Duplicates may occur when changing the days from one value and then changing the values back to the original value.

Tips

The Synchronizer is taking every precaution not to create any duplicates in SuperOffice and Microsoft Outlook.

This is done by making a copy of every appointment which is being synchronized to either program, and this copy is stored in a history table. Every time when the synchronization is triggered the Synchronizer will consult this history table to check if the appointment has already been already synchronized.

The history table looks something like this.

Date  Outlook ID SuperOffice ID User Type
6-1-2018 12 456 J. Langly Visit
6-1-2018 17 511 J. Langly Meeting
6-2-2018 19 662 J. Langly Phone Call
6-4-2018 33 669 J. Langly Demo
6-12-2018 67 701 J. Langly Visit
6-20-2018 90 788 J. Langly Internal Meeting
7-2-2018 98 793 J. Langly Meeting
9-10-2018 41 803 J. Langly Lunch
10-1-2018 53 804 J. Langly Demo

As an example, the current system date is 20-6-2018 and the days set in the past is 30 and the days set in the future is 120.

This means the synchronizer will synchronize all appointments between 21 May 2018 (05-21-2018) and 18 October 2018 (10-18-2018).

If you would change the days in the past to the value 1 and days in the future to 30, the Synchronizer will first clean out the history table for the selected range. Because the synchronizer range consists of all appointments between 19 June 2018 (06-19-2018) and 20 July 2018 (08-20-2018), the result in the history table will be:

Date  Outlook ID SuperOffice ID User Type
6-1-2018 12 456 J. Langly Visit
6-1-2018 17 511 J. Langly Meeting
6-2-2018 19 662 J. Langly Phone Call
6-4-2018 33 669 J. Langly Demo
6-12-2018 67 701 J. Langly Visit
6-20-2018 90 788 J. Langly Internal Meeting
7-2-2018 98 793 J. Langly Meeting
9-10-2018 41 803 J. Langly Lunch
10-1-2018 53 804 J. Langly Demo

The problem occurs when you decide changing the values back to the original values, so days in the past with the value 30 and the days in the future with the value 120.

When the Synchronizer is triggered again it will still encounter the appointments in Outlook or SuperOffice, but when checking the history table, the appointment is not found, and the decision is made to add the appointment.

THE GOLDEN RULES

1. Set the correct day values correctly the first time when using the Synchronizer the first time!
2. When changing the values afterwards, only change the days in the past to a lower value and only change the days in the future to a higher value!

Not following these rules will result in duplicate appointments. Follow our other guide to clean up SuperOffice / Outlook when such a situation occurs.