Example on how to install Requirements Viewpoint, and how to import requirements from an Excel

Hello.

I would be very grateful if you could tell me how to install Requirements Viewpoint. In order to facilitate the connection between the two tools Capella and Excel, to be able to import the requirements in Capella from an Excel file.

best regards
Meziane HACHEMI

The general installation procedure is here, you’ll see the addon section just below: https://wiki.eclipse.org/Capella/Extensions/Installation_Guide#Installation_Procedures

Right now it is not possible to import Requirements from an excel file. What we support is import from a ReqIF file. There is probably a way to use groovy for Capella to import Requirements from an Excel file, but I have not tried it so I can’t help you, see this post: https://forum.mbse-capella.org/t/1104421/

It is probably now possible/easier to import requirements using an excel file using Python for Capella…

The easiest way to import requirements from an Excel file is the use of pyreqif, which enables the conversion to ReqIF. Some care should be taken in the column naming to match ReqIF standards. As an example the requirement identifier column header should be “IE PUID”. Using Python4Capella I am currently able to export requirements from Capella straight to Excel.

Seems great! Could you please share the script you made?

Hi Juan,
I made some modifications to the simplified API requirement.py, adding the implementation of some classes and getters/setters.
More in details, the following classes have been implemented:

  • Attribute
  • ReqIFElement
  • AbstractRelation
  • CapellaIncomingRelation
  • CapellaOutgoingRelation
  • AbstractType
  • RelationType

The script for exporting requirements to Excel partially depends upon those modifications.
Please find attached the updated requirement.py and the export to Excel script. Some tuning to generalize the export script is needed.

Export_Requirements_to_xlsx.py (7.8 KB)
requirement.py (8.4 KB)

Pier Giorgio

Hello @pge62
Thank you for your contribution to Python4Capella :slight_smile: