“”

Export database/query to CSV

w_query2csv / stable

This is a CSV generator, which combines simplicity with high configurability and data processing powers. It provides download points for your preconfigured database queries dumped to customized CSV files. If you have some data collected in database tables, which must be periodically, like, downloaded by admins, sent to external CRM, where some raw values must be converted to something meaningful, like uids replaced with labels from relations, timestamps visualized, arrays deserialized, this extension is very useful. It's simple and easy to configure, but very flexible with input/output settings and scalability.

This version supports TYPO3

Older versions also support TYPO3

Tags

#csv #sql #dump #export #table #query #spreadsheet #excel #calc

Last upload comment

- [minor breaking] Core::config property was renamed to Core::file_config (might impact your custom processors or xclasses) - New options: output.additionalHeaders, output.additionalHeadersProcessor - File delivery was extracted to its own Disposition object, for more control of output and better extendability - Some old long-deprecated options (hsc, nbr) now triggers deprecation log/error

Downloads by month

Total downloads (TER and Extension Manager) incl. November 2020: 2,872

Download 0.6.1 External Manual Found an Issue? Code Insights
Author
Wolo
Company
wolo.pl '.' studio, Q3i
Last update
13. Jan 2021
First upload
06. Mar 2009
Downloads
3,170
Category
Frontend Plugins
Dependencies
  • TYPO3 (9.5.0 - 10.4.99)

Installation

  1. Download ZIP file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the ZIP file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.
  1. Download T3X file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the T3X file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.

Version history

Version Upload comment Works with TYPO3 Download
0.6.1 / stable
January 13, 2021
- [minor breaking] Core::config property was renamed to Core::file_config (might impact your custom processors or xclasses) - New options: output.additionalHeaders, output.additionalHeadersProcessor - File delivery was extracted to its own Disposition object, for more control of output and better extendability - Some old long-deprecated options (hsc, nbr) now triggers deprecation log/error 9.5.0 - 10.4.99 Download ZIP Archive
0.6.0 / stable
January 09, 2021
TYPO3 10.4 / full Doctrine compatibility - no more typo3db_legacy 9.5.0 - 10.4.99 Download ZIP Archive
0.5.0 / stable
May 17, 2020
TYPO3 9.5 compatibility (needs typo3db_legacy to be installed, no doctrine support yet) 9.0.0 - 9.5.99 Download ZIP Archive
0.4.2 / stable
January 30, 2019
Fixed stupid missed bracket, minor fix in readme 7.6.0 - 8.7.99 Download ZIP Archive
0.4.1 / stable
December 17, 2018
- Automatic debug_allowed now works also on Development/[*] instances 7.6.0 - 8.7.99 Download ZIP Archive
0.4.0 / stable
December 17, 2018
- Q3i modifications and features now integrated into ext (sql template file, postprocessors, some tuning)
- Value processing is now split to separate classes for each processor (@see Migrate) - (old way is deprecated but still works yet)
- Minor tweaks
7.6.0 - 8.7.99 Download ZIP Archive
0.3.0 / beta
June 27, 2018
- Charset converting - iconv changed to mbstring (thanks to Henri Nathanson for suggestion)
- Inactive records filtering changed to native - now use enableFields = 1 for this. use default_enableColumns only when table isn't in TCA
- Option add_fields fi
7.6.0 - 8.7.99 Download ZIP Archive
0.2.0 / beta
July 20, 2017
- Code reworked and compatible with TYPO3 version 7.x and 8.x (should work in 6 as well)
- Userfunc field processing
- Many minor improvements – some of them breaks compatibility. Please refer to Migration section in manual/readme, if updating
7.6.0 - 8.7.99 Download ZIP Archive
0.1.5 / beta
August 05, 2009
- Last built query is saved and available on debug,
- Quotes in input are escaped to csv-compatible double quotes (was messing whole csv)
- Additional tables added to non_allowed
Download ZIP Archive
0.1.4 / beta
May 29, 2009
added full sql query display in debug mode Download ZIP Archive
0.1.3 / beta
April 06, 2009
Fixed bad TER description... Download ZIP Archive
0.1.2 / beta
April 06, 2009
First release with full manual Download ZIP Archive
0.1.0 / beta
March 06, 2009
First release Download ZIP Archive