Author Topic: Easy Interchange Between Excel and EA - Please Give Me Your Opinion  (Read 22294 times)

Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Hi There,   I've been looking for an easier way to exchange "catalogs" of elements between EA and Excel.  Not having found anything that did it the way I wanted, I hacked together this little program which you can see demoed here...

https://www.youtube.com/watch?v=tpvqeNLQnxQ&feature=youtu.be

I'm not trying to make any money from this and I'm happy to give the Visual Studio project to anyone who asks for it.  I'm mostly interested to know whether this is something useful/unique or whether there are better ways to do this that I'm not aware of.  (I did check out the MDG for MS Office, but I found that to be more than I needed).   

Cheers!
Rich Anderson
Urgnt Limited

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13379
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #1 on: September 20, 2016, 04:44:31 pm »
Hi Rich,

A long time ago I have developed an Excel importer (with some VBA code doing the actual import)

The advantage of this approach is that is doesn't require any other tools then Excel, and it is easily adaptable by anyone who known a bit of VBA and is familiar with the EA API. (and I know of a number of cases where this has been done in various ways)

It has been on my backlog for ages to do an export as well, but I've never had an actual use case for it.

This excel has been free and open source since the beginning, so it want you can take it and make something better of it.

Geert

Geert


Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #2 on: September 21, 2016, 06:32:28 am »
Thanks, Geert.  I will check it out.  I think the primary use case for this is when someone using EA is working with others to gather and update catalogs of elements as part of building an enterprise architecture model.   

See some of the standard TOGAF catalogs here (See Section 35.6)

http://pubs.opengroup.org/architecture/togaf9-doc/arch/chap35.html#tagfcjh_75

Sometimes, the easiest way is to get "helpers" to ferret out this information to load into the repository for modeling and those helpers, in many cases, are not going to need or want to use EA.

Rich Anderson
Urgnt Limited

Glassboy

  • EA Practitioner
  • ***
  • Posts: 1367
  • Karma: +112/-75
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #3 on: September 21, 2016, 07:14:57 am »
Sometimes, the easiest way is to get "helpers" to ferret out this information to load into the repository for modeling and those helpers, in many cases, are not going to need or want to use EA.

Sure, until you try and work out what TOGAF means by application :-)

Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #4 on: September 21, 2016, 03:45:12 pm »
Yeah, well I just go with the Archimate definitions, mostly!
Rich Anderson
Urgnt Limited

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #5 on: September 21, 2016, 04:52:55 pm »
Sometimes, the easiest way is to get "helpers" to ferret out this information to load into the repository for modeling and those helpers, in many cases, are not going to need or want to use EA.

Sure, until you try and work out what TOGAF means by application :-)
Never mind TOGAF, what about Fred next door - whose definition is different from Mary down the road...

We've finally got working definitions for Application, System, (software) Environment and (software) Product - which are actually interconsistent (I've just coined a new word...) and sufficiently unique to apply the "Bjelke-Petersen Duck Test" against any proposed item.   Now the HARD part starts - convincing everyone to use these interconsistent definitions.

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

only4thefish

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #6 on: September 22, 2016, 05:03:01 am »
At the risk of sounding stupid, where do I find the EA API, or maybe I should ask what is the EA API?  I've been looking all through the online materials on the website and cannot find any description of API's.

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +54/-3
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #7 on: September 22, 2016, 08:43:23 am »
At the risk of sounding stupid, where do I find the EA API, or maybe I should ask what is the EA API?  I've been looking all through the online materials on the website and cannot find any description of API's.
In the EA help it's referred to as "Automation". There are two parts to it: the Object Model and the Add-in Model. The Object Model allows you to work with an EA repository and the Add-in Model allows you to interact with the EA application.
The Sparx Team
[email protected]

Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #8 on: September 22, 2016, 10:02:01 am »
Hi Paolo, I just tell everyone to use the definitions in the Archimate application layer and get over themselves. Seems to work for me  Too many amateur metamodelers around!

http://pubs.opengroup.org/architecture/archimate2-doc/chap04.html#_Toc371945177
Rich Anderson
Urgnt Limited

Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #9 on: September 22, 2016, 10:03:41 am »
only4thefish,  I found this book to be an essential reference to get started...

https://leanpub.com/ScriptingEA
Rich Anderson
Urgnt Limited

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #10 on: September 22, 2016, 05:10:37 pm »
Hi Paolo, I just tell everyone to use the definitions in the Archimate application layer and get over themselves. Seems to work for me  Too many amateur metamodelers around!

http://pubs.opengroup.org/architecture/archimate2-doc/chap04.html#_Toc371945177
We have problems with the whole Application "Layer".  Once you start getting a mite rigorous, things start to unravel a bit.  Still, if it works for you, great.

Paolo (professional metamodeller  ;))
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Glassboy

  • EA Practitioner
  • ***
  • Posts: 1367
  • Karma: +112/-75
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #11 on: September 23, 2016, 08:12:27 am »
We have problems with the whole Application "Layer".  Once you start getting a mite rigorous, things start to unravel a bit.  Still, if it works for you, great.

Well the biggest problem is it's name :-)  It should be called "Only the things you own the IP for layer (everything else is a technology service)"

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #12 on: September 23, 2016, 10:08:35 am »
We have problems with the whole Application "Layer".  Once you start getting a mite rigorous, things start to unravel a bit.  Still, if it works for you, great.

Well the biggest problem is it's name :-)  It should be called "Only the things you own the IP for layer (everything else is a technology service)"
Actually, we (and I'm not using the royal we) more or less agree (though not the name  :D)

Our "stack"  is split into two parts:
The "conceptual" aspects:
  • Business Motivation
  • Business Planning (ArchiMate Strategy)
  • Business Behaviour (part ArchiMate Business Layer)
  • Business Information (part ArchiMate Business Layer)
  • Business Services (part ArchiMate Business Layer) 
  • Business Applications  (aggregations of behaviour, capabilities, information and services which make sense to consider coherent entities)

The rest (as you say) is"physical" aspects:
  • Technology (as per ArchiMate)
  • Other Physical  (ArchiMate Physical)
The second (physical) part isn't as well defined yet - we're concentrating on the Business side at present.
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Rich Anderson

  • EA User
  • **
  • Posts: 142
  • Karma: +8/-0
    • View Profile
    • LinkedIn
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #13 on: September 23, 2016, 12:38:04 pm »
I used to be a big fan of ABACUS from Avolution because its really great at letting me extend or come up with my own custom metamodel.  So, I spent a lot of time as head of Architecture at a bank doing just that.   Then I started to realize what a waste of time it all was because all we did was argue about semantics while the actual work was left to languish.   Now, I just follow the standards and live within their definitions,even if I don't always like or totally understand them.  Usually I find, after a while, that the metamodels hammered out by standards bodies are better formed than anything I could have come up with on my own.  I'm much happier that way!

Now, there is a small minority of EAs who are perfectly qualified to mess about with metamodels, and I'm sure many of them lurk on this forum!  However, my experience is that most so-called "enterprise architects" are really posers who really don't understand the discipline very well at all. (These are often spotted in the wild as "PowerPoint Architects")  Unfortunately, that doesn't seem to stop them from opining about the ideal metamodel that would only be so perfect if we just made that. one. last. tweak!   (Sigh)

It's a bit like a novice musician trying to argue the fine points of musical notation. (Sorry, dude, but Mozart you aint!)  Fortunately, the music guys sorted this out a few centuries ago, but we, as a group, are probably not that advanced!

... I feel better now, thank you...
Rich Anderson
Urgnt Limited

Glassboy

  • EA Practitioner
  • ***
  • Posts: 1367
  • Karma: +112/-75
    • View Profile
Re: Easy Interchange Between Excel and EA - Please Give Me Your Opinion
« Reply #14 on: September 23, 2016, 01:00:20 pm »
I used to be a big fan of ABACUS from Avolution because its really great at letting me extend or come up with my own custom metamodel.  So, I spent a lot of time as head of Architecture at a bank doing just that.   Then I started to realize what a waste of time it all was because all we did was argue about semantics while the actual work was left to languish.   Now, I just follow the standards and live within their definitions,even if I don't always like or totally understand them.  Usually I find, after a while, that the metamodels hammered out by standards bodies are better formed than anything I could have come up with on my own.  I'm much happier that way!

To this point The Open Group is commercial consortium and The Object Model is a standards consortium.  Neither are a standards group in the same way as ISO, IEEE or government agencies like NIST are.

I make this point because I have seen some amazingly semantically void Archimate of late, with less knowledge being transmitted than your average piece of marketecture.  This is the danger when you ignore your information architecture.  If you want to be old school about it your definitions and meta-model are the conceptual-what box on the Zachman framework.

Quote
Now, there is a small minority of EAs who are perfectly qualified to mess about with metamodels, and I'm sure many of them lurk on this forum!  However, my experience is that most so-called "enterprise architects" are really posers who really don't understand the discipline very well at all. (These are often spotted in the wild as "PowerPoint Architects")  Unfortunately, that doesn't seem to stop them from opining about the ideal metamodel that would only be so perfect if we just made that. one. last. tweak!   (Sigh)

Well if they weren't introverts they'd be salesmen or managers.