It's all about the answers!

Ask a question

How to connect ReqPro -reqiremts at Excel-Import?


Diet Wolf (113) | asked Dec 12 '11, 4:30 a.m.
Hello,

I'm able to import Testcases and remotetestscripts by Excel config file in a RQM - playground project.

The next step is to connect the testcases with the (reqPro)- requirements.

unfortuatly I get the error

12/12/2011 10:15:22 AM:
--------------------------------------------------------------------------------
12/12/2011 10:15:22 AM:
SESSION: 12/12/2011 10:15:22 AM

12/12/2011 10:15:22 AM: Getting artifacts from current document Temp_Output_for_RQM.xls
12/12/2011 10:15:22 AM: Created 3 artifacts, sending to server
12/12/2011 10:15:22 AM: sending requirement0 named Temp_Output_for_RQM_Sheet1.xml
12/12/2011 10:15:22 AM: Error sending to server Temp_Output_for_RQM_Sheet1.xml of type requirement
12/12/2011 10:15:22 AM: sending remotescript1 named 131_TSPEC0001_001Man_CheckDragMeasureValue
12/12/2011 10:15:23 AM: Server returned code OK
12/12/2011 10:15:23 AM: sending testcase2 named 131_TSPEC0001_001Man_CheckDragMeasureValue
12/12/2011 10:15:25 AM: Server returned code OK
12/12/2011 10:15:25 AM: finished writing artifacts
_____________________________________________________


The config-file:
// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data


// Start looking for scripts after row 2
remotescript.XLSStartRow=2


remotescript.XLSArtifactID=A
remotescript.dc:title=A
remotescript.dc:description=B
remotescript.type="RQM-KEY-CMD-APTR-TYPE-NAME"
remotescript.arguments=F
remotescript.command=D
remotescript.manageadapter="true"


// a new script starts when we encounter an empty row
remotescript.XLSDelimeter=\n

// we want to use the data we got for each test script to create a test case
testcase.ID=remotescript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=remotescript.dc:title
testcase.dc:description=remotescript.dc:description
testcase.category term="Testcase_Classification".value=C


requirement.dc:title="Dummy Req Title"
requirement.dc:description="Dummy Req Descr"
requirement.reqProId="2479"
requirement.reqProProject="15000131 ToF ES Plattform"

There is only one testcase and testscript, so there also only one requirement entry, for testuses only.


The according XML-output (GET) of the manually created testcase / requirement connection is:
------------------------------------------------------------------------
<xml>
- <testcase>
<projectArea>
<ns3>https://pcmnt156.pcm.endress.com:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/ToF_ES/testcase/urn:com.ibm.rqm:testcase:4472</ns3>
<webId>4472</webId>
<ns3>First_T_Case_with_R893</ns3>
<ns3>
<creationDate>2011-12-12T07:03:03.701Z</creationDate>
<ns4>2011-12-12T07:03:08.873Z</ns4>
<ns4>com.ibm.rqm.planning.common.new</ns4>
<ns3>dwolf</ns3>
<ns4>nicht zugeordnet</ns4>
<weight>100</weight>
<category>
<category>
<category>
<category>
<variables>
<template>
<requirement>
<regressionTest>false</regressionTest>
- <com>
- <div>
<div>[]</div>
</div>
</com>
</testcase>
-----------------------------------------------------------------------------------------------

One answer



permanent link
Hao Wan (1.5k35) | answered Aug 02 '12, 5:28 a.m.
JAZZ DEVELOPER
Hi Dietmar,
are you using Excel Importer 3.0?

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.