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

Pages: 1 2 3 [4] 5 6 ... 48
Bugs and Issues / Re: EA repository performance on Oracle db
« on: October 11, 2018, 04:31:07 am »
Maybe time to realize that Sparx EA developers are still in the 1990 and developes old fashion Client-Server apps with bad SQL-queries. Most of other old apps architectures have evolved to modern apps, but not Sparx, still in retro Client-Server architecture.
Bit of a harsh negative statement there buddy  :(

Yes Sparx EA is a client-server app but not necessarily with bad SQL queries as they work fine on SQL and MySQL. You know modern databases not like Oracle which is from the 1980's and can't cope well with the style of query.

To be fair to Sparx Systems they have introduced Cloud Pro Server and Web EA over the last couple of years so they are changing the architecture to a that of a web oriented one. If you've done any development over the decades you'll realise it does take time to migrate a product from one style of architecture to another.

The important thing to remember is that Sparx EA works heaps better than anything else on the market. If you've found something better with a modern architecture then please share. I doubt you have :)

General Board / Re: Alternate images
« on: October 10, 2018, 10:07:32 am »
Anyone knows how to import a batch of  nice symbols for alternate_picture??
I have just dragged a bunch from windows file explorer to an empty diagram, but I dont get the right name for each picture ;(
Have you tried importing the images provided by Sparx Systems

General Board / Re: Alternate images
« on: October 10, 2018, 10:05:23 am »
Qwerty is correct you could write a script. Just so happens I did one a while back
The script will probably need some modifications if you want set different images depending on element type.
Code: [Select]
!INC Local Scripts.EAConstants-JScript

  * Script Name: Set Element Alternative Image
 * Description: Sets elements image on a diagram. Need to have images loaded into model.
 * For example images such as these

 * Diagram Script main function
function OnDiagramScript()
// Get a reference to the current diagram
var currentDiagram as EA.Diagram;
currentDiagram = Repository.GetCurrentDiagram();

if ( currentDiagram != null )
        Session.Output("Diagram Name:" + currentDiagram.Name);
ObjectsInDiagram( "    ", currentDiagram );
Session.Prompt( "The setting to non rectangular is now completed", promptOK)
Session.Prompt( "This script requires a diagram to be open.", promptOK)

// Converts the elements of the provided package to the Script output window
// Parameters:
// - indent A string representing the current level of indentation
// - thePackage The package object to be processed
function ObjectsInDiagram( indent, theDiagram )
    // Cast thePackage to EA.Package so we get intellisense
    var theCurrentDiagram as EA.Diagram;
    theCurrentDiagram = theDiagram;
    // Iterate through all elements and add them to the list
    var elementEnumerator = new Enumerator( theCurrentDiagram.DiagramObjects);
    while ( !elementEnumerator.atEnd() )
  var diagramObject as EA.DiagramObject;
        diagramObject = elementEnumerator.item();
        SetObject(indent+"    ",diagramObject );

function SetObject(indent, theObject)

    var diagramObject as EA.DiagramObject;
    diagramObject = theObject;
// List of ImageID values can be found in table t_image
diagramObject.SetStyleEx("ImageID", "1796848196");


General Board / Re: Status property of diagrams
« on: October 10, 2018, 06:47:22 am »
Thinking about this further overnight here are a few options open to you regarding capturing state of a diagram.

1) As the version field on diagrams are strings you could use version field in a diagram to indicate state as a work around.

For example;
Version: [ "0.01:Draft" | "0.02:Draft" | "0.03:Reviewed" | "1.01:Approved" ]
or some other format that suits
The benefit of this is it gets displayed on diagrams if you use diagram notes or show diagram details

For those purists out there - yes I know its violating 1st normal form but its a tactical solution given the constraints.

2) If your not using the stereotype field in the diagram you could hijack that and use that for state.

3) You could create a background image for each state that perhaps has text on it or a colour that reflects the state and set the background.

General Board / Re: Status property of diagrams
« on: October 09, 2018, 06:14:56 am »
That is correct they don't have a status field on the diagram like elements. Why? Good question I don't really know.

General Board / Re: More 'natural' curved connectors ?
« on: September 25, 2018, 12:01:37 pm »
Unfortunately, the control point gets ignored during layout changes, which is why curves appear distorted.

That's pretty much what I figured. So - is this a feature, a design limitation, an oversight or a bug ... ?
Is it worth raising a bug or feature request for it?

Call it what you like, a Feature, Design Limitation, Oversight or Bug no matter what it certain is an inconvenience to the user.

General Board / Re: Suggestions Required - LOV/Value Meaning
« on: September 25, 2018, 11:51:00 am »
You can try the following;
  • Use the attribute notes
  • attribute qualifiers
  • define your own attribute tag values

Bugs and Issues / Re: Space Horizontal Bug ?
« on: September 25, 2018, 11:42:56 am »
Try box layout with the same columns as elements. It tends to work better.

General Board / Re: More 'natural' curved connectors ?
« on: September 22, 2018, 07:14:58 am »
Not seen anything in the ArchiMate standards over the years to address the topic of curved lines. I've read pretty much all the literature out there on ArchiMate too. The ArchiMate examples in the standards past, usually show straight direct or orthogonal lines. However in Marc Lankhorst's book called "enterprise architect at work" one of the examples there are some curved lines, figure 1.1 Communicating about architecture.
Over the years I've occasionally informalised ArchiMate diagrams for the Management/Executive team and represented the elements with graphics and used beizer lines in Sparx EA. I call this Markitecture as its more aimed at marketing and selling the idea to management as the tend to go all cross-eyed if they see ArchiMate shapes.
So whilst not officially addressed I don't see why not use curved lines if its right for your situation.
You could post a question to Marc Lankhorst on the Linkedin ArchiMate group.

Think you've solved it by selecting ArchiMate3::ArchiMate_ApplicationComponent

Bugs and Issues / Re: EA repository performance on Oracle db
« on: September 18, 2018, 10:32:34 am »
Concur with all the previous comments regarding Oracle DB. I've been in 3 organisations with Oracle and 2 with MS SQL for the Database in last 10 years. Each time with Oracle we hit performance issues. After tweaking Oracle for months with no real benefit we moved to MS SQL and it immediately fixed those problems.
Perhaps there is an Oracle DBA out there who can make it perform well with Sparx EA but I've not come across them yet.

General Board / Re: Custom element label in EA with ArchiMate
« on: September 12, 2018, 07:01:12 pm »
Try this shape script as it draws the ArchiMate Application Component and will do what you appear to want.

Code: [Select]
shape main


shape port

shape name
v_align ="bottom";

shape packagename
v_align ="center";
println("#packagename#"); // Assume the package is domain then could use package name

shape stereotype
v_align ="top";


decoration component


The quick way to get the result you are looking for is to create a stereotype in your model called "ApplicationComponent" which extends UML component.

You can create stereotypes via Ribbon Configure>UML Types
Stereotype Name:ApplicationComponent
Base Class: Component
Override Appearance: Shape Script radio button
Click Edit button and paste the script
Click OK button
Click Save button
Click Close button

Once that done create a ArchiMate V3 diagram then drag a Archimate Component on to it and change the stereotype from "ArchiMate_ApplicationComponent" to "ApplicationComponent"

Hope you can follow those instructions
If you find that helpful then a helpful vote would be appreciated.

General Board / Re: Multiple Models in one SQL Server database
« on: September 12, 2018, 05:40:21 pm »
You can put all the 100 eap file models into one SQL repository. You just need to figure out how you want to structure it and that really depends on what you have in your eap files. If there is one for each project and the projects can be grouped into portfolios and programmes then it could look something like this
-Portfolio A (Root)
   - Programme A (View)
      + Project A (Package)
      + Project B (Package)
      + Project C (Package)
   -Programme B (View)
      + Project D (Package)
      + Project E (Package)
      + Project F (Package)
-Portfolio B (Root)

You can use XMI import/Export to create an XMI file from each eap file then import each one into the SQL central repository as structured above.
Hope that provides some food for thought.

diagram properties | Connector | Connector Notation

I don't see this option in "Diagram Properties."  I am using R14.
Right click on diagram background
diagram properties dialog| Connector | Connector Notation> Information Engineering
Or just create a data modelling diagram in the first place and its already set.

My data modeler refuses to use Sparx due to the way relationships are represented. He wants crows feet. He downloaded Oracle data modeler and is happy.
Doesn't make me feel good about the $2K we spent on Sparx licenses.
Don't worry data modellers are like that. They like to stick to notations and tools they know.
On the plus side Sparx EA can model a whole lot more from motivation models, business architect, business processes, business rules and data models as well as UML so you can design and develop lots more that just data model.

I've had this problem of showing several instances of the same archimate element on one diagram.
Originally I created this script to create multiple diagram elements pointing to the same element.
Code: [Select]
option explicit
'!INC Local Scripts.EAConstants-VBScript
' Script Name: Add Element to Diagram
' Purpose: This adds the currently selected element to the currently visible diagram
' Date: 11/08/2010
sub main
       Dim currentElement as EA.Element
       Set currentElement = Repository.GetTreeSelectedObject
       Dim currentDiagram as EA.Diagram
       Set currentDiagram = Repository.GetCurrentDiagram
       Dim diagramID
       if ( currentDiagram is Nothing ) then
              Session.Output("No Current Diagram Selected")
              Session.Output("Adding " & currentElement.Name & " to " & currentDiagram.Name)
              diagramID = currentDiagram.DiagramID
              Dim currentDiagramObject as EA.DiagramObject
              set currentDiagramObject = currentDiagram.DiagramObjects.AddNew("l=10;r=130;t=10;b=82", "")
              currentDiagramObject.ElementID = currentElement.ElementID
       end if
end sub
Initially that worked but after a few Sparx EA versions later it didn't work so well.
So now I have resorted to creating an instance of the ArchiMate element similar to a UML instance of a class. I had to create stereotypes with shapescript for the instance so it looked like the ArchiMate element. I put all the instances of the ArchiMate element under the original in the project explorer. Seems to work but kind of a hack.

Pages: 1 2 3 [4] 5 6 ... 48