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

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.

 

0 votes



2 answers

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

0 votes


Permanent link
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)

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
× 12,029
× 115

Question asked: Oct 07 '13, 9:11 a.m.

Question was seen: 4,875 times

Last updated: Oct 10 '13, 12:53 p.m.

Confirmation Cancel Confirm