Recent Posts

Pages: 1 2 [3] 4 5 ... 10
Bugs and Issues / TAM - Incorrect item cloned!
« Last post by Paolo F Cantoni on January 22, 2018, 12:57:13 pm »
We've found what we consider a SERIOUS defect in TAM (Time Aware Modelling).

Scenario:  We have a set of current items, in diagrams in a branch versioned "Curr".

We intend to make a RoadMap branch indicating the "To Be" state.  We clone the Current Branch - which gives us new Folder structure and Diagrams (but not the items) - which is what we want; to a branch versioned "RdMp".  Since we only want to clone items that will change in the future.  We clone an item in a RdMp diagram to version "RdMp".  The item is cloned correctly; so far, so good.

As part of our on-going repository management, every year (at the end of the year) we intend to clone Current into a "Past" "snapshot" that describes the state at the end of that year; giving us the ability to "compare and contrast" over time.  So I select the Current branch and say Clone structure (in this case, to a folder structure versioned "Past").  Again, folders and diagrams cloned, no items, as desired.  This time, however, to achieve our goal of snapshotting the entire Current branch we have to clone ALL the items in the "Curr" version.  We select all the items in the diagram in "Past" diagram (which are all namespaced "Curr::") and say Clone to new version (to "Past").

Imagine our surprise when for the item in "Curr" that had been cloned to "RdMp", instead of getting a new item in "Past", we got the "RdMp" item on the "Past" diagram!  :'(

We confirmed that the original item on the Current diagram was still the "Curr" item and that that item WAS NOT CLONED into Past as a new item.  This is a defect, the original "Curr" item (on the diagram) should have been cloned, not the "RdMp" item (which was nowhere to be seen).  We also confirmed it's not a caching problem since we exited Sparx and re-entered and then cloned the structure. This needs to be fixed urgently!

Thanks, Nabil,

On a related note, say I have previously cloned an item, but on another diagram, I have the original item.  If I attempt to clone that second original item on the second diagram (to the same version as the existing clone), will EA create a new clone or substitute the existing clone for the original item in the second diagram?  Have explained the use case correctly?

Suggestions and Requests / Re: local user favourites or preferences
« Last post by Simon M on January 22, 2018, 08:41:55 am »
a) Enable security. Users can then select their own default diagram.
b) Not available. These settings are common to all users.
Suggestions and Requests / local user favourites or preferences
« Last post by fararooy on January 22, 2018, 05:37:56 am »
Hi all

Using project browser in a multi-user access database, all users are taken to a default project location.

How can a specific user:
a) Set-up its own favourite or default project browser starting position?
b) Customise favourites in terms of even diagram properties, e.g. rather than A4/Portrait, all new diagrams are created in A3/Landscape size/layout?

Thanks, Saeed
General Board / Re: MS Acess SQL Query vs EA SQL Query returns different results
« Last post by yaccoff on January 21, 2018, 04:52:37 am »
Thx Geert. So with a bit of googling, I now have a SQL query that produces exactly the same result (bar 1 annoying entry), and I think its an EA activity consistency issue.

Here's the latest query: I replaced the Nz with IFF(...)

select distinct po.ea_guid as CLASSGUID, po.Object_Type as CLASSTYPE, tEndObj.Name as [Deliverable], tEndObj.Stereotype as [StereoType], as [Object Name]
, IIF(po.Alias Is Null, po.Name, po.Alias) As [Acticity Name], as 'Package Name' , as 'Package level -1', as 'Package level -2', as 'Package level -3', as [Role]
from ((((((( t_package tp
inner join t_object po on tp.Package_ID = po.Package_ID)
inner join t_object to2 on po.ParentID = to2.object_ID)
inner join t_connector tc on po.Object_ID = tc.Start_Object_ID)
left join t_package tp2 on tp2.Package_ID = tp.Parent_ID)
left join t_package tp3 on tp3.Package_ID = tp2.Parent_ID)
left join t_package tp4 on tp4.Package_ID = tp3.Parent_ID)
left join t_object tEndObj on tEndObj.Object_ID = tc.End_Object_ID)
po.Object_Type in ('Activity') and tEndObj.Stereotype in ('NATS_Deliverable') and in ('Enabling Processes', 'Operating Processes', 'Management and Support Processes')

Now thanks to your efforts, I want to incorporate this SQL with the scripted aspects of EA and automate the Excel output.
General Board / Re: Display linked objects on Class element within Class diagram
« Last post by qwerty on January 21, 2018, 03:36:32 am »
You would need to create a shape script with
Code: [Select]
shape RelatedElement. See

This only works for stereotyped classes. And it needs quite some fiddling until you get that working (at least for me it always takes time to tweak my brain to get queer Sparxian thinking adapted to my way of understanding things).

General Board / Display linked objects on Class element within Class diagram
« Last post by kpietrusewicz on January 21, 2018, 02:53:00 am »
Hi All,
Is it possible to show linked (Association, Generalization, others) classes on Class diagram.
I have Class1, Class2, type class.
I am linking them with Association connector.

I want to display only Class1 on diagram.
Is it possible to display (in the similar way as tags, attributes or operations) case that Class is linked with Class1?
Do I need to do some extra programming?

Please help.
Krzysztof Pietrusewicz
General Board / Re: Importing ERwin models
« Last post by Richard Freggi on January 20, 2018, 06:40:37 pm »
I am maybe not the most qualified person to post because my imports from ERWin (circa 2015... I forgot which ERWin version but it was the current one) did not go well.  I followed the instructions in ERWin to export as Sparx EA compatible XMI; all models imported but there were missing relationships so I had to manually correct the imported model, very time consuming.  Tried several times with different formats, still not good.

For me the safest way is to forward engineer the source model, create a database with it (in mySQL, SQLite, Oracle express etc), then connect Sparx to that database and reverse engineer it.

Good luck!
EA SQL == MS Access SQL.

Google has all the answers.

PackageID is not the same as ElementID.
You have to use Package.Element.ElementID

Of course, that worked a treat. Thanks Geert.
Pages: 1 2 [3] 4 5 ... 10