Import of requirements from Excel file

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

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?

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

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

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.