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

Pages: [1] 2 3 ... 55
PCS Suggestions and Requests / Prolaborate Share Link on widgets
« on: December 11, 2019, 07:24:35 pm »
It would be useful to have the Share Link option on a dashboard widget like a chart.

PCS Suggestions and Requests / Prolaborate Graph preview
« on: December 11, 2019, 12:58:51 am »
When I work on a SQL Query chart, it would save me time to run a preview on the chart without having to save and go back to the dashboard.
The Chart Preview in the Customize screen settings only provide illustrative data on the defined level coloring.
It would be nice to have a See Chart Preview on the Build Chart screen to test the query (or the designer if used). I find that even a query tested in EA may fail when run in Prolaborate due to its specific use there.

PCS Suggestions and Requests / Macros for Graph queries: package branch
« on: December 10, 2019, 10:57:22 pm »

Working on SQL custom searches in EA, I can use the #Branch# macro to get the list of package IDs from the selected package in the Browser.
It would be useful to have a similar macro in Prolaborate with the Package ID or GUID as the input parameter to select its full branch.

Is this feasible?

In the meantime, I added to my query the following condition: WHERE source.Package_ID IN (1,2,3) but this doesn't work. "WHERE source.Package_ID = 1 or source.Package_ID = 2 source.Package_ID = 3' works ok.


PCS Bugs and Issues / Prolaborate empty enum tagged value bug
« on: December 10, 2019, 09:19:06 pm »

I'm testing with a client an MDG on Prolaborate via the modeling languages feature. A stereotype has a number of enumeration tagged values (e.g. Type = A,B,C - no default value set).
When opened in EA, a stereotyped element doesn't yet have any value/selection for these tagged values. However Prolaborate displays the first entry in the list ; it should display a null value (and we also want to reset a tag a null as in EA when the tag can be updated via Prolaborate).

Tested with Prolaborate 3.2.4

Automation Interface, Add-Ins and Tools / Re: GML MDG
« on: December 09, 2019, 11:50:33 pm »
The link no longer works but I found a project here:
Where it contains relevant models related with these standards, I couldn't find a set of class to fulfil the above need.

If anyone has used GML, or if Sparx has a view on this, I'm interested.

Automation Interface, Add-Ins and Tools / GML MDG
« on: December 09, 2019, 11:03:16 pm »

This is a GML specific question: I started using the GML MDG to create an Application Schema.
In a FeatureType class, I can create attributes and set the type. Is there a way to select an existing GML type e.g. gml:AbstractSurface (

Or do I just need to manually enter "gml:AbstractSurface" in the attribute's data type?

The aim is to generate the GML Application Schema file (EA Help:


Suggestions and Requests / Dynamic Legends: text color support
« on: December 05, 2019, 12:17:42 am »
In EA 15, Legends have been improved so one can set a different value to check if an elements matches the condition from the displayed value
For instance if you set Apply auto color on the Class alias, you can set 1 in the Alias and display "Type 1", etc.

I can define the fill color, line color and line width. It would be useful to specific the text color e.g. white, black, red...

Suggestions and Requests / Multiple selection of RTF templates (to delete)
« on: December 04, 2019, 07:17:18 pm »
It would be nice to be able to select several templates in the Resources tabs to quickly delete them. I have a project with several templates to remove individually.

Bugs and Issues / Re: Missing FK in SQL Server DDL Import
« on: December 02, 2019, 06:48:49 pm »
Thank you for your replies. It appears that the DBA found some mistakes in the delivered schema so I'm waiting for a new file to test. Hopefully it will sort the few missing FK that I found, and confirming that it's not related with EA :)

Bugs and Issues / Missing FK in SQL Server DDL Import
« on: November 30, 2019, 12:53:30 am »
I ran a DB import from a local SQL Server DB and noticed that FK associations between tables are missing.
Creating a DB schema in SQL Server Management Studio, I can see all associations with 3 that are missing in EA. Is this a known issue?

In my ODBC DSN, I'm using the following ODBC driver: SQL Server native client 11.0 (SQL Server is v13.0). I also ran a test with the SQL Server 10.00 driver.

General Board / Re: RTF Generation: display tagged values only is populated
« on: November 29, 2019, 06:52:17 pm »
Thanks for the hint Geert. I'll give it a go.

Thank you all for your replies.

Sunshine: the XML comes from a custom tool so I have to address it via a specific solution (otherwise I indeed have a look first for existing 3rd party tools, although for other projects the license cost was much higher than the cost to develop a custom solution... but that's a different subject)

My script already uses whenever it is possible DB updates via the Repository.Execute method as it's improved the execution time (compared with the API).
From what I've gathered, C# seems to be a good candidate to address the XML processing.

If I get to build a similar solution with C#, I'll update this thread with the resulting performance.

Automation Interface, Add-Ins and Tools / Best language for bulk updates?
« on: November 29, 2019, 02:12:21 am »

I'm not sure there is a proper response for the following question...
Consider having to create and update multiple elements in your EA project by processing an external XML file (generated from a third party tool), including in depth synchronization.
I was wondering if there is any script language running in or outside EA that would be the most suitable and make a difference in terms of performance.

JScript in EA
Javascript in EA
Powershell (outside EA)

Or will they all more or less perform more or less the same?

General Board / Re: RTF Generation: display tagged values only is populated
« on: November 29, 2019, 02:05:56 am »
Hi Geert,

I managed to get it to work with a small SQL fragment. Down side is that I have as many SQL fragment as tagged values I need to generate but it does the job.


PCS General Board / Prolaborate Default group
« on: November 27, 2019, 03:36:09 am »
In a repository, there is a Default user group. What is it for and why can't I delete it? Is there a specific use?

Pages: [1] 2 3 ... 55