Book a Demo

Author Topic: Import/Export Tagged Values of a Requirement  (Read 5028 times)

Stefan Bolleininger

  • EA User
  • **
  • Posts: 308
  • Karma: +0/-0
    • View Profile
Import/Export Tagged Values of a Requirement
« on: July 10, 2011, 02:52:45 am »
Hi Guys,

i was wondering about if it is possible to export and import the tagged values of a requirement element.

Basically i want to Import loads of requirements from Excel to EA and could do this by hand or with the csv automation. ( I prefer the automation).

The basics work very well, however the specials about tagged values are not possible to run this way?

Any idea how to use the import and tagged values? afterwards to the report i will need the export as well.

Thank you for your help
Enterprise Architect in "safetycritical development" like medical device industry. My free Add-in at my Website

MV

  • EA User
  • **
  • Posts: 65
  • Karma: +1/-0
    • View Profile
Re: Import/Export Tagged Values of a Requirement
« Reply #1 on: July 11, 2011, 01:48:50 pm »
If your requirement and associated tag values are defined in excel then you can write a simple VB script to upload them in EA. I have done it several times. Pasting an example ..

set testElement = elements.AddNew(f3_reqReference,"Requirement")
      testElement.Notes = f4_description
      set tags = testElement.TaggedValues
      set newTag = tags.AddNew("Origin",f9_origin)
      newTag.Update
f3_refReference, f4_description and f9_origin are excel columns

You should check for length of tag value however and use note field of tag is value is more then 255 char.

For export you can write a simpole VB script again.

Cheers

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/Export Tagged Values of a Requirement
« Reply #2 on: July 11, 2011, 05:06:49 pm »
Sethor,

Have a look at the Excel importer I posted on the community site.
Should be a good start to import your requirements.

Geert

Stefan Bolleininger

  • EA User
  • **
  • Posts: 308
  • Karma: +0/-0
    • View Profile
Re: Import/Export Tagged Values of a Requirement
« Reply #3 on: July 12, 2011, 12:49:01 am »
Hi,

i had a close look but didn't get information i needed and had no clue what to do about.

My need:

With the export maybe a script i want to export all elements with type "requirement" in the following format:
-Name;-alias;-notes;-valueof"place";

Sometimes i need to change the "place" in my excelsheet and also want to import the exact sheet in EA again.

Could you provide me a little script how to export it?
Maybe i can get an idea how to import this again and than i learned a lot :-)

Thanks for all your help!

  



Enterprise Architect in "safetycritical development" like medical device industry. My free Add-in at my Website