"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 added 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 RC2 version of tool (for excel based workflow) were 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 the RTM version
This release (V1.1 RTM) includes fixes for 2 reported issues:
Issue#1: The tool crashes when used against a Scrum project template
This version includes the fix that enables you to work with Projects created with the Scrum Template. Without this fix, trying to use the tool against a project created using a Scrum template would either crash the tool or give various errors.
The core problem with the Scrum template was that the “Bug” work item was present in both “Requirements” category and “Bugs” category, whereas the tool was expecting it to be present only in the “Bugs” category. This has now been corrected.
Issue#2: Test Steps/Expected Results imported via tool do not show up in Microsoft Test Runner (MTR) during manual testing
The tool incorrectly imports the Test steps with Expected Results. Any test step with Expected result should be marked as a Validate step, however this was not set appropriately by the tool. As a result, when the test case is executed manually in MTR, the expected result does not show up inline with the test step.
Fix is that the ‘TestStepType’ field for such a test step should be set as TestStepType.ValidateStep
Thanks to kfkyle for submitting this fix
What's new for the RC2 version
With RC2, the following functionality was 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.1 RTM 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.