Tony Rockwell – Info

sharepoinTony@info – Cloud Computing adventures

Archive for June, 2009

Intermittent Green Post

Posted by sharepoinTony on June 29, 2009

SharePoint can also be utilized as a tool to better enable a business to act in a “green” manner.  Sharing documents and working online can reduce paper consumption and waste.

Automating business processes utilizing workflows can reduce time spent on these tasks which COULD be redirected to identifying other areas where the company may change the impact they have on our environment.

The efficiency gained this way allows the time spent on green initiatives to cost the company nothing…thereby improving the roi and goodwill received by implementing any green initiative.

This concept of businesses going green isn’t new,  and I am not alone in applying it in “new” and “different” ways.

Check out – Daily News on Green Business


Posted in Commentary, Green | Tagged: , | Comments Off on Intermittent Green Post

“Conference” Room Manager for SharePoint

Posted by sharepoinTony on June 26, 2009

Review and Implementation Notes on ACAR Room Manager for SharePoint

We had a need for a SharePoint calendar that would allow us to manage some conference rooms.  After searching around, and evaluating some other options, I decided to do a deeper evaluation of ACAR’s Room Manager for SharePoint.   This is my summary of findings and notes on the specific ways we wanted to implement this tool.

Review Notes

ACAR describes the product this way:

“Room Manager Suite for SharePoint is an easy to use room scheduling software solution for SharePoint. It is simple and powerful. Consists of a set of web parts which makes room reservation simple for end users.” (ACAR Room Manager)

It is a Room Scheduling Software for Office SharePoint Server 2007 and Windows SharePoint Services 3.0 which provides a nice interface that allows the user to see both a calendar and thumbnail photos of the rooms.  The rooms are color-coded so it is easier to identify what meeting is in which room, this is a nice feature and can be controlled within the “Room Details” screen.

Room Manager default page

Room Manager default page

The installation is simple and automatically creates a sub-site for you within SharePoint for the Room Manager.  Basic setup steps include uploading your photos of your conference rooms and entering the basic information about them.  ACAR provides a list with setup and administration guidance as well as FAQ and Information  lists.

Room Details screen

Room Details screen

Adding the Capacity and Description to your rooms helps users choose the right room for them.  If you add keywords and have Search enabled your users can find specific rooms quickly by searching.

The Sort Order is used to control the display of the rooms on the home page, next to the calendar.

The “Title” fields seem a little  irrelevant to me, they only control the label/link that is displayed next to the thumbnail.  I felt that anyone implementing this would want those to be consistent; and although you may want to modify them for your implementation they should be managed in a more central location.  (Side note: while testing this product, I had one person changing those and it really confused other users when they saw one room with varying text in the display.  Some thought there were problems with the product.)

The Picture Size field also seems unnecessary, and we would replace that colum in the display with  “Room Dimensions” to provide more useful information to the users of this tool.  That column would have to be added to the Room picture library.

This raises a good point, one of the great features of this product is the flexibility that they allow.  They hide a few lists, but otherwise if you are relatively careful you can modify the lists and libraries to fit your needs.  More on how we did some of this later.

ACAR Quick Launch - default for Room Manager home page

ACAR Quick Launch - default for Room Manager home page

The Quick Launch has been modified by ACAR for the Room Manager sub-site.  As you can see it provides for ease of navigation and a custom feel for your users.  Your users only see what they need to effectively schedule a room or manage the Room Manager.  Breadcrumbs are provided for access back to the host site in the normal SharePoint fashion.

You may want to “hide” the links to the settings or Information lists because of the information they contain.  This can be accomplished by setting permissions on those lists or by adding audiences to the Navigation item on the site.

One additional thing to watch out for is the selection of colors in the Room Details.  On our system, some of the colors selected did not display correctly when selected for a room.  As an example, I selected “Bright Green” from the ACAR provided list for one room.  After saving and going back to the Room Manager home page, I see that the room color displayed is a purple.  That rooms events are now the same color as another room with the selection “Violet”.  I had to go through and test everyone of the 27 pre-defined colors and try each one to determine what would work on our system.

Colors I found that displayed oddly:

Light Yellow (displays white, which is used for “waiting list”)
Bright Green (displays purple)
Violet (displays purple same as bright green)
Acqua (displays bright blue same as Turquoise)
Dark Teal (displays purple same as violet)

Colors that worked fine but caused the Events in the Calendar to be difficult to read:

Dark Red
Dark Blue
Dark Green

That left us with 17 colors to use for our rooms.  We could actually also use Violet as long as we didn’t use the conflicting colors, and it was our choice not to use the darker colors.

When contacted, ACAR support was surprised by this but agreed with my assessment to simply remove some of the options from the drop-down list.  If you need that many rooms you may want to consider either multiple implementations of this tool or plan to resolve this issue.  Also please note that this is only what happened on ONE test server implementation, results may vary. Also, the difficulty reading events when using the darker colors could potentially be mitigated through the use of CSS to alter the text color of the events for those specific rooms using those colors.

Overall, I really like this product. It allows you to quickly and easily implement a solution for room management while making use of mostly Out Of the Box SharePoint features.  Room management can be delegated down to appropriate levels and the Administrator shouldn’t have any major tasks after the initial setup.  We ran this test over several weeks, and never ran into anything beyond what was mentioned earlier.  It is very intuitive and simple to use.

ACAR offers a Standard Edition and an Enterprise Edition with single server licenses and discounted licenses for additional servers.  The difference between the Standard and Enterprise Editions is unlimited locations and rooms with Enterprise.  Enterprise also appears to allow for Invoicing or chargebacks of rooms, but this seems to be something you implement using InfoPath not something built-in.  We had no need for that so we did not look into that concept.

Implementation Notes

One of the “customizations” that I tested had to do with a specific need we had for this tool.  Several of the conference rooms are “owned” by a specific department, who has priority over all others when scheduling their specific rooms for meetings.  They had a person who approved all scheduled meetings in their rooms and wanted to keep that “chain of command” in place.  So, for our testing I wanted to intercept the auto-generated email notifying the user the room was scheduled and tell them it was pending approval.  Then I have to send a message to the appropriate approver so they can check conflicts, etc. and approve or reject the requested scheduling.

I was able to add columns to the Events list, turn off auto-emails, modify selections in the provided “choice” columns, and create a workflow in SharePoint Designer to accomplish this conference room scheduling process.  This also displays the flexibility with this product over some that really lock you out of “their application”.

Details on this customization may be in a follow-up article, if any interest is expressed…or I have time and less pressing topics to cover. 😉

Posted in Calendar, Commentary, SharePoint 2007 | Tagged: , , | 12 Comments »

2007 Alert Me management

Posted by sharepoinTony on June 17, 2009

Users can go to _layouts/MySubs.aspx on the site where they have an Alert setup to delete the alert.
Seems lots of people don’t know how to get there and remove an alert.

Posted in Alerts, SharePoint 2007 | Tagged: , | Comments Off on 2007 Alert Me management

MOSS 2007 size limits – and List Item Attachments

Posted by sharepoinTony on June 9, 2009

Basic stuff first (all of this can be found elsewhere, I just wanted it to be more handy).

  • Site Collections in a Web Application = 50,000
  • Sites in a Site Collection = 250,000
  • Sub-sites nested under a Site = 2,000
  • Lists on a Site = 2,000
  • Items in a List = 10,000,000
  • Documents in a Library = 2,000,000
  • Documents in a Folder = 2,000
  • Maximum document file size 2GB
  • Documents in an Index = 50,000,000
  • Search Scopes = 1,000
  • User Profiles = 5,000,000
  • Template size = 10,000,000 (default)

List Attachments over 50MB need more than an increase in Maximum Upload Size…

  1. Connect to Central Administration
  2. Navigate to Application Management, Web Application General Settings
  3. Select your web application
  4. Set the Maximum Upload Size value to the value you desire (we wanted 500)  MB and hit OK
  5. Open the web.config
  6. Replace <httpRuntime maxRequestLength=”51200″ />  with <httpRuntime maxRequestLength=”512000″ />

Something in IIS blocks List Attachments that are over 50mb, so unless you do the above steps they fail with “An unknown error occurred” message.


Saving site or list templates, especially With Content, have a 10 MB limit by default.  To change this you have to use the STSADM utility:

stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000

This sets the limit up to 50 MB, you can set it to the value you need.

Posted in Lists, SharePoint 2007 | Tagged: , , | 4 Comments »