TFS & Visual Studio ALM – by Neno Loje

(formerly Team System, VSTS)

Export TFS Work Items to an .XML file (using TFS Power Tools)

November 21st, 2011 · 1 Comment · TFS Work Item Tracking, Tools and Utilities

TFS Work Items can be easily exported to XMLSteps:

  1. Download Team Foundation Server Power Tools.

  2. On the command line use the TFPT.exe utility to export all work items from a team project in .XML format:

    tfpt query /collection:<URL> /format:xml /wiql:"SELECT * FROM WorkItems WHERE [System.TeamProject] = ‘<TeamProject>’ AND [System.WorkItemType] <> ‘Sprint’ ORDER BY [System.Id]" > WorkItems.xml

    As you can see I selected all work items from the team project excluding Sprint Work Items. Feel free to modify the query, if necessary.


One Comment so far ↓

Leave a Comment