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