It's all about the answers!

Ask a question

Is it possible to manage in both directions tests written in RQM and Excel?

Mark Lane (111) | asked Oct 07 '13, 9:11 a.m.
edited Oct 10 '13, 12:53 p.m. by David Walker (2264)

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
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

permanent link
Ara Masrof (3.2k15) | answered Oct 07 '13, 9:36 a.m.

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

permanent link
Mark Lane (111) | answered Oct 10 '13, 6:06 a.m.
edited Oct 10 '13, 7:40 a.m.
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.jzalm:state=D5 & " " & image(B) & " " & image(C) & " " & image(E)

Your answer

Register or to post your answer.