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

Importing Test Script Results from Excel to RQM

Hi there,

Could somebody please tell me if there is an .cfg importer file that allows you to import test script results and status from excell to RQM? Our client will be executing test scripts via excel and we therefore need to import their actual results into RQM when they are finished testing.

I could not find any .cfg files that did this in the Microsoft Excel Importer from the Jazz Team Wiki.

0 votes



4 answers

Permanent link
hi @annadoran82,
you can refer to the following config file.

executionresult.XLSStartRow=9

executionresult.XLSDelimeter=\n
executionresult.XLSArtifactID=B4
executionresult.jzalm:state=D5
executionresult.er:starttime=D3
executionresult.er:endtime=D3
executionresult.er:stepResults.XLSStartRow=13
executionresult.er:stepResults.er:result=D
executionresult.er:stepResults.vg:id=O
executionresult.er:stepResults.description=B & " " & image(B)
executionresult.er:stepResults.er:expectedresult=C & " " & image(C)
executionresult.er:stepResults.er:actualResult=E & " " & image(E)
executionresult.er:stepResults.er:comment=F
executionresult.er:stepResults.er:steptype=G
executionresult.testcase=Link(O2)
executionresult.testscript=Link(O3)


Hi there,

Could somebody please tell me if there is an .cfg importer file that allows you to import test script results and status from excell to RQM? Our client will be executing test scripts via excel and we therefore need to import their actual results into RQM when they are finished testing.

I could not find any .cfg files that did this in the Microsoft Excel Importer from the Jazz Team Wiki.

0 votes


Permanent link
Hi,

Thanks for getting back to me. Do you have an excel template that I could use as a reference to the code you sent me?

Thanks again,

Anna

0 votes


Permanent link
Hi @annadoran82,

would you please refer to the "Running manual tests in off-line mode"

http://publib.boulder.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.rational.test.qm.doc%2Ftopics%2Ft_run_offline.html

after importing for offline, you can refer to the generated excel and config file.




Hi,

Thanks for getting back to me. Do you have an excel template that I could use as a reference to the code you sent me?

Thanks again,

Anna

0 votes


Permanent link
Hi there,

My hosted version of RQM does not host the Offline feature. Therefore could you please send me an attached version of the excel spreadsheet you would use to execute the scripts offline?

Thanks again,

Anna

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: Apr 23 '12, 12:42 p.m.

Question was seen: 5,597 times

Last updated: Apr 23 '12, 12:42 p.m.

Confirmation Cancel Confirm