IBM Support

How to import Excel tables present as OLE objects into Rational Rhapsody Gateway

Question & Answer


Question

How do you import Excel tables present as OLE objects into IBM Rational Rhapsody Gateway?

Cause

Objective is to view Requirement tool data in Rational Rhapsody

Answer

Excel tables present as OLE objects in Rational DOORS can be imported into Rational Rhapsody Gateway as Images by applying the steps below:

  1. Launch Rational Rhapsody and load a project
  2. Open Rational Rhapsody Gateway via Tools > Open Rhapsody Gateway
  3. Navigate to the Types section in Rhapsody Gateway via File > Edit Types
  4. Expand the Analysis Type in use and ensure the Requirement section contains the Picture/Image tag <Picture>
  5. Navigate to the Project configuration section and select the Requirement document
  6. Ensure the variable Capture Diagrams of the Requirement document is set to checked
  7. Click OK
  8. Reload the Requirement document in the Rational Rhapsody Gateway main window
  9. Single-click each requirement and an image with the excel table will be displayed


Once the Excel table information is imported into Rational Rhapsody Gateway, it can further be transferred to Rational Rhapsody via the Add High Level Requirements function

[{"Product":{"code":"SSB2MU","label":"IBM Engineering Systems Design Rhapsody"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.6;7.6.0.1;7.6.1;7.6.1.1;7.6.1.2;7.6.1.3;8.0;8.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Rhapsody

Document Information

Modified date:
27 May 2022

UID

swg21622061