sharepoinTony

@info – The practical side of SharePoint

Archive for the ‘SharePoint Tools’ Category

USPJ does a great job

Posted by sharepoinTony on September 26, 2010

I finally got to read through the latest Understanding SharePoint Journal and I have to say I was impressed.  

The journal is clear and concise, it is very informative, and it is very easy to read.  The level of detail is great for anyone learning about SharePoint and provides sufficient information to allow you to build something of value by the time you finish reading.  In fact, the examples allow you to follow along and build something while you are reading. 

The format of these journals focus on one topic at a time, allowing you to get more depth in the topic and learning more without feeling like you sat through a lecture.  The coverage of the topic is excellent and fits the audience well.  I highly recommending the Understanding SharePoint Journal to anyone trying to learn SharePoint or learn more about SharePoint.   I certainly learned more about SharePoint 2010 Workflows than I expected after reading this issue.

Kudo’s to Bjorn and the USPJ team.

Advertisements

Posted in Commentary, SharePoint Tools, Workflow | Tagged: , | Leave a Comment »

What not to do – buying web parts

Posted by sharepoinTony on September 10, 2010

This is a message to business managers trying to solve problems using SharePoint.

First, good job using SharePoint!

Now, please DO look at the options available to you that will help you get things done or enrich your SharePoint environment.

Please DON’T puchase web parts without talking to your SharePoint Administrator, Specialist or whomever you have focused on SharePoint.

Why?  Well, here is a short story (which I will call a fairy tale) that should make my point.

Once upon a time there was a department looking for a more robust solution than was available in their OOTB SharePoint 2007 environment.  They happily danced around while looking for solutions and discovered a shiny web part package that was priced very well.  The joyful department manager purchased the package and gleefully notified the SharePoint Administrator of the wonderful find.  The glorious admin reviewed and installed the tool and went about configuring for the perfectly good solution for the happy department.

The happy department requested a meeting.  Before they start using this new dandy they want a few changes.  The excitement filled the air as the team listed requirements for their solution.  What’s this?  They want to change the columns used by the solution’s installed list.  They want the solution to use existing InfoPath forms.   Gee, that seems reasonable doesn’t it?

A cloud of darkness appeared over the happy crowd, evil seemed to rain over them, sadness ensued.

You see children, the solution is a good one only if it meets the requirements set forth in the beginning.  Oops, no requirements had been written.  That’s OK as long as the needs to enrich the environment and make the identified task easier for the joyous department members are met.  Oops, the solution won’t allow those desired changes to the list.  Oops, it will not allow the use of InfoPath forms.

Hmm, what went wrong?

Then End.

Posted in Best Practice, Commentary, SharePoint Tools | Tagged: , , | Leave a Comment »

Service Requests and Sensitivity

Posted by sharepoinTony on January 25, 2010

I recently implemented a customized version of the Microsoft Help Desk template for SharePoint 2007.  Quickly after launching I adjusted things based on feedback and input that never came prior to the launch.

Background

The service request system, implemented via the help desk template, by default requires that all employees have access to submit requests.  The open-nature of SharePoint (and most IT departments) also dictates that users be able to see the pending service requests.  This visibility is normally thought of as a good thing for IT and helps promote self-service internally.  One of the customizations that I put in place was a notification workflow that sent email to the help desk staff telling them of newly submitted requests.  This workflow also automatically responded to the customer via email providing confirmation that their submission was successful.  The email provides a link back to the service request list so the customer could see all of the pending requests, including their own.

The Request

One significant post-launch request came from Human Resources.  They occassionally make requests that are sensitive in nature, such as terminations.  HR felt that those requests should not be visible to all employees.  This posed a problem for the service request list.  There is no doubt that it is a valid request, and the desire to keep most requests visible to users hadn’t changed, so I now had an exception to deal with.
Options considered were limited for various reasons.  One option would be to simply make a duplicate request list for sensitive HR requests.  But that meant managing two lists for the help desk, tracking two lists worth of requests for IT management, and created a possibility that a request might sit un-noticed.
Another option was to avoid using the service request list for all sensitive requests.  HR could send an email request as they had done historically in this small company.  Everyone was already “comfortable” with that process, however no improvements would easily fit into the old email process.  Reverting back to an old process just didn’t sound good unless there wasn’t a better solution.

The Solution

The solution concept chosen was to install a CodePlex feature that would allow a workflow to change the permissions on specific requests.
The concept was that sensitive requests could easily be identified since HR knew at the time of submission whether or not the request was sensitive, and could simply ‘mark’ the request as sensitive.  The workflow could check the column used for this purpose and based on its value could change permissions on that specific item.  We could limit the visibility to the appropriate staff without significantly changing the existing service request system.

The “Useful SPD Workflow Activities” feature from CodePlex was installed on a test server and the concept was examined closer.  After successful examination and testing it was decided that this would provide a very acceptable solution to the situation, and a quick response to the request from HR.
I created a new workflow to manage these permissions changes for two reasons.  First, I like keeping workflows as simple as possible.  Second, I wanted to be able to provide the flexibility to execute this behavior without sending emails that may be confusing which might come from adding these steps into the existing notification workflow.
The new workflow is very simple.  I check the designated column in the service request list and if it indicates that the item is sensitive then I remove a SharePoint Group’s permissions to the list item. I use several SP Groups to provide access, one contains all users, one contains appropriate HR staff, and one contains help desk staff.  When I remove all permissions from the group containing all users then only the members of the HR and Help Desk groups can see the item in the service request list.  There is no impact to other users or other requests.

Because the workflow can be started manually, we have the flexibility to “hide” any request that comes in by simply modifying the designated field and initiating the workflow.  This means that if HR forgets to “flag” a request, or if any other request is deemed sensitive we can quickly and easily “fix” it without having a workflow running all the time to monitor changes to requests.  Everyone is happy with this solution and it took longer to write this blog post than it did to implement in production.
Footnote: This CodePlex feature was installed and implemented on a 64-bit Windows Server 2008 system running MOSS 2007.

Posted in Lists, Permissions, SharePoint Tools, Workflow | Tagged: , | Comments Off on Service Requests and Sensitivity

Free PowerShell e-book

Posted by sharepoinTony on November 30, 2009

At the recent SharePoint Saturday in Phoenix Arizona, I learned about this free resource from Tom Wisnowski…

“Mastering PowerShell” by Dr. Tobias Weltner, PowerShell MVP is available for free download at PowerShell.org/Mastering-PowerShell.pdf.   It is a 567 page PDF book.   There are lots of other resources on the PowerShell.org site, check it out SharePoint admins.

 

Posted in SharePoint Links, SharePoint Tools | Tagged: , | 1 Comment »