It's all about the answers!

Ask a question

Importing Test Case Execution Records in RQM without Test Scripts


Chanchal Gulati (112) | asked Jan 08 '19, 4:57 a.m.

 Hello,


I am trying to import test cases from excel sheet to RQM and link all those test cases to a test plan.
Now, I don't have any test scripts, so i dont have any step results.
But i have final result which i want to be stored in RQM as test execution record as Passed or Failed.

I have written below script:
//
testplan.dc:title=B1
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planBusinessObjectives","RQM-KEY-TP-BUSS-OBJ-TITLE")=B2
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planTestObjectives","RQM-KEY-TP-TEST-OBJ-TITLE")=B3
testplan.XLSLink=testcase
testplan.XLSWorksheetID="Test"

testcase.XLSStartRow=6

testcase.dc:title=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=C
testcase.dc:description=D
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=E
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseNotes","RQM-KEY-TC-NOTES-TITLE")=F


//execution workitem
executionworkitem.XLSWorksheetID="Test"
executionworkitem.XLSStartRow=6
executionworkitem.XLSDelimeter=\n
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=B
executionworkitem.testcase=Link(B)
executionworkitem.testplan=Link(B1)


//execution result
executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=6
executionresult.XLSDelimeter=\n
executionresult.dc:title=executionworkitem.dc:title
executionresult.er:details=E
executionresult.jzalm:state=G

executionresult.testcase=Link(B)

But i have getting errors. I am not able to import final results. RQM is creating a test plan and link all test cases in it but execution records are not creating.

One answer



permanent link
Mehul Patel (9695) | answered Jan 08 '19, 7:30 a.m.
FORUM MODERATOR
Chanchal,

I quickly modified 'Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne' to generate scriptless testresult and found its working as expected. I would suggest to check '%appdata%\Mso2Rqm\Mso2Rqm_Debug.log' for detailed debug log to investigate further.

Regards,
Mehul

Your answer


Register or to post your answer.