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 - Geert Bellekens

Pages: [1] 2 3 ... 566
There is actually a table called t_taggedValue table that is used for parameter tags and connector role tags.
They should be able to use it for diagram tags as well.


Good news indeed  ;D


General Board / Re: The mysteries of Roadmaps ... ?
« on: October 19, 2018, 04:51:41 pm »

The roadmap diagram stuff is fairly recent and what I like to call a "sales feature".
It's only true purpose is to allow the sales people to say "Look, we do Roadmap diagrams as well", but it hasn't been thoroughly designed and tested.
It probably only works well for the use case: "demonstrate the feature to a potential client"

As with many of these exotic features in EA (testing, debugging, project management, instant chat, email,...) there are most often better tools on the market for such tasks.

EA is really good as a general purpose modelling tool, and to generate development artifacts (code, database definitions, XSD) and documentation, but outside of that scope I'm not sure it is the best tool for the job.


General Board / Re: Logical Data Modelling in SPARX
« on: October 19, 2018, 03:09:05 pm »

Using Class Diagram for Logical Data Model is pretty much an industry standard these days.

Class diagrams allow for modelling on a higher conceptual level, including things like inheritance, many to many relations, etc..
From this logical model you can transform to a number of different technical model such as XML schema models, relational database model, code (java, C#,...) models etc..

So the transformation to a relation database model is just one of the possible transformations. Also not that this specific transformation probably can't be done completely automatically. Often design decisions have to be made to decide how to transform inheritance (at which level will you collapse into a table) and how to deal with many to many relations.

Typically in a LDM you would use associations for relations between entities (that will be translated into tables) and attributes for relations with datatype.
There is a property IsID that can be used to identify the unique identifiers for each class. This information could be used to create the primary key on the table, but more often than not tables get a technical PK that has not business value. In that case the "isID" information could still be used to create Unique constraints though.


Not really.
You can either use the API like myElement.ElementGUID (see for an API reference) or you can use Repository.SQLQuery() to get your data as a set.

I would probably go for the latter in case of an export. There is a huge difference in performance between the two.


C# and VBscript use the same API, so no  :-\


There is no way to use the CSV export/import definitions from scripting.

What you can do is write your own import/export routine. It is really not that difficult.

I have a couple of export script in my VBScript library:


Bugs and Issues / Re: Timeout on SQL search query
« on: October 18, 2018, 08:38:46 pm »
I searched a bit online on the problem, and it seems like the query timeout is set by the application code.
If that is the case then only the Sparx developers will be able to solve the problem.

Hoping to get a reponse from someone at Sparx.


Bugs and Issues / Timeout on SQL search query
« on: October 18, 2018, 07:11:17 pm »
We are using an SQL Server backend and one of our export searches returning a timeout after a while.
Does anyone know if you can somehow increase the timeout?
When running the same query directly in SQL Server Management Studio we don't get a timeout.

I know I can probably improve the performance of the query by rewriting it, but that is not what I'm looking for.
Optimizing the query would take a non-trivial amount of time, and since it's something we run only once every couple of months, we don't care if it takes 10 minutes to execute.

The query is a bit too long to post here (34.000 characters, 508 lines, the forum only allows 20.000 characters per post)



General Board / Re: Shape Script: print TaggedValue as decoration
« on: October 17, 2018, 11:57:35 pm »
Here's an example of one of my shapescript:
The "TAG" part is part of the syntax. The "condition" part should be replaced by the name.

Code: [Select]
shape expression
if (hastag("compositionExpression"))
PrintWrapped("Expression missing!");

For more example shapescripts see:


General Board / Re: How to put a search query on an element in a diagram?
« on: October 17, 2018, 11:36:57 pm »
You can use an SQL search and then drag the contents onto a diagram.
Or write a script that executes your query and puts the elements on a diagram.


General Board / Re: Search Diagrams and Elements by UserID
« on: October 17, 2018, 11:35:41 pm »
I think for both points you would need the Audit feature.


No, that doesn't exist. Would be a nice feature though.


General Board / Re: Package control without "version control" possible?
« on: October 16, 2018, 08:24:14 pm »
If the SCC link doesn't work you can still do something comparable with the package control.
You can configure it and set the version control configuration to "none".
In this case you can still define a filename and save/load the package from that filename.

If you have users who are sufficiently disciplined than that could work as a form of version control as well.

In v14 they have hidden all the relevant function in the ribbon
Publish | Model Exchange | Package Control


General Board / Re: Stereotypes data
« on: October 16, 2018, 06:22:50 pm »
The stereotype definitions of MDG's are not stored in the model.
They are read at startup and then kept in memory.

Usage of these stereotypes can indeed be found in t_xref


Pages: [1] 2 3 ... 566