"Test Case Migrator Plus" (Excel/MHT) Tool

Overview

With the prior releases of Test Case Migrator (Beta and RC1), it was possible to:

migrate test cases (along with test steps) present in Microsoft Excel to VS2010 TCM server AND
migrate VS 2005/2008 test templates present in MHT/doc formats to VS2010 TCM server.

These capabilities allowed you to reap all the benefits associated with Test Case Management (requirements traceability, test coverage, requirements coverage, test execution, test result analysis etc) present in VS 2010 release post migration.

With the RC2 release of this tool, we are adding to the Excel capabilities, the ability to migrate not just the Test case work item, but also Requirements and Bugs work items – hence the change in name of the executable to “TestCaseMigratorPlus.exe”. The mht/doc based workflow remains the same – i.e. it only supports migration of work item type present in the VS2005/2008 manual test templates.

Some of the salient features associated with this version of tool (for excel based workflow) are as follows:

Migrates work items belonging to Test case, Requirement/User story and Bug work item types.
Supports multi-pass migration process - i.e., each work item type has to be migrated in a different invocation/session of the tool.
Maintains links between work item types (Parent/Child, Related, Tested By, Tests etc) across multiple passes.
Provides ability to create Test suites for a test case work item type.

Salient features associated with prior versions of the tool include:

Migrates Test case information (along with Test Steps) present in Excel – This is a ONE way migration only.
Migrates VS2005/VS2008 manual test case templates (MHT/word) into TCM/TFS server – This also is ONE way migration only.
Provides a wizard based UI to run the tool one file at a time (for Excel) or iterate over multiple files within a folder in a single run (for MHT/word).
Provides a command line support to run the tool in a batch mode.
Allows you to save your selections/configurations into a settings/mappings file to be reused later.
Default settings/mapping file that works across both Agile based and CMMI based projects is 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 Plus” tool. Without these, the tool will not function.

Microsoft Visual Studio 2010 RTM bits

Version of Microsoft Office 2003 or beyond

What's new for this version (RC2)

With this new drop in RC2, the following functionality has been added to the Excel based workflow:

Migrate not just Test case, but also Requirement/User story and Bug work item types.
Migrate links (using “Links mapping” dialog (Excel flow)) between different work item types across different invocations/sessions of the tool. Refer to “LinksMapping(Excel)-Internals-Readme.doc” for additional details.
Default link types supported include:
- “Parent/Child” links between Requirement::Requirement
- “Related” links between Requirement::Requirement
- “Related” links between Test Case::Test Case
- “Related” links between Bug::Bug
- “Related” links between Requirement::Bug
- “Tested By/Tests” links between Requirement::Test Case
- “Tested By/Tests” links between Bug::Test Case
Create Test plans/test suites as part of migration process for a Test case work item type.
Create Area/Iteration Paths at runtime based on folder hierarchy specified in excel file for all supported work item types.
Analyze the migration process across different runs using “Consolidated Excel Pivot reports” (Excel flow) in addition to the session based output excel file.
Updated and polished UI for the tool – now this is consistent with VS2010 theme.
Improved and early inline error handling.

No changes have been made to the mht/doc based workflow other than UI polish.

Installation

Download the “TestCaseMigratorPlus(Excel-MHT) V1.0 RC2 Binaries.zip” and extract it to a folder and start the TestCaseMigratorPlus.exe application. Along with the binaries package, the other files that might be useful include the Readme document, the Linking internals document and the samples package (one for Excel & other for MHT). The sample packages contain corresponding setting file that you can use to jump start the migration process.

Usage

Refer to the TestCaseMigratorPlus(Excel-MHT)-Readme document in the downloads section for a step by step description of how to use the "Test Case Migrator Plus" (Excel/MHT) tool - both in UI mode and command line mode. Refer to the LinksMapping(Excel)-Internals-Readme for an in-depth look at how the links are migrated with this tool.

Last edited May 12 at 1:58 PM by ravishan, version 9

Want to leave feedback?
Please use Discussions or Reviews instead.

Download

Microsoft Public License (Ms-PL)

This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.

1. Definitions

The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.

A "contribution" is the original software, or any additions or changes to the software.

A "contributor" is any person that distributes its contribution under this license.

"Licensed patents" are a contributor's patent claims that read directly on its contribution.

2. Grant of Rights

(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.

(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.

3. Conditions and Limitations

(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.

(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.

(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.

(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.

(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

Current	V 1.0 (RC2)
Date	Fri May 7 2010 at 7:00 AM
Status	Beta
Rating	No Ratings 2294 downloads
More	View all downloads

Activity

7 30 All days

Page Views	337
Visits	210
Downloads	115
Application Runs	N/A

View Detailed Stats

Visual Studio 2010 Test Case Import Utilities