It's all about the answers!

Ask a question

Import of requirements from Excel file


Sandipq Mukhopadhyay (1666) | asked Sep 18 '11, 12:53 a.m.
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



permanent link
Paul Slauenwhite (8.4k12) | answered Sep 19 '11, 9:32 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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).

permanent link
Sandipq Mukhopadhyay (1666) | answered Sep 19 '11, 11:38 p.m.
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).



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?

permanent link
Paul Slauenwhite (8.4k12) | answered Sep 20 '11, 8:20 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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

permanent link
Yaqian Fang (2013223) | answered Sep 21 '11, 11:58 p.m.
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

9/22/2011 1:44:47 PM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.

9/22/2011 1:44:47 PM: at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)


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:

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

permanent link
Paul Slauenwhite (8.4k12) | answered Sep 22 '11, 1:47 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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


Register or 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.