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

xml format to import test cases in rqm

Hi. I need to import a test case in excel format in RQM. I made a XML file with the follow structure:

-------------------------------------------------------
<testcase>
<identifier>https://localhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/testcase/CP1.xml</identifier>

<title>CP1</title>

<description>Inyectar un archivo de deposito desmaterializado del banco BCI, con tipo de instrumento = Deposito a plazo fijo</description>

<state>Approved</state>

<creator>Lorena Cortes</creator>

<owner>Lorena Cortes</owner>

<category></category>

<category></category>

<Precondition>La jornada debe estar vigente </Precondition>

<template></template></testcase>
----------------------------------------------------------

When i finish to import the xml file in RQM, the pre-condition doesn't load in the test case's Pre-Condition section.

What i'm doing wrong?

0 votes

Comments

I am interested in this answer too.



16 answers

Permanent link
Sorry, but the MS Office import utilities have not been made available yet. We do supply a Samples directory when RQM is installed that contains some of the XML formats. Which RQM artifact are you most interested in (e.g., test plan, test case, test script)?

0 votes


Permanent link
I have a "quick and simple" EXAMPLE implementation that reads a list of testcases from an excel spread sheet and uses RQM API to import those to RQM project area.

The main program (class RqmApiClient) uses the open source HSSF component from Apache POI project (http://poi.apache.org) to read data of interest from the excel spread sheet.

Next, I generate an XML document for testcase & test execution records, and then use RQM API to add them to a project area. I use an attribute of the testcase to determine which test environments to create test execution records for.

The excel spread sheet also includes test environments, but because there were only a few of those, I created those by hand first.

Note: To make things simpler, you could just write the test case XML to a file and use the test case import capability rather than RQM API, but you need RQM API to create your own TERs.

You can download jar file that includes source code from internal IBM wiki at:
https://w3.tap.ibm.com/w3ki07/display/STGAuto/Using+RQM+API+from+Java+Client

Disclaimer: The attached source is provided as an example only with the standard legal caveats. You'll need to modify the spreadsheet reader to match the format of your excel files, and likely modify the XML documents to include the testcase details that are interesting for your implementation.

0 votes


Permanent link
Hi there,

I am looking to use RQM as a way to import test results (from tests executed on a non rational tool). These test results are in xml format and I am attempting to import them in and have RQM display the results in a nice graph. So far, i cant find any information on how this can be done.

Is this possible...?
If so...any idea how its done?

ta
Jon

0 votes


Permanent link
Hi,

Anyone have a format for import test case in RQM pliss.
I need one.

Thx

0 votes


Permanent link
Hi There,

I am using MSO2RQM utility to import a word document in to test case and test scripts to RQM. How do I get the precondition added to the test script from word doc.


Thanks

0 votes


Permanent link
Hi there,

I am looking to use RQM as a way to import test results (from tests executed on a non rational tool). These test results are in xml format and I am attempting to import them in and have RQM display the results in a nice graph. So far, i cant find any information on how this can be done.

Is this possible...?
If so...any idea how its done?

ta
Jon


Hello Jon,

Check out the information on the RQM API here: https://jazz.net/wiki/bin/view/Main/RqmApi

0 votes

1–15 items
page 2of 1 pagesof 2 pages

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: Mar 31 '09, 7:58 a.m.

Question was seen: 23,866 times

Last updated: Dec 30 '16, 6:29 a.m.

Confirmation Cancel Confirm