ExCon: User Manual - Project-IT/MySQL-ExCon GitHub Wiki

User Manual


First time installation

After installing the plug-in you need to input your SQL Database IP and the required log-in information to be able to access the Database.

On the right hand side of the add-ons configuration page you will see a link called 'ExCon Sync Configuration'.

There you will enter the SQL server credentials and select the scope of the plug-in. The little box-selecter tells the program how many months ahead to get information from.

If the database credentials are wrong, you will receive an exception specifying what is wrong or missing when attempting to synchronize with Outlook.

After this first time setup has been completed you should be good to go! You can get events from today all the way to today 2 years from now. Since the start date is set from the day you perform first time setup, if you ever have any problems - return to the 'ExCon Sync Configuration' page.


User Configuration

Every time a user wants to sync his/her Outlook Calendar he/she can press the navigation button Outlook Sync. [PIC OF NAV BUTTON] In this menu, the user would enter their Outlook Email Account, Outlook Password and the name of the Calendar you want to put your events into.

Be patient! Our plug-in is logging into your Outlook account and that takes a while. The event fetching runs at ~nlog(n) time though so even if you have a lot of events it should not take that long after it has logged in!

Only All-Day Events

The way our code works is, it checks if the events in Outlook are marked as All-Day events and only retrieves them. This was decided along with our product owner since they only wanted Vacation Events to be synced and All-Day is a good indication of a vacation.

You are free to change the source code to include all types of events.

Results

After performing these steps, you should see your Outlook Events tagged as All-Day events show up in the Confluence Calendar with the associated account in front of the event name. This is to show everyone who views the Team Calendar who added the events.