NOTE: THE STEPS OUTLINED IN THIS POST ONLY APPLIED TO TFS 2010 BETA 2. PLEASE SEE THIS POST FOR THE SIMPLIFIED RTM STEPS.
Visual Studio Team System (VSTS) 2010 Beta2 introduces new features and capabilities to help agile teams with planning. One of those features is “out of the box” Excel workbooks that ship as part of the MSF for Agile Software Development v5.0 process template:
This article describes the steps you can take to enable the Product Backlog workbook for existing Team Projects not based on the MSF for Agile Software Development v5.0 process template. This post is one of a series about upgrading Team Projects to take advantage of new features that ship in VSTS 2010. To simplify the steps this article assumes you’re existing Team Project is built on the MSF for Agile Software Development v4.2 process template.
To get started you’ll first need to download the MSF for Agile Software Development v5.0 process template from your Team Foundation Server. We need to download this template to get a copy of the Product Backlog workbook.
Next, let’s modify the Scenario work item in your current project definition to include the fields required by the Product Backlog workbook.
witadmin.exe exportwitd /collection:http://myserver:8080/path/mycollection/p:myproject/n:“Scenario” /f:MyScenario.xml
<FIELD name="Story Points" type="Double" refname="Microsoft.VSTS.Scheduling.StoryPoints" > <HELPTEXT>An estimate of the size of a User Story or Scenario</HELPTEXT> </FIELD>
<CONTROL type="FieldControl" fieldname="Microsoft.VSTS.Scheduling.StoryPoints" label="Story Points:" labelposition="Left" numberformat="WholeNumbers" maxlength="10" />
witadmin.exe importwitd /collection:http://myserver:8080/path/mycollection/p:myproject/f:MyScenario.xml
In order to use the Product Backlog workbook you must create the appropriate query in Team Explorer.
The final step is to bind the query we created in Step 3 to the workbook.
Your new Product Backlog workbook is now attached to your Team Project and can be used to manage your backlog of Scenarios. Make sure to save the workbook to a permanent location such as your SharePoint document library.
After you upgrade your server to Visual Studio Team System 2010 Beta 1, you have a wealth of new features
I followed the above instructions but got an Application-defined or object-defined error when I'm on the Iterations tab. I believe the error occurs when it tries to calculate the Planned column at the last line of code in UpdatePointsColumn():
list.ListColumns(columnIndex).DataBodyRange.formula = formula
Any ideas what might be wrong? I have created a brand new project in the same collection and the product planning workbook works fine there.
It works after I added the State column to the Product Backlog/Planning query (and I have changed Rank to Stack Rank before too).