RQM import function from xml file
Hi all,
I am trying to import a test script and test case into RQM from the xml file generated through excel. The code I am using is below which correctly creates the test case.xml and test script.xml
My question is how is the link automatically created in RQM? I can import both the test case (Construction -> Import Test Case) and test script (Construction -> Import Test Script), but when I check, there is no mapping between the two?
Any help would be gratefully appreciated.
testscript.XLSStartRow=2
testscript.XLSArtifactID=A
testscript.dc:title=A
testscript.dc:description=B
testscript.steps.title=C
testscript.steps.name=C
testscript.steps.type="execution"
testscript.steps.description=D
testscript.steps.expectedResult=E
testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.description=testscript.description
One answer
if you want export the test artifacts from Excel to RQM, you can use Export to repository directly.
and if you want to export manually from the RQM UI, you need to upload the referenced artifacts first, else the link will miss.
i.e. in you case you create test case and test script
assume
testcase xml is :
<testcase>
<title> case1 </title>
<testscript href="../testscript/testscript1" />
</testcase>
and testscript xml is
<testscript>
<title>testscript1</title>
<id>testscript1</id>
</testscript>
we need to upload the testscript first then testcase as testcase have a reference to testscript.
if you upload testcase first
the testcase xml will become.
<testcase>
<title> case1 </title>
</testcase>
---> <testscript href="../testscript/testscript1" /> will be lost.
Comments
Jerry Shengulette
JAZZ DEVELOPER Nov 15 '12, 9:53 a.m.Is this XML generated directly with Excel (Save as...) or with the Microsoft Excel and Word to Rational Quality Manager Import Utility?
Ara Masrof
JAZZ DEVELOPER Nov 15 '12, 10:20 a.m.Peter,
Peter Storey
Nov 15 '12, 10:44 a.m.Hi thanks for the responses,
The XML is created using the .cfg file and the import add in in excel.
I've only tried so far to import the files via the import options within RQM. Is it the correct process to first do this through Construction -> Import Test Case and then Construction -> Import Test Script?
(And yes - I am trying to write a cfg from scratch using the sample files :-) )
Ara Masrof
JAZZ DEVELOPER Nov 15 '12, 11:22 a.m.Using the samples provided by the tool as the basis for your specific needs is always a good approach; it will provide a sound baseline from which you can build from.