Archive

Posts Tagged ‘aggregating’

Aggregate room and resource calendars for Overview

Calendar_Language_Resource_Center_UNC_Charlotte_-_2014-03-26_20.10.30

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

Protected: Facilitating equipment circulation and room booking with website calendar aggregation?

2014/01/29 Enter your password to view comments.

This content is password protected. To view it please enter your password below: