This topic is locked

Export table data as .txt

6/27/2007 1:57:07 PM
PHPRunner General questions
rsawchuk author

I have an application where I need to export the table data as pure fixed-field text. I don't see this as an option under Export.
Is there a way to do this (without the usual editing of Word, Excel, etc. files)? If not, would you consider adding the option to export as .txt in future versions?
Also, I would like to export only certain fields of a data table. I would like to see this option added to future versions as well.
Thanks,
Russ
Yes, I have these options available to me using my database management software. However, I don't want to give clients direct access to my databases.

Alexey admin 6/28/2007

Russ,
you can modify Export to CSV routine to save text files.

Modify ExportToCSV function in export.php file for that.

You'll need to change response headers there and remove quotes and commas from the output.
To define a subset of fields being exported use Choose pages tab in PHPRunner.

rsawchuk author 6/28/2007

Thanks, I will give it a try.
Russ