Is it possible to manage in both directions tests written in RQM and Excel?
First method tried
Starting from Excel I use the menu-item RQM Export to Repository so as to import into RQM the .xls file
that I created using the .cfg configuration file which I also created in order to be able to carry out the import.
The import works correctly and I find my data in RQM.
Now I want to modify the data inside RQM and export the modified data back to Excel so as to update the .xls
file.
Is this possible and, if so, how?
Second method tried
I create my tests in RQM,
I do a Run Offline on a test case (which has a test script) to work in Excel (I opened the rqms file in Excel using Import Offline).
I cannot update the result in RQM. I used Export to Repository.
2 answers
Mark,
Currently, there is no ‘built in’ way to export individual assets from RQM to Excel; there is an ‘Download as Spreadheet ( csv )” option for some of the Browse asset views but I don’t think that is what you are looking for
What you tried using the REST API?
You can capture the xml associated to the artifact(s) using Poster , CURL or some other 3rd party http client
Thank you for your help but in fact a solution (a workaround) has been found.
The offline export of data from RQM generates an .rqms file.
This can be read in Excel with appropriate plugin.
The file is converted to an .xls file.
The data can be modified in Excel and then imported to RQM as an .xls file.
The update works correctly.
The source of the earlier problem was the incorrect generation of the configuration .cfg file.
Commenting out the first line solved the problem.........
//executionresult.XLSStartRow=7
executionresult.XLSDelimeter=\n
executionresult.XLSArtifactID=B4
executionresult.jzalm:state=D5
executionresult.er:starttime=D3
executionresult.er:endtime=D3
executionresult.er:stepResults.XLSStartRow=8
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)
executionresult.executionworkitem=Link(O4)
The offline export of data from RQM generates an .rqms file.
This can be read in Excel with appropriate plugin.
The file is converted to an .xls file.
The data can be modified in Excel and then imported to RQM as an .xls file.
The update works correctly.
The source of the earlier problem was the incorrect generation of the configuration .cfg file.
Commenting out the first line solved the problem.........
//executionresult.XLSStartRow=7
executionresult.XLSDelimeter=\n
executionresult.XLSArtifactID=B4
executionresult.jzalm:state=D5
executionresult.er:starttime=D3
executionresult.er:endtime=D3
executionresult.er:stepResults.XLSStartRow=8
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)
executionresult.executionworkitem=Link(O4)