Archive
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:
First add ICS-based internet calendar subscriptions to Google calendar:
We have prior ICS feeds arranged in MS-Exchange 2010 which are listed in the LRC calendar spreadsheet:
Open the calendar
Copy the URL form the address bar:
Insert it here:
Replace html at the end by ics.
Check “make calendar publicly accessible”
Access calendar settings
Change calendar name to part before @
You can rename these subscribed calendars, but this name will not carry over to the embedded calendar, see below:
Open the settings for the main calendar:
In the settings section “embed”, Click the “Customize” link to open the “Google Embeddable Calendar helper”:
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:
Embedding the iframe HTML snippet works in WordPress