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 [4] 5 6 ... 754
46
I think Model add-ins are actually the alternative for EA-Matic.

Geert

47
Bugs and Issues / Re: Relationship Matrix in Report Generator
« on: October 28, 2021, 08:00:51 pm »
Here's an example of a RASCI matrix between BPMN activities and PartnerRoles

Code: [Select]
select bpa.name as Activity,
r.RoleName, r.RASCI
, CASE WHEN r.RASCI = 'R' THEN r.RASCI ELSE NULL END as R
, CASE WHEN r.RASCI = 'A' THEN r.RASCI ELSE NULL END as A
, CASE WHEN r.RASCI = 'S' THEN r.RASCI ELSE NULL END as S
, CASE WHEN r.RASCI = 'C' THEN r.RASCI ELSE NULL END as C
, CASE WHEN r.RASCI = 'I' THEN r.RASCI ELSE NULL END as I
from t_object bp
left join t_object pl on pl.ParentID = bp.Object_ID
and pl.Stereotype = 'Pool'
left join t_object ln on ln.ParentID in (pl.Object_ID, bp.Object_ID)
and ln.Stereotype = 'Lane'
inner join t_object bpa on bpa.ParentID in (ln.Object_ID, pl.Object_ID, bp.Object_ID)
and bpa.Stereotype = 'Activity'
left join t_objectproperties tv on tv.Object_ID = bpa.Object_ID
and tv.Property = 'calledActivityRef'
left join t_object ca on ca.ea_guid = tv.Value
left join
(select c.Start_Object_ID, ro.Name as RoleName, tv.VALUE as RASCI from t_connector c
inner join t_object ro on ro.Object_ID = c.End_Object_ID
and ro.Stereotype = 'PartnerRole'
left join t_connectortag tv on tv.ElementID = c.Connector_ID
and tv.Property = 'RA(S)CI'
where c.Stereotype = 'trace') r on r.Start_Object_ID = bpa.Object_ID
left join t_diagramobjects do on do.Object_ID = bpa.Object_ID
left join t_diagram d on d.Diagram_ID = do.Diagram_ID
and d.ParentID = bp.Object_ID
where bp.Object_ID = #OBJECTID#
order by do.RectLeft, do.RectTop desc, bpa.Name
, CASE WHEN r.RASCI = 'R' THEN 1
WHEN r.RASCI = 'A' THEN 2
WHEN r.RASCI = 'S' THEN 3
WHEN r.RASCI = 'C' THEN 4
WHEN r.RASCI = 'I' THEN 5 END

Geert

48
Bugs and Issues / Re: Relationship Matrix in Report Generator
« on: October 28, 2021, 06:09:38 pm »
I've got a relationsjip matrix generating in a Word document using the Matrix.Image field in the report template. However, the matrix is over 150 rows and it scales to a single page, so it's unreadable.
Can I split it over several pages by scaling it to be one page wide?
Not really I'm afraid.
I usually use an SQL fragment to retrieve the matrix data in tabular format.
It shows the same data, but not in a matrix format.

Geert

49
Hi rabyvf,

I think you are right, it would be nice to have a more functional API. Currently it's only a thing layer on top of the database.

If you want your request to have any chance of being implemented, make sure to actually send a feature request using the link on the bottom of this very page.

Some of us have stopped waiting for sparx to do something, and have started developing our own, more functional API, that hides all the StyleEx ugliness.

You can find my efforts on github:
For C# https://github.com/GeertBellekens/Enterprise-Architect-Add-in-Framework
For VBScript: https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library

Geert

50
General Board / Re: Where has 'make this diagram my default' gone in v16?
« on: October 26, 2021, 09:04:10 pm »
Or it could have been a bug in EA 15.x. When you think of it, how would EA know which user to show which diagram for if you do not have user security enabled?

Henrik
I think it used to use your windows user name.

Geert

51
Bugs and Issues / Re: is the ExitPoint dead?
« on: October 26, 2021, 07:43:20 pm »
I don't think the placement on the diagram is an issue, but rather where in the project browser the Exitpoint lives.
It should be nested under (=>owned by) State1

Geert

52
Thanks for the input. I'll investigate further.

Geert

53
General Board / Re: Where has 'make this diagram my default' gone in v16?
« on: October 26, 2021, 06:12:03 am »
Works for me, but I'm using security. I can imagine that is a prerequisite.
It doesn't work for me on a new model without security enabled.

Geert

54
General Board / Re: Project Integrity Check: No jump to element?
« on: October 26, 2021, 12:54:21 am »
yes, ignore the CYA warning.

76MB is in fact a fairly small model, so that won't be the problem.
You might want to try to send an email to sparx support to get the errors fixed.

Geert

55
General Board / Re: Project Integrity Check: No jump to element?
« on: October 26, 2021, 12:01:46 am »
Simply always recover/clean all issues.

There are a couple of topics on the forum that go a bit deeper in the why/how.

Geert

56
Code: [Select]
'useful bit
Repository.GetElementByID(targetID).Notes = Repository.GetElementByID(sourceID).Notes
Gets object x from the database and sets the notes, but doesn't keep object x in memory   
Code: [Select]
'commit
Repository.GetElementByID(targetID).Update()
Gets object y from the database, and save's it directly back to the database without changing anything in memory.

You want to get the object, change a property, and then save it

Code: [Select]
dim myElement
set myElement = Repository.GetElementByID(targetID)
'useful bit
myElement.Notes = Repository.GetElementByID(sourceID).Notes

'commit
myElement.Update()

Geert

57
PCS General Board / Re: Unable to add a repository to Prolaborate
« on: October 25, 2021, 02:33:00 pm »
On the last image I see "EA Model" on the Prolaborate configuration, where you have "EA model" on the PCS configuration.
Not sure if that is the issue, but I can image those things to be case sensitive.

Geert

58
Look at Pdata2 (Miscdata) and Gentype

Geert

PS. It's Thomas' book, not mine ;)

59
"Client" is not a property of EA.Connector.

Geert

60
The conclusion was that it really only works with a single stereotype.

I think you better find an approach with single stereotypes. You can still use a shapescript that changes the appearance depending on the type of diagram (I think), or some other diagram specific property that the user can select (similar to rectangle format)

Geert

Pages: 1 2 3 [4] 5 6 ... 754