How to aggregate items from different calendars into one list or calendar

I am currently using MOSS to implement a portal for a bank named ABC . For each branch we have created a subsite like below:

http://ABCPortal/Branch1
http://ABCPortal/Branch2
.....
http://ABCPortal/Branchn

Each branch has different sections lets say which again is going to be another subsite of the branch. Something like this:

http://ABCPortal/Branch1/Section1
http://ABCPortal/Branch1/Section2
..
http://ABCPortal/Branch1/SectionN

In each section we have a calendar which memebers of that section can create events on it. Now here is my question , we have an employee site (dashboard sort of) called http://ABCPortal/Employees which everyone has access to it (an employee can have access to differnt sections in differnet branches as well). We would like to aggeegate the calander items in all sections of all branches which *emplyee is a memeber of* to the employee site(dashboard).

Originally we thought about content query web part ,but soon we realized that it cannot go cross sites, then RSS feed came to our mind which again is limited to one feed. Is there anything out-of-the-box we can use OR we have to implement our own method

Thanks a lot

SharePoint Products and Technologies2

Ray,

Are Branch1, Branch2... BranchN and Employees in the same site collection or does each branch and employee's their own site collection Contet Query WP can traverse all sites within a site collection.

If it isn't working for you then it sounds like you do have multiple site collections set up.

Let me know and maybe I can help.

Randy

no, not out of the box.

I would point you to the neat CalendarPlus web part for MOSS 2007/WSS 3.0

here is some data from their site:

Aggregate events from multiple SharePoint sites
Connect to any required list type (not only "Events")
Support viewing data from the user's Exchange calendar
Support resizing the calendar to fit your web site's design
Aggregates data from any legacy application (Professional edition)
Support list views - enabling you aggregate list items defined by custom SharePoint list views (Professional edition)
No client installation needed – fast & easy deployment
Multi-lingual (standard for all KWizCom components)
Supports MOSS 2007/WSS 3.0 (New beta version)
Supports different user credentials for SharePoint and Exchange server (New beta version)
Printable calendar (New beta version)

Thanks Ishai for your recommendation, we have actually added some new features...

full list on our web site - on Calendar web part - calendar plus page.

Thanks,

Uri Nissani

KWizCom Corp.

this is the current list -

Key Features

Feature	Standard edition	Professional edition	MOSS 2007/WSS 3.0
Support both MOSS 2007/WSS 3.0 and SPS 2003/WSS 2.0	P	P	P
Support resizing the calendar to fit your web page's design	P	P
Aggregate events from multiple SharePoint sites	P	P
Connect to any required list type (not only "Events")	P	P
Support viewing data from the user's Outlook calendar	P	P
Support viewing Microsoft Outlook shared calendars		P
Aggregate data from any legacy application		P
Event coloring according to event source	P	P
Event coloring according to event type		P
Support list views - enabling you to aggregate list items defined by custom SharePoint list views		P
Printable calendar	P	P
Support dynamic URL tokens – tokens such as [current site] enable you to use the CalendarPlus web part in a site template using relative URL, eliminating the need to configure the web part after a site is created		P
No client installation needed – fast & easy deployment	P	P	P
Dynamic generated background colors for aggregated list levels	P	P
Asynchronous calendar loading	P	P
Support different user credentials for SharePoint and Exchange server	P	P
Multi-lingual	P	P	P

No problems.

I still think you should add "actions" support to the items in the calendar, so people can do quick actions on the items.

"import to my calendar"
"Send link by email"
"delete"

and so on...

thanks,

we will consider it for our roadmap .

thanks Ishai

Uri