Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: EA_enthusiast 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 (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
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 (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 (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 (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.
-
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
-
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 (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 (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?
-
100% correct
Geert
-
Thank you very much, Geert, for your confirmation :)
-
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.
-
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.
-
DeBAAT, I sent you a private message.
Ian, I will check out your website.
Thank you!