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

How to connect ReqPro -reqiremts at Excel-Import?

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>
-----------------------------------------------------------------------------------------------

0 votes



One answer

Permanent link
Hi Dietmar,
are you using Excel Importer 3.0?

0 votes

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: Dec 12 '11, 4:30 a.m.

Question was seen: 4,461 times

Last updated: Aug 02 '12, 5:28 a.m.

Confirmation Cancel Confirm