Messages

1

General Board / Re: Can no longer post SQL Statements to this forum

« on: July 04, 2025, 11:49:03 pm »

I've already sent a message about it to [email protected]

I suspect it's some sort of half-assed sql injection "protection".

Geert

2

General Board / Re: Getting error of Remote Procedure Failed when trying to Save EA Diagram to File

« on: July 04, 2025, 08:01:32 pm »

I have validated following:

1. GUID is correct, before saving image diagram to file, I am fetching entity before to validate entity is not deleted.

Yes, but is it in the correct format? Most operations on the project interface require the guid to be in xml format, which is different from the format used by rest of the API. See https://sparxsystems.com/enterprise_architect_user_guide/17.1/add-ins___scripting/project_2.html

(Don't ask for my opinion on that )

Geert

3

General Board / Re: Getting error of Remote Procedure Failed when trying to Save EA Diagram to File

« on: July 04, 2025, 05:45:38 pm »

might be a problem with the parameters. Either the guid is not in the correct format, or there is something wrong with the filepath... (file in use, directory not existing,...)

Geert

4

Automation Interface, Add-Ins and Tools / Re: No values using reporttemplate

« on: June 30, 2025, 07:55:06 pm »

Have you checked the filters in the template properties? If it contains filters that use BPMN stereotypes, then your custom stereotypes might not show up.

Geert

5

Bugs and Issues / Re: Bug in export to XMI: SQL API Open FAILED with error -- Images

« on: June 28, 2025, 01:58:03 am »

Hmm, SQL Injection anyone?

Geert

6

Automation Interface, Add-Ins and Tools / Re: Session.Prompt Dialog

« on: June 26, 2025, 09:35:25 pm »

Oh, yeah, I had my share of "pop-under" dialogs that make it look like EA is not responding.

I sometimes feel like it happens more with Remote Desktop installation (running as published app) then with local EA installations.

Geert

7

PCS Frequently Asked Questions / Re: Migration - qeax file to PCS

« on: June 18, 2025, 03:39:45 am »

Yes, it is that simple.
Project transfer doesn't care about root nodes and stuff. It simply copies tables from one DB to another.

Geert

PS. You are not really transferring to PCS. PCS is only an access layer. You could even link PCS to your existing .qeax file (although I wouldn't recommend that)

8

Automation Interface, Add-Ins and Tools / Re: Move multiple items into current package

« on: June 17, 2025, 11:43:11 pm »

Repository.ReloadPackage() is probably better then Repository.RefreshModelView()

Geert

9

General Board / Re: Bring move all diagram elements to the same package

« on: June 16, 2025, 04:10:58 pm »

Write a little script that moves the elements based on the rules you set.

Should only be a few hours of work for an experienced script writer to write and test such a script.

Geert

10

General Board / Re: How to produce a product breakdown structure in a table

« on: June 13, 2025, 11:23:56 pm »

I'll give that a go and see what happens

I like the recursive query because I don't have to guess how many levels I will have and I can use it on any object at any level without having to modify it, it's just the output isn't the way I want it 

I understand. Maybe this output is possible with recursive queries as well, but I don't have enough experience with those (they tend to hurt my head when I try to use them)

Geert

11

Automation Interface, Add-Ins and Tools / Re: MDG technology: reverse engineer from XML

« on: June 13, 2025, 09:29:01 pm »

Me too

I found myself recently trying to recreate a UML profile model from a profile xml thinking: this would be some much easier if I simply automated this.
Doesn't even look that complex.

Geert

12

General Board / Re: How to produce a product breakdown structure in a table

« on: June 13, 2025, 08:41:17 pm »

Suppose I have the following structure

package1
          - Package1.1
                     - Element1.1.1
                     - Element1.1.2
          - Package1.2
package2

I would make a query that contains a field with the fully qualified name of each element

package1
package1.Package1.1
package1.Package1.1.Element1.1.1
package1.Package1.1.Element1.1.2
package1.Package1.2
package2
And sort on that field.

Geert

13

General Board / Re: How to produce a product breakdown structure in a table

« on: June 13, 2025, 04:43:00 pm »

With a query you should be able to do that.

I usually don't use a recursive query, but instead opt for a "fixed" query with enough levels.
That allows you to keep track of the "fully qualified name" to use as the order by field.

Geert

14

General Board / Re: Generate Documentation - Exclude Filters

« on: June 12, 2025, 10:32:12 pm »

I'm not sure what the issue is you are having, but this has always worked for me.

Geert

15

Automation Interface, Add-Ins and Tools / Re: Get/check all stereotypes via SQL Query?

« on: June 12, 2025, 10:25:26 pm »

Hi all,

using the EA API there is an attribute called StereotypeEx that includes all Stereotypes of a given EA.Element as a comma separated list in a string.
I need to check for a certain Stereotype via SQL Query but the t_object obj.Stereotype only returns the first being set in model. How can I fetch (or better check) the other ones via SQL?

Thank you very much for any hint!

Best regards,
Daiim

Full stereotype info is stored in t_xref

Geert