Topics

1

General Board / Script does not work on Non-Selecteble objects

« on: November 21, 2023, 10:15:54 pm »

Hi. Have a lot of old Archimate2 diagram and objects.
When running the standard transformation script Archimate2 -> Archimate3 , it does not change object that are Non-Selecteble.
Anyone knows how to change that in a script??
Have several hundreds diagram and manully check each diagram and all object its a nightmare, that I dont whant to do

2

General Board / Whant diffrent text for objects depending of report type

« on: November 11, 2023, 07:28:06 pm »

We have an Application catalog based on Archimate_Component in a structure based on bussiness capability.
The Notes field have an short description of the systems capability.
Severel Tags of diffrent information
But, where should we but in an longer and more description text for each app/system?
- as linked dokument?
- a Tag field?
- other solutions?

The purpose is to generate an it-landscape document for every time we are in an procurment phase

3

Bugs and Issues / SQL error after PC wakes up from Sleep or Hibernate

« on: August 20, 2023, 08:35:12 am »

Anyone having SQL-connection problem when CLient (EA 16.1 &4 bit om Win10 & 11) wakes up after sleep or hibernation??
Problem ocurs  only in v 16.x, did not occurs in EA v 15. Have to terminate Sparx EA program execution with Windows Task kill.
Using MS SQL DB-server. (We are about 50 users with same problem with just EA v 16.x ) Other users (35.000 with 800 apps have not this sleep & hibernate problem at all)
Have reportet as a error to SParx support but no replay after 3 month, still under investigation.....

4

General Board / Any tips & trix how to get an report of users i ms-SQL repository

« on: April 14, 2023, 07:59:21 pm »

Halloy.
We have about 65 users i ouer ms-SQL repository in 15 diffrent user groups.
Is there any doc-template or SQL-script that can list users och groups för possible export to excel & document printout

5

General Board / Automatic glossary list based on report content

« on: December 31, 2022, 03:30:58 am »

Hi. Is there any one knowing how to select (manualy/script) those terms in Sparx glossary used in generated report and got those as glossary list as apendix in generated report?
My whole glossary is about 28 pages when printed, but only 30 terms is used in my specific report

6

Automation Interface, Add-Ins and Tools / How replace duplicated elements to ONE master elements

« on: November 29, 2021, 07:10:39 pm »

In EA Repository we have a lot of duplicated element for same objects.
How to replace those in an efficiant way??
- 3:rd party product (Expensive)?
- Own script (Difficult) ?
- Dont bother hmmm

7

Automation Interface, Add-Ins and Tools / Use Transformation script metod or standard scripting

« on: November 23, 2021, 12:04:49 am »

Have some users using an propritary notation "Prime Arch" that is as Archimate om Steriods .
Now they have some issues and we Wonder how to simply transform those models  to UML and/or Archimate.
By Transformation script or  standard scripting (JavaScript).
Whats easiest method??

8

PCS General Board / What are the Road-map for Sparx EA and PCS & WEB-EA with Prolaborate

« on: September 28, 2021, 08:17:16 am »

Under 2020&2021 we where testing the full stack of PCS&WebEA and Prolaborate.
As system responsible för Sparx EA plattform I help about 50 users with users problems, Sparx EA UI changes in each new versions etc. But as Prolaborate is an orthodox overlay to the Sparx EA platform, I dont understand wy all new stuff as drill down charts, templates and features is NOT stored in same databas and USEFUL for ordinary Sparx EA & Web-EA users.
To use those tools together we need an superuser with some schizofren ability. Or hire 2 diffrent persons with diffrent abilitys.
- Create good looking charts & templates for Sparx EA modellers & Web EA users
- Create by another tool, good looking charts & templates for premium Web users who pays more than ordinary WEB-EA users

Other EA tools may have some separation for Premium & ordinary user groups, but most have same toolbox & common platform.
Its the same problem as MS Office had have with different dev-groups för Word, Excel & PowerPoint. Each product handels MetaData/Tags diffrently and does not support VBA in same way. Completly diffrent anmials but in same zoo.

9

General Board / How model an central system with published interface and attributs and its users

« on: April 16, 2021, 10:33:13 pm »

We have an Central Directory (organizations & users) where consuming systems use diffrent attributes.
Today its documented in an "Huge" Excel" with Interface & attributes as Y-axel and Consuming system as X-Axel and CRUD function in resp cell.

I have imported parts of this excel into Sparx EA
- Interface & Attributes as UML Class object and its published attributes
- Consuming Systems is already in the Repository as Archimate ApplicationComponents
- Was trying a Matrix for the relations, but the Attributes in each class was not selectble in the Matrix, only Class & Consuming Systems objects.....

But the hurdle is: How to model the Consuming system and the attributes that is used for each relation.

The model must be simple to handle for changes & updates in the feature 

10

General Board / Sparx EA - Dropped from latest EA Tool report from Gartner, Pity.....

« on: December 18, 2020, 10:13:21 pm »

https://www.gartner.com/doc/reprints?id=1-24U1NXFZ&ct=201216&st=sb

11

Automation Interface, Add-Ins and Tools / SQL script for a Model View table

« on: October 31, 2020, 09:22:02 am »

Any one  that can give an example how a ModelView SQL-script that selects elements from a specific parent package (GUID) and shows several colums for specific TaggedValues

Please, me and my collegues have not succeded with this task as we are not fluent in SQL

12

Bugs and Issues / v 15.2 1554 Auto Save doent seem to work as good as previes versiones

« on: September 25, 2020, 10:44:41 pm »

Have been using EA from v 12, and is often working from home with VPN-tunnel.
Have been using 15.2 1554 several week and have got several "Crashes" where I was in beleef that AutoSave was working as before.
But when I was changing back to 15.1 1527 it has been no problem.

Any one out there having same problem??

13

General Board / What the benefits of RootNodes?

« on: September 24, 2020, 07:53:06 am »

Ouer Repository is based on 4 different RootNoods (I was earlier in beleef that there was a good point to separate stuff in different RootNodes)

Have used Sparx EA for about 5 years, but Im still strugling why we have RootNods..... Any hidden Gem ??

It only gets in the way for the users and me as administrator:
- Long branches as the RootNod needs the Viewpackets before any usefull modeling stuff
- Cant Publish (HTML report) more than a singel RootNod at same time
- Cant Export/Import more than one RootNod at same time
- and some more issues.....

14

Automation Interface, Add-Ins and Tools / Dynamic Charts how read tagged-values

« on: September 15, 2020, 08:53:55 pm »

Anyone used new v 15 Dynamic Charts with javaScript and can show how to read any TaggedValues??
I have got some SQL script working with old Charts, but now I have to learn all over again.
The examplesfor dynamic charts are all dummies, no use of data from repository ....

15

Automation Interface, Add-Ins and Tools / How create charts that are based on TaggedValues-CheckList

« on: September 11, 2020, 01:06:21 am »

I have used a SQL-script for my Charts based from TaggedValues.
But I have a few TaggedValues based on CheckList type.
With same script I only got 0/o if each checkbox is marked ie 0,0,1,0

How to get each checkbox value with its  Name and Value in SQL-script that is working with Charts

Sql-script för Charts:

SELECT tv.Value AS Series, tv.Property as GroupName
FROM t_objectproperties tv
INNER JOIN t_object o ON o.Object_ID = tv.Object_ID
WHERE tv.Property in ('TaggedValueName')