You can import test artifacts from Microsoft Word or Microsoft Excel into an Engineering Test Management repository by using the IBM® Engineering Test Management Word/Excel Importer Utility,
earlier known as RQMExcelWordImporter.
Before you begin
The export utility must be installed as an add-in to Word or Excel. You must create a
configuration file that describes the artifact for the export utility. For more information about
utility installation and configuration, see the wiki
page.
Procedure
-
In Word or Excel, from the menu bar, click .
-
Enter the server information and your user credentials.
-
From the Project list, select the Engineering Test Management project. Depending
on your credentials, the list might take a long time to be displayed. The projects that are listed
are based on your username and the projects that you participate in.
-
Specify which document to import:
- To export only the document that is open in Word or Excel, click Active
Document.
- To specify multiple documents to export, click Other Documents, and
then add the documents to export.
-
In the Artifact Details field, choose a mapping file. This file
describes the content of the file to be exported. It is required for the export utility to decipher
the contents of the document.
- Optional:
In version 4.0.1 and later of the export utility, you can link exported test artifacts to
requirement artifacts on a Engineering Requirements Management DOORS® server. To enable linking between test
artifacts and requirement artifacts, select the Link to existing RM
requirement checkbox.
-
Start the export process by clicking Export. The selected artifacts are
converted into XML and are sent over an HTTP connection to the Engineering Test Management
server.
- Optional:
If requirement artifacts are being exported, or if you plan to link requirement artifacts to
the exported test artifacts, the RM Login Information window opens. To link
artifacts, do these steps:
-
Specify the settings for linking artifacts:
- From the Linked RM Project list, select the requirements management
project. This list includes projects that are linked to the Engineering Test Management project.
Tip: The RM Server field is read-only because the selected requirements
management project specifies the server URL.
- Enter your user credentials for the RM server.
- Click Export. If no linked RM project areas are available, this message
is displayed: No RM Projects Linked. No Requirement would be exported. Would you like
to continue with partial export?
- To cancel the export process, click No. To export artifacts other than
requirements, click Yes.
Important: If you click
Yes, no test artifacts are linked to requirement artifacts.
When you
link exported test artifacts to requirement artifacts, the Requirement Links
window opens. Test artifacts populate one column, while requirement artifacts populate the other
column. To search for requirement artifacts by ID or text, use the filter at one end. To toggle the
display of requirements and requirement collections, use the boxes that are under the
filter.
-
Link the artifacts:
- To link a test artifact to one or more requirement artifacts, select those artifacts and click
Add.
Restriction: You cannot associate requirements with test
plans or requirement collections with test cases.
- After the artifacts are associated, when you select a test artifact, the corresponding
requirement artifacts are displayed in the Linked RM requirement artifact
section.
- To remove an associated requirement artifact from a test artifact, in the Linked RM
requirement artifact section, select the artifact and then click
Remove.