Room Booking History/Reports

[mattianuk]

Hi guys

Is it possible to take a look at previous weeks bookings in HAP booking system? Or even to print off some kind of reports?

Thanks

Matt

[beneal]

Hi Matt, you can view an indivdual day by putting '/#date' after the url, the same format it uses when you go forward in time:

eg. ..hap/bookingsystem/#25/01/2013

It'll show any dates that are still in the bookings.xml file. Obviously if you've got 'KeepXMLClean' on then it only keeps the last week I think. I don't know if there's a way to report a full week, although that would be a useful addition.

[nickbro]

Weekview.aspx is what you want, keepxmlclean clears the xml database after 1 full week

/bookingsystem/weekview.aspx?d=20/1/13 or what ever date

[beneal]

Thanks Nick, didn't know that existed! Unfortunately when I try it I just get a server error 'Index was outside the bounds of the array. ' Any ideas?

[nickbro]

Sounds like it can't go back in the data that far

[nickbro]

Ok, the index error is a strange one, try copying the file from the main release and replace it, I may of updated and not released it in the update release

[beneal]

Sorry, that didn't work. We started from scratch with our current install using the main release anyway so that's the version we had

[nickbro]

Ah ok, can you paste the error you're getting, do you have any timetabled lessons in the system yet?

[beneal]

Here it is:

Server Error in '/hap' Application.
Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[IndexOutOfRangeException: Index was outside the bounds of the array.]
HAP.BookingSystem.Booking.get_User() +637
HAP.Web.BookingSystem.WeekViewRow.RenderContents(H tmlTextWriter writer) +1321
System.Web.UI.WebControls.WebControl.Render(HtmlTe xtWriter writer) +52
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +315
System.Web.UI.HtmlControls.HtmlContainerControl.Re nder(HtmlTextWriter writer) +48
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Page.Render(HtmlTextWriter writer) +40
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5290


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

And yep, loads of static bookings

[nickbro]

Ok, it doesn't seem to like one of the users it is trying to get

[beneal]

Cheers Nick, you're right - there were a few static bookings where we'd used names other than usernames (or blanks). Have edited those and it's fine now. This is a great feature! Is there any styling I can edit to differentiate static/casual bookings?

[nickbro]

Can't really remember it's been a while since that page was touched

[mattianuk]

I am getting the following error:

Server Error in '/HAP' Application.

Index was outside the bounds of the array.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[IndexOutOfRangeException: Index was outside the bounds of the array.]
HAP.BookingSystem.Booking.get_User() +637
HAP.Web.BookingSystem.WeekViewRow.RenderContents(H tmlTextWriter writer) +1321
System.Web.UI.WebControls.WebControl.Render(HtmlTe xtWriter writer) +52
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +315
System.Web.UI.HtmlControls.HtmlContainerControl.Re nder(HtmlTextWriter writer) +48
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +246
System.Web.UI.Page.Render(HtmlTextWriter writer) +40
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5290

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

[nickbro]

There's a static or booking made with a user that doesn't exist any more

[mattianuk]

How can I look through to remove that? Is it in an XML file somewhere?