Requirement management and Excel

[NG]

I'm starting a new project and want to do my requirement management with Enterprise Architect.

It look really nice to define requirements, associate use cases, design elements, test and so on, all in one software.

I succeeded in creating a profile that let met drag custom requirement with predefined tagged value for enterprise stuff.

My problem is that the requirements must be manage at 3 level. The team, the management and the client. The management and the client both communicate with Excel.

My question is, it is possible to do something like: - Create requirements diagram in EA with predefined tag value - Export requirements in Excel (with predefined tag value) - I haven't been able to export my predefined tagged value. - Modify the excel file - Import from excel and update the requirements in EA.

[AndyJ]

You can export your requirements as .csv

When you create the export specification, there is a button under the "Available Fields" dialog which allows you to add tagged values.

Any tagged values that you have created, may be selected by that button.

Once you've exported requirements, you can open the csv in Excel and see the format for importing...

Make sure that you include the GUID in your export, so that imports update your existing requirements.

I'm using this process for moving requirements in and out of JIRA, (but may have access to JIRA-connect in the near future).

[Geert Bellekens]

If the standard export/import doesn't suit you, you can quite easily write your own export/import.
see http://community.sparxsystems.com/resources/scripts/simple-vba-excel-ea-importer for an excel import example.

Geert