Book a Demo

Author Topic: import a csv table with own collumn header  (Read 12346 times)

Eckard Klotz

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
import a csv table with own collumn header
« on: June 20, 2013, 07:02:50 pm »
Hello Everybody.

Since a long time we develop software for vehicle electronics, what means a lot of knowledge how to design this kind of software is already existing. Now we want to display this with UML as base for a redesign.

A lot of various data has to be exchanged between diverse modules. Currently we plan to describe this with interface-classes which contain some attributes with simple data-types. This will be done by hand but since we already have tables which contain the names and types with some more information it will be extremely helpful if this tables could be imported some how. Unfortunately all this tables have their own identifier format. Some of them will be written in excel others are created by tools. One example may be our CAN message description file created by the dbc-editor tool from Vector-informatic.  

How ever is there a tool in the Enterprise Architect (version 9.2.921) that enables to load a text-table with its own column-headers to provide the content as database for copy and paste actions?

Best regards,
                    Eckard Klotz.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: import a csv table with own collumn header
« Reply #1 on: June 20, 2013, 11:03:51 pm »
You can either try the native CSV import, or you could have a look at my Simple VBA Excel to EA importer v3
That should give you a basis to start from.

Geert

Eckard Klotz

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: import a csv table with own collumn header
« Reply #2 on: June 20, 2013, 11:27:48 pm »
Hello Geert.

 Thank you for your tip I will try it out.

Best regards,
                    Eckard.

Eckard Klotz

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: import a csv table with own collumn header
« Reply #3 on: June 21, 2013, 01:07:44 am »
Hello Geert.

It took a while to learn how to use it. At the beginning the used description-language in the example-tables confused me. Thus I didn't recocnize that they where part of an example.

But once I just added my own content it worked . And in the meanwhile I'm able to add own property-tags.

I think this was a very good tip. Thank you very much.

Best regards,
                    Eckard.