Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: megzari on December 31, 2013, 10:57:58 pm

Title: CSV import Issue for Class diagram
Post by: megzari on December 31, 2013, 10:57:58 pm

Hello,

I have an excel file (or csv file) with this structure (for example):

Package;Class;Class Stereotype;Attribut;Stereotype Attribut;type
Package1;Class11;bz;Attribut11;pk;string
;;;Attribut12;pk;string
;;;Attribut13;fk;long
;;;Attribut14;;date
;Class12;bz;Attribut21;pk;string
;;;Attribut22;pk;string
;;;Attribut23;fk;hexBinary
;;;Attribut24;;integer
Package2;Class21;bz;Attribut211;pk;string
;;;Attribut212;pk;string
;;;Attribut213;fk;long
;;;Attribut214;;date
;Class22;bz;Attribut221;pk;string
;;;Attribut222;pk;string
;;;Attribut223;fk;hexBinary
;;;Attribut224;;integer

How we could generate 2 EAP with 2 class diagrams as bellow in EA10? I have not been able to do with CSV import!
If it’s possible with CSV import could you please explain me how we do it step by step?


Diagram1.EAP contains

Package1, class11 and class12 (with attributs, types and stereotypes)


Diagram2.EAP contains

 Package2, class21 and class22 (with attributs, types and stereotypes)


Thank you for your response.

Best regards,

Title: Re: CSV import Issue for Class diagram
Post by: Eve on January 02, 2014, 09:21:16 am

The built-in CSV import doesn't import attributes.

Various people have done it using automation, you should be able to find something by searching.

Title: Re: CSV import Issue for Class diagram
Post by: Dermot on January 02, 2014, 03:40:58 pm

See the Community site entry for an Excel VBA script to import elements and attributes into EA:
http://community.sparxsystems.com/community-resources/488-simple-vba-excel-to-ea-importer
(Courtesy of Geert).