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
testcase.XLSStartRow=3testcase.XLSWorksheetID="TC list"testcase.dc:title=Ctestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=Itestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Jtestcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=K
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,...
//Config for Testplantestplan.dc:title=C1testplan.XLSArtifactID=C1testplan.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.Section("com.ibm.rqm.planning.editor.section.planTestEnvDetails","RQM-KEY-TP-TEST-ENV-DETAIL-TITLE")=Div(C4)testplan.XLSLink=testcasetestplan.configuration=Link(H3)testplan.XLSWorksheetID="Testplan" : "Test"//testplan.jzalm:owner="abc"
//Config for testphasetestphase.XLSWorksheetID="Test"//testphase.XLSArtifactID=H2testphase.dc:title=C5testphase.dc:description=C6testphase.testplan=Link(C1)
testcase.XLSArtifactID=Btestcase.XLSWorksheetID="Test"testcase.XLSStartRow=15testcase.dc:title=B
//execution workitemexecutionworkitem.XLSWorksheetID="Test"executionworkitem.XLSStartRow=15executionworkitem.XLSDelimeter=\n// should NOT remove below line (one)executionworkitem.XLSArtifactID="executionworkitem_" & Bexecutionworkitem.dc:title=Bexecutionworkitem.testcase=Link(B)executionworkitem.testplan=Link(C1)executionworkitem.configuration=Link(N)executionworkitem.testphase=Link(O6)
//execution resultexecutionresult.XLSWorksheetID="Test"executionresult.XLSStartRow=15executionresult.XLSDelimeter=\nexecutionresult.dc:title=executionworkitem.dc:titleexecutionresult.er:details=Eexecutionresult.jzalm:state=Jexecutionresult.er:starttime=Kexecutionresult.er:endtime=Lexecutionresult.er:stepResults.er:steptype="execution"executionresult.er:stepResults.er:result=Iexecutionresult.er:stepResults.er:description=Eexecutionresult.er:stepResults.er:expectedResult=Fexecutionresult.er:stepResults.er:actualResult=J//executionresult.er:stepResults.er:actualResult=Fexecutionresult.testcase=Link(D)executionresult.testscript=Link(B)
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
At least I see some problems here.
When there is no scripts in your cfg file, why there are step results for test scripts which does not make sense?
Also the line executionresult.testscript=Link(B) is odd as there is no script.
See if this post helps:
https://jazz.net/forum/questions/243497/rqm-tips-sharing-using-rqmexcelimporter-to-export-multiple-test-execution-results-to-the-same-tcer
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
Comments
Thao Nguyen
Oct 17 '17, 4:05 a.m.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