Author Topic: Import columns from Excel to EA as attributes  (Read 8253 times)

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Import columns from Excel to EA as attributes
« on: December 09, 2020, 01:58:42 pm »
Hello, EA Experts,

I managed to import the below Excel table

https://ibb.co/qWY3q8q

But I need help to import columns A and B as attributes, please see below:

https://ibb.co/sqhP5sc

Thank you!
Mo

Thank you to all the contributors who spread their knowledge and experience!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13295
  • Karma: +557/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Import columns from Excel to EA as attributes
« Reply #1 on: December 09, 2020, 03:58:46 pm »
Check out the excel importer tool I wrote.
That imports attributes as well.

https://bellekens.com/ea-excel-import-export/

Geert

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Import columns from Excel to EA as attributes
« Reply #2 on: December 10, 2020, 03:47:47 am »
Thank you, Geert for sharing the excel importer tool. I will try it.

I am just curious to know whether I can achieve what I wanted through EA?
Thank you to all the contributors who spread their knowledge and experience!

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Import columns from Excel to EA as attributes
« Reply #3 on: December 26, 2020, 05:38:24 pm »
I used your tool Geert and it worked perfectly to import several enumerations with several attributes. I could not manage to import Data Type through. I ended up adding them manually. I am looking forward to using your tool in other use cases.

Thank you so much!

Mo
Thank you to all the contributors who spread their knowledge and experience!