Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Tom_Evans on October 20, 2009, 04:19:53 am

Title: csv import export  instances & run-time data
Post by: Tom_Evans 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

Title: Re: csv import export  instances & run-time data
Post by: Geert Bellekens 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