Test cases

[Theresa_R]

Hi there,

I would like to be able to export the structured specifications portion (action/results/etc) that we have for our test cases/scenarios into MS Excel (CSV as an interium is also acceptable).  I have tried out the built in csv export, but it only includes the "top level" test case header information.  The details or "steps" that we have specified don't get included in the export.  

[Geert Bellekens]

Theresa,

CSV export is rather limited, so I can imagine that you can't export the steps.
If you feel comfortable in SQL then you could write an SQL Search and copy/past the results in an excel file.
The most flexible solution is to write a small add-in to export the data you need. Should be about half a day of work.

Geert

[Theresa_R]

We are strong on the SQL side, but unfamiliar with this type of advanced feature in EA.  Is this the sort of api you mean for us to use?


RunModelSearch (string sQueryName, string sSearchTerm, string sSearchOptions, string sSearchData)
 
 Runs a search, displaying the results in Enterprise Architect's Model Search window.

Parameters:

· sQueryName: String - the name of the search to run, for example Simple

· sSearchTerm: String - the term to search for

· sSearchOptions: String - currently not being used

· sSearchData: String - enables you to supply a list of results in the form of XML, which is appended onto the result list in Enterprise Architect - see XML Format; this parameter is not mandatory so pass in an empty string to run the search as per normal
  
 XML Format

OR, I also happened across the C sharp add in examples.  They are in 2003 of visual studio.  Is the EA interop reference compatible if we use a newer version of visual studio?

We might need a little push in the right direction to get started.

[Geert Bellekens]

Hi Theresa,

Yes, I'm using VS 2010 at work to create C# add-ins for EA (and sharpdevelop at home).
You can find for more info on creating C# add-ins here:
Tutorial: Create your first C# Enterprise Architect addin in 10 minutes
The complete Enterprise Architect C# add-in template
Testing and debugging your Enterprise Architect C# Add-In
Tutorial: Deploy your Enterprise Architect C# add-in with an MSI package

If you are looking for an example code see my open source add-in EA Navigator on github

If you want more info on how to write your own SQL searches:
Harvesting the power of EA’s SQL searches

Geert