Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Importing Test Case Execution Records in RQM without Test Scripts

 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.

0 votes



One answer

Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014

Question asked: Jan 08 '19, 4:57 a.m.

Question was seen: 1,348 times

Last updated: Jan 08 '19, 7:30 a.m.

Confirmation Cancel Confirm