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.


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.