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

Pages: 1 2 [3] 4 5 ... 11
Automation Interface, Add-Ins and Tools / Re: EA.App in VBA automation
« on: September 02, 2016, 06:25:27 pm »
I haven't tested with EA, but as the first parameter of the GetObject function can be set as "The full path and name of the file containing the object to retrieve"  - this can be used to specify which version to run.

So the issue is knowing the filename for a specific version.  Here are several ideas (I am sure there are more):
  • Search the registry in your code to retrieve the path for the desired version - or
  • Install EA in specific directory that has the version number e.g. "C:\Program Files (x86)\Sparx Systems V12\EA" - or
  • Have a text file which contains the filename which could be read (or use a registry key you could read)
The purest in me would be to search the registry however this is a bit of an overhead.  Both the version number and install path are located under each EA install section within
  • HKLM or HKCU (depending on installation type) \ Software \  (optionally WoW6432Node) \ Sparx Systems \ EA400 \  EA
The relevant keys are:
  • Version
  • Install Path

NB: I haven't installed Version 13 yet so there may be some changes that I haven't seen yet!

My practical approach would be to install with a version number (but that could be too late and prone to omission when updating etc), ...

Hope this helps.

As promised I have done a post with information on how we create non-admin installers

Hope this helps.


I have a non-admin installer for eaForms, which works fine, although without admin rights you need to be careful with updates/uninstall.

I'm out of the office today but if you send me a mail eaforms(at) that will remind me and I'll try and provide the relevant information.

Just to let you know, although you will see an entry with my installation inspector it won't display the DLL information for VisioImporter DLL, even for a working installation. 

I was about asked about this addin earlier today, and upon checking, see that the VisioImporter is not a .NET assembly, it's a typelib, which I don't check for.

The error code indicates an "invalid class string" - so I guess sparx will have to provide insights into how they are loading addins and what could go wrong.  I'm afraid my inspector is based on general assumptions about loading dlls rather than any knowledge of what is actually checked.

I have made some additions to the Installation Inspector (V3) and submit to the community site - which will take a few days.
In the meantime a ZIP file containing the Beta for Installation Inspector V3 can be downloaded at - note: this is a temporary download only until updated on the community site.

I should have noticed that on a diagram the right click properties is equivalent to "Alt+enter" and this combination has always opened the properties page regardless of where the item is selected, and does not fire an event.  I've always used this to open EA properties editor even when eaForms installed.

@Uffe agree that the it would be useful to differentiate real events so that when the item was selected from a context menu I knew that compared with double clicking the element in one of several locations.  However I guess this is probably too deeply established in EAs UI code.

BTW: Clicking a diagram in project browser fires the EA_OnContextItemDoubleClicked event.

I just checked with bld 1226 and EA_OnContextItemDoubleClicked is fired if properties selected in the project browser, but not on a diagram; can't remember what happened before.  But like you I use this to override EA properties in eaForms.... 

Would it be correct that in practice most users working in a diagram would double click?

Suggestions and Requests / Re: Richer note fields (on elements)
« on: June 03, 2015, 06:19:53 pm »
Thanks - updated and see the new option; and mouse operation really useful.

Suggestions and Requests / Re: Richer note fields (on elements)
« on: June 03, 2015, 07:00:19 am »
Hi Simon

You talk about the visual appearance dialog - can you advise where I find this as I can't find the option you refer to (bld 1207).

Also tried the ctrl+mouse in an elements notes window without any effect.  Have I misunderstood what you suggest can be achieved.


Suggestions and Requests / Re: enhance Gantt chart features
« on: February 13, 2014, 02:27:08 am »

Interesting idea - but based on some work with EA and MS Project in the past I'm not convinced that PM's will run towards EA.  However, I'm sure this will depend on the organisation.

Your suggestion prompted me to write this post in which I outline some of my findings/thinking.


Suggestions and Requests / Re: Diagram: duplicate layout
« on: February 08, 2014, 09:31:49 pm »

In terms of your layout - exactly what attributes
position, size, appearance?

nice little AddIn for a tutorial me thinks

General Board / Re: Mysterious history tab
« on: December 09, 2015, 11:35:56 pm »
@Geert -
Over the years I've come to the conviction that EA is the only application a Sparx Systems employee is allowed to have installed

I think you are correct, as supported by the recent article about EA referenced on the community site -

Enterprise Architect was developed with several key design rules in order for project teams to be able to use a single platform ...

Personally I've tried to adopt/test the single platform approach, depending on projects, with the aim of keeping all knowledge in one place, including using the project management stuff(!).  However, I've rarely fully succeeded - in part because I've got frustrated with trying to work out how it's done (or should be done) with EA.

I think it's a pity we are all so reliant on the forum for documentation and support, and that there isn't more DETAILED information with real world (industrial sized) examples available from Sparx on using EA.  I'm just grateful for the few stalwarts who provide great support to the forum.

I'd be really interested to understand how EA could truly be used as a single platform (a key aim of EXploringEA), if only to get Sparxs' view of best practice of how the bits in this ever expanding tool should work together.  And although I suspect it will be difficult to deploy for many projects, it could at least provide a clear vision of what could be; but I guess that would be a big undertaking for Sparx :-?

General Board / Re: Project Management Using EA
« on: November 12, 2015, 02:11:12 am »
Hi guys

I know this is an old post, but came across the same issue with trying to produce a gantt with the tasks output as ordered in the package.  As stated the tasks are listed in alphabetical order. Is there a way to preserve the defined sort order?


General Board / Re: Unable to Obtain Table Information
« on: June 02, 2015, 05:03:09 pm »
Thanks to qwerty, who did a check to verify that it was my issue, so on further inspection I found I had used a wrong odbc driver combination, so with some new drivers downloaded from MS all working.  

I managed to use an mbd driver for an Access 2007 format file which worked fine in terms of importing the schema but not executing SQL.

@Roy - thanks, yes the latest chm for V12 has a few more pages on the database builder, so a little clearer.

And so now back to exploring this new feature of EA :)

General Board / Re: Unable to Obtain Table Information
« on: June 02, 2015, 06:01:17 am »
Sorry - I'm using Access 2007 (accdb).
My test copied an eap file to accdb which seems to work fine.  The one conversion error I got was "The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions." But the tables looked fine and schema imported OK.

But then my joy of playing slowly disappeared :-?

Hopefully you can shed some light on the issue.

General Board / Unable to Obtain Table Information
« on: June 02, 2015, 04:50:27 am »
Started to check out the database builder.
Managed to set up connection and import schema all OK for access database. But then when I use the SQL Scratch Pad with simple SQL query e.g. SELECT * FROM t_authors

I get the message "Unable to Obtain Table Information" and no visible clues to what the error is.  I have tried various syntax changes as it states no pre-execution validate e.g. SELECT * FROM [t_authors] and making all caps but no clues on what's not working.

Seen in past post issues with ODBC drivers, but using 32-bit and that's all OK since the import worked OK; guess that's proof.

Anybody an idea of solution or where more information is logged that may help resolve.

Is there any more documentation on using the database builder than the single page in the CHM file?


Pages: 1 2 [3] 4 5 ... 11