Summary Matrix?

[geguerrero]

I have a weekly and monthly need to summarize reservation data in off-line calendars for non-internet enabled users of our schedule. I have been trying to find a quick and easy way to pull a weeks worth of reservations, or a months worth with start/end time, summary, and resource but I just can't seem to find a way to get it. I have tried searching for the time period, but the output does not contain the summary and is broken up by user and resource rather than being chronological.

The closest thing I have found is "Manage Reservations", I can navigate to a time period, and cut and copy the data into a word processor or spreadsheet and remove extraneous columns. Is there an easy way to add the summary data to this matrix? I've seen at least one suggestion for getting summary data to display in the scheduling grid, but I don't know enough about php to know how or where to modify the templates to pull that into the displayed data.

This might also be a general suggestion, essentially all the matrices that I have seen, My Reservations, My Invitations, etc. omit the summary data, which I think many users would appreciate viewing.

As always, thank for any assistance anyone can offer. And kudoes to Nick (and all the others who have helped) for making such a terrific and useful product.

Gil Guerrero

[Nick]

The easiest (and from your post, hopefully the most useful) would be to show it on the "My Calendar" and "Resource Calendar" pages.  This is something that could easily make it into the next version.

[picabotwo]

Well you could do it quite easily by installing the mysql OBDC interface and importing and show what information you want in excel. You might have to do a few excel conversion scripts but that should not be to hard.

I also wrote a perl script that generates an output of every single resource, email, start date, end date, start time, and end time based on what day it is.
I guess it would not be too hard to make it pull a weeks worth or months worth. I basically have the perl script generating a file to a network drive. And another sh script run when a person logs into a server and lets them know if the resource is scheduled. Email me here or at josh.noonan @ andrew.com if you got any questions.

Thanks!