Room and Equipment Reservations

Right, after an extremely frustrating day trying to get my head around XSL – something I never want to repeat again – I am near to having completing a re-hashed template of the Room and Equipment Reservations template originally provided by Microsoft for SharePoint 2007.

Following the post by Samantha – http://blogs.technet.com/b/tothesharepoint/archive/2010/08/18/sharepoint-2010-products-upgrade-and-the-fabulous-40-application-templates.aspx – which explains that the Fab 40 are not to be recreated, and although Khalil is working hard to recreate them on his site http://techsolutions.net/Blog/tabid/65/EntryId/17/Fab-40-Templates-for-MOSS-2010.aspx), I am just impatiant really!

So, for out recently upgraded SharePoint 2010 deployment we will shortly have a working Room Bookings system again.

One of the key changes in my rewrite of the template, is the removal of the need for the list to have to include details of all the time in a day – both available and booked. One of the things that really frustrated me in SharePoint 2007 was the need to make sure when you deleted a booking that the free time was re-calculated – which depending on the view that you were in (we frequently did bulk updates through the datasheet view) didn’t update the list correctly. Bit of a headache to implement in XSL – but nearly there. Also I have managed to break down all of the ‘Free’ time into 30 minute blocks. One of the frequent problems at work was people clicking a section and forgetting to check both the start and the end times – resulting in wasted resources.

I am hoping that I will be able to finish tweaking the template tomorrow. Providing I can sort out restrictions on double booking a resource, I will be able to post the template on this site for others to download. Not saying that it is going to be perfect (still spending a lot of time working on SharePoint and developing my skills) but hopeflly it will help someone else out.

5 people found this post useful.


14 thoughts on “Room and Equipment Reservations

    1. I have just picked this back up again to fix an error in the version that I have running – still some work to do on conflict checking, etc. It’s back on at the minute though – so will see what I can get done.

      1. Would love to know where we could take a look at the template in it’s current state, or where we can download it? We just had a request come in for this type of solution. Thanks!!! Jeff

  1. Oh oh oh – how’s it coming? I’m another one who could really, really use this for SharePoint Server 2010. Thanks for undertaking a project to benefit the rest of us.

  2. Hi Craig,

    do you have any news re this?
    Unfortunately both you and Khalil not accomplished that long-awaited thing yet.
    Or am I wrong?

    1. You are right – I have not yet managed to complete it!

      Work pressures at the minute are not giving me enough time to work on the project – so it has stalled. I do hope to complete it one day shortly though.

  3. Craig,

    I deployed the RR Template and being using it and I was aware of the bug that if you delete a reservation then the resource looks booked like forever, so I had told people to create a new reservation instead of deleting, weel they did not listen and now I have a couple of resources not available for booking. Is you fix going to deal with this? and how is that going? Thx

    Carlos

    1. Carlos,

      My site will not fix any previous errors (like the one you have mentioned). It does however work in a totally different way and only deal with actual bookings and not free time too in the database.

      The template is coming along, but I have not had time to complete it due to other work pressures. Hoping to get it done soon though.

      Thanks for your interest.

  4. Hi Craig,

    Any news on when this might be available? I am new to sharepoint as well and would love to see how you have imporoved upon this template.

    Thanks,
    Kim

    1. Ive just about finished testing the event handlers. Been on the back burner for a couple of weeks though. Hoping to complete by mid February though.

  5. Just incase someone is looking, I haven’t forgotten about this. Not yet had the time to set up a development server to write the checking module.

    Am working on it, and hoping it might be done for the new year.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.