CSV import

[OpenIT Solutions]

We have a list of requirments that we will need to import, on a regular basis. The CSV import capability works fine. However when i re-import the list (to pick up additions and changes) any existing entry in EA is created again. I'd like EA to either skip or overwrite duplicate entries - is there any way to when using CSV import to do this (when we don't have GUIDS) on the import CSV file?

[smendonc]

The procedure I use is along these lines:
1. Import requirements into EA
2. Export the just imported requirements including the EA assigned GUID
3. Update the requirements (I use Excel) with the attached GUID
4. Reimport when necessary.

When I've had to use new CSV's with no GUID but which may have been imported, I've needed to do data munging external to EA to get the GUIDs in for the existing requirements.

Stan.

[Geert Bellekens]

Another option is to use your own custom importer.
Here: simple-vba-excel-ea-importer is an example of an excel with some VBA code to import classes and attributes into EA. This will update the existing classes/attributes if it finds a class/attribute with the same name (in the same package/class).
Should be easy enough to adapt the sheet to import requirements iso classes.

Geert