It's all about the answers!

Ask a question

mapping excel test cases to RQM - what is the best practice?


Ryan Rayner (361715) | asked Jun 01 '11, 10:18 p.m.
Is there a way we can show tabular test case information in RQM? We have an excel spreadsheet we want to import, however I'm struggling with how it can be represented in RQM when we do an import. For example each line item on the "test grid" represents a test case an has the following attributes

- test case ID
- requirement ID
- test case objective
- test data (to be used for the test case)
- test case preconditions
- expected results
- actual results
- pass / fail

We could have 500 test cases on the excel "test grid". Is there a way we can repreent in tabular fashion and still collect the metrics via insight? I would love to use the rich text editor to drop in an excel document but we probably can't report on that via Insight. At the same time, I don't want to have my testers have do a click on a hyperlink in the table of contents every time they want to browse an excel "cell". please help! what is the best practice for what we are trying to do.

3 answers



permanent link
Paul Slauenwhite (8.4k12) | answered Jun 02 '11, 7:22 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Is there a way we can show tabular test case information in RQM? We have an excel spreadsheet we want to import, however I'm struggling with how it can be represented in RQM when we do an import. For example each line item on the "test grid" represents a test case an has the following attributes

- test case ID
- requirement ID
- test case objective
- test data (to be used for the test case)
- test case preconditions
- expected results
- actual results
- pass / fail

We could have 500 test cases on the excel "test grid". Is there a way we can repreent in tabular fashion and still collect the metrics via insight? I would love to use the rich text editor to drop in an excel document but we probably can't report on that via Insight. At the same time, I don't want to have my testers have do a click on a hyperlink in the table of contents every time they want to browse an excel "cell". please help! what is the best practice for what we are trying to do.


A couple of comments:

-You can import test cases (and other test resources) in the UI or using the RQM Excel/Word Importer (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter).

-To determine the properties or fields of a test case, you can resolve the fully populated feed using the RQM reportable REST services (https://jazz.net/wiki/bin/view/Main/RqmApi#Fully_Populated_feedUrl) using Poster (https://jazz.net/wiki/bin/view/Main/RQMUsingPoster) or your web browser.

-All of the RQM resources/properties are documented in RQM schema documentation (http://jazz.net/projects/rational-quality-manager/api-doc-2.0/).

-These features are noted in the product documentation (https://jazz.net/help-dev/clm/topic/com.ibm.rational.test.qm.doc/topics/c_extendrqm.html).

permanent link
Jyothi kana (26) | answered Aug 04 '11, 1:37 a.m.
Hi,

please provide a sample xml template for import execution result. And
what is the executionworkitem when we are importing the execution result for new execution.please help me out in this.

permanent link
Robert Rassmann (9923) | answered Aug 08 '11, 3:13 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi,

please provide a sample xml template for import execution result. And
what is the executionworkitem when we are importing the execution result for new execution.please help me out in this.


The best way to get a template for your data is to create an execution result (or other resource for which you want a template) in the tool and then do a GET on it. That way you can include the fields you want to see.

Executionworkitem is a "Test Case Execution Record". Executionworkitem was the original name for this resource and it is still called that in the API so that the API remains backward compatible.

- Rob

Your answer


Register or 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.