How to link a requirement to a tc using RQMExcelImporter
I have an excel spreadsheet with several rows each of which looks like:
rqm_name rqm_desc risk tc_name
(blank)
rqm_name2 rqm_desc2 risk tc_name2
(blank)
risk is a string "Low".
The 2 requirements get created and the 2 testcases get created but each testcase has both of the requirements specified and not just the 1 on the same line. I believe it is because of the last line of the cfg file:
-----------------------------------------------------------
// this configuration file creates requirements with testcases using self referential
// and column based data with categories
// Start looking for scripts after row 4
requirement.XLSStartRow=5
requirement.XLSWorksheetID="sandbox"
requirement.XLSDelimeter=\n
// a new script starts when we encounter an empty row
requirement.dc:title=D
requirement.dc:description=M
requirement.alm:owner="Tim McStraw"
//requirement.dc:creator="Tim McStraw"
requirement.risk="Low"
requirement.priority=J
//requirement.tags=I
// self referential links must be declared before also using column definitions
testcase.XLSStartRow=5
testcase.XLSWorksheetID="sandbox"
testcase.XLSDelimeter=\n
testcase.dc:title=L
testcase.dc:description=M
testcase.weight="100"
testcase.XLSLink=requirement
------------------------------------------------------------
since requirement probably defines both.
How do I just get the single requirement on the same line linked in. Also why is Risk set to unassigned?
rqm_name rqm_desc risk tc_name
(blank)
rqm_name2 rqm_desc2 risk tc_name2
(blank)
risk is a string "Low".
The 2 requirements get created and the 2 testcases get created but each testcase has both of the requirements specified and not just the 1 on the same line. I believe it is because of the last line of the cfg file:
-----------------------------------------------------------
// this configuration file creates requirements with testcases using self referential
// and column based data with categories
// Start looking for scripts after row 4
requirement.XLSStartRow=5
requirement.XLSWorksheetID="sandbox"
requirement.XLSDelimeter=\n
// a new script starts when we encounter an empty row
requirement.dc:title=D
requirement.dc:description=M
requirement.alm:owner="Tim McStraw"
//requirement.dc:creator="Tim McStraw"
requirement.risk="Low"
requirement.priority=J
//requirement.tags=I
// self referential links must be declared before also using column definitions
testcase.XLSStartRow=5
testcase.XLSWorksheetID="sandbox"
testcase.XLSDelimeter=\n
testcase.dc:title=L
testcase.dc:description=M
testcase.weight="100"
testcase.XLSLink=requirement
------------------------------------------------------------
since requirement probably defines both.
How do I just get the single requirement on the same line linked in. Also why is Risk set to unassigned?
2 answers
Well, I was wrong. The previous reply indicated the earlier article addressed the mechanism to do this. However, that is only valid for release 2.0.0.1. I am currently running 2.0.1.1 and when that is tried, an error message is displayed
Here is a portion of that error message. Either the Excel importer did not install the testcases correctly or else internal format is different. The test cases seem to be okay because they can be traversed normally.
Back to looking for a way to do this. Any ideas?
Dec 10, 2010 9:18:33 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Reading feed for artifact type: testcase
Dec 10, 2010 9:18:33 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Done reading feed for artifact type: testcase
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Starting: Test Case RQMT-5.xml
Dec 10, 2010 9:18:40 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
Dec 10, 2010 9:18:40 PM com.ibm.rqm.ct.util.Logger logError
SEVERE: RestException executing: PUT, RC: 400, message: <xml><ns2><ns2>400</ns2><ns2>The uploaded content does not match the XML schema for test
case</ns2><ns2>javax.xml.bind.UnmarshalException
- with linked exception:
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.createUnmarshalException(AbstractUnmarshallerImpl.java:315)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.createUnmarshalException(UnmarshallerImpl.java:502)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal0(UnmarshallerImpl.java:207)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal(UnmarshallerImpl.java:176)
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.unmarshal(AbstractUnmarshallerImpl.java:137)
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.unmarshal(AbstractUnmarshallerImpl.java:194)
at com.ibm.rqm.xml.service.internal.JAXBContextService.unmarshalReader(JAXBContextService.java:86)
Here is a portion of that error message. Either the Excel importer did not install the testcases correctly or else internal format is different. The test cases seem to be okay because they can be traversed normally.
Back to looking for a way to do this. Any ideas?
Dec 10, 2010 9:18:33 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Reading feed for artifact type: testcase
Dec 10, 2010 9:18:33 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Done reading feed for artifact type: testcase
Dec 10, 2010 9:18:33 PM com.ibm.rqm.ct.util.Logger logInfo
INFO: Starting: Test Case RQMT-5.xml
Dec 10, 2010 9:18:40 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
Dec 10, 2010 9:18:40 PM com.ibm.rqm.ct.util.Logger logError
SEVERE: RestException executing: PUT, RC: 400, message: <xml><ns2><ns2>400</ns2><ns2>The uploaded content does not match the XML schema for test
case</ns2><ns2>javax.xml.bind.UnmarshalException
- with linked exception:
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.createUnmarshalException(AbstractUnmarshallerImpl.java:315)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.createUnmarshalException(UnmarshallerImpl.java:502)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal0(UnmarshallerImpl.java:207)
at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal(UnmarshallerImpl.java:176)
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.unmarshal(AbstractUnmarshallerImpl.java:137)
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.unmarshal(AbstractUnmarshallerImpl.java:194)
at com.ibm.rqm.xml.service.internal.JAXBContextService.unmarshalReader(JAXBContextService.java:86)