Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Geert Bellekens

Pages: [1] 2 3 ... 893
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
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 :-X)

Geert

3
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
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
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
Repository.ReloadPackage() is probably better then Repository.RefreshModelView()

Geert

9
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
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
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
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
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
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

Pages: [1] 2 3 ... 893