IBM Support

Using ETMExcelImporter to export multiple test execution results to the same Test Case Execution Record

Troubleshooting


Problem

How to export multiple execution results to the same Test Case Execution Record(TCER) by using ETMExcelImporter.

Resolving The Problem

Suppose you have ETMExcelImporter installed. The sample under the installation directory [Scripts that create testcases with TCER.xls]/[Scripts that create testcases with TCER.cfg] is used to explain the procedures.

1. Specifying external id with "XLSArtifactID" keyword in cfg file(Scripts that create testcases with TCER.cfg) for execution result.

1-1. In cfg file, add a line
executionresult.XLSArtifactID="executionresult_" & B
to //Execution result section
1-2. Export "Scripts that create testcases with TCER.xls" to IBM Engineering Test Management(ETM)
1-3. Change the external id for execution result only for example: executionresult.XLSArtifactID="executionresult1_" & B
1-4. Update the result in the xls file if any
1-5. Export to the same ETM project area
1-6. Repeat the above three steps if you have more results to export

2. If no external id is specified for execution result in cfg file, try:

2-1. Add the below line to //Execution result section
executionresult.executionworkitem=Link(B)
2-2. Export "Scripts that create testcases with TCER.xls" to ETM
2-3. Update the result in the xls file if any
2-4. Change the name of xls file name or worksheet name
2-5. Export to the same ETM project area
2-6. Repeat the above three steps if you have more results to export

[{"Type":"MASTER","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":"Test Management-\u003EUtilities-\u003EETMExcelWordImporter Utility-\u003EMicrosoft Excel Specific"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Product Synonym

IBM Engineering Test Management

Document Information

Modified date:
24 January 2023

UID

swg21700216