Book a Demo

Author Topic: csv import export  instances & run-time data  (Read 2874 times)

Tom_Evans

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
csv import export  instances & run-time data
« on: October 20, 2009, 04:19:53 am »
Apologies if my search missed this same topic:
I want to use EA to do Enterprise Architecture - modeling all the connected stuff in the enterprise (vs a design model)

I want to import csv data to create Instances of Classifiers, with run-time data values for their attributes, and export csv data to publish the instances and their run-time values found in packages in my model.  

I am modeling the systems and integrations of a business as instances of two Classifiers:  System and Integration.  I define attributes such as technology, owner, deploymentDate, etc,  and then create instances.  I use Set Run State to set the values for the instances.  I have groups of these instances in specific packages.  The System instances have an association to and from Integration instances.  Thus the full enterprise model - current state and/or future state.  

On import I would be happy to just populate packages and (for now) leave the diagramming to manual effort.

csv col possibilities
PackageName|classifer|InstanceName|UserCreatedClassifierAttributeName1|UCCAN2|UCCAN3...

example file
PackageName|classifer|Name|Vendor|StartDate|BCPReady|...
HRSystems|System|PayrollApp|BigBadSWCo|2001-01-01|Yes

Integrations

PackageName|Classifier|IntegrationName|SourceSystemName|DestinationSystemName|integrationAttrbute1|IntAttribute2|...

Each integration points to a source system and a destination system.
Associations are created between the integration and each system.

Or any pattern for simple data import/export pf any associations - the model could have other Classifiers and other associations - Organization, Capability, DataCenter, etc

I currently use Classes, Objects, and Object Model Diagrams for the instance views.

Already done? Hints?  New product feature award?
Thanks - Tom

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: csv import export  instances & run-time data
« Reply #1 on: October 21, 2009, 04:54:08 pm »
You could of course request a new feature, but then you'll have to be patient. (if it even makes the cut).
If you want a faster solution then I suggest you write a little tool using the API.
Should not be too hard. (couple of days max)

Geert