+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Home Access Plus+ Thread, Room Booking History/Reports in Projects:; Hi guys Is it possible to take a look at previous weeks bookings in HAP booking system? Or even to ...
  1. #1

    Join Date
    Apr 2012
    Posts
    420
    Thank Post
    39
    Thanked 35 Times in 28 Posts
    Rep Power
    16

    Room Booking History/Reports

    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

  2. #2
    beneal's Avatar
    Join Date
    Mar 2010
    Location
    Ormskirk
    Posts
    48
    Thank Post
    8
    Thanked 10 Times in 9 Posts
    Rep Power
    20
    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.
    Last edited by beneal; 31st January 2013 at 09:29 AM.

  3. #3

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    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

  4. #4
    beneal's Avatar
    Join Date
    Mar 2010
    Location
    Ormskirk
    Posts
    48
    Thank Post
    8
    Thanked 10 Times in 9 Posts
    Rep Power
    20
    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?

  5. #5

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    Sounds like it can't go back in the data that far

  6. #6

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    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

  7. #7
    beneal's Avatar
    Join Date
    Mar 2010
    Location
    Ormskirk
    Posts
    48
    Thank Post
    8
    Thanked 10 Times in 9 Posts
    Rep Power
    20
    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

  8. #8

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    Ah ok, can you paste the error you're getting, do you have any timetabled lessons in the system yet?

  9. #9
    beneal's Avatar
    Join Date
    Mar 2010
    Location
    Ormskirk
    Posts
    48
    Thank Post
    8
    Thanked 10 Times in 9 Posts
    Rep Power
    20
    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

  10. #10

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    Ok, it doesn't seem to like one of the users it is trying to get

  11. Thanks to nickbro from:

    beneal (31st January 2013)

  12. #11
    beneal's Avatar
    Join Date
    Mar 2010
    Location
    Ormskirk
    Posts
    48
    Thank Post
    8
    Thanked 10 Times in 9 Posts
    Rep Power
    20
    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?

  13. #12

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    Can't really remember it's been a while since that page was touched

  14. #13

    Join Date
    Apr 2012
    Posts
    420
    Thank Post
    39
    Thanked 35 Times in 28 Posts
    Rep Power
    16
    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

  15. #14

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,649
    Thank Post
    43
    Thanked 553 Times in 461 Posts
    Rep Power
    122
    There's a static or booking made with a user that doesn't exist any more

  16. #15

    Join Date
    Apr 2012
    Posts
    420
    Thank Post
    39
    Thanked 35 Times in 28 Posts
    Rep Power
    16
    How can I look through to remove that? Is it in an XML file somewhere?

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Room Booking Software
    By timbo343 in forum Windows
    Replies: 14
    Last Post: 6th June 2009, 10:28 AM
  2. Room booking application
    By OverWorked in forum How do you do....it?
    Replies: 45
    Last Post: 23rd October 2008, 11:21 AM
  3. Do you use Room Booking Software?
    By jazzy639 in forum Educational Software
    Replies: 30
    Last Post: 23rd October 2008, 11:09 AM
  4. Room Booking Database/Web based (.asp)
    By danIT in forum Downloads
    Replies: 131
    Last Post: 7th November 2007, 10:20 AM
  5. Meeting Room Booking System - examples config inside!
    By db260179 in forum Network and Classroom Management
    Replies: 7
    Last Post: 25th July 2007, 07:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •