IBM Support

Linking new test cases to existing test plans using the RQM Excel Importer

Technote (FAQ)


Is it possible to Link new Test Cases to Existing Test Plans using the MSO2RQM Microsoft Excel and Word Import Utilities?


Yes, this is possible.

The caveat of linking new Test Cases to an existing Test Plan is that the Test Plan is the parent of the Test Case, and therefore contains the link.

It is also necessary not only to import the new Test Cases from Microsoft Excel to IBM Rational Quality Manager (RQM) but also to update the existing Test Plans XML to include a link to these Test Cases.
If you try to link TestCases to an existing Test Plan that already has some links to existing Test Cases and are using a version earlier than 4.0.1, the existing links get replaced with the newly created ones. So you must include the existing.

The sample syntax below must be implemented in the CFG file to accomplish this link.

In the above example, represents a valid internal or external ID of an existing Test Plan.

See the following work item for more information about the change in 4.0.1:

WARNING: The ability to update specific fields is not consistent across all test assets. A normal REST implementation will overwrite all fields in the existing test asset, and replace them with the fields provided in the import. The concepts in this technote have been validated to work against Test Plans, but users should test and verify this behavior before using it on production data. Failure to do so could result in the tool overwriting existing test assets.

Leverage the Jazz Community

The Jazz based products have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Document information

More support for: Rational Quality Manager
RQM Server

Software version: 3.0.1,,,,,,, 4.0,,, 4.0.1, 4.0.2, 4.0.3, 4.0.4, 4.0.5

Operating system(s): Windows

Reference #: 1589309

Modified date: 14 October 2017

Translate this page: