Sparx Systems Forum

Discussion => General Board => Topic started by: alazarou on November 30, 2017, 11:33:22 am

Title: Importing Elements & Associated Attributes & Links (Using CSV or API Method)
Post by: alazarou on November 30, 2017, 11:33:22 am
Hi,
I am looking for source code that can do the following:

Add/Modify Elements & associated Attributes & Links specifying the following (non-default values):
 o Element Name
 o Element Type
 o Element Stereotype
 o Element Description (Main Body)
 o Element Attributes
Title: Re: Importing Elements & Associated Attributes & Links (Using CSV or API Method)
Post by: EAUser3200 on November 30, 2017, 02:28:45 pm
Hi Andrew

You can import \modify objects in EA using MDG Office Suite(It's available with EA Ultimate Edition by default).

Using this tool you can import\Update elements from both word and excel files.

https://sparxsystems.com.au/products/mdg/int/office/office-integration.html
Title: Re: Importing Elements & Associated Attributes & Links (Using CSV or API Method)
Post by: Geert Bellekens on November 30, 2017, 04:27:41 pm
Hi Andrew,

I have since long published a simple Excel importer on my website (https://bellekens.com/2015/10/24/simple-vba-excel-to-ea-importer-v4/)
This Excel file uses VBA to import elements and attributes into Enterprise Architect.

It does what I need it to do, and I sometimes update it with new features if/when the need arises.
You can download it and use it as a starting point for your tooling.

I know other people have extended it for their own use with capabilities such as
- importing more fields
- Importing operations
- Importing connectors

If you would like me to build something for you, we can organize a call and discuss details.
I could build something in Excel VBA, or use EA scripting engine, or do something in C# as well, depending on your needs.

Geert
Title: Re: Importing Elements & Associated Attributes & Links (Using CSV or API Method)
Post by: alazarou on December 02, 2017, 09:01:38 pm
Thanks Both.

I am in the process of using Geert's VBA spreadsheet for importing elements and associated attributes.

The final bit of code I am looking for is to import source/target element connectors.

Geert mentioned someone may have extended their spreadsheet to cater for this but was unsure of the outcome?

Is there anyone on the forum aware of this being done?

Thanks, Andrew
Title: Re: Importing Elements & Associated Attributes & Links (Using CSV or API Method)
Post by: qwerty on December 03, 2017, 09:11:43 am
I also seem to remember some post about that. If you're bored over the weekend (and likely few will read here anyway then) you can try to search the forum. Good luck with that and have a beer while fiddling with the search.

q.