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 - Richard Freggi

Pages: 1 [2] 3 4 ... 21
16
Suggestions and Requests / Re: Note links in sequence diagrams
« on: July 27, 2020, 07:37:27 pm »
Yup

17
General Board / Re: Listing the "visible" attributes in a diagram.
« on: July 27, 2020, 06:06:07 pm »
BRILLIANT!  Thank you wverhoef you saved me days of work and an ulcer or three.

Your query works perfectly.

Here's the version for Firebird (just the filter condition):

Code: [Select]
-- Filter out attributes hidden via EA's Features and Properties menu: custom visibility
AND (--List attributes of classes where nothing is hidden
(
(POSITION(SUBSTRING(t_object.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) = 0)
AND (POSITION('AttPro=0;AttPri=0;AttPub=0;AttPkg=0' IN t_diagramobjects.ObjectStyle) = 0)
AND (POSITION('AttCustom=0' IN t_diagramobjects.ObjectStyle) = 0)
)
OR --Ensure no listing of attributes of classes where all attributes are hidden

(
    (POSITION('AttPro=0;AttPri=0;AttPub=0;AttPkg=0' IN t_diagramobjects.ObjectStyle) > 0)     
    AND (POSITION(SUBSTRING('S_' || t_object.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) > 0)
    AND (POSITION(SUBSTRING(t_attribute.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) = 0)
)   
OR----List attributes of classes hidden using the SHow visibility - custom button

(
(POSITION(SUBSTRING(t_attribute.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) = 0)     
AND (POSITION(SUBSTRING(t_object.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) > 0)
AND (POSITION('AttCustom=0' IN t_diagramobjects.ObjectStyle) > 0)
)

OR (--List unhidden attributes
(POSITION(SUBSTRING(t_attribute.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) > 0)     
AND (POSITION(SUBSTRING(t_object.ea_guid FROM 2 FOR 6) IN t_diagram.StyleEx) > 0)
AND (POSITION('AttCustom=1' IN t_diagramobjects.ObjectStyle) > 0)
)
)

-- End filtering of hidden attributes

18
General Board / Re: avoiding duplication
« on: July 23, 2020, 07:04:10 pm »
Shouldn't it be possible to create a script that removes the option to drag an element from project browser to diagram as instance, forcing everything to be a link?

19
YO DAWG
I heard you like interfaces so I put an interface in your interface so you can interface while you interface

SORRY COULD NOT RESIST!!!!!!

20
The vendor should know...

q.

Yes you would think they would put it in the documentation somewhere....

21
You should see it under Apps & Features as a separate programme.

Never found the help too helpful. In particular, I seem to remember that to import from and export to excel I needed to 2 profiles (one for the import and another for export). For some reason, if I used one profile I seemed to end up with a big mess.

Yes installation and use has been clunky and unnecessarily complicated.  Also the spec says that you can import hierarchy of elements but it seems to support only 1 level, i.e. I can import packages and classes within their package but it's impossible to import the class attributes at the same time. 

My experience is that if I deviate even a little from what is shown in the Youtube video or in the help html, I'm in the jungle and need a few hours of trial and error to make anything work.  By contrast I tried Geert's free Excel importer and it worked right away for several layers of hierarchy no problem.

The biggest weaknesses in this MDG so far:
- Very unique installation and handling: does not show up in the MDG menu ("Configure - manage technology"), apparently no way to unistall from EA (may just delete the folders but they are spread about the Windows directory, and good luck with unistalling from Office and Registry)
- Only works for *eap repositories apparently, at least the Office application menus
- It's almost impossible to get the Office template AND the profile AND the source document perfectly OK, there are dozens of things you can do wrong in each one of them, the chance of getting everything 100% perfect is almost zero and the documentation is insufficient
- Haven't been able to import class attributes yet, maybe it's my fault
- There are import / exports menus in both the Office applications (Excel, Word etc.) and in EA, the wizards are quite similar and the documentation almost never tells you which one it's showing, so you have to flounder trying this and that until MAYBE you get something that works

I have not completed my evaluation but definitely for a $140+ plugin it's hard to justify.  Most likely I will need to figure out how to unistall cleanly from my machine before the evaluation ends, anyone knows how to do that?

p.s. EA build 1310 on Windows 10 professional

22
For now I need help to uninstall Office MDG integration!
I installed both the 32 and the 64 bit versions of the MDG (seems like my company is using win 10 but with office 32 bit), and the profile editor I'm getting is different from what the user guide and the youtube video shows, so maybe reinstalling would help...  anybody knows how to delete completely?

p.s. It's a bit conky because the Office MDG does not show up in the Manage Technology or Manage Add-Ins windows, if it's an MDG I should be able to activate and deactivate it via the MDG Technologies window?

pp..s. "There's a HTML user guide installed in the Windows Program data / MDG folder!  I really think that should be mentioned SOMEWHERE in the Sparx website!  I found out by rereading the comments on the Youtube video.": I just realized that it is the MDG help menu launched via the ribbon...  duh.

23
Bugs and Issues / Re: HTML Generation not Loading MS Edge
« on: July 16, 2020, 03:08:11 pm »
Javascript and activex have no place in a modeling tool... even less in a distributable html report.  Still can't understand why EA uses them at all.

24
Thank you very much Modesto, that page was very helpful, and also somehow omitted to mention that there's a HTML user guide installed in the Windows Program data / MDG folder!  I really think that should be mentioned SOMEWHERE in the Sparx website!  I found out by rereading the comments on the Youtube video.  I'm going thru the HTML guide, seems has the details I need.

Thanks again for your help Modesto.

25
General Board / Re: Resources for Sparx EA?
« on: July 10, 2020, 09:07:00 pm »
No, an identifying relationship can be optional, meaning 0 cardinality at child table, so that every child record has 1 parent, but some parent have 0 children, same as a non-identifying relationship.

Identification is really about composite PK, and as mentioned EA is very kludgy about its key management.  As I said, an OK short term stopgap measure for data modeling and no complaints, at EA's price point the kludge is acceptable. 

I just would not use it as THE data modeling tool

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

27
General Board / Re: Resources for Sparx EA?
« on: July 10, 2020, 11:53:26 am »
Here's another example of limitations of EA for data modeling... no support for non-identifying relationships.  Maybe a future release could address this issue?

https://www.sparxsystems.com/forums/smf/index.php?topic=14353.0
Richard that post is 15 years old. Are you just having a go?

I have used both UML notation and Information Engineering notation to data model with Sparx EA and never have a problem re-presenting identifying and non-identifying relationships.

Using crow-feet notation, is an identfiying relationaship anything other than "minimum one to maximum one (mandatory)" in one end and  "minimum one, maximum many (mandatory)" on the other - i.e., double dash in one end and dash and crow-foot in the other end?

15 years old, and still true as far as I know (please correct me if I'm wrong)

28
General Board / Re: Resources for Sparx EA?
« on: July 09, 2020, 12:05:04 pm »
Here's another example of limitations of EA for data modeling... no support for non-identifying relationships.  Maybe a future release could address this issue?

https://www.sparxsystems.com/forums/smf/index.php?topic=14353.0

29
General Board / Re: Resources for Sparx EA?
« on: July 08, 2020, 12:51:32 am »
Hi Paolo,
if someone at Sparx is listening, here are some of the things that would help turn Sparx into a contender as data modeling tool:
- Treat attributes as model elements, not as an inconvenience / afterthought: CSV export/import, attribute views, attributes can be dragged/dropped from one table to another in the diagram (not just in project explorer)
- Treat relationships in a relational model: if PK is changed in parent table, the relationship and the child FK are automatically updated (or at least a warning), if relationship is changed / deleted than the FKs are changed / deleted etc.
- Provide a data dictionary search that actually generates a data dictionary

Just a few off the top of my head...

30
General Board / Re: Resources for Sparx EA?
« on: July 07, 2020, 08:41:23 pm »
OOOOOhhhh...
Sparx for data modeling = you are in for a world of hurt.  Sparx works OK as a lightweight stopgap but is not a data modeling tool like ERwin, Embarcadero, Toad etc (don't let the brochures tell you otherwise!)
Sparx for UML modeling of processes, systems, software at any level (conceptual, logical, physical) = welcome to one of the best tools around for this. 

I guess what I'm saying is... good luck *averts eyes, gazes to the floor*

Pages: 1 [2] 3 4 ... 21