Author Topic: Importing Elements & Associated Attributes & Links (Using CSV or API Method)  (Read 2027 times)


  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
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
    o Element Links to other Elements
      specifying the following:
       * Direction
       * Link Type
       * Link Stereotype

      Does anyone know whether there is any code/APIs that can cater for the above (i.e. a complete Element creation including default, non-default and generated values) and specify the format of the data we need to interface with the code/APIs?

       Capgemini Solutions Architect


  • EA User
  • **
  • Posts: 201
  • Karma: +14/-1
    • View Profile
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.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 10129
  • Karma: +326/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Hi Andrew,

I have since long published a simple Excel importer on my website
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.



  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
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


  • EA Guru
  • *****
  • Posts: 11121
  • Karma: +262/-246
  • I'm no guru at all
    • View Profile
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.