Author Topic: Tagged Value Import/Export  (Read 4405 times)

ymc

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Tagged Value Import/Export
« on: February 23, 2011, 10:23:32 am »
I'm trying to extend out of the box attributes using tagged values but I couldn't find a way to import Excel data creating elements or export element data into a spreadsheet.
Is there a way to import/export tagged values?

Thanx

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13274
  • Karma: +556/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Tagged Value Import/Export
« Reply #1 on: February 23, 2011, 06:57:23 pm »
The Simple VBA Excel Importer should be a good start.

Geert

ymc

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Tagged Value Import/Export
« Reply #2 on: February 23, 2011, 07:53:19 pm »
Thank you

But how can I use this to import tagged values?
I've tried some ways but they didn't work out.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13274
  • Karma: +556/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Tagged Value Import/Export
« Reply #3 on: February 23, 2011, 08:05:31 pm »
I think the "length" column is translated in a tagged value.
You'll have to modify the vba code to get other tagged values to import.

Geert

ymc

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Tagged Value Import/Export
« Reply #4 on: February 24, 2011, 02:10:59 am »
While using DB, is there painless way to import/export data -especially requirements- with tagged values?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13274
  • Karma: +556/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Tagged Value Import/Export
« Reply #5 on: February 24, 2011, 06:19:49 pm »
I think it's going to be a lot less painful to to use the API then to try an import directly into the DB.

Geert

Kris Nunes

  • EA Novice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Re: Tagged Value Import/Export
« Reply #6 on: March 28, 2011, 05:58:49 pm »
This can be done by using the API as said before, and things work like a charm. I use excel to populate the tag values.

If you are having trouble, please do let me know and I will try to help.

Kind regards,
Kris NUNES

Estienne

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Tagged Value Import/Export
« Reply #7 on: April 05, 2011, 11:30:28 am »
I too am trying to import tagged values for a list of objects.  I ran the excel macro, but it seems to create attributes that are attached to the base object.  That's not quite the same thing, so if someone can point me in the right direction, I would greatly appreciate it.

Simple example:

We have a technology (.NET) that should use stereotype TechnologyComponent.  I want to import the vendor (Microsoft) as a tagged value.

Thanks...

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13274
  • Karma: +556/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Tagged Value Import/Export
« Reply #8 on: April 05, 2011, 01:14:48 pm »
Estienne,

The excel importer was indeed designed to import classes and attributes.
It does however also create tagged values on those attributes. (the "length" column).
I suggest you use the excel importer as a base, and add your own code to import the tagged values you need.

Geert

PS. If you're unable to modify the code yourself, I guess I could do that for you, but I'm afraid I can't do that for free :-[