Posts

Simple VBA Excel to EA importer v4.2

,

Version 4.2 of the Excel to EA Importer now introduces a new GUI to follow the progress of the import, and a massive increase in performance.

The Excel to EA importer is a rather simple tool to import stuff into EA. It has been available on the Sparx Community Site since 2009 and it has always been one of the most popular resources.

Version 2 was a small improvement allowing for different types of Elements.

Version 3 added the feature to import the glossary into EA.… Read more

/8 Comments/by

Simple VBA Excel to EA importer v4

Version 4 on the Excel to EA Importer now introduces a feature to export Tagged Values to Excel, edit them in Excel and import the changes back into Enterprise Architect.

The Excel to EA importer is a rather simple tool to import stuff into EA. It has been available on the Sparx Community Site since 2009 and it has always been one of the most popular resources.

Version 2 was a small improvement allowing for different types of Elements.

Version 3 added the feature to import the glossary into EA.… Read more

/30 Comments/by

Simple VBA Excel to EA importer v3

 

There is an updated version available. Check out Excel to EA Importer v4

The Excel to EA importer is a rather simple tool to import stuff into EA.

It has been available on the Sparx Community Site since 2009 and it has always been one of the most popular resources.

Version 2 was a small improvement allowing for different types of Elements.

In version 3, thanks to the kind help of Paulus, I’ve now added a new function in order to import Glossary Terms.… Read more

/0 Comments/by

Simple VBA Excel to EA importer v2

There is an updated version available. Check out EA Excel Importer V4

The Excel to EA importer is a rather simple tool to import stuff into EA.

It has been available on the Sparx Community Site since 2009 and it has always been one of the most popular resources.

Now I decided to improve it a little bit and publish version 2.

Download

Download the excel file here: EAExcelImporter_v2

Usage

Columns A till F are used in the sheet. Fill in the the columns with your own data.… Read more

/25 Comments/by

Pages

EA Excel import-export

The EA Excel import-export tool can be used to export and import between Sparx Enterprise Architect and Excel. Using only an Excel file, and the built in macro’s you can use it to

  • Export and Import element and attribute data (including tagged values on elements and attributes)
  • Import the Glossary
  • Export and Import tagged values

Version 5.0

Version 5.0 adds a complete new import and export feature for elements and attributes.

  • Configure exactly what you would like to export using an SQL Query
  • Use GUID’s of elements and attributes to update items regardless of their location in the model
  • Define whether to create, update, or delete items using the Action column
  • Specify a datatypes package and link attribute types with the datatypes in the datatype package
  • Support for a lot more fields such as alias, version, status, initial value etc.
… Read more
/21 Comments/by