It's all about the answers!

Ask a question

xml format to import test cases in rqm


Pablo Schwarzenberg (11) | asked Mar 31 '09, 7:58 a.m.
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?

Comments
Brian Lahaie commented Mar 31 '09, 2:21 p.m. | edited Dec 30 '16, 6:29 a.m.

I am interested in this answer too.

16 answers



permanent link
Helen Lozoraitis (60624) | answered May 12 '09, 2:14 p.m.
JAZZ DEVELOPER
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)?

permanent link
William Owen (9145) | answered May 12 '09, 4:33 p.m.
JAZZ DEVELOPER
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.

permanent link
jon mcnamara (622) | answered Jun 22 '09, 12:33 p.m.
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

permanent link
Roberto Norambuena (11) | answered Jul 07 '09, 12:55 p.m.
Hi,

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

Thx

permanent link
Srilatha Kolla (1111) | answered Nov 09 '10, 1:37 p.m.
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

permanent link
John Nason (2.4k1012) | answered Dec 02 '10, 6:39 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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

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.