Tuesday, September 8, 2009

Master “Roll-Up” Calendar in SharePoint 2007


This post simply references a video I recorded for a customer.  I was asked to build and demonstrate one approach to consolidating six calendars that were maintained independently across the organization into SharePoint 2007.  Some were updated simply by making changes to static HTML pages, while others were served up by a variety of application servers (classic ASP, Rails, PHP, etc.).

The premise of my solution was that all these individual calendars needed to be migrated to SharePoint, since that was a large organizational objective anyway.  Once that was done, a “master calendar” would be created in SharePoint, and a custom event handler would be written in C# so that create, update, and delete events in any of the six “child” calendars would be synchronized to the “master” calendar. 

http://www.screencast.com/users/JonSchultz/folders/Default/media/2663912c-23d0-4eb3-871e-91889baf0681

UT

Caveat:  I realize that most of these stated requirements could have been achieved with some combination of either custom views or perhaps content types.  However, I was also instructed that our solution needed to connect to Outlook, Entourage, and essentially any other RSS reader our customer might choose to use.  The organization has a large percentage of Mac users, and after testing a few approaches using views and content types, we found a simple custom event receiver to be more reliable when serving the content across such a wide variety of consumer applications. 


Jonathon Schultz
mobile:
407.923.4946 | fax: 866.569.2615 | email: jon@jonschultz.com