RQMExcelImporter-cannot upload TCER results (without test script)
![]() Hello,
I created config file to upload Test Case name/identifier without creating Test script (as below) through RQMExcelImporter successfully
Then i generate Test Plan, TCER to relate only one newly created Test Case (column B15 as in excel file)
However, i could not use RQMExcelImporter to upload TCER result with following config file (customize from sample config: Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.cfg. Therefore, overrall result is in column J). My need is to upload test result only, without filling aditional information such as: Weight, Test Environment,...
Excel add-in runs without error, but i do not see updated result in Execution-TCER or TCR view
Could you advise if anything is wrong here?
|
2 answers
![]() Hi, Thao
|
![]() Thanks Don,
I modify config file as below and successfully upload test results , however i see 2 strange things
1. Test cases do not appear in Test Plan--Test Case section, they only appear at Test Plan--Test Case Execution Records section. Seem this is different from the way we create Test Plan then TCER then run TCER
How can we make these Test Cases names appear in Test Plan--Test Case section? (I doubt of following bold line in config file)
2. If i change test plan name in Excel file, change for example from name TestPlan_1 to TestPlan_2. Use same config file as below to update result. These TCERs disappear from TestPlan_1 and appear in TestPlan_2. Look it is design intent to make TCER name unique (as what i see when i create TCEr manually on Jazz QM web GUI)?
Is there any way to make same/different TCER name appear at both Test Plan (TestPlan_1 and TestPlan_2) by config file?
// static test case definition
testcase.XLSWorksheetID="Test"
testcase.XLSStartRow=15
testcase.XLSArtifactID=B
testcase.dc:title=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=I
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=J
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=K
//test plan
testplan.XLSWorksheetID="Testplan" : "Test"
testplan.dc:title=C1
testplan.XLSArtifactID=C1
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planBusinessObjectives","RQM-KEY-TP-BUSS-OBJ-TITLE")=Div(C2)
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planTestObjectives","RQM-KEY-TP-TEST-OBJ-TITLE")=Div(C3)
testplan.XLSLink=testcase
//execution workitem
executionworkitem.XLSWorksheetID="Test"
executionworkitem.XLSStartRow=15
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=B
executionworkitem.testcase=Link(B)
executionworkitem.testplan=Link(C1)
//execution result
executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=15
executionresult.dc:title=executionworkitem.dc:title
executionresult.jzalm:state=J
//executionresult.testcase=Link(D) -not sure if this can add Test Case to Test plan
Excel file contains test result is similar to sample file of RQMExcelImporter utility: Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Could someone give me a hand on this? I need to upload hundred test results (with different categories selection/test conditions), updating results manually on Jazz QM looks not efficiently