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

Pages: [1]
General Board / Re: Hide packages/folders from users (Sparx V14
« on: March 13, 2018, 06:00:57 pm »
I have played a little with Row Level Security, Its pretty neat  - here are my findings/comments

  • Documentation is still a little contradictory (I think Sparx Systems have made a few enhancements subsequent to writing of guides
  • You need the latest version of SQL (i think from 2018 or latest Oracle
  • EA Adds new DATABASE roles to the DATABASE -- this means that you manage access levels against AD Groups/members, so you now grant datareader & datawriter to each AD Group, then a specific visibilitylevel Role (i.e. 1-20) 
  • I like the database level security (as opposed to the tool-level security which is implemented in most other tooling)
  • One thing I have not got working yet is the added menu item in the "package management" menu item -- keen to see how this works, but I suspect my database is not correct yet.

What's still in the air for me is how Sparx Systems have implemented the levels, I still need to confirm if each user/group needs to be allocated visibility roles cumulatively (i.e. you grant permissions visibility1, visibility2, visibility3 ) to get access to levels 0, 1, 2, 3  or if by just granting Visibility3, you inherently have access to all sub-levels (the help file and sample DB script say differently)  -- Granted I just need to test this, but have not had the time (or lazy)

Thanks! ..

I really struggled... cant believe it was so easy.

I am trying to get these SQL macros working.

The following query works perfectly in a MS SQL database, however, does not work when running in the direct database connection (MS JET)

any ideas?

select top 10 name,
   #DB=JET#, 'MSJET' as source#DB=JET#

Thanks Nabil, Philip.

I will look into these as a solution.  And Yes. I have extended Sparx to create my own diagram types i.e profile::behavior_view and profile::structure_View, and as a rule... i never want to see structure connectors on a behavior view and behavior connectors on a structure view (something like that... )

I was looking at the diagram filters and its so close to what I want.. just that you cannot create a filter on (Diagram type AND connector type)

I think the script idea is best (EA_OnRunDiagramRule)  --

Its just strange that other Sparx Users dont find that they have this same requirement -- I know how to hide connectors on a single diagram, but we have so many diagrams that I wanted a standard rule.


I love the functionality of the model filters, specifically where you can automatically hide connectors which dont "belong" on a specific view (probably using the model type) -- is there any way to permanently create a rule that automatically applies a diagram filter to a specific type of diagram across the repository?


General Board / Import of PlantUML Sequence Diagrams
« on: December 13, 2017, 05:07:57 pm »
I have many PlantUML Sequence diagrams which are "modelled" using the plantUML pseudo-code. I would like to know if anyone has tried to generate sequence diagrams from this code? Essentially building a parser for the pseudo language? This would make migration a lot easier. I would be happy to collaborate if anyone else had such a requirement?

Automation Interface, Add-Ins and Tools / Re: Odd QuickLink Issue
« on: November 24, 2017, 07:31:27 pm »
It seems that composition kind of the connector is set in the definition of the connector.

I have tried to get quicklink to work with the ArchiMate_Aggregation connector, however if you notice, its actually an association connector with the composition kind attribute = "shared"

There is no way to set this via the quicklink options, it must to be defined under the profile for the connector definition, meaning that if you extend your custom connector type, you will be able to set it on your stereotype. Specifically, add a compositionKind attribute to the Association metaclass element.
See Sparx help for details:

Bugs and Issues / Re: Version 11 - Change Diagram Type option missin
« on: March 26, 2014, 05:51:19 pm »
thanks!  I found it.

Must have been tired last night, since thats the first place i Should have looked! ..


Bugs and Issues / Version 11 - Change Diagram Type option missing
« on: March 26, 2014, 07:10:59 am »
When creating a composite diagram. I cannot seem to find the option (normally under the advanced right-click menu) to change the model type.

Has this moved in version 11?

(using the 11rc)

Hi, thanks.

well, I am utilising the technology as a sort of "metamodel" for the organisation, following an approach where diagram linkages may be done using the matrix view. in this case there will not be a pre-defined model type created via MDG, however there will be a pre-defined matrix to which the link can be modelled.

To illustrate with an example,  I have created a model type called "L4 Activity Diagram"  and  another model called "Business Organisation Diagram"  then lastly there is a matrix profile which will be used to link the lane on the activity diagram to a role used on the organisation diagram ... hence the need for a matrix profile to be included in the MDG.



I have created a sample MDG file whereby i have created many different element types, my intention now, is to create a few predefined matrix profiles which will be used to associate the new elements to each other.

Is it possible to include a set of matrix profiles as part of an MDG technology import?


Problem Solved (as per EA support guys)

I was using the color palette on the toolbar to define the color,

I should have selected the element -> Appearance --> Default Appearance  to change the color.


I have created a UML Profile, and on that profile, have extended a normal class meta-type with a new stereotype.

I have set the background colour of my new stereotype element and exported the profile as per: instructions

This does not seem to work as expected, the new elements color is unchanged and when looking at the profile.xml file, I see that the bgcolor property is "-1"  indicating that the colour attribute did not pull through.

Is this an EA Bug, or have I just done something wrong.


Hi.. I am trying to import a Hierarchy of Classes into EA.. i have looked at the XMI import and that would work if i could generate the XMI structure, however all i have is a Spreadsheet with data as follows:
-car (attributes)
   -door (attributes)
      -handle (attributes)
      -lock (attributes)
   -engine (attributes)
      -starter (attributes)
I tried the CSV import, and that works, however i would like to have the class hierarchy defined by the import also...
any ideas?

Pages: [1]