CSV import: tagged values

[Uffe]

Hey hi!


I've got an Excel spreadsheet I need to import and which will need to be reimported on a regular basis (monthly).
The spreadsheet has a dozen-odd columns which I place into tagged values. I import the rows as non-stereotyped Components, and all tags are simple text; I haven't specified any tagged value types in the project.
In other words, neither the set of tags nor the value ranges are predefined, everything's created on the fly.

If a cell is empty, no corresponding tag is created. That's fine.
But I've noticed that on reimport, if a cell has become empty (ie had a value in the previous import but not now), the corresponding tag is not deleted.

I assume this is by design -- EA supports duplicate tag names, and the tag GUIDs are not included in a CSV export. But what about using a profile?
Would the tag be cleared if I used a stereotype with a predefined set of tags?

Cheers,


/Uffe

[qwerty]

I don't get it. When should the stereo-TV be cleared? On export?

q.

[Uffe]

On reimport. The corresponding cell in the spreadsheet is empty, so the tagged value should be deleted.

/U

[Robert Sheridan]

When I have updated streotypes by removing tags or changed the stereotype for an element so that it has different tags I have noticed that any populated tags remain so I guess that this is normal.

The only way round it that springs to mind (just because that is what I am working on at the moment) is to import the spreadsheet via the API as then you can control whether or not an existing tag is retained.

[qwerty]

Since (IIRC) V10 has a different behavior for TVs from stereotypes. It shows them dynamically while you change the stereotype. So it will (again IIRC) delete the TV if you change the stereotype and the new one does not have the same TV. But it keeps the set. So I guess an import should not delete it but only blank its value.

q.