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 - ea0522

Pages: [1] 2 3 4
If you are fiddling with regex to change the code, it may be an option to check whether EA can use another character combination to recognise a commented line.
I.e. the '#' character is often used to comment out lines of code...

General Board / Re: SQL Query - extracting tag iformation and headings.
« on: February 15, 2024, 09:29:36 pm »
One option I use very often in these cases is the Excel Import/Export tool of Geert Bellekens (see
It also contains a configuration sheet with SQL you can change yourself which could be used as an example to create the specific export you need.
I, for instance, altered it to only export information on certain stereotypes.

Prolaborate has a promising Lifecycle feature (see
In that documentation is mentioned as a prerequisite that pre-defined date type tagged values must be included for the required stereotype when defining the modeling language.

Now I have a number of ArchiMate 3.1 WorkPackages containing the information on the projects we are working on.
And I would like to use those default stereotypes for showing a Lifecycle Roadmap.
For that I have defined some date type defined tagged values assigned to the elements but they are not recognised when defining the Lifecycle within Prolaborate.

Is it really necessary to define a custom stereotype for using the Lifecycle feature?

Hai Geert,
Thanks for the quick reply.
However, I don't think it will be that simple.

For both versions I have an ArchiMate file which I can transform to a QEA file. So far so good.
But I'm afraid the GUIDs are different from the last import although I can use an ArchiMate guid to match elements.

Even then, when I just import the new version, what will happen with the elements that are removed from the model?
And what will happen with the diagrams? Could they have the same GUID and thus be replaced with new versions?
Could it be an option to split diagrams and elements?

For the business area I'm currently working in, there are some reference models supported by an external party.
About once a year, a new version of the reference model is released.
In the mean time, I have made references from my own elements to elements in the reference model.
Can anyone point me into the direction on how to replace the old version with the new model without losing my own references?

A similar question is asked about two years ago but it didn't get any answer.


General Board / Re: SQL driven matrix profile
« on: January 10, 2024, 01:50:40 am »
You could collect the elements of interest in a separate package and then select the contents of that package as source or target.

General Board / Re: Finding duplicate elements and replacing them
« on: January 08, 2024, 06:50:20 pm »
There is an IDEA add-on that does deduplication on elements and connectors.

I support this request.
Especially because we were used to handling the discussions integrated with WebEA as part of PCS.

PCS Suggestions and Requests / Re: Prolaborate 4 Reports export to Excel
« on: November 23, 2023, 05:30:54 pm »
Export to Excel is also available in Prolaborate 5.0.
However, only to export the list limited to the elements shown (so with a max of 100).
Is this different in 5.1?

PCS General Board / How to leave Analyzer in Prolaborate
« on: November 16, 2023, 11:56:56 pm »
Just starting the exploration of our repository using Prolaborate.
The Analyzer feature looks very promising allowing to analyse all relations and other stuff of an element.
However, I cannot find a button to leave the Analyzer window.

Is there something I'm missing or is it intended to return to Prolaborate via the original login link?

For this kind of imports, I usually use the Excel tool from Geert Bellekens.
See for more information.

PCS General Board / Re: Relationship Matrix in WebEA
« on: October 23, 2023, 11:22:11 pm »
Is this issue addressed?

Looks like it is still the case in WebEA V5.1.

On a diagram I have several objects of the same type and connected with the same connector type.
When I change the appearance of some connectors, they look different.
What I change is the color and thickness. The difference is in the thickness. The color is showing ok.
The effect is in several combinations of element and connector types.
The last diagram I have it, it shows differences between ArchiMate ApplicationComponents and Nodes, connected with Flows To and Serving connectors.

Any suggestions on how to fix this?
Refreshing / reloading the diagram doesn't work.
It even shows the differences in the images generated for the WebEA pages.

Every thing has its pros and cons as a famous soccer player once said ;-)
In our case, the QEA file is the most easy to set up and maintain. Too much of a hassle (and costs) to set up a SQL server.

PCS Frequently Asked Questions / Handling of journal file with QEA on PCS
« on: October 17, 2023, 04:49:37 pm »
We have a PCS environment using a QEA file on the server to store our repository.
This works fine, I just have some questions regarding the journal file created.
What is the algorithm to commit the journal information into the QEA file?
How long will it take for the background proces to do the commit?
Can I force a commit?

Is there a limitation on the direct use of the QEA file while there is still a journal file present?
For instance, can I copy the QEA file for backup or use elsewhere without copying the journal file?

I have a PowerBI connection using the QEA file directly as a source for data.
Can I just use that connection even when the journal file is still present or do I have to wait for the data to be committed?

Just some questions.

Pages: [1] 2 3 4