Book a Demo

Author Topic: Attributes csv import  (Read 9206 times)

DavidM

  • EA User
  • **
  • Posts: 82
  • Karma: +0/-0
    • View Profile
Attributes csv import
« on: November 30, 2016, 08:15:17 pm »
I would like to import a class with attributes from a CV file. I see references to this a couple of years ago and talk about using external tools and scripts etc. I just wonder if there is anything out of the  box"  now with Sparx

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Attributes csv import
« Reply #1 on: November 30, 2016, 08:30:14 pm »
You can use Package/CSV Import for simple cases. The EAScriptLib has a CSV scaffold script you can modify for complex tasks. Or you can use Geert's CSV importer.

q.

DavidM

  • EA User
  • **
  • Posts: 82
  • Karma: +0/-0
    • View Profile
Re: Attributes csv import
« Reply #2 on: December 01, 2016, 03:02:47 pm »
Hi Thanks for the reply.
I do (I think) have simple cases.
e.g.

TABLE NAME   ATTRIBUTE
table1                  field1
table1                  field2
table1                  field3

and so on. Can that be done "out of the box"?

DavidM

  • EA User
  • **
  • Posts: 82
  • Karma: +0/-0
    • View Profile
Re: Attributes csv import
« Reply #3 on: December 01, 2016, 03:14:48 pm »
if not, can you direct me to Geert's csv importer please?

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Attributes csv import
« Reply #4 on: December 01, 2016, 04:34:37 pm »
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Attributes csv import
« Reply #5 on: December 02, 2016, 12:23:20 am »
Hi David,

In case you haven't found it yet on my website, here's the direct link:

http://bellekens.com/2015/10/24/simple-vba-excel-to-ea-importer-v4/

Geert

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Attributes csv import
« Reply #6 on: December 02, 2016, 03:01:00 pm »
If you set the class to null it doesn't know where to put the attributes
Give the class a name and that should go better.

Geert