The Appie Awards…

 Last night at the SharePoint Conference in Las Vegas, Microsoft announced the winners of the ‘Appies’, recognising the best apps in the Microsoft Office and SharePoint stores. The awards highlighted a number of great apps covering SharePoint, Office and Project, including:

  • Campagna and Schott for their CS Task Board app, a runner up in the Best UI award;
  • CPS’s Project Task Auditor, winning the Most Business Value award for Project client apps; and
  • Sensei’s Project Dashboard, winning the Most Interesting Scenario, Project category.

Personally, whilst I didn’t get a chance to enter any of my existing, or new apps into the awards, I was really excited that Nintex (who I work for in my day job) won three categories including Most Interesting Scenario for SharePoint, Most Downloaded SharePoint app & the People’s Choice for Nintex Workflow for Office 365 and runner up in two categories for Nintex Forms for Office 365 :)

So given that there are so many great apps out there in the store, I thought this would be a good time to do some mini reviews of the apps for Project Server, so over the coming weeks will be diving into a few of them in a bit more detail, including:

Stay tuned :)

Advertisements

Project Conference Session videos now available on Channel 9

Hot off the press this morning, the session video’s for the Project Conference are now available to watch via Channel 9.

Here are a couple of my favourites so far (and I may be biased)..

Click me to to go the video

Future of Business Productivity Keynote – Check out the great demo with the Nintex Workflow for Office 365 app.

Click me to to go the video

My session Implementing your organizational process in SharePoint, Project Server and Office 365 with Nintex

And finally, the great vision keynote where the future direction of the business is revealed and Ludo and Heather show off their comedic skills whilst doing some great demos Smile

Click me to to go the video

Enjoy.

Check out the MS Project Podcast

MS Project Podcast - On the airEarlier in the week I was lucky enough to be interviewed for the MS Project Podcast by Prasanna Adavi and David Fletcher.

The interview was a little about Nintex Workflow for Project Server, some Office 365 and a fair dose of my love of all things Project Server.

The episode is available at ttp://www.msprojectpodcast.com/post/65349292852/ep-2-nintex-workflows-project-server-2013-and or you can subscribe to the ongoing podcast at http://feeds.feedburner.com/msprojectpodcast

This is a great initiative by Prasanna and David and I encourage you all to get subscribing and sharing your Project stories with them Smile

Introducing Nintex Workflow for Office 365

Nintex Workflow for Office 365You couldn’t have helped but notice the blog has been a bit quiet recently. The reason is that I have been pretty busy in my day job at Nintex. Well, I am pleased to say I can finally reveal what I have been working on. This week we released Nintex Workflow for Office 365, a new product in the Nintex family that brings the power of Nintex Workflow to the Office 365 platform.

Nintex Workflow for Office 365 - Workflow Designer

Nintex Workflow for Office 365 allows you to build workflows for Office 365 directly from within the browser, providing full access to the new workflow manager as well as world of cloud services through the Nintex Store. What makes it even more impressive is that it’s all done in the new SharePoint app model.

Nintex Store

You can find out more by checking out nintex.com/workflowo365 or by heading over to the SharePoint store, installing the app in your Office 365 tenant and signing up for a trial.

Normal Project Server service will now resume :)

Introducing Nintex Workflow for Project Server 2013

I try not to mix my day job at Nintex with my community work and the content on this site, but today I want to make an exception and share some news on one of the projects I have been working on for the past few months.

I am pleased to announce that we have shipped Nintex Workflow for Project Server 2013 (NW4PS), an update to the popular workflow product for Project Server 2013.

Nintex Workflow for Project Server 2013

NW4PS 2013 provides all the capabilities of the 2010 version for use within Project Server 2013, including:

  • Demand Management workflows– implement workflows that support your full project lifecycle, from creation, through selection, planning, execution and to closure, leveraging an array of actions, including Query Project Server (PSI data), Project Publish and Change EPT;
  • Event Driven workflows – associated workflows to over 115 different Project Server event handlers;
  • Collaboration workflows – build workflows to support project collaboration scenarios that can talk back directly into Project Server.

NW4PS 2013 provides a seamless upgrade experience from Nintex Workflow for Project Server 2010, allowing organisations to leverage the new Project Server 2013 capabilities and features without having to worry about rebuilding & refactoring workflows.

As you would expect, Nintex Workflow for Project Server 2013 is fully Project Server 2013 aware, supporting items such as the new security modes, claims and 2010 look and feel in project workspaces.

You can read more on Nintex Workflow for Project Server 2013 over at nintex.com/project

Collecting business requests in SharePoint and automatically pushing into Project Server

At SharePoint Saturday Toronto, I presented one of my favourite sessions on SharePoint Governance and Lifecycle Management using Project Server 2010, based on Christophe Fiessinger’s and Scott Jamison’s session from TechEd NA 2011. I’ve delivered this session three or four times now, showing how organisations can benefit from using Project Server to collect business requests and guiding them through a process to successfully collect information, objectively determine which project to implement and then assist in the implementation.

Each time I have delivered the session, I have been asked if there were ways to collect the initial business requests outside of Project Server, in a SharePoint list for instance, reducing the need to licence and more importantly train all users within an organisation that may wish to lodge a business request. So, for SharePoint Saturday Toronto I decided to implement an interface that allows the business requests to be created initially in a SharePoint list and then via a workflow pumped into Project Server for the Project Server governance process to be applied.

image

 

This post shows you how you can implement it too. For this example, I will be using Nintex for the workflow component (disclosure, I work for Nintex), but you could also use a SharePoint Designer built workflow with the Christian Glessner’s iLSP SharePoint Designer Add-ons and a little elbow grease.

At a high level the solution has three components:

  • A SharePoint list that will be used to capture the business request. The list should be configured to capture the relevant items for the business request. In this example, the list requests the project name and a description, but you could extend this to capture other information such as anticipated budget, business need etc;
  • A default Enterprise Project Type configured to use the SharePoint Governance and Lifecycle Management demand management workflow. This EPT should also have a default Project schedule template associated; and
  • A list workflow associated with the SharePoint list above that will be used to call the PSI to create the project.

 

The list

Configure a SharePoint list to capture the information you want to capture. In this example, I have only captured two fields, as the rest will be captured within Project Server.

Both fields are set to be mandatory and the title field has been set to enforce unique values.

SharePoint list columns

 

The EPT

The Governance and Lifecycle Management white paper and databases guide you through the process of configuring a demand management workflow and EPT. For the list workflow to create a project automatically, it is essential to make sure this EPT is set as the ‘default’ and that a Project schedule template has been uploaded and associated with the EPT.

Before building the workflow, we need to know some information about the project schedule template, this will be used by the workflow to create the project. Each project template is stored within the DRAFT Project Server database and can be extracted with the following query:

SELECT PROJ_NAME, PROJ_UID FROM MSP_PROJECTS WHERE PROJ_TYPE = 1

Write down the PROJ_UID of the relevant record for the Project Template you associated with the default EPT.

 

The Workflow

The key component of the process is the workflow that will take the list item and create a project in Project Server. As I mentioned above, in this example I will use Nintex Workflow & Nintex Workflow for Project Server as it has Project Server specific actions, but you can achieve a similar outcome in SPD with a little more effort.

The workflow itself consists of only three actions, the first action ‘Call Web Service’ is used to call Project Server’s PSI and specifically the Project web service and the CreateProjectFromTemplate web method. This method creates a project within Project Server based on a specific project schedule template.

The action should be configured as below, ensuring you change the URL of the web service, credentials and Template GUID to match your environment.

Configure Call Web Service Action

The projectName field above is using the Title variable. A great thing about Nintex is that you have access to the list context information by clicking on the lookup icon as below:

Select item title

The final part of the configuration is to capture the UID of the project that is created. When CreateProjectFromTemplate is called, if the method is successful it will return the UID of the created project in an XML envelope.

The Call Web Service action can listen for the response and parse it. To do so, click on Specify Elements and then Select Element.

Web Service Output

A XML browser dialog will be displayed allowing you to select which item in the response to read, in this case we are interested in the CreateProjectFromTemplateResult, so select it and click on Apply.

Web Service Response

Choose to save the returned value into a variable called ProjectUID, this will be used later.

The second action is also a Call Web Service action, this time used to Publish the Project in Project Server, up until now our project has resided in the Draft database, performing this publish will make sure it is published and therefore visible in PWA.

Like the previous action, configure the web service to call the Project PSI server with the relevant URL and credentials.

Publish Project

For this action, choose the QueuePublish method. This method has different parameter requirements:

  • jobUid – A GUID used to identify the job, in this case use the inline function fn-NewGuid()
  • projectUID – the UID captured in the ProjectUID variable prior
  • fullPublish – true
  • WssURL – leave blank

Once these two actions are run, a project will be created in Project Server using the default EPT and schedule template, all that is needed to do is to copy the other fields from the list into the project custom field using the last action ‘Update Project Properties’ from Nintex Workflow for Project Server that provides a simple wrapper for updating project custom fields. If you decide to use SPD, you would need to perform a raw PSI call to update the property making sure you have created a valid XML message (Fiddler will be your friend here, but a word of warning, it is not simple).

Configure the action as shown below, ensuring you select Title from the lookup field for the Project Name and then choosing to update the WPROJ_DESCRIPTION field with a list lookup against our SharePoint list, the item we are starting the workflow against (our project idea) and relevant field (in this case the Project Description field).

Update Project Properties

If there were other fields you wished to push into Project Server, they can be chosen in the Project Property drop down.

Finally, configure the action to ‘Publish after update’ and to ‘Wait for job completion’.

The completed workflow should look like this:

Completed workflow

All that is needed to complete the workflow is to modify the workflow settings to allow it to be manually started, and to add it to the list item context menu as follows:

Configure workflow settings

Then publish the workflow and you’re ready to start pushing your project ideas from a SharePoint list into Project Server Smile

Of course, what I have shown you above is the tip of the iceberg, with a little more work you could:

  • extend the workflow to add in some approvals before the business request is pushed into Project Server, allowing people like team leads or managers that may not necessarily need access to Project Server to review, add additional information and approve or reject the request;
  • configure the demand management workflow to push updates about where the business request is back out to the SharePoint list; and
  • add additional fields to the list that are pushed through into Project Server custom fields at project creation time.

Building advanced Project Server workflows with Nintex Workflow for Project Server

Over the past week or two, Microsoft have been quietly uploading all the sessions from the recent Project Conference held in Phoenix to the Project channel on Microsoft Showcase. This morning the Project team officially announced the availability, so I am pleased to announce that the video of Mark McDermott’s and my session is now available for your viewing pleasure. I encourage you to watch it and let me know if you have any questions.

image

Finally, the session deck, including notes is available for download at slideshare.net.