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.
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.
4 answers
hi @annadoran82,
you can refer to the following config file.
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.
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.
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