It's all about the answers!

Ask a question

RQMExcelImporter-cannot upload TCER results (without test script)


Thao Nguyen (3713) | asked Oct 12 '17, 10:48 p.m.

 Hello,


I created config file to upload Test Case name/identifier without creating Test script (as below) through RQMExcelImporter successfully
testcase.XLSStartRow=3
testcase.XLSWorksheetID="TC list"
testcase.dc:title=C
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

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 Testplan 
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.Section("com.ibm.rqm.planning.editor.section.planTestEnvDetails","RQM-KEY-TP-TEST-ENV-DETAIL-TITLE")=Div(C4)
testplan.XLSLink=testcase
testplan.configuration=Link(H3)
testplan.XLSWorksheetID="Testplan" : "Test"
//testplan.jzalm:owner="abc"

//Config for testphase
testphase.XLSWorksheetID="Test"
//testphase.XLSArtifactID=H2
testphase.dc:title=C5
testphase.dc:description=C6
testphase.testplan=Link(C1)

testcase.XLSArtifactID=B
testcase.XLSWorksheetID="Test"
testcase.XLSStartRow=15
testcase.dc:title=B

//execution workitem
executionworkitem.XLSWorksheetID="Test"
executionworkitem.XLSStartRow=15
executionworkitem.XLSDelimeter=\n
// should NOT remove below line (one) 
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=B
executionworkitem.testcase=Link(B)
executionworkitem.testplan=Link(C1)
executionworkitem.configuration=Link(N)
executionworkitem.testphase=Link(O6)

//execution result
executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=15
executionresult.XLSDelimeter=\n
executionresult.dc:title=executionworkitem.dc:title
executionresult.er:details=E
executionresult.jzalm:state=J
executionresult.er:starttime=K
executionresult.er:endtime=L
executionresult.er:stepResults.er:steptype="execution"
executionresult.er:stepResults.er:result=I
executionresult.er:stepResults.er:description=E
executionresult.er:stepResults.er:expectedResult=F
executionresult.er:stepResults.er:actualResult=J
//executionresult.er:stepResults.er:actualResult=F
executionresult.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?


Comments
Thao Nguyen commented Oct 17 '17, 4:04 a.m. | edited 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

2 answers



permanent link
Don Yang (7.5k2195130) | answered Oct 19 '17, 6:23 a.m.

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


permanent link
Thao Nguyen (3713) | answered Oct 25 '17, 5:32 a.m.
edited Oct 25 '17, 10:37 p.m.

 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


Register or to post your answer.