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 ... 26 27 [28] 29 30 ... 53
General Board / Re: ArchiMate 3?
« on: June 15, 2016, 02:44:20 pm »
Oh god, they're tried to cope with the cloud at the technology layer.  :-[
Just read the spec but can't see what you are talking about. Care to elaborate?

General Board / Re: ArchiMate 3?
« on: June 15, 2016, 08:03:54 am »
So,  ArchiMate 3.0 is published.  See

When will Sparx support this version?
Good question. I'm interested in the answer too. Would be good if it was in the next release of version of V13 please?

General Board / Re: ArchiMate 3?
« on: June 15, 2016, 07:48:03 am »

General Board / Re: New Beta
« on: June 08, 2016, 02:14:20 pm »
Had a crash on my Apple Mac using Wine but other than than not bad.
Hey, we haven't been able to reproduce a crash on mac so far.

If you wouldn't mind, could you please provide to support your OS and Wine versions along with what you were trying to do?

Was planning on doing so but got distracted and forgot - Thanks for the reminder. Will send you guys as much info as I can on it once I get back on my Apple Mac.

General Board / Re: Enterprise Architect 13 Beta 1 1300
« on: June 05, 2016, 03:25:19 pm »
You wouldn't do it if you didn't like it ;D

General Board / Re: New Beta
« on: June 05, 2016, 03:24:45 pm »
Well had my first spin of V13 Beta.
First impressions are it will be easier to persuade people to use it.
Yes changing the menus to ribbons does mean us old timers have to once again re-learn where stuff is but I think its a positive step in the right direction. After all over the years a lot of people have been saying the menu's need revamping so here we have it.
I also like the new kanban diagram additions think they'll prove to be useful in the future.
Had a crash on my Apple Mac using Wine but other than than not bad.
Good effort Sparx's
Thumbs up from me. :)

We should really find a good way to share shapescripts.

I have written about 100 of them now, but they are all scattered in different profiles in different projects.
Would be nice to have one place that I can store them all, and browse them with an image and description of how they work.

Anyone have a great idea?
I've been sharing all of my code on github, but I'm not sure if that is the best way to go if we want to show an image for each shapescript as well.


I think github is fine for the code.  Nothing stopping there being a blog with pictures that points at Github.

Sounds like an excellent idea. Source forge could be another option. Somethings we could share;
MDG profiles and source models

General Board / Re: ArchiMate 3?
« on: May 31, 2016, 06:55:22 pm »
I concur with Paolo - fool with a tool is still a fool. Choose any language; English, UML, ArchiMate, BPMN etc. and there will be people who can't use them effectively. Sounds like the author of the ArchiMate diagrams you saw fits into that category. Similarly I've seen really bad UML and BPMN diagrams produced that provide no value. On the other hand I've seen lots of people use ArchiMate well and provide real value.

ArchiMate v2.1 is reasonably good for Enterprise Architecture level work to show how things hang together. ArchiMate V3.0 seems like it will be better. BPMN is good for detailed processes and UML good for Solution Design and detailed software design. The trick is to know when to use which and how to blend them together.

A common anti-pattern I see is that people see a modelling language like ArchiMate and use it for the wrong purpose. Kind of like when I was teaching my daughter at the age of 10 some woodwork. She picked up a screw driver to hammer in a nail. ???

If you want to represent an object differently using shapescript here is some code that shows an achimate application component normally but if the diagram has a stereotype of "BubbleChart" then it draws a circle.
I use this for showing a TIME (Tolerate, Invest, Migrate, Eliminate) quadrant diagram for application portfolio management on a bubble chart diagram but represent the same thing as an application component on other diagrams.

Code: [Select]
shape main
defsize(90,70); //

shape bubblename

shape port

shape padding

shape name


decoration component
if(hasproperty("diagram.stereotype", "BubbleChart"))


General Board / Re: Data Landscape Diagram
« on: May 31, 2016, 10:58:44 am »
What do others feel about Glassboy's cool idea about using Component Diagrams for showing how about 100 applications interact with each other in terms of the data flows and documenting application details.

Case of great minds think alike. I do this using Archimate Application Components and Information flows. I call this an Application Information Flow Diagram cos it shows the information flow between applications.

General Board / Re: ArchiMate 3?
« on: May 31, 2016, 10:48:51 am »
Yes I was given an overview of changes to ArchiMate a little while ago and told it was going to be released in June 2016.
Can't say much on details - confidentiality and all that.
Looking forward to it.

General Board / Re: Enterprise Integration Patterns
« on: May 13, 2016, 07:06:53 pm »
Here you go, I created an MDG a few years back. Free for anyone to use, coz thats the sort of guy I am.

Just copy the file to a folder and point Sparx EA to it via the advanced button on the MDG dialog.!28344&authkey=!ADy8vNiywP4KOrY&ithint=folder%2cxml
Next time you open up Sparx EA it should be listed
Hope that helps

Karma points welcome.

Okay after some distractions at work I managed to get back to looking at this particular problem again. Here is what I did to solve it.
  • Installed SQL Server Express and Management studio
  • Created a SQL Repository in SQL Server
  • Did a project Transfer using Sparx EA from eap file to SQL repository
  • Run the script below
  • Did project integrity check just to make sure everything worked ok
  • Did another project transfer using Sparx EA from SQL repository to a new eap file
Code: [Select]
/*Converts objects originally created as classes into packages*/
/*Copy Classes into into t_Package*/
INSERT INTO t_package
FROM t_object
WHERE  ((t_object.[Object_Type])='Class');
/*Update objects with objects as parents in t_packages*/
p.Parent_ID = p2.package_ID
FROM dbo.t_package as p, dbo.t_object as o, dbo.t_package as p2
WHERE (p.parent_id=o.Object_ID) and (o.ea_guid = p2.ea_guid) and o.Object_Type='Class'

/*Update objects with packages as parents in t_packages*/
p.Parent_ID = o.package_ID
FROM dbo.t_package as p, dbo.t_object as o
WHERE (o.parentid=0) and (p.ea_guid=o.ea_guid) and (o.Object_Type='Class')

/*Set t_object table values*/
UPDATE t_object
object_type = 'Package',
package_id = p.parent_id,
parentid =0,
pdata1 = p.Package_ID
from t_object, t_package p
Where  t_object.ea_guid = p.ea_guid AND t_object.object_type = 'Class'

/*Update diagrams parent ids*/
d.Package_ID = o.PDATA1,
FROM dbo.t_diagram as d, dbo.t_object as o
WHERE (d.ParentID!=0) and (d.ParentID=o.Object_ID)

That could work too, but I try to avoid editing the database whenever possible.

You can try this on a .eap file using a generic SQL Client. I've been using the free [ur=]AnySQL Maestro[/url] for this purpose.

Or you can run it through a script using Repository.Execute(SQLString)

Thanks Geert I concur about avoiding the editing the Database whenever possible but in this case I can't see how to do it via the API as it just creates new packages. I tried using MS Access initially but had to upgrade the eap file to MS Access 2010 got some SQL working but Sparx EA wouldn't read it so changed to using MS SQL Express.
Will post my SQL solution shortly

General Board / Re: Is there any solution for Docs Generator (RTF)?
« on: May 05, 2016, 05:23:51 pm »
I've got to agree with Geert and disagree with advice of not using the builtin report generator. I've managed to work with the built in report generator to create 100% of my docs. In fact I've not written a doc for about 5 or 6 years now.  It has been a journey to learn the ins and outs of the report generator but its possible to do virtually anything so long as you use your imagination.

On the other hand it would be nice to improve it with some of the suggestions mentioned earlier.

Pages: 1 ... 26 27 [28] 29 30 ... 53