Enhancement Request: Direct Export without display

[Harry MacDonald]

We use QR often for generating transaction files for further analysis in other tools via TSV files. It would be helpful if we had the option to bypass the report formation on screen, and choose to export directly when we execute the report, rather than waiting for the report to execute, then waiting for the report to be drawn on screen (often takes as long as the execution), before we can select the export function and re-run the query to produce the required .tsv file.

As a workaround, since version 2.05, I often submit the report for execution, immediately cancel it, then select Export Results to re-run the query into the export file, but this seems a rather inelegant way of handling what could be a simple direct export of results.

This request also applies to reports run from within PL/SQL Developer, by the way ...

Thanx,
HMD

 

[Marco Kalter]

You can export a query directly from the command line. For example:

QueryReporter.exe userid=scott/tiger@chicago exec=emp.rep tsv=emp.tsv quit

This connects as scott@chicago, runs emp.rep, exports the results to emp.tsv, and quits.

 

[Matt Symes]

Marco, can I second this request. It would be *very* useful to be able to have query reporter effectively mimic just the standard SQL window in PL/SQL developer. When doing analysis we usually take the data from the report and dump it into Excel anyway.

Hence, either a report which creates an unformatted SQL table (and hence ran quicker) or one which just creates the extract file directly would be a great help.

I know there are a million tools that do this already but none have the report variables feature that I love from PL/SQL developer (and which I use in SQL window usually, rather than the Report window).

Thanks in anticipations,

- Matt Symes

 

[Marco Kalter]

I assume you want a GUI function that directly writes the results to a file?

I have added this to the list of enhancement requests.