Home > documentation, e-infrastructure, service-is-library > To publish an aggregate calendar of MS-Exchange ICS calendar subscriptions, use Google Calendar

To publish an aggregate calendar of MS-Exchange ICS calendar subscriptions, use Google Calendar

If you manage many resources that many users need to share, you will want to give them an intuitive overview of the utilization. We manage room and equipment booking in MS-Exchange 2010, but both Exchange and Outlook/OWA/Office365 are not for everyone (to set up), and seem to lack a convenient way to publish an aggregation of the iCal feeds of the individual resources that can be published.

Enter Google calendar: Start with creating a new calendar which will hold your calendar aggregation, and make it public:

clip_image002

clip_image003

clip_image004

clip_image005

First add ICS-based internet calendar subscriptions to Google calendar:

clip_image006

clip_image007

We have prior ICS feeds arranged in MS-Exchange 2010 which are listed in the LRC calendar spreadsheet:

clip_image008

Open the calendar

clip_image009

Copy the URL form the address bar:

clip_image010

Insert it here:

clip_image011

Replace html at the end by ics.

Check “make calendar publicly accessible”

clip_image012

Access calendar settings

clip_image013

Change calendar name to part before @

clip_image014

clip_image016

clip_image017

You can rename these subscribed calendars, but this name will not carry over to the embedded calendar, see below:

clip_image018

clip_image019

Open the settings for the main calendar:

In the settings section “embed”, Click the “Customize” link to open the “Google Embeddable Calendar helper”:

clip_image020

Select the “Calendars to display”: this list contains the ICS-subscriptions you added earlier.

Unfortunately, the Google’s embeddable Calendar helper seems to “eat” the names you have given these calendars, and replace it by the default “Calendar” (there is no calendar name stored in the ICS, it seems), so you have to maintain a color legend manually (the color is permanently stored in the iframe HTML code snippet).

Also, you users have to manually match the color when they (de)select calendar subscriptions from the main calendar:

clip_image022

Embedding the iframe HTML snippet works in WordPress

clip_image023

as well as Drupal: image

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: