Messages

1

Automation Interface, Add-Ins and Tools / Re: No values using reporttemplate

« on: July 04, 2025, 07:32:09 am »

My first thought was possibly filters however, as you've eliminated that then other sources of that problem could be.
a) Not selecting the right package for the template to generate the information from.
b) Some kind of corruption in the model. Perform a integrity check to correct.

2

Automation Interface, Add-Ins and Tools / Re: Importing CSV Columns into EAUML::table Stereotype Tables

« on: May 29, 2025, 07:19:01 pm »

If I've understood correctly you want to model the oracle database so why don't you just reverse engineer the oracle database
 using functionality built into Sparx EA?
https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_domains/importdatabaseschemafromod.html

3

Automation Interface, Add-Ins and Tools / Re: v16 Database Builder does not read VIEW COLUMNS from Oracle DB

« on: May 24, 2025, 12:05:10 pm »

Have you tried a different option to connect to Oracle DB. I have a distant memory of reverse engineering an Oracle DB which didn't import everything I was expecting and the solution was to use a different way of connecting to the DB. IIRC it was either a version of the driver or ODBC vs OLEDB.

4

General Board / Re: Applying custom stereotypes

« on: May 24, 2025, 11:48:42 am »

Thanks for trying that out @PDC. I now see where the cause of the problem. In V17.0 and V17.1 there is no option to select Profile = 'None' thus local stereotypes in the model aren't listed.
In this case I was just wanting to try out a complex shapescript on a stereotype and so just adding the stereotype to the model so I could rapidly see the effects of the shapescript.

The shape script associated with stereotype was eventually destined for our ArchiMate Extension MDG which works fine as I can select the perspective and the profile to see the stereotypes.

I did try all the potential combinations of perspectives and profiles with no luck thus posting to this forum.

Looks like a bug to me so I'll raise a bug report in the near future.

5

General Board / Applying custom stereotypes

« on: May 21, 2025, 12:26:56 pm »

I added a custom stereotype to class using Settings > Reference Data > UML Types > Stereotypes as directed by the guide
https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_languages/creatingcustomstereotypes.html
However, when I try to apply the stereotype I can't see it because they are filtered via perspective. I've tried changing perspective to different settings but still can't see the stereotype I created to apply to the class.

Using V17.1. Any help would be appreciated.

6

Automation Interface, Add-Ins and Tools / Re: Updating Table and Column Descriptions with Scripting

« on: May 15, 2025, 05:48:54 pm »

Just saw your message a few minutes ago.
IIRC as its was back in 2020 since we wrote the C# plugin I believe the diagrams turned out to be too difficult however we dragged all the elements on to a diagram in Sparx EA then ran auto layout.

7

General Board / Re: How to export a diagram to draw.io?

« on: March 16, 2025, 07:54:36 am »

I asked Copilot

"I need to export BPMN diagrams from Sparx Enterprise Architect to drawio BPMN format and then re-import them. Can you suggest any AI tools that can help with that problem?"

and it gave this answer

Exporting BPMN diagrams from EA is usually done by saving out an XML file in a proprietary or semi-standard format. The challenge is then to transform that into a draw.io–compatible BPMN XML. Although there isn’t a single "one-click" AI tool to perform this end-to-end conversion, combining the strengths of these AI tools can help you:

Draft and iterate transformation code: Use Copilot, Codex/ChatGPT, or Tabnine to generate and refine your conversion scripts.

Debug and Optimize: Leverage CodeGuru and DeepCode to ensure your code is efficient and robust.

Visualize and validate XML structures: Utilize XMLSpy and BPMN.io to compare input/output, making sure all BPMN elements are correctly mapped.

Innovate with custom pipelines: If off-the-shelf tools don’t fully cover your needs, consider developing a custom AI conversion model using frameworks like TensorFlow.

This layered approach should empower you to build a reliable export–transform–import pipeline between Sparx Enterprise Architect and draw.io..

Would you like a deeper dive into one of these tools or even a sample transformation workflow diagram to illustrate how these components might interact?

I love how AI tools can do all this research in minutes.

8

General Board / Re: How to export a diagram to draw.io?

« on: March 16, 2025, 07:42:50 am »

At present I don't believe that is possible unless someone writes plug-in to sparx thats exports and even imports for two way sync. Whilst you can save as SVG and import into drawio it won't be the same as creating BPMN diagrams in drawio so the user experience will be awful trying to move text, lines and shapes around from the svg import as they won't be the BPMN shapes and connectors.

Whilst Prolaborate allows some integration between Sparx EA and confluence which happens to use drawio I don't think the diagrams are anything other than graphics exported as an image. Thus not allowing editing with drawio.

A while ago we had the same problem with business using visio to draw BPMN process and that was partially solved by Visio importer for Sparx EA. However, that wasn't two way synch so continued updating in Visio just created more diagrams and objects in sparx ea when re-importing rather than updating.

One possible option that you may wish to investigate is the use of AI to translate BPMN exported from Sparx EA to drawio format. One of my colleagues was experimenting with Claude to do some similar translation from xml using xslt to mermaid format.

So unless someone creates an exporter from Sparx EA to draw IO you may have to resort to manually re-creating the diagrams in drawio. If you wanted to re-import them into back into Sparx EA you could save them as visio then import into Sparx EA using visio importer.

Hope that helps.

9

General Board / Re: Converting the Model File to HTML Report

« on: January 21, 2025, 05:37:21 pm »

I can generate both HTML and docx from my local models (*.qea files) fine with both V16.1 and V17 so it must be something to do with your model.
Try disabling security on your local model that should clear any limitations you have. You'll need admin privileges and the security key to do that. If you don't have them talk to the person who administers the model.

10

Bugs and Issues / Re: Sparx EA V17 - Printing issues with some elements not showing text.

« on: January 15, 2025, 05:48:05 pm »

I've now raised this a bug with Sparx Systems.

11

Bugs and Issues / Re: Sparx EA V17 - Printing issues with some elements not showing text.

« on: January 15, 2025, 05:15:39 pm »

One thing I discovered is that the issue of element text not being printed appears to be connected to whether or not the diagram has been set to the diagram setting "Scale to 1 Page". If this is not set it appears to print okay. Weird right?

12

Bugs and Issues / Sparx EA V17 - Printing issues with some elements not showing text.

« on: January 15, 2025, 01:09:26 pm »

Just moved over to V17 build 1704. Everything seemed fine until I tried to print a diagram where some elements but not all on the diagram didn't print the text for the element. Its worth saying I didn't have this problem with V16.1. The print issue is a bit of a weird bug as its not consistent. I have some other diagrams with the same elements on that print okay. I've event tried copy and pasting the problematic elements from the diagram that printed fine to the problematic diagram and still those elements don't print the text.
Has anyone else experience this problem?
Does anyone have any ideas what could be causing it?
I'm using ArchiMate BTW.

13

General Board / Re: Model Integration for Microsoft Office

« on: January 10, 2025, 12:38:56 pm »

I've used it on both V16.1 and V17 seems to work ok. The only gotcha is to make sure you use the same 32/64bit for all the components like Sparx EA, MS Office 365 and the MDG Office Integration.

14

General Board / Re: Merry Holidays to all!

« on: January 09, 2025, 07:46:30 am »

Belated Merry Christmas and a Happy new year.

15

General Board / Re: Script Library Templates

« on: December 21, 2024, 09:58:52 am »

Sounds like you've looked at changing the scripts where Sparx is installed to update the local scripts. For example look at the following location for JavaScripts and assuming its where you've installed sparx enterprise architect.
C:\Program Files\Sparx Systems\EA\Scripts\JavaScript.
However you need admin privileges to do that so assuming thats what you mean when you say you don't have access to them because of IT policy and as you don't have Admin Priviledges.
The other alternative is the create an MDG similar to EAScriptLib and put that file in a location that you can reference from the MDG settings dialog. You can use this technique to share script libraries across models.