Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Irene on January 19, 2005, 12:04:22 am

Title: Requirements Export to Excel CSV
Post by: Irene on January 19, 2005, 12:04:22 am

We look for a simple way to export reqirements to Excel CSV, so that the list of requirements can easily be presented to a project steering committee. Decision makers always would like to see summaries  ;). Using the Excel-csv-Specifications we could only export the details of our use cases and activities, but not the requirements attached to them. Using the new Raquest Tool did also not work properly. Does anyone have a solution for that? Thanks in forward.

Title: Re: Requirements Export to Excel CSV
Post by: thomaskilian on January 19, 2005, 01:36:54 am

You can import external data to Excel using the MS Access driver from an ODBC source. Connect to the EA repository (make sure to search for *.* since .EAP are nothing else than MS Access files).  Use something like the following to show Requirements and objects connected to the requirement

SELECT t_connector.Connector_ID, t_connector.Name, t_connector.Direction, t_connector.Notes, t_connector.SourceAccess, t_connector.DestAccess, t_connector.Btm_Mid_Label, t_connector.Stereotype, t_connector.Start_Object_ID, t_object.Name, t_connector.End_Object_ID, t_object_1.Name
FROM t_connector t_connector, t_object t_object, t_object t_object_1
WHERE t_connector.Start_Object_ID = t_object.Object_ID AND t_connector.End_Object_ID = t_object_1.Object_ID AND ((t_connector.Connector_Type='Realisation') AND (t_object_1.Object_Type='Requirement'))

Use MSQRY32 to edit the contents appropriately

Title: Re: Requirements Export to Excel CSV
Post by: Irene on January 19, 2005, 06:38:45 am

Thank you very much for answering. Your recommendation was of great use for us. My collegue managed to export all data to Excel we were looking for. He used the following statement:

SELECT q_object.PackageName, q_object.Object_Type, q_object.Name, t_objectrequires.Requirement, t_objectrequires.Status, t_objectrequires.Priority, t_objectrequires.Difficulty, t_objectrequires.Stability, q_object.Note, t_objectrequires.Notes, t_objectrequires.LastUpdate, q_object.Stereotype, t_objectrequires.ReqID, q_object.Object_ID, t_objectrequires.Object_ID
FROM q_object q_object, t_objectrequires t_objectrequires
WHERE q_object.Object_ID = t_objectrequires.Object_ID