Calendar Script 2

[CMUTech]

Looking for script that will extract Exchange calendar information into html. We have five conference rooms. I would like to display each day's meetings in an html table on our intranet, so that staff could take a quick look at one web page and see all the meetings in all the rooms for that day (minus the unscheduled hours).

Currently I am using

http://accessmail/exchange/roomname/Calendar/?Cmd=contents&View=daily&Page=1

It displays a nice html page of only one room for that day but also with all the hours that have no appointments scheduled. I want to extract only the appointments, and do that for five different rooms, on one web page.

Thanks,
CMU Tech

 

[WhoKilledKenny]

Suggestion...

You could build a web page that uses frames and add each Calendar in it's own frame. You could also change it to a monthy view by changing View=monthly in the URL.

 

[BenChristian]

You have a few options. The easiest solution is to create an HTML doc that contains 5 Outlook View Control ActiveX Controls. The Outlook view control allows to to point to an Outlook folder (a public folder for example). The content is displayed on the web page exactly how it would be displayed in Outlook. Take a look at an example here:

http://www.outlookcode.com/d/OVCViewDemo.htm

Note that the security issues surrounding the OVC where resolved in Outlook 2003.

The second method would be do use the Outlook Object Model to access the items in each calendar, then loop through each item in your date range and display them on the web page. I can help you out with some sample code if you decide to go down this path.



Ben Christian
MCSE, MCSA:Messaging

http://www.benchristian.com

 

[58sniper]

CMUTech -

Are you using SharePoint for your Intranet? If so, I think there is built in support for what you're trying to do.

Pat Richard, MCSE MCSA:Messaging CNA
Microsoft Exchange MVP
Want to know how email works? Read for yourself -

http://www.ietf.org/rfc/rfc2821.txt

 

[dearingkr]

BenChristian:
I followed your link expecting a standard demo page...
It kind of freaked me out because it showed MY OUTLOOK stuff!
Very cool though.

MCSE CCNA CCDA

 

[BenChristian]

Yep, it's cool. Don't be freaked out by the fact that it was displaying your outlook inbox etc, that's exactly what it is supposed to do!



Ben Christian
MCSE, MCSA:Messaging

http://www.benchristian.com

 

[markdmac]

A star from me Ben, that is really cool stuff.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[CMUTech]

Thanks everyone. I think I'll try the Outlook Object Model route. I don't really want to display an entire day of unscheduled slots, just the ones that are scheduled. When I started searching for a solution I ran into several web sites that raved about the OWA possibilities of mining information but when I actually tried to track down resources, I could not find anything but continued raving. That's when I came here for help. Your attention to my concern is very much appreciated.

CMU Tech

 

[BenChristian]

Great, here's an excellent reference for working with the outlook object model:

http://www.microeye.com/resources/Outlook 2003 Object Model Extended View.zip

Ben Christian
MCSE, MCSA:Messaging

http://www.benchristian.com