“”

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

11.x compatibility

Downloads by month

Download 0.6.6 External Manual Found an Issue? Code Insights
Author
Wolo
Company
wolo.pl '.' studio, Q3i
Last update
04. Mar 2022
First upload
06. Mar 2009
Downloads
3,955
Category
Frontend Plugins
Dependencies
  • TYPO3 (9.5.0 - 11.5.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.

Other extensions by this user (1)

Chrome's Developer tools Console php debug. Short call - just use cp(var);. ChromePHP globally included in TYPO. Respects DevIpMask. Needs Chrome Logger ext for Chrome. @See README for details. @See https://craig.is/writing/chrome-logger

Supported TYPO3 versions:

Version history

Version Upload comment Works with TYPO3 Download
0.6.6 / stable
March 04, 2022
11.x compatibility
9.5.0 - 11.5.99 Download
0.6.4 / stable
August 20, 2021
Feature: header row labels userfunc postprocessing
9.5.0 - 10.4.99 Download
0.6.3 / stable
June 02, 2021
Minor fix in custom processing
9.5.0 - 10.4.99 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
0.6.0 / stable
January 09, 2021
TYPO3 10.4 / full Doctrine compatibility - no more typo3db_legacy
9.5.0 - 10.4.99 Download
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
0.4.2 / stable
January 30, 2019
Fixed stupid missed bracket, minor fix in readme
7.6.0 - 8.7.99 Download
0.4.1 / stable
December 17, 2018
- Automatic debug_allowed now works also on Development/[*] instances
7.6.0 - 8.7.99 Download
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
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
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
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
0.1.4 / beta
May 29, 2009
added full sql query display in debug mode
Download
0.1.3 / beta
April 06, 2009
Fixed bad TER description...
Download
0.1.2 / beta
April 06, 2009
First release with full manual
Download
0.1.0 / beta
March 06, 2009
First release
Download