Test Case Migrator (Excel) Tool
Overview
With Microsoft Visual Studio 2010, you get the End-to-End support for dealing with Test artifacts (test cases, test steps, test results etc) when they are stored in Test Case Management (TCM)/Team Foundation Server (TFS). This allows you to reap all the benefits associated with Test Case Management (requirements traceability, test coverage, requirements coverage, test execution, test result analysis etc).
However, most of the test user base have their test artifacts in Microsoft Excel. For folks who want to move this test data into TCM server and then would want to use TCM Server/Microsoft Test and Lab Manager client going forward, the "Test Case Migrator (Excel)" tool provides you this capability.
Some of the salient features associated with this tool are as follows:
- Imports Test case information (along with Test Steps) present in Excel into TCM/TFS server – Note: This is ONE way migration only
- Provides a wizard based UI to run the tool one file at a time
- Provides a command line support to run the tool in a batch mode
- Allows you to save your selections/configurations into a mappings file to be reused later
- Default mapping file that works across both Agile based and CMMI based projects are shipped along with the tool
Pre-Requisites
Both the following pre-requisites need to be present on the machine before you can run the “Test Case Migrator” tool. Without these, the tool will not function.
- Microsoft Visual Studio 2010 Beta2 bits
- Version of Microsoft Office 2003 or beyond
Installation
Unzip the TestCaseMigrator.zip and extract all the files to a local folder. Along with the core bits, the zip file also contains the default mapping file that works across both Agile & CMMI project templates that ship out-of-the-box.
Usage
Refer to the
TestCaseMigrator(Excel)-Readme document in the downloads section for a step by step description of how to use the Test Case Migrator (Excel) tool - both in UI mode and command line mode.