Author Topic: Bellekens EA Excel import-export to create tagged values  (Read 3013 times)

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Bellekens EA Excel import-export to create tagged values
« on: December 10, 2023, 12:40:42 pm »
Hello EA experts,

Part 1 of the question: how to import application attributes
I understand that the most suitable way to add the application attributes shown in the below screenshot is by creating tagged values.

https://ibb.co/ynq0FdL

 I also understand that Bellekens EA Excel import-export can be used for that purpose, however, one of my colleagues brought to my attention that on the tool web page, it was stated that

Quote
The Tagged Values sheet can only be used to edit existing tagged values, not for importing new tagged values into EA. It contains the following columns
https://ibb.co/k6PDnzL

In the same time, the script (in the tool) seems to indicate that creating tagged values is possible, as shown in the screenshot below:

https://ibb.co/qBfdKww

I would appreciate if you provide some guidance on how to import the application attributes using Bellekens EA Excel import-export tool.

Part 2 of the question: for each application, how to import multiple interfacing applications

As shown in the application attribute (first screenshot), one of the application is called "Advantage". As shown in the below screenshot, "Advantage" has multiple interfaces. How can we import the multiple interfaces for the application inventory?

https://ibb.co/NCq6H1L

I would appreciate if you provide some guidance on how to import the application interfaces using Bellekens EA Excel import-export tool.
Thank you to all the contributors who spread their knowledge and experience!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12996
  • Karma: +544/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Bellekens EA Excel import-export to create tagged values
« Reply #1 on: December 10, 2023, 08:10:24 pm »
You can export and import existing tagged values on elements using the standard impor/export.

In the example query there are a few tags included.

You can import interfaces as well, but you can't currently import the relation between your interfaces, and your applications.

Geert

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Bellekens EA Excel import-export to create tagged values
« Reply #2 on: December 11, 2023, 03:05:30 am »
Hello, Geert,

Thanks a lot for chiming in.

Please correct me if I am wrong. This is what I understood:

(1) I can use your Excel import-export tool to import applications (which do not exist in the model) with tagged values. I want to import the applications as ArchiMate_ApplicationComponenent. Please see the below screenshot and let me know whether I got this step correctly.

https://ibb.co/sQPt28g

(2) I can import the interfaces of the applications but I will have to manually create the relationships between the interfaces and the applications. If this is correct, is this how the interfaces can be imported as "ArchiMate_ApplicationInterface". Please note that the last 3 columns are tagged values for the interfaces (as seen in the below screenshot)

https://ibb.co/9vvqLH2

(3) After completing the importing process in step (1) and step (2), I should manually create a relationship between the application (from step 1) and its 3 interfaces (from step 2).

Did I get the process right?
Thank you to all the contributors who spread their knowledge and experience!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12996
  • Karma: +544/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Bellekens EA Excel import-export to create tagged values
« Reply #3 on: December 11, 2023, 04:29:39 pm »
100% correct

Geert

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Bellekens EA Excel import-export to create tagged values
« Reply #4 on: December 12, 2023, 04:19:01 am »
Thank you very much, Geert, for your confirmation  :)
Thank you to all the contributors who spread their knowledge and experience!

DeBAAT

  • EA User
  • **
  • Posts: 54
  • Karma: +2/-0
    • View Profile
Re: Bellekens EA Excel import-export to create tagged values
« Reply #5 on: December 12, 2023, 10:23:00 pm »
The process you described was correct and for me a bit cumbersome with lots of relations to create.
So I extended the tool from Geert to be able to import relations as well.
If you are interested, I can mail you my version.
Please note it is not that thoroughly tested as I would like.

Ian Mitchell

  • EA User
  • **
  • Posts: 506
  • Karma: +22/-4
  • The eaDocX and Model Expert guy
    • View Profile
Re: Bellekens EA Excel import-export to create tagged values
« Reply #6 on: December 15, 2023, 09:30:22 pm »
Interest: I'm the author of this tool.

The eaSheets bit of eaTeamWorks can do this - import the element, and relationships of the element. See the eaTeamWorks website.
Ian Mitchell, Designer, eaDocX


www.eaDocX.com
www.theartfulmodeller.com

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Bellekens EA Excel import-export to create tagged values
« Reply #7 on: January 03, 2024, 03:42:27 pm »
DeBAAT, I sent you a private message.
Ian, I will check out your website.

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