Exporting multiple test cases with test scripts by ETMExcelImporter

Troubleshooting

Problem

How to export multiple test cases with test scripts by using ETMExcelImporter into IBM Engineering Test Management(ETM)?

Resolving The Problem

If you have multiple test cases and want to link each test case to multiple test scripts in one worksheet, you cannot export to ETM because ETMExcelImporter does not support it. The Sample from ETMExcelImporter provides a way to export one test case with multiple test scripts in one worksheet. To work around the limitation, you can try:

1. Separate test case and test script into two worksheets in an excel file.
2. Specify testcase.XLSWorksheetID="testcase sheet name" and testscript.XLSWorksheetID="test script sheet name" in cfg file.
3. In the test case sheet, specify the IDs(external ids) of the associated test scripts for the test case in single cell separated by newline. If test case is linked to 2 test scripts, then for that test case row, the test script cell should have 2 ID values separated by newline.
4. In the cfg file, use testcase.testscript=Link(x) to link the test case with test scripts. Here x is the column in the test case sheet where you specify test script IDs in step 3.

[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"ARM Category":[{"code":"a8m50000000CjKiAAK","label":"Quality Manager-\u003EUtilities-\u003EETMExcelWordImporter Utility-\u003EMicrosoft Excel Specific"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Product Synonym

Rational Quality Manager,RQM,ETM,Engineering Test Management

Was this topic helpful?

Document Information

Modified date:
11 October 2023

UID

swg21701101

Tips