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


i have set of user stories , associated test cases in excel spreadsheet. set tree list per page here (https://msdn.microsoft.com/en-us/library/dd286627.aspx), when import tfs 2013 test cases show under "all links" tab, not "test cases" tab.

how import user stories , associated test cases excel , have test cases appear under "test cases", , likewise have user stories linked under "tested user stories" tab on test cases?

excel create parent-child links , you'd tests-tested links you're looking @ using tfs api.

i'd pull ids csv file , use powershell script create links.

this similar question answered more details on script:

tfs 2013 - link work items via spreadsheet

the easiest thing have 2 columns, 1 user story id , 1 test case id. you'd repeat story id in multiple rows if has more 1 test case.

the difference here change link type testedby rather hierarchy.

more detail on link types here:

tfs api part 22 – create link between work item


Comments