in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

tigirry's SharePoint Blog

Room and Equipment Reservations SharePoint Template Can't Reserve

As many of you have already experienced, "Room and Equipment Reservations" template from Fantastic 40 Application Templates is weak and poorly designed. Default list and calendar views for lists such as Reservations only display current user's reservations and if an administrator tries to change or create a all item calendar view, this view will display all items including "non-reservation" item. This "non-reservation" item is created in Reservations list when a user creates a new resource in Resources list. This is due to Microsoft's "brilliant" hidden field called RERStatus.

The way "Room and Equipment Reservations" template works is that users with Contribute or higher permission can create a new resource (room, equipment, etc) in Resources list and the workflow will start as soon as the item is created to make the same item in Reservations list with Available status. When this happens, this "non-reservation" item is created in Reservations list. The value for the hidden field, RERStatus, is changed during the workflow and all pre-defined views in the template make a use out of it. By default, you won't be able to see the value of this hidden field nor change the value. However, Kenneth Scott has a great post in his blog on how to make the hidden field visible but not editable: http://programmerramblings.blogspot.com/2008/03/adventures-with-wss30-room-and.html.

Another thing that I found was that with you logged in as System Account, "setup" workflow in Resources list will not automatically start. Basically, if the workflow does not start automatically or fails to start, you will NOT be able to make reservations - the resource will appear as if it is fully reserved forever.

However, if you create a resource with any other account with Contribute or higher permission, the "setup" workflow will work smoothly. So, keep this in mind when you are using System Account as a service account for testing "Room and Equipment Reservations" template.

You can also customize your "Room and Equipment Reservations" template to integrate with Microsoft Outlook and Patrik Luca has a great post in his blog (Patrik Luca's Blog) that talks about this customization in SharePoint Designer: http://patrikluca.blogspot.com/2008/03/extension-to-rooms-and-equipment.html. I tried this customization but I figured out that Outlook with Exchange Server does not work - I get the javascript error.

Hope this helps!

Comments

 

Room and Equipment Reservations SharePoint Template Can't Reserve said:

Pingback from  Room and Equipment Reservations SharePoint Template Can't Reserve

June 11, 2008 2:36 PM
 

Links (6/12/2008) « Steve Pietrek - Everything SharePoint said:

Pingback from  Links (6/12/2008) « Steve Pietrek - Everything SharePoint

June 12, 2008 9:11 PM
 

Luis Castanheira said:

you can change de description of hours from 12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12

to 00,01,02,03,04,05,06,07,08,09,10,11,12,13,14...

just editing the xml in the webpart inside the portal

July 8, 2008 6:42 AM
 

Nate said:

I have run into a strange issue, when I attempt to create a reservation I get  "The resource you are trying to reserve is not available at the time you specified"; however, the site is brand new and does not have any conflicting events.... any ideas how to resolve? Thanks!

July 9, 2008 3:43 PM
 

tigirry said:

Nate,

Check if you created a resource using System Account. As I described above, the resource will not be available for reservation is you create a resource with System Account. Use a different user who has Full Control permission to the site to create a resource.

July 11, 2008 9:48 AM
 

tigirry said:

Luis Castanheira,

Can you explain further in detail? Editing which xml? I am interested to know how to make the hour change as you illustrated. Thank you!

July 14, 2008 11:20 AM
 

gilad said:

hello to you all ,

I am still facing the prob of unable to reserve an resorce becuase it's taling me that the resurce is unavlibale/....... what is the sulation???

July 20, 2008 7:11 AM
 

Nate said:

Tigirry,

  The resource was created from a user with Full Control.  The resource workflow completes properly and it appears to be available at all times as the bar is all white (not purple), but when i try to make a new reservation, i get "the resource you are trying to reserve is not available at the time you specified."  The strange part is it works perfectly on my virtual machine, but we can't get it to work on our development or production servers.  Any ideas ?

August 1, 2008 12:32 PM
 

tigirry said:

Nate,

It seems like the workflow associated with the reservation template is not properly firing which makes the resource unavailable. Try to edit the xml file as Kenneth Scott describes at programmerramblings.blogspot.com/.../adventures-with-wss30-room-and.html and check if the status column value is "Available" for the resource. You should also be able to make a reservation with a Contributor.

Also, check if you configured the Reservations list for users to be able to edit their own items only. I noticed that if I allow users to only edit their own items, the reservations are not properly made (others can reserve the same resource at the same time frame).

August 3, 2008 4:17 PM
 

Son said:

Hi Tigirry,

I can't see any workflow in Reservation and Resouce list. why

August 18, 2008 5:27 AM
 

Csam0003 said:

Hi,

I too am havign problems with reserving a resource. I have full control and when I create a resource it becomes reserved indefinitely.

Any ideas?

Thanks

Chris

August 21, 2008 6:21 AM
 

Antigone said:

Hi  - I'm relatively new on sharepoint. Can anyone tell me where to download Room and Equipment Reservation template for MOSS 07?

Thanks

August 25, 2008 9:46 PM
 

Antigone said:

oops sorry, just managed to find out through Microsoft's online help.

(www.microsoft.com/.../details.aspx)

I'm sure I'll be in touch again after downloading it!

August 25, 2008 10:12 PM
 

Rita said:

Has anyone found a way to modify the romm and equipment reservation template so we can do re-ocurring meetings

August 26, 2008 8:13 AM
 

Melissa said:

Has anyone figured out how to display availability and reservations made by other users? None of my users are able to see reservations made by anyone except themselves.

August 26, 2008 10:24 AM
 

Matty said:

I am facing an issue where having more than 21 resources causes the follwing. When a user click the calendar looking webpart the drop down list is not populated with that resource name, you are required to click the list to fill in.

August 27, 2008 9:52 AM

Leave a Comment

(required )  
(optional )
(required )  
Add

About tigirry

Title; SharePoint Developer / ASP.NET Developer Certifications: MCPD: Web Developer MCTS: Microsoft Office SharePoint Server 2007 – Application Development MCTS: Microsoft Windows SharePoint Services 3.0 – Application Development MCTS: Microsoft Office SharePoint Server 2007 – Configuring MCTS: Microsoft Windows SharePoint Services 3.0 – Configuring

Need SharePoint Training? Attend a SharePoint Bootcamp!

Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts