Author Topic: Enable Search to Export Results to CSV  (Read 6858 times)

wikitect

  • EA User
  • **
  • Posts: 117
  • Karma: +2/-0
    • View Profile
    • TRAK Community
Enable Search to Export Results to CSV
« 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.
======
Favourite epitaph: 'Under this sod lies another'

TRAK Framework https://sf.net/p/trak
MDG for TRAK https://sf.net/p/mdgfortrak

Luis J. Lobo

  • EA User
  • **
  • Posts: 252
  • Karma: +0/-0
  • IT Consultant
    • View Profile
Re: Enable Search to Export Results to CSV
« Reply #1 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...)

wikitect

  • EA User
  • **
  • Posts: 117
  • Karma: +2/-0
    • View Profile
    • TRAK Community
Re: Enable Search to Export Results to CSV
« Reply #2 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.
======
Favourite epitaph: 'Under this sod lies another'

TRAK Framework https://sf.net/p/trak
MDG for TRAK https://sf.net/p/mdgfortrak

Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 591
  • Karma: +7/-0
    • View Profile
Re: Enable Search to Export Results to CSV
« Reply #3 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.

wikitect

  • EA User
  • **
  • Posts: 117
  • Karma: +2/-0
    • View Profile
    • TRAK Community
Re: Enable Search to Export Results to CSV
« Reply #4 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.
======
Favourite epitaph: 'Under this sod lies another'

TRAK Framework https://sf.net/p/trak
MDG for TRAK https://sf.net/p/mdgfortrak

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Enable Search to Export Results to CSV
« Reply #5 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...)
Recursion definition:
If you don’t understand the definition read "Recursion definition".

wikitect

  • EA User
  • **
  • Posts: 117
  • Karma: +2/-0
    • View Profile
    • TRAK Community
Re: Enable Search to Export Results to CSV
« Reply #6 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.
======
Favourite epitaph: 'Under this sod lies another'

TRAK Framework https://sf.net/p/trak
MDG for TRAK https://sf.net/p/mdgfortrak