Import test cases from Excel

by Ewald Hofman 6. November 2009 13:28

On of the pillars of TFS 2010 is the “No More No Repro”. This statement is based on the exceptional tooling to improve the communication and information hand-over between the developer and the tester. The tooling that is used is the IntelliTrace (aka Historical Debugging) and the Test Center.

The Test Center is heavily based on the Test Case work item. That work item contains the steps for the test case, which are shown when executing the test case.

 ScreenShot001

That is very nice, but what to do with all those test cases that we have already defined in other applications. And what to do with testers who does not want to leave their own tooling, such as Excel. For those situation, Microsoft has created a Test Case Importer tool on Codeplex. This post shows you what you can expect from that importer.

You can download the importer from: http://tcmimport.codeplex.com.

When you first start the importer you will see the following screen

ScreenShot002

The importer will guide you through a couple of steps to give enough information how and what to import. In this post the following sheet is used as example.

ScreenShot003

First it asks the destination of the test steps.

 image

Then the wizard asks for the destination. This is a combination of the TFS Server, the team project and the work item type.

image

The next step is to create a mapping between the columns in Excel and the fields in the work item

image

In the Data Mapping step you have the possibility to create a mapping between values in Excel and lists in the TFS work item, for example for the Priority field.

When you then start the import, a progress dialog appears

image

When the importer is ready, you have created for each row a new test case work item which you can use to do the further testing.

I am very satisfied that Microsoft has provided a tool to import test cases that were created in the past. Can’t wait to convert all those test cases in the excellent TFS 2010 environment and make my product very stable.

Tags:

VSTS 2010 | Work items | Test Essentials

Powered by BlogEngine.NET 1.6.1.0
Theme by Mads Kristensen


ClusterMap

Statistics

Statistics created at 09 Sep 2009

121 posts
487 comments
316 raters
1762482 visit (1044 per day)
21 users online

Recent comments

Comment RSS