Hidden Gems in TFS–Part 3 Editing multiple work items at the same time (Bulk Edit)

In this series of blog posts I like to highlight some features of TFS/Visual Studio that people seem to overlook. In my day to day job I often see that people don’t know about certain feature that are available in Team Foundation Server, Visual Studio or some of the Powertools.

Some features are available as a Powertool. These can be downloaded from here

Earlier Posts

In this part…….

Editing multiple work items at the same time (Bulk Edit)

Sometimes it is useful to edit multiple work items at once. For example when you want to set the area or iteration for a group of work items, or if you want to set a value in another field. Visual Studio does not allow you to do this, besides editing work items and save them all at once.

However, there are 2 ways in which you can easily edit multiple work items in TFS at the same time. I will describe them both.

Excel

The easiest and most documented way to bulk edit work items is with the help of excel. In order to this you first create a Work Item Query in Visual Studio

image

  • Fill in your filters and save the query in the My Queries or Team Queries folder.
    When the query is saved, right click the query and choose Open in Microsoft Excel

    image

  • The query results are opened in Excel
  • Once open edit all the fields you like
    image
  • Once done, press the Publish button on the Team Tab on the Ribbon

    image

When the Team Tab does not show, please read this blogpost

Web Access Client

For bulk edit Excel is really good, and a lot of people already know this. Less popular but effective as well is using the Web Access Client for Bulk Edit.

  • Open the Web Access Client (WAC). Usually you can access the WAC by typing http://<tfs server>:8080/tfs/web
  • Find the project and query you just created, or create a query in the WAC
    image
  • Run the query
  • Select the Work Items you want to edit by CTRL-Click or Shift Click
  • Choose Tools | Bulk Edit Selected Work Items

    image

  • Edit the fields you like and press Start

    image

  • All Work Items are updated

Enjoy!

Advertisements

7 Responses to “Hidden Gems in TFS–Part 3 Editing multiple work items at the same time (Bulk Edit)”

  1. Can this be updated to show how this would work in TFS 2012?

  2. Thanks much you saved me hours of useless clicking!

  3. What about bulk editing test steps?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: