import requirements from excel (including tags)

[bch]

From what I can understand, there is no way to import my (csv) excel requirements list with custom atttributes (tags).
I planned on creating new tags for the requirement object.  In theory those tag names would be the headings for my custom excel columns.  I would then proceed to use the hypothetical functionality within EA to import the default attributes as well as the custom attributes(EA).  I used to do this in Metastorm Provision and was expecting to be able to do the same here.  There are 2000 lines of data I'd rather not input by hand.

Is there any way to do as I expected?  maybe an add-on someone has developed perhaps?

thank-you

[Geert Bellekens]

this tool should be a good place to start: http://community.sparxsystems.com/resources/scripts/simple-vba-excel-ea-importer

Geert

[bch]

Thank-you.  I did look at this yesterday.  After looking at the spreadsheet and VB macro I see it will add attributes (tags) to the specified class.  It does not allow populating(importing) the data within those newly created attributes (tags).

I searched for available methods that would hopefully allow this, but unfortunately found none.

Any other suggestions?

[Geert Bellekens]

I don't get it. What do you mean?
The importer create/updates attributes, adds tagged values to those attributes and sets their value.
What more do you want?

Geert

[bch]

Maybe my terminology is not correct. I am using attributes and tagged values interchangably.
in any case... i have a list of requirements in excel which have many more columns than what intrinsic properties EA has (description, priority, status, difficulty, etc).  There are about 20 more custom properties i need to add to the 'requirements' object.  I see this is done by adding 'tags'.  I will add these tags manually.
i need a mothod to import the data within my excel spreadsheet into EA.
I dont see any way to set, and therefore import the 'tag' values within this spreadsheet importer.

[Geert Bellekens]

The importer adds the Attribute Length column as a tagged value to the attributes.
Adding tagged values to Element works exactly the same way, I'm sure you can figure it out if you try.
Look into the manual for Element.TaggedValues

Geert