Importing requirements from an excel list

[palim]

Hello guys,

I`m trying to import requirements from an excel list.
So far, I guess this might be done via the cvs import function.

Additionally, I want to import two excel files that have a reference to each other (worksheet or separate file, no difference here).
Meaning: Requirement A has a reference to requirement B, requirement A1 has a reference to requirement B1 and so on.

Now, my question is how this is being done in EA? I hope that the references are being imported, too. I`ve already looked onto the exported csv files after adding a reference manually in EA - unfortunately, I didn`t see a 'reference' tag or something like this - neither in the exported csv nor in the exported xml.

Any ideas how references might be imported and used by EA?

Best regards,
palim

[Geert Bellekens]

Palim,

With a little effort you should be able to modify the Simple VBA Excel EA Importer to do what you want.
The basis is already there. It is just a matter of changing the type of the elements to create from Class to Requirement, and adding something to add relations between requirements.

Geert

[palim]

Palim,

With a little effort you should be able to modify the Simple VBA Excel EA Importer to do what you want.
The basis is already there. It is just a matter of changing the type of the elements to create from Class to Requirement, and adding something to add relations between requirements.

Geert

@Geert:
Thank you for the link to the zip file.
Unfortunately, I have the problem that I don`t know how to make use of it. I don`t really have knowledge about VBA, so I`m kind of stuck right now.
Could you (or anyone else) please give me a short example that matches to my problem.

Best regards,
palim

[Geert Bellekens]

Palim,

It's really not that difficult. If you have any kind of technical (programming) background you should be able to understand what's going on.
I don't really have time right now to do it for you, but if you have concrete questions, or you are stuck somewhere I'm happy to help.

Geert

[Minton]

My issue is on the same topic, so I will continue the thread. I am trying to import a simple set of requirements -- 'capabilities.' I have two fields: Name and Type. I am importing into a package called 'Capabilities.' The dialogue shows 'Import Complete,' but I see no resulting requirement elements coming into the package. What am I doing wrong?

[Minton]

Also . . .

When I start an import CSV, the CSV Import/Export dialog Specification drop-down does not show any of the saved specifications that I have previously created.

[Robert Sheridan]

I am very rusty at VBA but was able to use Geert's code to get a solution for our import in about a day (Thanks Geert, would have been stuck finding out the API calls without you).  

I would say it would be worth finding a programmer in your organisation if you can not do the edits yourself.

Robert