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 - Paolo F Cantoni

Pages: [1] 2 3 ... 394
1
I Believe updating external elements on every diagram is not handled by EA.
Also doing this via script is also bit tricky as you know the id of element is changed but it has a connector relation to its previous version so we can update on other diagrams

Best Regards,
Nabil
Thanks, Nabil,

That's what I thought.  We have a consolidation process which already knows how to substitute one item in a diagram with another.  I'm sure it can be modified to do this.

I guess I have to respond to the EA_MenuClick event to intercept the cloning and add the additional functionality.

It seems to me that this would be a common requirement and maybe I should put in a Feature request.

Thoughts?
Paolo

2
We are about to embark on a serious implementation of Time Aware Modelling (TAM) in our corporate repository.

As we understand TAM, if we have the different versions (of items) in their individual branches, we can use items from another version in the diagrams for a specific version.  So far, so good.

When we clone an element (from another branch from within a diagram in this branch), a clone of the external element will be created in the current diagram branch.  The external element in the diagram will be replaced by the cloned element in that diagram.

Question:  Is there any mechanism to replace the external element in every diagram in the appropriate version, or will we have to "roll our own"?

TIA,
Paolo

3
Hi Daniel,

I haven't checked for QuickLinker, but for other elements of the MDG, we don't have to restart EA to get the updated MDG installed.  The QuickLinker is a global structure (to which each MDG supplies a portion), so I suspect that it is not possible to unload the existing QuickLinker for a specific MDG (probably because each entry is NOT tagged with the MDG(s) that provided it).  Hence a restart is required.  You can append (as you load MDGs dynamically), but you can't remove.

HTH,
Paolo

4
General Board / Re: View indexes script
« on: January 18, 2018, 05:41:38 pm »
I don't know what "materialized views" are, but here's an example on how to create indexed views in SQL server.

https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views

Geert
Thanks, Geert,

It looks like a SQL Server "Indexed View" is functionally equivalent to an Oracle "Materialized View" and consequently is a dynamic table in all but name.  Like Trump's Media Spokesperson calling a non-fact an "alternative fact".  It's either an objective fact or it isn't.  These kinds of objects are tables whose contents are maintained by means of triggers in other tables that respond to the "query specification".  They are VERY USEFUL but are just tables - dynamically maintained by the RDBMS.

The problem appears to be that EA doesn't recognise them as "tables" and, consequently, doesn't reverse engineer their indexes.

Paolo

5
So I changed the ODBC driver to SQL Server Native Client 11.0 and things started to improve.  But I've just noticed that Reflexive (that is back to the same table) FK associations aren't being imported.  They are present in the DB and will show up under the SQL Diagramming section.  They are present on the imported table as stereotyped FKs, but associations are nowhere to be found.

Anyone confirm or deny this?

Paolo

6
General Board / Re: How to become and Enterprise Architect.
« on: January 18, 2018, 11:23:09 am »

Generally those titled Enterprise Architect are very entitled leading to poor engagement with the business and other architects :-)
To paraphrase Descartes:
"In titulo, ergo sum" - I am thus entitled, therefore I must be...

Paolo

7
In response to Paolo's question, the instructions provided to us were to run up MS Access and Open the EAP file, which converts the  EAP to a .aacdb file, so my use of the term 'export' was misleading.

Geert (Sherlock) thx for your efforts, but the suggested change doesn't produce the missing items. What I intend to do next is compare the output columns for the original query and the new query and identify the EAP elements that it isn't finding and deduce why the select statement isn't finding these 13 items.
We use MS Access with Linked Tables so that the source EAP (or another repository) file doesn't need to change.  We DO use .accdb MS Access DBs but they still link to the repositories via Linked Tables.

If the intent was to transfer the repository from a .eap to a .accdb repository, then the Transfer Project functionality should have been used.

Paolo

8
General Board / Re: View indexes script
« on: January 18, 2018, 10:40:30 am »
As I read the whole set of responses, my original assertion stands.  (If you accept that "materialised views" are dynamic tables - as per response #5 in the link).

What is the syntax for defining an index directly on a view (that is not materialised)?

Paolo

9
Hi there,

Some time ago an SQL query was devised to parse an exported EA DB to Microsoft Access: The query took 30 minutes to run:

[SNIP]
(my emphasis)
Exactly what does the highlighted phrase mean?

Paolo

10
General Board / Re: View indexes script
« on: January 17, 2018, 05:43:03 pm »
I didn't know Views had indexes.  They use indexes (in the underlying tables), but don't have any themselves.  Even "Materialized" Views aren't Views, per se, but dynamic tables.

Paolo

11
Daniel
To verify a stereotype definition -> once you save your profile, you can import it in your Resources Window -> UML Profile, this will allow you to drag and drop your stereotypes into a diagram and verify your results.


FWIW - I've noticed that The color of your extended stereotype goes to the native color is due to the order of stereotype (in the stereotypeex field), When we remove the Archimate stereotype and reapply the color will be usually corrected.  But this isn't always a reliable solution.

Nizam
(my emphasis)
Which is (one of the reasons) why we stopped using multiple stereotypes getting on for a decade ago.  Each element has only ONE stereotype (used to define the metatype).  All other uses of "stereotypes" are catered for by using various properties (including tagged values).

Paolo

12
General Board / Re: Diagram Details hide when publishing
« on: January 17, 2018, 10:47:59 am »
Hi!

Is there an option or setting where I can show Diagram Details in Enterprise Architect but when I copy to clipboard or publish that I can hide the details?

Eamonn J.
Hi Eamonn,

We have forsaken the Diagram Details feature for the use of the Diagram Note Element.  We make it non-selectable and so it WON'T appear in the clipboard (unless we want it to by making it selectable).

It's been SO long since I use the Diagram Details that at first, I wasn't sure what you were talking about.   ::)

Paolo

13
General Board / Re: Hyperlink as an element in Project Browser
« on: January 11, 2018, 10:45:05 am »
We would like to make a list of hyperlinks, and refer to these hyperlinks from multiple diagrams, like other elements. Is this possible?
You can collect the hyperlinks you want to share into one or more diagrams and then get your users to copy and paste into the relevant diagrams.  As qwerty says, you can't "see" them directly in the browser, but this can be the next best thing.

Paolo

14
General Board / Re: SQL to find mult connectors between to elements
« on: January 11, 2018, 10:40:11 am »
That will output all elements with more than one connector. I guess the OP is after a list of connectors for two distinct element?

q.
No it won't, see the grouping.
It will output all element/connector details for all elements that have 2 or more of the same kind of connector to the same element (which makes them a candidate for duplicate connectors, although there might be valid exceptions)

Geert
Candidacy is relatively easy.  Actually determining whether two connectors are semantically the same (and perhaps consolidating properties that are not semantically significant) is non-trivial.  We have a version which we are testing as part of our element consolidation process.

Paolo

15
General Board / Re: Running script from an specific Element
« on: January 10, 2018, 06:03:33 pm »
Hello Paolo,

We can use context item event to get the script from an element.

We can execute the script using Script Control Class (there are certain limitations)

HTH

Nabil,
Thanks, Nabil,

so it's not via the UI directly.

Paolo

Pages: [1] 2 3 ... 394