Description
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
For more info see EA Excel Importer-Export
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.
- Export and import formatted notes (limited to bold, italic and underline)
- Import and export any tagged values you define on elements and attributes.
David McGuffin (verified owner) –
Thank you for producing this useful resource. I have used your Simple VBA Excel to EA importer before. Are you planning on creating any instructions on how to use this new tool?
Geert Bellekens –
Hi David,
I’m glad you like it. I’ve written some basic instructions here: https://bellekens.com/ea-excel-import-export/
I’ll update the product to include this link.
Geert
Mo (verified owner) –
Thank you, Geert. This is a great tool!
It became an integral part of my interaction with EA.
Sylvain –
Hi Geert,
Thank you for this tool. It is working as expected on EA 13. I’m starting to migrate to EA15.2 so I’m testing my previous scripts/add-in before… Unfortunatelly, the EA Excel Import-Export is not working anymore : “execution error 429, an ActiveX component can not create an object” : Set parentPackage = eaConn.getSelectedPackage(); Did someone have the same issue ?
Geert Bellekens –
You might need to re-link EA’s API using the references in the VBA editor
Sylvain –
Hi Geert, Thank you for the answer., but what to you mean by re-link EA’s API ? Checking that operations/functions did not change between the two versions ?
Concretely, the execution error is here :
Dim EAapp As EA.App
Dim EArepository As EA.Repository
On Error Resume Next
Set EAapp = GetObject(, “EA.App”)
in VBA, references are enabled, I have access to all the EA functions/object pressing F2…
I removed all previous references in the registry, performed a fresh installation, still not working with version 15.2.
A have a copy of the EA 13.5’s folder before the upgrade to 15.2, just launching the ea.exe and using the toolbox/dll from the 15.2 and it works !
Just testing Sparx example doesn’t work… so I opened an issue…
Geert Bellekens –
Go to the VBA editor (Alt-11) and then Tools | References and make sure the Enterprise Architect Object Model is checked. Possibly uncheck it and check it again.