Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: EA_enthusiast on November 16, 2023, 02:48:16 pm

Title: Import 300+ application profiles from Excel to EA
Post by: EA_enthusiast on November 16, 2023, 02:48:16 pm

Hello, EA experts,

I need your advice on the right approach to import 300+ application profiles from Excel to EA. The first few records are shown in the screenshot below.

(https://i.ibb.co/0c9zhr9/App-profile.png)

This Excel spreadsheet is an export from another architecture tool. You will notice that the GUID is available in the first column.

Thank you so much in advance!

Title: Re: Import 300+ application profiles from Excel to EA
Post by: Hurra on November 16, 2023, 08:30:58 pm

I would script a custom csv import, using the csv's guid as some kind of external id. I would let EA create the element, thus give it a new guid. The other fields I would save either as existent standard-fields, like 'Application' would probably be name, and 'Criticality' a tagged value.

Title: Re: Import 300+ application profiles from Excel to EA
Post by: ea0522 on November 16, 2023, 10:55:48 pm

For this kind of imports, I usually use the Excel tool from Geert Bellekens.
See https://bellekens.com/ea-excel-import-export/ (https://bellekens.com/ea-excel-import-export/) for more information.

Title: Re: Import 300+ application profiles from Excel to EA
Post by: EA_enthusiast on November 17, 2023, 11:33:48 am

Thank you, ea0522 and Hurra for your advice.