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 - Rich Anderson

Pages: [1] 2 3 ... 5
Automation Interface, Add-Ins and Tools / Re: Tabular Reports
« on: November 22, 2018, 02:43:34 pm »
For stuff like this, I just write a VB.Net program in Visual Studio Community edtion that populates and Excel workbook directly using .NET calls and some simple looping.   I find I can create pretty much anything I want this way.   

Thanks, for pointing me to these resources.  I also found this library that avoids Interop and writes to the XML files directly, which looks pretty promising as I do pretty much all my scripting from Visual Studio.   

As to querty's question, all I can say is that I have several use cases such as, importing and exporting APQC process libraries (1,800 rows), generating large Excel files to be read in by Tableau (3,000 rows),  generating a mapping table for analysts to map one enterprise chart of accounts to another (2,000 rows), and generating multiple Excel files to ETL into an ERP system for configuration.   Particularly with business analysts when you are generating and capturing large catalogs (a very common occurrence in my world), they don't want things in databases which are strange and foreign objects to most of them. They almost always want Excel.   It would be better if they used EA directly, but this is not always possible.

Hi There,  I'm writing lots of VB.NET code that reads and generates Excel files.  I've just been using the Excel API directly to exchange data between EA and Excel and this works really well most of the time.  However, there are times when I want to generate very large Excel files (thousands of rows) and that gets pretty slow, even when I turn the calculations off and do other tricks.  Writing to a CSV file to be opened by Excel, would be faster but I really prefer the convenience of using the Excel API to do things such as formatting and navigating between rows and columns as I please.  I see that there are some 3rd party APIs that don't have Excel dependencies to do this, so I'm wondering what people have used for this or whether you have a recommendation that I might try.   Thanks for your help.

Thanks Paolo!  That fixed it!   8) 8) :)

Bugs and Issues / DAO.Recordset Errors after File Transfer from EAP to EAPX
« on: September 19, 2018, 06:32:58 pm »
Hi There, I recently migrated my repository to EAPX (Jet 4) using the file transfer utility.  Now, every time I attempt to add a new element to a diagram or a connection between two elements, I get the DAO.Recordset[3022] error that says the change was not successful because duplicate values would be created. I did an integrity check and it comes back clean.   So, I have reverted back to EAP, for now.       

I am using the most recent Release 14.1.

I would like to start using EAPX, if I can, but this is stopping me.  Anyone have any ideas or experience with this one?

When dealing with spreadsheets and interchanging data with EA, I find the best way is to just read (and write) the spreadsheet directly using the Excel API and then do the same to EA using the EA API.   I use Visual Studio with VB.Net (or you could use C#).   Once you get the hang of doing this, you should find that you can handle almost any situation pretty easily because your code can be set up to handle all the different exceptions.   

Hi There,  Just checking to see whether this has been figured out.  (and I have not been able to find any other posts on this topic)  I have a situation where I have a connector that is connected to a class from the connector and would like to get a reference to it, but cannot seem to figure out how to do so with the API. (Although I can get to the 'ProxyConnector' element from the other side) The diagram where this happens look like this.

General Board / Re: Archimate requirement aggregation in EA 14
« on: June 05, 2018, 12:27:10 pm »
I have filed other (similar) bug reports regarding Archimate in EA14 which are being worked.  In the meantime, I have gone back to 13.5.   

Learning how to model for the first time using EA is a bit like learning to drive by starting with an 18 wheel truck.  I usually recommend that people get the hang of modeling using the free Archi tool ( and then come over to EA once the basic principles are understood. You can even export your models from Archi and import them into EA when you are ready.  Clearly that works best when using Archimate, but it has really helped me help people get over the mental barrier between diagramming and modeling.   

Bugs and Issues / Re: EA 14 - Problems with Archimate
« on: June 01, 2018, 09:04:12 am »
Bug acknowledged by Sparx and they are planning to fix in an upcoming build.

Bugs and Issues / Re: EA 14 - Problems with Archimate
« on: May 31, 2018, 06:42:50 am »
AND I will file a bug report.

Bugs and Issues / Re: EA 14 - Problems with Archimate
« on: May 31, 2018, 06:42:26 am »
Thanks for letting me know.  There were some problems in previous builds, but it seems to be worse.   They should be fully regression testing this against v13, which does  a pretty good job of implementing the Archimate 3.0 rules.    These rules are well-documented and shouldn't be hard to test!

Bugs and Issues / EA 14 - Problems with Archimate
« on: May 30, 2018, 10:19:58 am »
I'm getting some different (and very annoying) behaviours when modeling in Archimate with EA14 (Build 1421).   The diagram illustrates this pretty well when I'm trying to use the quick linker to create a simple composition association.   Look at this simple comparison between EA 13 and EA 14 on the same diagram in the same repository.   (!)

I've also had to turn the Strict Connector Syntax off in Preferences because it was preventing me from making perfectly legal composition associations between data objects.   

Something looks fundamentally broken with the way Archimate works in EA14.     :-[

Is anyone else seeing this or am I missing something?

Bugs and Issues / Cannot select dbms when trying to generate DDL
« on: May 29, 2018, 02:04:18 pm »
I'm not sure what's going on, but I'm suddenly not able to select a database when attempting to generate DDL from this window.  I even went so far as to completely uninstall and reinstall EA, but that did not fix it.  Here is an image of the screen where I can't select the database for each table in the list.    This used to work and it would give me dropdown of all the templates.  Yes, I checked and the templates are all still there.

What am I missing?

General Board / Re: System Resource Exceeded on Large Deletes
« on: May 29, 2018, 08:58:18 am »
Hi Guys, I couldn't actually find the registry entries mentioned in these articles. Even searching the registry would not find them.  I think I'll just write a script that recursively goes through all the packages, sub-package and elements and deletes them one at a time.  It seems to me that this should be an option in EA itself. It would be something like "Execute deletes as separate transactions (helpful for large deletes)" with a checkbox.   

Pages: [1] 2 3 ... 5