Open Source Initiative (OSI) PostgreSQL Java

VCalendar Integration

Integrating remote calendars with Connect

Using a vcalendar/ics compliant URL allows for events to be synchronized right into Connect. Your events are then displayed in the web events calendar, and can flow right into your mobile apps for additional functionality.

Setup is done by an administrator.

  1. Locate the profile you want to import the calendar into. Record its text profile-id either from the URL (the part after /show/) or from the Details page next to its numerical id.
  2. Make sure the calendar URL works and is publicly available. Try adding the URL to your own calendar app.
  3. Insert a record into the \ table in the Connect Database. Specify the URL and the projecttextid fields.
  4. Once the scheduler has run, the Admins will receive an email showing the events which were synchronized. Verify the start date/time of the events. If an adjustment is required due to a mismatch, then update the \ table with a date_time_offset.

Events are updated and cancelled as they are updated and cancelled in the calendar service.

Example database record:

-[ RECORD 1 ]----+-------
id               | 1
url              |
projecttextid    | 
enabled          | t
entered          | 2016-04-04 16:12:23.677
modified         | 2016-04-04 16:12:23.677
processed        | 2016-06-14 00:10:15.993
date_time_offset | 0 

Sign in to add your comment.