Archive for October, 2009

SharePoint Workflows & Collecting Data from Users


30 Oct
No Gravatar

Recently I was presented with a problem that I’m sure many of you have faced but it took some thinking – not an easy task for me – on the best way to resolve it. Let me give you a run down on the problem and then speak about the solution in more generic terms.

We have a list that is used to store various types of equipment that is available throughout our organization. We have a parent content type of Equipment Item and about 18 child content types including Robot, Welding, Plant Equipment etc. When equipment is identified and agreed to it is entered into this SharePoint List which initiates a SharePoint Designer(SPD) workflow. There are a few steps and then a Collect Data from a User action is called. This action creates a task for the specified user which in our case is where they specify the status of the equipment. With me so far?

Collect_Data

Here is the problem. There are currently approximately 300 active workflows and the volume of activity is going to increase significantly over the next few months.  The Collect Data from a User action however creates a task with a generic title and description like so:

Tasks

You can see what the issue is – how do I quickly tell which task is  associated with which piece of equipment?   You could click on the Link column to see the item however that is time cosuming and very cumbersome.  What we need to do is pull some key data from the equipment list into the associated task.    What makes a little trickier than it appears at first blush is the fact that until the user provides the required data to the workflow the Collect Data from a User essentially pauses the workflow.  This means that we can’t add a step in the workflow to update the task with pertinent information until after the user acts on it which is after he needs the pertinent information.  

The solution in this case is to create a secondary workflow on the task list that will be automatically triggered when a new item is created.  This workflow will then go back to the related item in the equipment list and pull in the required information.  We will use the Update List Item action in order to accomplish this.

Workflow_Designer

In this case we are updating 3 columns from the Equipment list but in the interest of keeping things concise we’ll focus on 1.  Since the workflow is being initiated on the Task list will will want to be updating the current list item.   We’ll be updating the SubCategory field, which is a column that we added to the Task list with the value of the Sub Category column from the Equipment list.

Update_List_Item

Defining the workflow look up is the key to making this work.  We know that these tasks must be associated with the specific Equipment item but how can we make sure we are looking up the values from the right piece of equipment?  Each list by default has a unique identifier called ID.  The task list also has a column called Workflow Item ID which is the ID of the related list item.  So by looking up the ID of the piece of Equipment that corresponds with the value of the Workflow Item ID in the Task list we will be able to grab the correct data to populate our Task list.

Define_Workflow_Lookup

I hope you found this information helpful and any feedback is welcome.

VN:F [1.9.21_1169]
Rating: 9.5/10 (2 votes cast)
VN:F [1.9.21_1169]
Rating: +1 (from 1 vote)

My SPC 09 Calendar


14 Oct
No Gravatar

SPC09Here’s my schedule for the upcoming SharePoint conference.  I’ll also be live blogging for End User SharePoint which I am really looking forward to.

Monday, October 19th, 2009
9:00 AMKeynote: Unveiling Microsoft SharePoint 2010
Mandalay Bay BallroomSpeaker: Steve Ballmer

10:30 AMKeynote: Microsoft SharePoint 2010 Drilldown
Mandalay Bay BallroomSpeaker: Jeff Teper

1:15 PMEnterprise Search Overview
Islander GSpeaker: Evan Richman

2:45 PMECM for the Masses – How SharePoint 2010 delivers on the promise
Lagoon HSpeaker: Ryan Duguid

4:30 PMOverview of Social Computing in SharePoint 2010
South Seas DSpeaker: Christian Finn

Tuesday, October 20th, 2009
9:00 AMWhat’s New in Business Connectivity Services (Evolution of BDC!)
South Seas BSpeaker: Michal Gideoni

10:30 AMScaling SharePoint 2010 topologies for your organization
Mandalay Bay FSpeaker: Simon Skaria, Umesh Unnikrishnan

1:15 PMSharePoint Document Management Deep Dive
Mandalay Bay KSpeaker: Ryan Duguid

2:45 PMOffice 2007 vs. Office 2010 – Deployment Considerations
Breakers BSpeaker: Chris Bortlik

4:30 PMContinental Airlines: Architecting Enterprise Content Management -…
Breakers ESpeaker: Benjamin Lee, Denise Wilson, Jason Deere

Wednesday, October 21th, 2009
9:00 AMSharePoint 2010 Governance: Planning and Implementation
Mandalay Bay GSpeaker: Scott Jamison, Susan Hanley

10:30 AMConfiguring and Deploying a Reporting Environment in SharePoint…
Mandalay Bay KSpeaker: Prash Shirolkar, Thierry D’hers

1:15 PMOverview of Content Acquisition for Search in SharePoint 2010
ReefSpeaker: Siddharth Shah

2:45 PMSolving Information Chaos: Advanced Content Processing with FAST…
Lagoon JSpeaker: Sven Arne Gylterud

4:30 PMSocial Search in SharePoint 2010
Mandalay Bay HSpeaker: Jessica Alspaugh

Thursday, October 22th, 2009
9:00 AMUnveiling New Management Tools for Administering SharePoint 2010
South Seas BSpeaker: Zach Rosenfield

10:30 AMDeep Dive into SharePoint 2010 Profile Store and Profile Data…
Mandalay Bay GSpeaker: Chris Gideon, Tanuj Bansal

12:00 PMForm-driven Mashups Using InfoPath and Forms Services 2010
Mandalay Bay JSpeaker: Nick Dallett

VN:F [1.9.21_1169]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.21_1169]
Rating: 0 (from 0 votes)

SP Workflow Governance


13 Oct
No Gravatar

As the adoption of our MOSS 2007 platform continues to gain traction we have begun delivering some of the more important pieces of our moss_2007governance plan.  Due to our limited resources we have identified the areas that we feel are the most important and are delivering those as they are developed. 

First, a primer on our environment in order to provide some context on the why.  I work for a global manufacturing company with a decentralized operational structure.  We currently have about 8000 users and are at approximately 600,000 hits per month across the portal.  Many of our facilities are coming on board to our MOSS implementation which is managed centrally in the Toronto area by a relatively (by the standards of other organizations) small team of people.    When I say small – I mean 3 in IT.   As our facilities come on board there are increasing requests to automate business processes by creating and hosting workflows in SharePoint.  We felt it was necessary to quickly develop and publish some policies around this type of activity that takes into account three main factors:  reinforcing the concept of user ownership over SharePoint functionality, the resource levels at the central office, and the current processes around deployment that are already in place.

Obviously many pieces of successful governance are inter-related which is why in conjunction with these specific policies we have published governance about the roles & responsibilities of the various types of users interacting with SharePoint: site collection administrators, site administrators, content creators etc.  Support processes need to be documented as well in order for the site administrators/content creators to understand their role and the escalation path.

Below is an overview of the workflow-related policies and the rationale behind them.

Policies

  • Out of the Box SharePoint workflows will be the first option examined when implementing workflows
    • This is straightforward and doesn’t require much explanation.  OOTB should always be the first option when looking at new functionality whether its SharePoint or any other technology solution
  • We do not currently support the out of the box translation workflows
    • Our implementation is currently English only so there is no business need to be using these workflows
  • We will not provide support for user developed SharePoint Designer workflows
    • This does not mean that we will not allow SPD workflows to be created and deployed.  It means that should a user choose to use SPD designer to create a workflow they own it we will not be able to support them with their troubleshooting requirements.  We simply do not have the resources to spend time with individual users or teams analyzing why their workflow is not doing what they expected it to do.
  • SharePoint Designer training must be taken prior to creating workflows with this tool.
    • We will however recommend training providers that can provide the required training or will assist individuals or teams with the fundamentals of SPD workflows.  We are also developing training material that will be provided through the MS Productivity Hub which will allow them to access material on demand.
  • The creator of the workflow owns it and is responsible for any documentation/knowledge transfer.
    • This was touched on in Point 4 but it can’t be stressed enough.  As with any business solution the functional business owners are responsible for knowing, using and training on the functionality and business processes they own.  We are making a much more concerted effort as part of the governance process to define and communicate the responsibilities of the business owner/site administrator. 
    • Communicating the necessity of cross training to the owner as a risk mitigation strategy is essential in helping them understand their responsibility.
  • Errors with workflows will be investigated by the owner of the workflow by reviewing the workflow history.  If, after investigating, the error appears to be platform related an email will be sent to the helpdesk with detailed information about the error.
    • The intention here is to again ensure that IT and more specifically the Help Desk is not the first option when an issue with a workflow is discovered.
    • Training the users on the fundamentals of workflows, tasks, workflow history etc. will empower them to attempt to troubleshoot the issue and resolve it more quickly.
  • We will not support the developer training or deployment related to custom developed workflows in Visual Studio.  
    • VS workflows need to be deployed by someone with access to Central Administration
    • We have a rigid deployment process of one deployment to QA and Production per month.  We have 1 person responsible for doing this (along with many other tasks including non-SP related).   This means that a custom developed workflow change could potentially be facing a lag of 1 month prior to being deployed
    • The issue for us here is not the mechanics of deploying the workflows, but the inevitability of the software developers at our divisions creating more complex workflows over time with increased needs for changes, errors and “emergency” deployments putting our current deployment processes and policies at risk.
  • SharePoint workflows will not be used to automate business critical processes.
    • This policy is derivative of the previous points and realities of our environment.  As is common with most SharePoint deployments there is a tendency for people to think of SharePoint as the solution for everything.  We are attempting to place reasonable constraints on the use of the environment while working proactively with our users to identify alternatives by helping them clearly define their requirement and choosing the right solution.

This policies will evolve over time, as they should.  We have already referred numerous people to these policies and their supporting documentation.  As our organizational maturity with this platform improves our governance model will evolve in parallel.

VN:F [1.9.21_1169]
Rating: 7.0/10 (1 vote cast)
VN:F [1.9.21_1169]
Rating: +1 (from 1 vote)

Intelligence Among Us

it's there…use it.