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

Pages: [1]
Hi Eddy,

I too had this issue so glad it's not just me. If you get no response maybe we can think about logging a support ticket with EA?

My workaround is to not use EA for document generation. I am a software developer, so have used c# to query the database for my requirements and to export any diagrams. I am now trying to figure out the best LaTex format to generate the PDF documentation or will use Word Automation if I cannot get the exact format I require.

My original issue was here:,39060.0.html

To follow on from Geerts response, I just want to ensure you are indeed trying to query an EAP file outside of Enterprise Architect?

If this correct then an EAP file is actually a MDB file in Access97 format. You will not be able to open this in later versions of access until the underlying database is upgraded to an Access 2000 MDB file structure. Also note, that updating the database will now make it unusable to Enterprise Architect.

However, you can query this database directly from within EA ( version 13.5 used here)

  • Start EA and open your model
  • CTRL+F to bring the find dialog up
  • Click the magnifying glass and give the search a name
  • Click Query Builder and you now have the SQL Scratch pad available
  • Query should be select * from t_object, remove t_object and type t then use CTRL+SPACE this shows all the tables

Hope this helps if this is what you are after, if it's not, please expand on what you are trying to achieve.

Bugs and Issues / Re: Orphaned EA.exe process - Interop.EA.dll [Solved]
« on: January 04, 2018, 12:58:33 am »
damn! did not see that function even though it was in my face  :P

And yes, that does solve the problem as well

Bugs and Issues / Orphaned EA.exe process - Interop.EA.dll [Solved]
« on: January 04, 2018, 12:11:26 am »

I am trying to automate the generation of my own documents by using a hybrid repository to walk all the required tables and assemble the required records.

This all works well, but as soon as I use EA.Repository() to save images, after my application finished, I have rouge EA.exe processes still running.

Is there something I am doing wrong so that the COM API closes the EA instance it has opened?

This is my code. Normally I let GC run in it's own time, but just forcing in-case it was the GC holding some COM lock. Please note this is EA 13.5.1352 Professional Edition

Code: [Select]
        private void ExportDiagrams()
            var eaRepos = new EA.Repository
                SuppressEADialogs = true,
                SuppressSecurityDialog = true

            foreach (var d in Diagrams)
                d.SaveImage(options.WorkingDir, eaRepos);

            eaRepos = null;

        // inside my Diagram class...
        public void SaveImage(string dirName, EA.Repository repository)
            var pi = repository.GetProjectInterface();
            pi = null;

Thanks @qwerty! I did not need to read all your books to get a handle on the DB. But it gave me enough tips to figure out the API calls.

I have used a hybrid repository that queries the MDB directly to create a treeview of packages and diagrams. I can then select a diagram and export that to a JPG thus minimizing the slow EA API COM calls.

This simple POC has most of what I need to think about how to automate my documentation generation. I am now very glad I chose EA as I can use the tool to create all the UML I require, in a hierarchy that I want, and my own custom tool-chain to generate the documentation that I want in a format that I choose.

@qwerty - I bought your books and have "upsized" the access db to SQL Server to poke around the tables. Once I get the general structure of the DB I will be able to extract what I need. Your scripting book should hopefully answer some API questions around how to actually get EA to "export" the diagram to a non-vector based file format like jpg/png/tiff or whatever.

With all that completed, then doing the automation should be fairly simple. On another note, I will never use perl again! While at one time I could read files without a manual, those days are long gone, so a nice structured easy to read language like C# or Java will suffice in my automation needs :)

Hi qwerty,

Thanks for that resource would have loved to seen your perl script to see the complete end-to-end result. I used to be a data warehouse consultant so am comfortable trying to reverse engineer relationships.

Anyway, because you have done it, i believe I can do it :) I think I will consider the documentation generator as being flawed in some areas and strive to write my own.

Ok, leanpub it is and down the rabbit hole I go [hopefully the back-end data structures are easier to understand than the EAUI :)]

thanks qwerty

an old unix head here so l was thinking LaTeX as well then can output to various mediums. as a developer for over 20 years i dont mind cutting code and piping commands together. would love to see how you do that end-to-end so that i can get these leanpub book bundles and really understand how to "gain the upper hand" with EA so too speak :)

how do you do that! would love to know how to generate my own docs. i suspect scripting and some automation will be the key here

Hi q,

Yes that all works, but the diagram does not come out in the documentation generation. I attached the XMI into pastebin incase I have not setup my package correctly and it needs a proper "EA Way of doing things" to work :)

On another note, want to purchase your books but not sure if EA for the BA is for EA newbies like myself....

Hi qwerty,

Afraid that does not work either. I get the "glasses" symbol (i guess means linked?) but still no output on generation.

<strike>I would love to attach my sample ea file but I cannot attach documents in this forum.</strike>

Pastebin of exported XMI incase I am doing something wrong in my project setup:

Hi Nizam,

Thanks for the fast response.

Set the statemachine diagram as the composite diagram under the chosen requirement (Right Click -> New Child Diagram -> Select Composite Diagram)

I have no new child diagram in 13.5 but have Add=>Select Composite Diagram=>Choose the diagram. This did not generate the diagram in any output from either the  "Specification Manager List" or "Requirements Report - Details" templates.

Will try to understand the template fragment method.

General Board / Specification Manager - Child Diagrams And Embedded Images
« on: December 31, 2017, 06:34:17 pm »

Forgive my ignorance as am new to EA and am having some issues with the specification manager.  While I can create the hierarchy of requirements, the issue I am facing is trying to get embedded diagrams in the published output, or to add custom image(s) to the output.

I have tried to follow the EA User Guide but have failed to get either a state machine diagram or a copy-and-pasted object into the notes to be exported during the publish.

While usually not a fan of the dummies books, it seems Sparx Systems EA for Dummies is just what I need to understand this software as I am finding this are just not clicking with me yet. I usually don't consider myself unintelligent, but this is the first time I have had a piece of software where I don't just click into understanding how to drive it.

If anyone can give me pointers, or even a short list on what to do to get the expected output, I would be extremely grateful.


I want to achieve something like as follows. NOTE: It would be great if instead of linking to a diagram in the model, if I could also paste a custom image and have this in the output.

  • Create a new package called Diagrams
  • Create a new package called Requirements
  • Add a new Requirements Diagram to the Requirements Package
  • Use Specification Manager to create a hierarchy of elements i.e: 1.0, 1.1, 1.2, 2.0, 2.1 etc..
  • Add a new State Machine Diagram to Diagrams package
  • Implement a basic state machine
  • Link the State Machine to any node in the requirement hierarchy
  • From Specify in the ribbon, Click Documentation=>Generate Documentation=>Generate
  • Open the DOCX and find the state machine diagram in there (or an embedded image)

Bugs and Issues / Webpage Wireframe - Table Control - ReOrder Columns?
« on: September 15, 2017, 12:31:08 pm »

Is there an easy way to sort the columns of the table without having to destroy columns to put things in the order you require for your technical specifications?

I tried to edit the memo note XML directly, but that did not work.

Any help would be appreciated as surely I am not the only one to have this requirement?

General Board / Re: UML-ERP Workshop with EA - 100% Completed
« on: July 24, 2017, 02:50:00 pm »

I have only just purchased EA and also purchased your book hoping to get a quick start to using the application.

Unfortunately, I found your document hard to understand. It feels like I purchased your generated documentation rather than information on how to setup and create a project in EA in relation to building up the requirements, use cases and other diagrams and how to link them together. As well as how to create your own document templates so that the published document is just to your needs.

So what I found is that it's 39 pages of high-level things like naming standards and 505 pages of your generated output.

Your information: "This book helps you design an application with the UML modeling tool, Enterprise Architect." is actually not 100% true in the way that I saw it.

Sorry for what seems like a negative post, but as a complete newcomer to EA this book does not offer the "step-by-step & best practices" help in designing an application in EA.

I still thank you for supplying this information and I know there is possibly some hidden gems in this document - plus I do work with Dynamics AX development so understand ERP's.

Pages: [1]