Messages

1

Automation Interface, Add-Ins and Tools / Re: Setting Custom Diagram Appearance from Script

« on: March 06, 2025, 08:56:23 pm »

Have solved it, although not in a very elegant way.  I basically copied the StyleEx and ExtendedStyle attribute values for a diagram that does have Custom Style enabled and this seems to have worked.  I omitted the SaveTag vaue through, as this looks like it's some kind of tracking variable.   These attributes map to the StyleEx and PDATA columns in the t_diagram table if taking the values from the database directly.

Martin

2

Automation Interface, Add-Ins and Tools / Setting Custom Diagram Appearance from Script

« on: March 06, 2025, 08:27:55 pm »

Hi All,

I've written a script to create a (large) package hierarchy with default diagrams.  I want some of these diagrams to have Custom Style enabled (as can be set in the Diagram Properties from the EA user interface) but I can't see a way of achieving this through the EA Automation interface.  I thought it might be buried in the StyleEx settings, but can't see anything obvious, even when comparing a diagram that does / does not have his setting enabled.

Has anyone managed this from a script?

Thanks,
Martin

3

General Board / Re: Document Generation Bookmarks in SQL Fragments

« on: November 09, 2023, 02:50:44 am »

Hi Farkas,

Thanks so much for your solution  I'll give it a try and let you know how I get on.  Generating the RTF string from a custom SQL fragment will be easy enough I think - the key will be if EA can then interpret it as RTF and convert into a bookmark in the generated document.

Martin

4

General Board / Document Generation Bookmarks in SQL Fragments

« on: November 08, 2023, 09:11:28 pm »

Hi,

I have an SQL Template fragment that is reporting on requirements in a table as part of a parent template, and I'd like insert standard EA bookmarks into the generated table (i.e. in "BM_<GUID>" format), so that other element notes that include hyperlinks to those requirements resolve properly.  However I haven't found a way of doing it.

Is this possible from within the EA template?   As a workaround I can generate text tags into my report output and use a Word macro afterwards to convert them into actual bookmarks, but it would be good if I could do this all within the EA SQL template fragment.

Thanks,
Martin

5

General Board / Re: Unable to perform Forum Searches

« on: February 01, 2023, 05:05:10 pm »

Thanks for the reply Eve - yes it definitely seems connected to my work PC.  We use a VPN to tunnel into our corporate environment, but I'm seeing this problem both when working at home (i.e. using the VPN) and at work (when I don't have to).  I suspect it is some kind of network configuration change that has triggered CleanTalk....

6

General Board / Re: Unable to perform Forum Searches

« on: February 01, 2023, 01:03:22 am »

Thanks for the suggestion - yes tried that - no dice unfortunately :-(  I've emailed Sparx so hopefully they'll come up with a solution.

7

General Board / Re: Unable to perform Forum Searches

« on: January 31, 2023, 08:21:30 pm »

Thanks qwerty - will do.

8

General Board / Unable to perform Forum Searches

« on: January 31, 2023, 07:54:33 pm »

In the past week or so I've noticed that forum searches have stopped working for me.  Has anyone else had similar issues?  I get a message from CleanTalk saying "Sender Blacklisted", which is strange as I rarely use the forum.  The other strange thing is that I can search from my mobile phone when logged into this account, just not from my work PC.  A quick look at the CleanTalk website suggests it may be due to network settings on my PC, but I'm not in control of these as they are set by company policy.
Has anyone else had a similar issue?  Unsure who to contact to resolve it TBH...

Thanks,
Martin

9

General Board / Re: Difference between Properties and Attributes and Values in EA SysML

« on: January 13, 2023, 05:33:52 pm »

Drag a Property shape from the Toolbox onto your Block.  Name the Property the value name.  In the Properties panel, set the Type to your Value Type.  Remove the Property shape.  The Values compartment will appear.

It seems tedious to add an item only to remove a few clicks later.  I posted a question this afternoon to see if there were more efficient ways of adding Values.

Another way is to click on Property in the toolbox and then click on your Block in the project browser.  This adds the property directly to the Block without having to add the shape to the diagram.  You will probably have to refresh the diagram to see the new property however.

10

Automation Interface, Add-Ins and Tools / Re: Issues with heading levels on generated documents in EA16

« on: October 18, 2022, 02:39:53 am »

I'm also seeing issues in EA 16 32bit - I have a document template that follows a package hierarchy and what should be a third level heading gets generated as level 2.  The sub-packages inside that package then (correctly) get generated as level 4 but obviously it looks a mess in the generated document.  I have the adjust heading levels setting at its default (9) so that shouldn't affect it.

Now that you are saying it, I think I noticed something similar a while ago.
I did not recognise that v16 might have been the culprit, but now that I know I will pay closer attention to that in my v16 tests.

Geert

I've just downgraded back to EA 15.2 having transferred the report templates to the v15 model and the problem disappears, so looks to be an EAv16 issue (one of a few that I've come across in the Report Generation area in EA16 - the other (crash when trying to edit list level in EA 16x64) has been acknowledged as a bug by Sparx.  I'll raise a bug report....

11

Automation Interface, Add-Ins and Tools / Re: Issues with heading levels on generated documents in EA16

« on: October 18, 2022, 12:43:46 am »

I'm also seeing issues in EA 16 32bit - I have a document template that follows a package hierarchy and what should be a third level heading gets generated as level 2.  The sub-packages inside that package then (correctly) get generated as level 4 but obviously it looks a mess in the generated document.  I have the adjust heading levels setting at its default (9) so that shouldn't affect it.

12

General Board / Re: WITH RECURSIVE support in Model Search / RTF templates

« on: August 04, 2022, 06:32:14 pm »

You can't do any SQL queries in EA that don't start with "Select"

You'll have to figure out a different way. There might be a way to use this recursive query by wrapping it in a subquery, but I'm not sure. I know I gave up at one time, but that was on SQL Server.

The easiest in this case is probably to join t_package enough times.
Enough would be the current maximum package depth +2 or something?

Geert

Just to follow up on this, I solved my immediate problem with a bunch of left joins in the end (ugly but it worked).  However I've had reason to revisit this problem as I wanted a query that only returned rows if the element I was selecting was inside a specific sub-tree in the package hierarchy.  You were spot on Geert - putting WITH RECURSIVE in a sub-select worked in this particular case...

13

General Board / Re: WITH RECURSIVE support in Model Search / RTF templates

« on: June 15, 2022, 12:58:44 am »

You should be able to access the EA QEA file with an SQLite frontend (DBeaver, SQLite studio... even the CLI) and run common table expressions which should support recursive queries

Thanks for the suggestion Richard.  My database (MariaDB) supports recursive queries, its just that they don't work when used in the EA client.  The ultimate objective is to include this information in a Report Template through a SQL template fragment, so at the moment JOINS look to be the only option....

14

General Board / Re: WITH RECURSIVE support in Model Search / RTF templates

« on: June 13, 2022, 11:28:27 pm »

Hi Geert,

No I want to report on the full path from a leaf package, so JOINS work quite well.  The only complication is dealing with null returns when you reach the top of the tree (as you suggest I've coded in enough for future expansion).  A shame WITH RECURSIVE isn't supported as that would make it completely future proof, but I've got something working at least.

Thanks again.
Martin

15

General Board / Re: WITH RECURSIVE support in Model Search / RTF templates

« on: June 13, 2022, 06:38:06 pm »

Thanks Geert.  I suspected that would probably be the answer, but worth asking nonetheless.  Thanks for your suggestion of using join - I was contemplating a bunch of UNIONS but join should result in a much less verbose statement.

Martin