Import/Export Requirements to MS Excel/Access

[Don Dalton]

I am new to EA and I am investigating using EA on a development project.  

Currently I have a large set of requirements maintained in MS Access and would like to import them into EA.  In addition, once the realization relationships are created, I would like to export this information to Access (a path through Excel would be sufficient).

I looked over the help documentation and didn't find anything obvious.  Thanks for your help.

[gsparks]

Hi,

There is no current tool to automatically do this ... although I appreciate it is a common task, and maybe there is the need for a module to import objects from a comma separated file or similar.

Some import suggestions for now are (none of which are really simple):

The EA back end is a JET database - you can open it in MS Access and view the repository. It would be possible to write a script to populate the repository directly - BUT - you would need to invest some time in understanding what fields mean.

The XMI interface allows importing of new objects - if you examine the structure of an XMI file it would be possible to create additional elements for import. Again this would take some time to understand.

For exporting the same suggestions apply - you can get the information from the backend directly, or you could use the XMI export facility and use XSLT or a small scripting program to parse the XMI and extract the relevant fields.

Note that the relationship matrix has a simple 'export to CSV' option to export a list of objects, the relationship and the partner object - this may satisfy part of your request.

Hope this is of some interest,

Geoff Sparks

[PhilBoyd]

Would it be possible for Sparx to publish an EA model that we could look at to help understand these things?

[Philippe Back]

I second that requirement. For significant requirement work, we need XLS and Access exports...

And the doc is quite unclear on how to use the automation interfaces. I don't mind scripting them but I need some samples !!

[Steve_Straley]

Phillipe and Phil,

Are you trying to understand the format of the data and use the Jet Engine to pull out information or just want information on scripting to the EA interface?   The reason I'm asking is I'm trying to keep a data schema in sync with Geoff's/Paul's developments and I'm putting together a toolkit to extract out data within the tables... and extract out to CSV is one of format options.   I hope later on over the summer when a few more things get added to have the data schema in an ERwin model.

Anyway, would any of this be of help?

Steve

[Philippe Back]

Whatever you have will be nice !