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

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

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.

0 votes



3 answers

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

0 votes


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

0 votes


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

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

Question asked: Jun 01 '11, 10:18 p.m.

Question was seen: 5,691 times

Last updated: Jun 01 '11, 10:18 p.m.

Confirmation Cancel Confirm