CODEWITHSUNDEEP
tfstfs-workitem
ChrisC
ChrisC

Reputation: 1171

How to import linked Test Cases/User Stories from Excel into TFS2013?

I have a set of User stories and their associated test cases in an Excel spreadsheet. I set it up as a tree list as per this page here (https://msdn.microsoft.com/en-us/library/dd286627.aspx), but when I import into TFS 2013 the test cases only show up under the "All Links" tab, not the "Test Cases" tab.

How do I import User Stories and their associated test cases from Excel and have the test cases appear under "Test Cases", and likewise have the User Stories linked under "Tested User Stories" tab on the test cases?

Upvotes: 1

Views: 1324

Answers (1)

rerwinX
rerwinX

Reputation: 2035

Excel will create Parent-Child links and you'd like Tests-Tested by links so you're looking at using the TFS API.

I'd pull the IDs into a csv file and then use a PowerShell script to create the links.

This was a similar question I answered with more details on the script:

TFS 2013 - Link Work Items via Spreadsheet

The easiest thing would be to have two columns, one for User Story ID and one for Test Case ID. You'd just repeat the Story ID in multiple rows if it has more than one Test Case.

The only difference here would be to change the link type to TestedBy rather than Hierarchy.

More detail on link types here:

TFS API Part 22 – Create Link Between Work Item

Upvotes: 0

Related Questions