Importing Operations from a CSV/excel file - any tools out there?

[johnks]

Does anyone know of a tool that would help me to import a list of operations. I have a CSV file containing nearly 2k operations that I need to import into the tool.

I see that I can get interfaces in using the Sparx CSV import. However, each of my interfaces has a set of operations. Getting these operations in (without crafting some XMI file from the CSV) is the challenge.

As a minimum just being able to import the operations list against a single interface element would be ok. I could then drag them to the correct interface manually.

The operations have name, description, stereotype,status and a single tag/value.

Many thanks for any help you could provide!

John

[Geert Bellekens]

Hi John,

Rodrigo once published an adaptation to my Excel importer that imports operations as well.

http://connection.rnascimento.com/2015/02/24/service-catalogue-importer-tool-sparx-ea/

That should at least give you a head start.

Geert

[johnks]

Looks exactly like what I want. 

Hmm.. getting a compile error when running the xls (your import tool and Rodrigo's) on my Mac Excel (15.22). Is this Windows only?

Compile error (Rodrigo's):

Can't find project or library
(ThisWorkbook 24:13)

[Geert Bellekens]

Seems logical. The Excel needs the EA.interlop.dll in order to communicate with EA.
And since EA isn't installed on your mac (natively) your Mac Excel won't be able to communicate with EA.

If you would try it on an windows excel in your wine/parallels I guess it would work.

Geert

[johnks]

Great - installed excel on Parallels/Windows and it works :-)

[johnks]

Geert/Rodrigo - the importer tool worked like a dream. I can't tell you how much pain this has saved!

Many, many thanks. I know there are a lot of people who really appreciate not only the advice, but the fact that you make these very handy tools available for free.

 

John