TFS 2010 – Adding the SharePoint portal afterwards [Beta 2]

by Ewald Hofman 11. December 2009 05:39

I created a new Team Project in TFS 2010 Beta 2 and choose not to configure SharePoint during the creation of the Team Project. Of course I found out fairly quickly that a portal for TFS is very useful, especially the Iteration and the Product backlog workbooks and the dashboard reports.

This blog describes how you can configure the SharePoint portal afterwards. Many thanks to Adam Cogan, who gave me fantastic directions to improve the blog post.

Update #1 September 9th, 2009: As suggested by Adam Cogan, added the option of the Dummy project.

Update #2 December 11th, 2009: As suggested by Adam Cogan, modified the post to Beta 2 + added the summary.

Summary of your options

You have several options to get the portal to your team project. The best option would be to have the ability in the Team Foundation Administration Console to create the portal for you, but that feature will not be added in TFS 2010 RTM . If you want it in a future version, please vote on

Then there are two other options that you can use today:
Option 1: Create a Dummy Project in TFS to get the SharePoint Portal (recommended)
Option 2: Create the Portal in SharePoint and then fix up the missing documents

Option 1: Create a Dummy Project in TFS to get the SharePoint Portal (recommended)

Step 1: Create a new temporary project (with a SharePoint site for it).

  1. Open the Team Explorer

  2. Right click in the Team Explorer the root node (i.e. the project collection)

  3. Select "New team project" from the menu

  4. Walk throught he wizard and make sure you check the option to create the portal (which is by default checked)

Step 2: Disable the site for the new project

  1. Open the Team Explorer

  2. Select the team project you created in step 1

  3. In the menu click on Team -> Show Project Portal.

  4. In the menu click on Team -> Team Project Settings -> Portal Settings...

  5. The following dialog pops up

  6. Uncheck the option "Enable team project portal"

  7. Confirm the dialog with OK

Step 3: Enable the site for the original one. Point it to the newly created site.

  1. Open the Team Explorer

  2. Select the team project you want to add the portal to

  3. In the menu open Team -> Team Project Settings -> Portal Settings...

  4. The same dialog as in step 2 pops up

  5. Check the option "Enable team project portal"

  6. Click on the "Configure URL" button

  7. The following dialog pops up


  8. In the dialog select in the combobox of the web application the TFS server

  9. Enter in the Relative site path the text "sites/[Project Collection Name]/[Team Project Name created in step 1]"

  10. Confirm the "Specify an existing SharePoint Site" with OK

  11. Check the "Reports and dashboards refer to data for this team project" option

  12. Confirm the dialog "Project Portal Settings" with OK

Step 4: Delete the temporary project you created.

  1. Open the command prompt (Start –> Run, cmd)

  2. Go to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE

  3. Enter the following command:

    TFSDeleteProject /q /collection:http://<servername>:8080/tfs/<project_collection_name> <Team Project Name>

    for example, TFSDeleteProject /q /collection:http://localhost:8080/tfs/DefaultCollection TempProject

Option 2: Create the Portal in SharePoint and then fix up the missing documents

Step 1: Create new portal site

  1. Go to the sharepoint site of your project collection (/sites//default.aspx">/sites//default.aspx">/sites//default.aspx">/sites//default.aspx">/sites//default.aspx">http://<servername>/sites/<project_collection_name>/default.aspx)

  2. Click on the Site Actions at the left side of the screen and choose the option Site Settings

  3. In the site settings, choose the Sites and workspaces option

  4. Create a new site

  5. Enter the values for the Title, the description, the site address. And choose for the TFS2010 Agile Dashboard as template.

  6. Create the site, by clicking on the Create button

Step 2: Integrate portal site with team project

  1. Open Visual Studio

  2. Open the Team Explorer (View -> Team Explorer)

  3. Select in the Team Explorer tool window the Team Project for which you are create a new portal

  4. Open the Project Portal Settings (Team -> Team Project Settings -> Portal Setings...)

  5. Check the Enable team project portal checkbox

  6. Click on Configure URL...

  7. You will get a new dialog as below

  8. Enter the url to the TFS server in the web application combobox

  9. And specify the relative site path: sites/<project collection>/<site name>

  10. Confirm with OK

  11. Check in the Project Portal Settings dialog the checkbox "Reports and dashboards refer to data for this team project"

  12. Confirm the settings with OK (this takes a while...)

  13. When you now browse to the portal, you will see that the dashboards are now showing up with the data for the current team project. We will fix that in the next step.

Step 3: Download process template

  1. To get a copy of the documents that are default in a team project, we need to have a fresh set of files that are not attached to a team project yet. You can do that with the following steps.

  2. Start the Process Template Manager (Team -> Team Project Collection Settings -> Process Template Manager...)

  3. Choose the Agile process template and click on download

  4. Choose a folder to download

Step 4: Add Product and Iteration backlog

  1. Go to the Team Explorer in Visual Studio

  2. Make sure the team project is in the list of team projects, and expand the team project

  3. Right click the Documents node, and choose New Document Library

  4. Enter "Shared Documents", and click on Add

  5. Right click the Shared Documents node and choose Upload Document

  6. Go the the file location where you stored the process template from step 3 and then navigate to the subdirectory "Agile Process Template 5.0\MSF for Agile Software Development v5.0\Windows SharePoint Services\Shared Documents\Project Management"

  7. Select in the Open Dialog the files "Iteration Backlog" and "Product Backlog", and click Open

Step 5: Bind Iteration backlog workbook to the team project

  1. Right click on the "Iteration Backlog" file and select Edit, and confirm any warning messages

  2. Place your cursor in cell A1 of the Iteration backlog worksheet

  3. Switch to the Team ribbon and click New List.

  4. Select your Team Project and click Connect

  5. From the New List dialog, select the Iteration Backlog query in the Workbook Queries folder.

  6. The final step is to add a set of document properties that allow the workbook to communicate with the TFS reporting warehouse. Before we create the properties we need to collect some information about your project. The first piece of information comes from the table created in the previous step.  As you collect these properties, copy them into notepad so they can be used in later steps.

    Property How to retrieve the value?
    [Table name] Switch to the Design ribbon and select the Table Name value in the Properties portion of the ribbon
    [Project GUID] In the Visual Studio Team Explorer, right click your Team Project and select Properties.  Select the URL value and copy the GUID (long value with lots of characters) at the end of the URL
    [Team Project name] In the Properties dialog, select the Name field and copy the value
    [TFS server name]

    In the Properties dialog, select the Server Name field and copy the value

    [UPDATE] I have found that this is not correct: you need to specify the instance of your SQL Server. The value is used to create a connection to the TFS cube.

  7. Switch back to the Iteration Backlog workbook.

  8. Click the Office button and select Prepare – Properties.

  9. Click the Document Properties – Server drop down and select Advanced Properties.

  10. Switch to the Custom tab and add the following properties using the values you collected above.

    Variable name Value
    [Table name]_ASServerName [TFS server name]
    [Table name]_ASDatabase tfs_warehouse
    [Table name]_TeamProjectName [Team Project name]
    [Table name]_TeamProjectId [Project GUID]

  11. Click OK to close the properties dialog.

  12. It is possible that the Estimated Work (Hours) is showing the #REF! value. To resolve that change the formula with:

    =SUMIFS([Table name][Original Estimate]; [Table name][Iteration Path];CurrentIteration&"*";[Table name][Area Path];AreaPath&"*";[Table name][Work Item Type]; "Task")

    For example

    =SUMIFS(VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Original Estimate]; VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Iteration Path];CurrentIteration&"*";VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Area Path];AreaPath&"*";VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Work Item Type]; "Task")

  13. Also the Total Remaining Work in the Individual Capacity table may contain #REF! values. To resolve that change the formula with:

    =SUMIFS([Table name][Remaining Work]; [Table name][Iteration Path];CurrentIteration&"*";[Table name][Area Path];AreaPath&"*";[Table name][Assigned To];[Team Member];[Table name][Work Item Type]; "Task")

    For example

    =SUMIFS(VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Remaining Work]; VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Iteration Path];CurrentIteration&"*";VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Area Path];AreaPath&"*";VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Assigned To];[Team Member];VSTS_ab392b55_6647_439a_bae4_8c66e908bc0d[Work Item Type]; "Task")

  14. Save and close the workbook.

Step 6: Bind Product backlog workbook to the team project

  1. Repeat the steps for binding the Iteration backlog for thiw workbook too.

  2. In the worksheet Capacity, the formula of the Storypoints might be missing. You can resolve it with:

    =IF([Iteration]="";"";SUMIFS([Table name][Story Points];[Table name][Iteration Path];[Iteration]&"*"))


    =IF([Iteration]="";"";SUMIFS(VSTS_487f1e4c_db30_4302_b5e8_bd80195bc2ec[Story Points];VSTS_487f1e4c_db30_4302_b5e8_bd80195bc2ec[Iteration Path];[Iteration]&"*"))


Portal | VSTS 2010


1/25/2010 1:30:37 AM #

Doug Wilson

Hi Ewald

Am trying to do the same thing as this doc (Configure TFS Portal Afterwards) outlines on TFS 2008.
However, when right clicking on a project and choosing Team Project Settings, I don't have Portal Settings in the menu.

Would you be able to point me in the right direction on how to add the project portal when you've selected "Do Not setup project portal" when creating the TFS Project, on TFS 2008?

Any help greatly appreciated.

Doug Wilson South Africa |

1/25/2010 1:34:46 AM #

Ewald Hofman

In TFS 2008 you don't have the option of not setting up a portal.

Ewald Hofman Netherlands |

4/9/2010 5:56:16 AM #


How to set the Default Team Project for a SharePoint site

You have probably created a SharePoint site after creating the Team Project and a receiving the error

Visual Studio Team System (VSTS) Blog - by Neno Loje |

4/12/2011 5:44:55 PM #


Never in my life have I seen such a terrible product. I can't believe the hoops you have to jump through to make this shocking product work.

Peter Australia |

8/27/2011 7:34:16 AM #


How to add a SharePoint portal after you created the Team Project

How to add a SharePoint portal after you created the Team Project

Donovan Brown's blog |

11/5/2016 3:30:55 PM #


How to add a SharePoint portal after you created the Team Project

How to add a SharePoint portal after you created the Team Project

Donovan Brown |

Comments are closed

Powered by BlogEngine.NET
Theme by Mads Kristensen


Widget Statistics not found.

There is an error in XML document (0, 0).X

Recent comments

Comment RSS