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?
-------------------------------------------------------
<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?
16 answers
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 anexample 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.
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
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
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
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
page 2of 1 pagesof 2 pages
Comments
Brian Lahaie
Dec 30 '16, 6:29 a.m.I am interested in this answer too.