How to Export manual test cases written in Excel to TFS

Question

Hi,

I am using excel to mailntain our test cases. Now we are moving to TFS for storing test cases.
So does anyone knows any Micro(excel) / tool to directly export test cases from Excel to TFS

Answer 1

You can try the Test Case Migrator (Excel) Tool: http://tcmimport.codeplex.com/

---

Ewald - Please remember to mark the replies as answers if they help.


Blog: www.ewaldhofman.nl

Answer 2

Is there a tool for TFS 2008 and not only 2010 ?

Answer 3

Hi you can use following link

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Arial Rounded MT Bold"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} a:link, span.MsoHyperlink {mso-style-noshow:yes; mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> http://social.msdn.microsoft.com/Forums/en/tfsworkitemtracking/thread/3451ff62-fba9-4b60-a018-e3d6cb80fbe9

Answer 4

Link is not working...

Answer 5

What do you want to import? TFS 2008 does not have the manual tests like in TFS 2010.

---

Ewald - Please remember to mark the replies as answers if they help.


Blog: www.ewaldhofman.nl

Answer 6

what I'm actually looking for is a simple manage of test cases in TFS 2008.
Meaning, define a new WI for Test Case, maybe link it as "related WI" to each task WI, and to learn how to use TFS reporting capabilities to check for coverage.
Do you have by any chance example XML for WI representing test case ?
And also can you please advise how can we use the reporting capabilities to check for coverage.

10X,Rinat.