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

General Board / What are the queries to show attribute constraints?
« on: February 18, 2020, 12:54:32 pm »
I'm creating a SQL query to show attribute constraints on a data model (PK/FK, null/not null, unique etc.), but I can;t find where they are stored in the model database.  Anyone knows which EA table/attribute holds them?  Maybe as tagged values somewhere?  Thanks!

General Board / How to show connector tagged values in diagrams?
« on: February 12, 2020, 02:57:43 pm »
The Diagram properties menu to show tags works for elements but not for connectors.  Is there a way to show connector tags in diagrams?  I have a use case diagram where I assign RACI to associations thru the relationship matrix with overlay (very handy), but I cannot show the RACI values in diagram (relationship matrix overlay requires the values to be entered as association tagged values)
An alternative would be to somehow copy the tagged value to the connector stereotype, which then shows on the diagram.  Is there a way of doing this without scripting?

I have the properties window docked on the side of the screen.  it shows lots of useful info for every element, including GUID.  My team uses Object IDs a lot instead of object names because the IDs are easy to remember 4-digit numbers instead of complicated names.  GUIDs are too long and complex for this.  We obviously list the Object ID in our SQL queries, but is there a easy way to have it displayed in the Property window instead of GUID, so we can see it real time?  Thanks!

Pages: [1] 2 3 4