It's all about the answers!

Ask a question

[Closed] RQM Excel Import: Importing TER


0
1
Kumar Kumar (6427) | asked Feb 06 '17, 5:51 a.m.
edited Feb 22 '17, 12:15 a.m.

Hello,
I need to export set of Test cases and its results with a Test plan to RQM. I don't have a Testscript.
I am trying with the below code

//execution workitem
executionworkitem.XLSWorksheetID="Example"
executionworkitem.XLSStartRow=2
executionworkitem.XLSDelimeter=\n
executionworkitem.XLSArtifactID="executionworkitem_" & B
executionworkitem.dc:title=A
executionworkitem.testcase=Link(A)
executionworkitem.testplan=Link(C1)

//oexecutionworkitem.testphase=Link(testphase.XLSArtifactID)

//execution result
executionresult.XLSWorksheetID="Example"
executionresult.XLSStartRow=2
executionresult.XLSDelimeter=\n
executionresult.dc:title=executionworkitem.dc:title
executionresult.er:details=D
executionresult.jzalm:state=H
executionresult.testcase=Link(A)

TestPlan and Test case creation happens as normal but Execution item and execution results throws an Internal server error 500.

Could any one help me to solve this problem.
NOTE: Every Test cases are in different row separated by a empty line.


Comments
Don Yang commented Feb 14 '17, 12:03 a.m.

If you check with Samples such as all in one(which has similar TCER and result creation) and it works, then something is related to your cfg and xls files. Otherwise, it could be related to the version of ExcelImporter. It will always be good to know what version of RQM and RQMExcelImporter you are using.

Accepted answer


permanent link
Mehul Patel (9695) | answered Feb 13 '17, 12:28 p.m.
FORUM MODERATOR

Kumar,


I would suggest to check log file for more detail, or provide sample excel file and cfg file to investigate further.

Regards,
Mehul

Kumar Kumar selected this answer as the correct answer

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.