Create new executionresults for existing executionworkitems
I have a ready made test structure in RQM with test plans, -cases, -scripts, configurations and schedules.
I already have pre-created the TERs.
Now I want to import test results using the excel importer.
I have seen, that for offline testing, the executionresults are pre-created and their ID is used to update upon import. But I have not managed to create the executionresults during the import.
Is that possible???
Thanks
Stefan
One answer
Can you elaborate a little bit about your requirement?
Do you have the Test Results in excel sheet and you want to create execution results from that excel sheet?
Or you are trying to update the execution result using Offline execution feature?
Comments
Hi Reshma,
it is the first case.
I have Test Results in an excel sheet and I have TERs in RQM and now I want to create new results from those Test Results in Excel.
Hi Stefan,
You can use Link attribute to link the result with existing TCER. cfg should have line as below. Column D should have IDs of Test Case Execution Records
executionresult.executionworkitem=Link(D)
Hi Reshma,
thank you for the answer. I have tried this, but I am always getting errors. It seems only to work, if I have a testresult precreated (as is the case for the offline execution). However this is not the intention.
Hi, Reshma,
I have similar requests to export the test result from ExcelImporter to the existing TCER. In your comment, you mentioned to have column D with IDs of TCERs. Should this ID be the TCER's ID in GUI or it should be the specified external ID using importer to create TCER previously?
I am wondering if it is possible to import result for the TCER which were created via GUI(no external id) or from excelimporter without specifying external id in the cfg file?
Thank you very much.
Hi Stefan,
You can create ExecutionResult by linking to existing TCER using Link attribute. A sample cfg would look as below where column D should have ID(Internal or External) of TCER. You can find the ID value from feed url.
//execution result
executionresult.XLSStartRow=2
executionresult.XLSDelimeter=\n
executionresult.dc:title=D
executionresult.executionworkitem=Link(D)
executionresult.jzalm:state=I
executionresult.er:stepResults.er:steptype="execution"
executionresult.er:stepResults.er:result=I
executionresult.er:stepResults.er:description=E
executionresult.er:stepResults.er:expectedResult=G & image(G)
executionresult.er:stepResults.er:actualResult=H & image(H)
executionresult.er:stepResults.er:comment=L