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.

Topics - Richard Freggi

Pages: [1] 2 3 4
I'm modeling some database views as classes using the <<view>> stereotype and it's nice that if I double click on the view, a menu comes up showing database, dependencies, definition (DML) and name of the view.

I'd like to access this info using SQL query on EA internal tables, can anyone advise which tables I can find them?  I don't see them in t_object or t_objectproperties.

I've been reading the user manual but I'm still not clear on what is the best approach to meet my requirement.  Any advice is warmly welcome!

I have two models in my project (each with its root package):  an "Import" model containing complex package hierarchy and classes of a system, and a "Reporting" model consisting of package hierarchy and diagrams.  The diagram elements come from the Import model.

The system is updated on a weekly basis, so every week I need to extract an XMI file from the system and import the XMI into my "Import" package.  I need to make sure that elements that are changed or deleted are represented correctly in my diagrams (if an element is added, I can manually drag it into my diagram).

The most common changes are moving elements from one package to another, adding new packages and elements, and renaming elements.

It's not clear to me what is the right way to do this in EA.  Should I set my Import package as baseline, then import the XMI in a temporary package, then use package compare utility and manually merge the temporary package in the Import package?  Then delete the temporary package.

I think this should be a common scenario, so there must be some straightforward way to do it, but right now I'm confused by the user manual and can't find the right way of doing it - if anybody has experience please share! Thanks!

EA version 1310

General Board / Is there a way to change a class into an attribute??
« on: July 30, 2020, 06:36:48 pm »
So I'm evaluating the Office integration MDG to import ~ 150K elements including classes, attributes and their dependencies into EA v. 1310.
You can read about my misadventures using this MDG in its own thread.
By now I can import Packages, classes and dependencies, but no way to import attributes (UML class properties) if I have the Element type specified.  The MDG documentation mentions importing attributes but they are really properties of EA's internal data structures like Style, IsDerived etc.  There is a choice to import attributes only in the MDG if you select "sample document has no data type" but I've not been able to import the attributes this way (cannot nest them in the parent class).

But it's straightforward to import nested *classes* (or other EA element types: requirements, contraints etc.)  as surrogates for the attributes.  The result is a class containing nested classes with all the names and properties of the attributes.  If I could then convert these to real SParx attributes, I'd be OK.  Does anybody know it this is possible, thanks!!!

So I googled and searched the Sparx website for full documentation of the Office Integration MDG, but all I could find was promo brochures and youtube video "Integration of Microsoft Office and Enterprise Architect" that had a very cursory introduction.
I am now trying to reverse engineer how to set profiles and template documents for Excel import of classes, attributes and associations, each with their notes; and it's hit-and-miss, I'm guessing (often wrong) how to set profiles and worksheets up.  If anyone has some good documentation on how to do it please share thanks!!!

Hello in EA v 1310 I find that my combined fragments move around the diagram randomly when I reopen an old diagram, or when I rearrange other messages in the diagram (both with and without ALT key to move the messages).

I tried adding a message from an actor to the fragment, or adding a gate then having a message from actor to gate and another message from gate to fragment to stop them moving around.  The gate trick seems to help a little (the actor > gate messages does not move, and the fragment moves around less, especially does not jump over the next messages)

I would like to know if different versions maybe have resolved this issue, or if there is some trick to fix it.  Thanks!

As far as I know it's not possible to import classes, class description, their attributes and attribute description from csv, tab delimited or excel into EA.. including the MS office integration MDG or similar.  That's my understanding from reading the manuals... am I wrong?  Thanks!

p.s. my workaround would be to create a database with tables and attributes, include their comments and import that as DB reverse engineering, then do a package transformation. Bit it's a route I would prefer not to take.

General Board / No Specialize menu in EA V1310 Professional?
« on: May 08, 2020, 11:10:28 pm »
I'd like to import the Open Group IT4IT Archimate model into EA, then extract a UML class diagram that I can use as part of our overall UML architecture for IT services.

My version is 1310 professional, I enabled Archimate MDG but I don't have the "Specialize" menu that the user manual says is needed to import Archimate xml files.  Can anyone confirm if it's not available in 1310, or not available in Professional, or hidden somewhwere in the ribbons?  I know Sparx has the bad habit of not telling you when an edition is lacking features of higher editions...

Or any workaround to import the Archimate xml file into SParx... all I need is the class diagram.

p.s. I should add that I don't know anything about Archimate...

General Board / Version 1310 crashed when transforming huge package
« on: April 21, 2020, 07:17:13 pm »
I have a package with > 4300 classes and their attributes and associations.

I want to convert it to Tables and generate DDL.  But my version which is normally very stable, stops conversion with an error message after an hour or so of trying to convert.  This happens regardless if the EA database is *eap or *feap.  Any ideas on how to do it?  p.s. I think if I only convert a few hundred classes at a time I would lose the associations of the classes that are NOT being converted, right?  My PC is supposed to be a workstation and I have 16GB memory, Windows 10 professional.

Any advice welcome!  Thanks!

I have a query with a seriously messed up join condition (result of a botched copy-paste job) on t_object on a large model (many thousands of elements).
The database is local to my PC and is Firebird
The query has been running for 30 minutes, I'm tempted to just shutdown the application reasoning that this is DML so should not corrupt the database file (OF COURSE I have not backed up in a couple of days!)

Can anyone advise if just pulling the plug is safe?  Or better to just wait it out for a few hours?  Thanks!!!
- p.s. the query finally completed after about 40 minutes, everything seems OK, but I still would like to know if CTRL-ALT-DEL during a query is safe to do!  Thanks!

General Board / Why does this query fail?
« on: April 02, 2020, 02:08:44 am »
In query editor:
Code: [Select]
SELECT Version from t_object
Microsoft OLE DB Provider etc. etc.
Column unknown VERSION

Sparx 13.10, on Firebird DB on my own PC (integrity check and index update all OK)

I think that the correct way of doing this is with interaction overview diagrams.

Anyhoo for convenience I would like to set the start numbering of a sequence message arbitrarily e.g. 1, 2, 3 etc so that all messages in one diagram are labeled 1.0, 1.2, 1.3 and the messages in another diagram are labelled 2.0, 2.1, 2.2, 2.3.

Right now I do this by creating dummy messages at the beginning of the sequence, and making each "start new activation", then making them same color as background so they are invisible.

Is there an easier way?  Thanks!

For various reasons I can;t install Firebird and its server/guardian components.  So I can't connect to my feap model file (in my own hard disk) using the DBeaver Firebird driver.  But I should be able to connect via OBDC.  Don't know how to set it up, and that OBDC driver to use (the one provided by Firebird I guess???).  I will ask in DBeaver forums but of anyone has experience with EA, please share OBDC driver info and setup procedure!  Thanks!!!

General Board / What query to list all messages in a sequence diagram?
« on: March 10, 2020, 03:36:39 pm »
I need a query to show: Message number, message source (participant), message label (operation name/parameters), message destination (participant) from a sequence diagram.

I can't find which attributes of t_connector and / or t_connectortag carry this information.

Anyone knows?

General Board / Relationship matrix is skipping one element!
« on: February 25, 2020, 12:09:54 pm »
I have a relationship matrix showing use cases vs. actors and it works fine except that the very first use case in my package is missing from the matrix!  Tried a few times in different ways, tried editing the missing use case, reset IDs, integrity check etc...
The use case shows up in searches, queries etc.  It's just missing from the relationship matrix
Has anyone had this issue and is there a solution?  Thanks!

I'd like to color-code elements appearing in diagrams based on their package (including super-package etc.).  Right now I'm creating a diagram, dragging all elements in package/subpackage in manually, then SHIFT-CTL-E and set default color.  Is there a way to avoid the hassle (without shapescript and such wizardry). Thanks!!!

Pages: [1] 2 3 4