VJ SQL to File

File types can be: Excel/XLS, Word/DOC, PDF, CSV.

---

TOP FEATURES

PDF, XLS, DOC, CSV files
Generate PDF, Excel/XLS, Word/DOC, CSV files from SQL queries with a single click.

All kinds of SQL queries
Create as simple or as complex SQL queries as you want.

Supports different database types
The following database types are supported: fbsql, gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. To work with some databases, an appropriate php extension may need to be installed and enabled.

Save and reuse
Save and reuse SQL queries for different file types.

---

Other Notable Features

• Comes as a component and module
• When a user clicks a link to download the file, the file is generated dynamically by running appropriate SQL query
• You can post links to generated files anywhere: on the front-end and back-end, in articles and modules
• Extension can retrieve data from Joomla! database or other databases
• Can accept and use parameters passed to query by user
• Can handle large data sets and avoid memory leaks by consistently appending files
• Auto-size for Excel columns to fit text
• Easy-to-use SQL to Excel tool
• Easy-to-use SQL to PDF tool
• Easy-to-use SQL to DOC tool
• Easy-to-use SQL to CSV tool
• This is open-source software under GPL license