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

[Closed] RQM Excel Import: Importing TER

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.

1

0 votes

Comments

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

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

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

Question asked: Feb 06 '17, 5:51 a.m.

Question was seen: 1,789 times

Last updated: Feb 22 '17, 12:15 a.m.

Confirmation Cancel Confirm