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> ----------------------------------------------------------------------------------------------- |
One answer
Hi Dietmar,
are you using Excel Importer 3.0? |
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.