Author Topic: Import 300+ application profiles from Excel to EA  (Read 387 times)

EA_enthusiast

  • EA User
  • **
  • Posts: 169
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Import 300+ application profiles from Excel to EA
« 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.



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!
Thank you to all the contributors who spread their knowledge and experience!

Hurra

  • EA User
  • **
  • Posts: 183
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Import 300+ application profiles from Excel to EA
« Reply #1 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.
always learning!

ea0522

  • EA User
  • **
  • Posts: 50
  • Karma: +1/-0
    • View Profile
Re: Import 300+ application profiles from Excel to EA
« Reply #2 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/ for more information.

EA_enthusiast

  • EA User
  • **
  • Posts: 169
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Import 300+ application profiles from Excel to EA
« Reply #3 on: November 17, 2023, 11:33:48 am »
Thank you, ea0522 and Hurra for your advice.
Thank you to all the contributors who spread their knowledge and experience!