Book a Demo

Author Topic: Can I import values of custom attributes from CSV?  (Read 3628 times)

Adrian Cook

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Can I import values of custom attributes from CSV?
« on: December 16, 2009, 07:24:15 am »
Hi folks,

We're planning to use EA on our project and we need to load some requirements and other external data currently in spreadsheets into the tool so that we can trace model elements to them. I've played with the import from CSV functionality but the problem is that it doesn't seem to allow the import of any attributes that are not already attributes of the EA Element type.

I know that I can define custom attributes on an element as tagged values, but that's little good to us if I can't load values for these attributes from an external source (there are too many values to manually input via the GUI). Does anyone have any ideas?

Also, is there a way to export the tagged values on an element to a spreadsheet?

Thanks,
Adrian

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can I import values of custom attributes from
« Reply #1 on: December 16, 2009, 05:48:21 pm »
Adrian,

I would suggest you look at the excel importer I posted on the commity site a while ago.
The attribute "Length" is stored in a tagged value of an attribute.
It should be pretty straightforward to extend that to be able to import other tagged values.

Geert

Adrian Cook

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Re: Can I import values of custom attributes from
« Reply #2 on: December 17, 2009, 05:10:04 am »
Hi,

Thanks for the link to your Excel macro - it shows me how to do what I need to do. Now I just need to write a little VBA code!

Adrian