Topics

1

General Board / Package Control & making them unerasable

« on: August 19, 2022, 07:47:06 pm »

Hello friends,

I have a model created for reuse across various models called Elements-Library, and want this to be unerasable by all the people modelling. They should be able to import and use the elements from this library into their model packages and delete them from their whole model but never from Elements-Library,.

For example - In my EA project, I have two product models M1 & M2 (their diagrams & elements) in their respective packages P1 & P2 . I have another package just below the root node called Elements-Library, for keeping all the elements (classes) used in M1 & M2 models. How can delete elements only from model M1 without it getting deleted from model  M2 and Elements-Library packages? Is there a way to make my Elements-Library element unerasable and import its available elements into any other model?

Thank you.

Kind regards,
Oz

2

General Board / Configuring Visual Studio/Eclipse for EA scripting in Java/C++

« on: February 24, 2022, 11:23:26 pm »

Hi friends,

hope all is well. I have realised the default IDE, is really terrible for using script languages so can anyone provide some tips on the steps to configure a dedicated programming IDE like visual basic or eclipse so that I can write code to interact with the EA Repository/Model? Any language like C++, C# or Java would do.

Thanks,
Oz

3

General Board / using Javascript/VBscript to query/modify my Model

« on: February 21, 2022, 12:07:24 am »

Hi EA Users,

Hope all is well on your sides!

I am trying to get started using any programming language (VB, JavaScript, C++ or Java) to start developing more complex queries than SQL route offers and eventually to modify the model elements via this code. I think (not 100% certain) the class Repository and its's methods are central to developing any interacting code:
https://sparxsystems.com/enterprise_architect_user_guide/15.2/automation/repository3.html

Please, can someone guide me on how to get started here? @Geert had suggested using the "built-in scripting module" so towards this I tried consulting his webpage:
https://bellekens.com/2015/12/27/how-to-use-the-enterprise-architect-vbscript-library/
Here, I have downloaded his example code, and then got stuck on the next step of importin the code into EA: "After downloading the file select menu option Project|Data Management|Import Reference Data and choose the downloaded file. Make sure to select Automation scripts and click Import." I could not find in EA, the menu options stated here.

Please help me to write a basic Javascript or any other language code to query and modify my model.

Many thanks for your consideration.

Best,
Oz

4

General Board / Diagrams relocating issue - "Diagram frame(s) are currently being displayed"

« on: February 10, 2022, 09:01:35 am »

Hello EA users,

I have been searching for a good solution online to the problem of moving SysML diagrams. Every time I attempt it, I get the following annoying message:
"Diagram frame(s) are currently being displayed. Please disable them and save the diagram(s) before continuing."

I need to move 100s of diagrams so any help would be appreciated.
I need a solution where I can retain the diagram headers/frames which are required by the SysML language.

Thanks,
Oz

5

General Board / EA SQL search using [] brackets?

« on: February 08, 2022, 08:23:32 am »

Hello EA users,

I am trying to understand how the square brackets have  been using in the following bit of SQL code:
( t_object o
left join t_diagramobjects dob on dob.[Object_ID] = o.[Object_ID])

code is part of the Orphan search of elements by Geert:
https://bellekens.com/2015/10/16/searching-for-real-orphans-in-enterprise-architect/

What does the square bracket mean? Why is it used here?

Any tips or references to consult would be useful - thank you!

BR,
Oz

6

General Board / <<block>> definition stereotype & it's usage search

« on: February 05, 2022, 10:35:01 pm »

Hi Friends,

Hope all is well.

I need some idea on how to search for say a <<block A>> and it's usage location of which diagram it has been utilised in?

I know CTRL-u for a particular block on the diagram gives that information but how can this be done for all the block stereotypes of a model(s)/ package (recursively to include all subfolders) using SQL/JavaScript (or another)?

Thanks,
Oz

7

General Board / Making visible inherited parts in a block compartment

« on: February 04, 2022, 05:24:28 am »

Hi EA users,

I have a <<block>> C (child block or subtype) is specialised from a parent block or supertype <<block>> A. There is a part <<block>> B which is a part of <<block>> A. How can I show in the compartment of <<block>> C that it inherits <<block>> B as a part?

Thanks,
Oz

8

General Board / SQL Search within model - to find packages hierarchy of Diagrams (+ its GUID)

« on: January 27, 2022, 09:34:43 pm »

Hi EA Users,

I have had valuable input from Geert on package level search but I am stuck on modifying his script to:

• Get search results beyond 3 levels of packages
• Get the details of diagrams in each of those packages such as diagram name & it's GUID#

from (t_package p
inner join t_object o on o.Package_ID = p.Package_ID)
where
p.Package_ID = #Package#
union
select p.name as PackageName ,p2.Name as PackageLevel2,null as PackageLevel3
,o.ea_guid as CLASSGUID,o.Object_Type as CLASSTYPE,o.Name as Name,o.Stereotype
from ((t_package p
inner join t_package p2 on p2.Parent_ID = p.Package_ID)
inner join t_object o on o.Package_ID = p2.Package_ID)
where
p.Package_ID = #Package#
union
select p.name as PackageName ,p2.Name as PackageLevel2,p3.Name as PackageLevel3
,o.ea_guid as CLASSGUID,o.Object_Type as CLASSTYPE,o.Name as Name,o.Stereotype
from (((t_package p
inner join t_package p2 on p2.Parent_ID = p.Package_ID)
inner join t_package p3 on p3.Parent_ID = p2.Package_ID)
inner join t_object o on o.Package_ID = p3.Package_ID)
where
p.Package_ID = #Package#
order by 1, 2, 3

Any help to get me going would be really appreciated AND/OR if I could get an idea of the tables related to my model, how they are accessed, viewed and parsed using SQL it will be an even bigger help.

Thank you for your consideration.

Best,
Oz

9

General Board / Exporting model with package hierarchy to CSV file

« on: January 11, 2022, 08:17:13 pm »

Hi,

I have been able to export the model elements, guid, ...etc to a CSV format to view in Excel via Publish Ribbon > CSV import/export HOWEVER it does not export the hierarchy packages so that we have a clear view of what elements are within which package. During export in CSV exchange specification one can choose required fields but it does not include packages.

Any assistance on this front will be really appreciated. Thank you for your consideration.

Best regards,
Oz