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 ... 48
1
Automation Interface, Add-Ins and Tools / Re: Reverse engineer MDG
« on: December 11, 2018, 07:29:36 pm »
Yeah know how you feel at this time of year. Just about run out of steam my self.
12 sleeps to Christmas :)

Anyway here is a hack in the run up to the holidays for you to create those diagrams for enterprise risk management and security using the standard ArchiMate MDG.

Use the Alias to store the risk type and enable alias and name to be displayed in the diagram. For example
Use Goal and Add "Risk Treatment" in Alias
Use Assessment and Add "Threat" or "Vulnerability" or "Event" or "Impact" or "Risk" to alias field
Use Driver and add "Security Objective"
etc.
Get the idea?
Merry Christmas

2
To do transform select package and from ribbon Design > Tools > Transform > Transform Selection
Apply Transform
Select classes
Select DDL Transform
Click Do Transform button
For detailed description see
https://sparxsystems.com/resources/user-guides/14.0/model-domains/model-transformation.pdf
Try the search its wonderful at finding things :)

3
If the JavaScript is becoming too much effort then an alternative path to get a quick result of  adding PK and FK might be to do a DDL transformation. However that adds new attributes.

4
Automation Interface, Add-Ins and Tools / Re: Reverse engineer MDG
« on: December 10, 2018, 06:18:23 pm »
In theory you could create an XSLT file that transforms the MDG file to an XMI file which can be imported into Sparx EA. Looking at the MDG files its probably going to take someone anything upto a week to two of effort which is probably about the same amount of effort it would probably take to create an MDG that extends ArchiMate.
If its about the same amount of effort then I guess recreating the MDG from a Sparx EA model is the way to go.
 

5
General Board / Re: Are spammers the main users of this forum?
« on: December 08, 2018, 04:22:38 pm »
Bit of a silly question because clearly they're not

6
Suggestions and Requests / Re: Reporting Spam
« on: December 06, 2018, 11:13:09 am »
Clearly you are typing too fast  :)

7
Generally yes you can add attributes using tagged values. Three ways to do this add them manually one at a time.  Write a script to add them automatically. Create and MDG that extends the stereotype and adds the tagged values.

8
Here is a trick. When translating an object type from one to another try creating that target object type first, then retrieving those values so get to know what values you need. Write the code to put those values you've retrieved into your code to translate the object types. Saves a guess work along with a lot of time and energy.
:)

9
General Board / APQC Process Model
« on: November 17, 2018, 06:51:14 am »
APQC is a process framework for the full enterprise.
Quote
APQC's Process Classification Framework (PCF) is the most used process framework in the world. It creates a common language for organizations to communicate and define work processes comprehensively and without redundancies. Organizations are using it to support benchmarking, manage content, and perform other important performance management activities.
https://www.apqc.org/pcf

For those who have requested it via PM I've published APQC process model on Git hub.
https://github.com/EASunshine/Sparx-EA

It utilises a custom Enterprise Architecture MDG that is also located there so you need to copy that into a folder and reference it via the MDG dialog set up in Sparx EA to get a proper view of the diagrams.
You also need to change preferences to show both alias and name to see both the ID and name. The ID is in the alias.

To access the metrics you need to enable the metrics window and you will see them when you click on certain process elements.
Enjoy  :)

10
General Board / Re: How to create a "click-through" object in a diagram
« on: November 17, 2018, 05:56:48 am »
Child diagram is the thing you want.

11
Bugs and Issues / Re: Mysql model changed
« on: November 16, 2018, 11:52:32 am »
Kind of looks like the parent_ID or package_ID in the table t_object may have been corrupted in someway.

12
General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 02:55:18 pm »
Backing up before resetting the IDs is a good move. Exporting to XMI will work to a point as it will export the model elements and their connectors along with the diagrams. But it won't include other stuff like alternative images or model defined stereotypes etc. Can you not just backup the SQL server? You should have at least a daily backup on that SQL server surely.  Alternatively a transfer to eapx or feap file would be more complete back up. You could try the reset ID on the eapx file then transfer back to SQL Server as an alternative course of action.

Didn't think Reset ID's would take that long. Pretty sure when I did it a while ago it only took about 10 min for a few hundred thousand elements.
Not sure about whether its one transaction but if something does go wrong you've got your backup.

13
General Board / Re: Got stuck on Check Integrity
« on: November 15, 2018, 06:55:19 am »
I change from .eap to SQL Server for more stable behavior. It turns out to be true.

However, now I got a problem that I cannot overcome:
When transfering from SQL Server to a local .eap I get "Unrecognized database format" if I try to open the .eap file. And it is true: I expect a size of ~100MByte and get 12kB as the size of the exported .eap-File.
I've gotten that error and its to do with eap and eapx where the latter is Jet V4.0 engine and the former V3.5. The older versions of Sparx used to open both even if it was named eap. However you seem to get that error now when opening a Jet 4 db when its got the extension eap. Found by renaming it to eapx it worked ok.
When doing Check Integrity/Project Integrity on the model in SQL Server I am left with one problem: Invalid Realization Stereotype. ITEM: . ACTION: Updated Applies To.

Any time I try to Recover/Clean I get a SQL Server failure Violation of PRIMARY KEY constraint 'pk_stereotypes'. Cannot insert duplicate key in object 'dbo.t_stereotypes'. The duplicate key value is (realization, realize).

What would be the next steps to solve that problem? How can I find the stereotype that caused it?
Sounds like the primary keys have gotten into a bit of tiz. Try reset IDs - the next option down from project integrity

15
General Board / Re: Kanban MDG not listed in version 12.1
« on: November 14, 2018, 09:20:44 am »
Yep its confusing reading the wrong version of the manual. Done that before.
I can second that advice to upgrading as KP recommends. Difference is I don't work for Sparx Systems nor do I get any commission so its kind of independent advice if that's what you are after.

Lets face the licence costs for upgrading Sparx EA isn't going to break the bank and you've probably spent that amount of money in the time you took to figure our your problem.

Pages: [1] 2 3 ... 48