Import of requirements from Excel file
Can we import requirements from excel using Excel Import Add ins into RQM projects ? If so, what are the lines we need to incorporate into our Configuration file to enable the requirements import.
Thanks in advance. Regards, Sandy |
5 answers
Yes (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Resources).
There are several examples (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration). |
Yes (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Resources). Thanks for your assistance. But the links above does not contain the specific information which I am searching. Anyone else can throw any light on this? |
There are several sample configuration files to guide you:
Requirements 001 using document properties.cfg Requirements 001 with dynamic directive setting.cfg Requirements 001.cfg TestPlan with TestCases 001 linked to requirement 001.cfg |
I tried those samples provided to import requirements, but they all failed. The error in the debug log is:
9/22/2011 1:44:47 PM: ERROR: : RQMConnector: PutToServer - Error putting resource: https://rqm3.au.com:9443/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Test%2bLifecycle%2bProject%2b%2528Quality%2bManagement%2529/requirement/ID.02 What does it mean? I thought requirement in RQM 3 is using different API, thus it failed. Correct? There are several sample configuration files to guide you: |
A couple of comments:
-The debug log is missing some detail (see https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/55185). See https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Troubleshooting to determine the root cause. -Note, http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/topic/com.ibm.rational.test.qm.doc/topics/t_manage_reqs_rm.html. -Note, https://jazz.net/wiki/bin/view/Main/RqmApi#Resources_and_their_Supported_Op. |
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.