Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I modify the title of work items in TFS en masse?

I have a Product Backlog Item (PBI) in TFS, which has multiple Sprint Backlog Tasks (SBTs) under it in a grid.

How can I modify the title of the items in that grid without opening each one individually in the preview or otherwise?

enter image description here

like image 824
Ryan Gates Avatar asked Apr 23 '13 16:04

Ryan Gates


Video Answer


2 Answers

It is possible because when selecting a WorkItem, in the half screen on the bottom, you will have its details, and thus can change it. After you re done, you will be able to save all in one Ctrl-S

Better way :

I have done that by exporting result of query in MS Excel, modifying multiple columns and rows rapidly; then Publish the whole by one click.

like image 112
a.boussema Avatar answered Sep 29 '22 17:09

a.boussema


For Visual Studio 2010, 2013, the following will work:

  1. Open a list of the items you wish to edit in Visual Studio/Team Explorer Tab. This can be done via a new query.
  2. Highlight all items (of the same type) that you want to change.
  3. Click the ‘Open in Microsoft Office’ drop-down or right click on one of the selected task items and select ‘Open In Microsoft Excel’.
  4. Edit the fields you are interested in using standard Excel functionality to copy/paste or replace.
  5. Click the ‘Publish’ button at the upper left in Excel.
  6. After that has completed, click on the Refresh icon at the top of your product backlog view in Visual Studio.
  7. Your updated/bulk-edited entries will now appear.
like image 26
Curtis Avatar answered Sep 29 '22 18:09

Curtis