Recent Posts

11

General Board / Re: Fragments and SQL

« Last post by Geert Bellekens on September 03, 2025, 08:50:03 pm »

My crystal ball is in the shop currently, so I can't really help you if you don't share the details.

- What is the SQL you are using in the fragment?
- which ones work?
- which ones don't work?
- what does "don't work" mean?

Details, details details...

Geert

12

Automation Interface, Add-Ins and Tools / Re: SaveDiagram performance V17.1 compared to V16.1

« Last post by Geert Bellekens on September 03, 2025, 04:12:19 pm »

I just did a small test with the script, and I see no meaningfull difference between v16 and v17

Both saved my diagram in about 100 to 150 ms

I'm on a local SQL Server repo

Geert

13

General Board / Fragments and SQL

« Last post by EAButNotForGames on September 03, 2025, 03:24:10 pm »

Got a small problem with the Fragments
I want to count elements with a specific tagged value via a sql search and post the result into a report.
This works for some but not for all, even though, if I test the sql in "Find in Project" it works.

Has anyone an idea? 

14

Automation Interface, Add-Ins and Tools / Re: SaveDiagram performance V17.1 compared to V16.1

« Last post by Takeshi K on September 03, 2025, 08:57:30 am »

Hi OJB,

I guess that the new snapshot feature might cause the delay. The feature saves diagram image for every saving attempt. If you enable the automatic snapshot creation feature, EA will save the image to the project. Even if not, EA generates the image of the diagram (and stores it in the memory) so it might take some time to create the image.

HTH,

15

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

« Last post by Elpis on September 03, 2025, 02:12:01 am »

I uploaded the Addin to GitHub:
https://github.com/shimonj/ModelAddinStarter

Error 404. Is the URL correct? Have you exposed the project to a public?

16

Automation Interface, Add-Ins and Tools / SaveDiagram performance V17.1 compared to V16.1

« Last post by OJB on September 02, 2025, 11:52:39 pm »

Hi There 

I'm new to this forum and asking for help. I used the great content here in the past "passively" to learn Sparx EA automation.
Over time I created an extensive JavaScript library mainly focussing on diagram generation automation. I tried to achieve near-real-time response times and encountered a problem while testing V17.1 64 bit (currently using V16.1 32 bit) - with qea/SQLite databases

I have to start many automations by saving the current diagram (Repository.SaveDiagram()) to not lose user changes. With version V16 this takes about 0,1s for standard diagrams - with version V17 it is 0,8-1s (even for completely unchanged diagrams) which is a huge impact when mostly save and reload are the time consuming actions and many automations finish (in V16) in a total time below 0,3-0,5s with complex automations. So the save action is 8-10 worse in V17 compared to V16

I created a small script to measure the performance and I hope you could help verifying this behaviour or find a solution.
If you have the same experience would you see this as a bug?

Best regards, Oliver

the test script (for the Script Diagram Group) I used for the tests ...

Code: [Select]

Repository.EnsureOutputVisible("Script")
var curDG = Repository.GetCurrentDiagram()
if (curDG != null){
var start = new Date().getTime()
Repository.SaveDiagram(curDG.DiagramID)
var stop = new Date().getTime()
Repository.WriteOutput("Script", "Time: " + (stop - start) + " ms", 0)
}

17

Bugs and Issues / Re: shortcut files with extension .qea don't get registered in the Recent files

« Last post by Eve on September 02, 2025, 08:16:23 am »

- Save the connection as a shortcut with .qea  extension

Pretty sure that that's the issue. The save as shortcut should only allow .eap.

18

PCS General Board / Re: WAIT_TIMEOUT for multiple operations / login to PCS

« Last post by Guillaume on September 01, 2025, 06:26:12 pm »

I remember having a similar issue in the past but I can't remember how it's been sorted out.
What PCS build are you using ? If you use a SQL Server db, have you tried configuring the PCS with different options: ODBC DSN vs Native Connection, OLE DB ?

19

Bugs and Issues / shortcut files with extension .qea don't get registered in the Recent files

« Last post by Geert Bellekens on September 01, 2025, 06:16:35 pm »

In version 17.1.1713, when you open a shortcut file with extension .qea, it does not get registered in the Recent files section.
After changing the extension to .eap it worked as expected.

Steps to Reproduce
- Connect to a SQL Server database model
- Save the connection as a shortcut with .qea  extension
- clear the recent files section
- use Open File to open the shortcut file
- notice that the Recent files section remains empty
- change extension to .eap
- open the .eap shortcut file
- notice that the Recent Files section now mentions the model opened using the .eap shortcut file.

Reported

Geert

20

General Board / Re: How to use Relationship matrix in RTF template

« Last post by Guillaume on September 01, 2025, 05:14:31 pm »

Thank you both your valuable feedback 

I managed to generate an image having the matrix profile configured with the selected package. I agree it's not practical but at least it's useful to understand how it works.
Geert, have you got by any chance an example of a fragment to try out ?