Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: wikitect on July 01, 2009, 10:10:24 pm

Title: Enable Search to Export Results to CSV
Post by: wikitect on July 01, 2009, 10:10:24 pm
Search provides a tabular set of results and yet is not able to export to CSV (from which to build a table) - unlike the Relationship Matrix.

The documentation options are very limited and there's little control over the presentation so it would make a lot of sense to be able to export and re-import the CSV into something with more control over presentation.

This ought to be an option for any tabular view or set of results produced within EA.
Title: Re: Enable Search to Export Results to CSV
Post by: Luis J. Lobo on July 01, 2009, 10:39:19 pm
You can create a RTF report with the results of a search.

Well, create a simple RTF Style Template with only [name] and comma, and you obtain your CSV file (you will need to rename the .rtf extension by .csv...)
Title: Re: Enable Search to Export Results to CSV
Post by: wikitect on July 01, 2009, 11:17:51 pm
Hmm.

The only options from the search results are:

Documentation > RTF report for Each Selected Item
Documentation > RTF Report on Selected Items

In both cases I then get the error that the selection does not contain any element for which RTF documentation can be generated.

Not sure how then to create a report.
Title: Re: Enable Search to Export Results to CSV
Post by: Dermot on July 02, 2009, 12:52:20 pm
Try Ctrl-A to select all, then in the context menu select: Copy to Clipboard.  
Open say Excel and Ctrl-v to get the full format - save to CVS.
Title: Re: Enable Search to Export Results to CSV
Post by: wikitect on July 16, 2009, 11:04:06 pm
Hmm. I'm using EA on a Mac via Crossover. When I select all the search rows and paste into Notepad I precisely nothing. If this were going to work I'd have hoped to get text and some form of column separator. At the moment therefore I can't see how this might work.
Title: Re: Enable Search to Export Results to CSV
Post by: Martin Terreni on July 20, 2009, 12:23:44 am
Even if it works, some "exprt results to CSV" would be nice (and it is not that mush work...)
Title: Re: Enable Search to Export Results to CSV
Post by: wikitect on July 20, 2009, 10:24:44 pm
Indeed.

As I've just found out (this time using EA in a VMWare Fusion Virtual Machine) ... where the copied search text includes a carriage return the paste into Excel fails as it then places the subsequent paragraph into the wrong column so the tabular report gets jumbled. :'(

Not a viable solution. More a temporary and partial workaround.