jDBexport - export data from your Joomla! databases to Excel
jDBexport is a Joomla component which allows you to export data from your databases (JOOMLA and others). The reports are generated on-demand into an Excel document, when the users request them.
As a powerful data reports extension jDBexport allows you to deliver data from your databases directly to your users. Write any valid SQL SELECT query in the configuration of this component. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file.
Forked from the well known (Joomla 1.5 extension) SQL 2 Excel Pro data reports extension jDBexport allows you to deliver data from your databases directly to your users. Write any valid SQL SELECT query in the configuration of this component. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file.
Please note that
- jDBexport versionbranch 5.0.x is developed from scratch for Joomla 5 and newer!
- jDBexport versionbranch 4.0.x is fully compatible with Joomla 4 and compatible with Joomla 5 when the compatibility plugin of J5 is activated
- jDBexport versionbranch 4.0.x is fully compatible with PHP8
- jDBexport versionbranch 3.2.x is developed for JOOMLA 3.x and newer ONLY!
- jDBexport version 3.2.4 and newer is fully compatible with Joomla 3.5.1 and newer
- jDBexport version 3.2.4 and newer is fully compatible with PHP7
- Information about outdated (no longer supported) versionbranches can be found in the version history
For users with active subscriptions
Please remember to login to our website here to have full access to all available resources.
Subscribe now for only EUR 43,00 per year
This subscription is valid for 1 year and allows you to:
- access the download aera and get all software updates available
- access the full documentation for the product
- access our support forum and submit support requests
AND
- use the downloaded software forever - even after your subscription expired
- access our product forum forever - even after your subscription expired
- install the software on as many sites as you wish: one subscription - unlimited installations
Renewal discount: If you renew at least 15 days before your subscription expires you get a 25 % discount - and your new subscription will only start the day after your current subscription expires (so you don't lose a single day). This is our way to honor your ongoing support for this product.
Note: Prices are shown without VAT. On top of the listed prices, VAT (at the rate per your country of residence) will be charged unless you are a resident of a country outside the European Union or you are an EU resident outside Austria with a VIES-registered VAT number (in accordance to European Directive 2008/8/EU and its incorporation into EU member states' local laws).
Please note our genereal refund policy.
Overview
Full feature list
- Create Excel Spreadsheets directly from database queries
- Create OpenXML Excel documents (*.xlsx), binary Excel (.xls) files ( 97-2003 format ), OpenDocument Spreadsheets (*.ods), Comma separated Value files (*.csv), HTML pages, PDF documents, JSON files
- Backend ControlPanel
- access all features of jDBexport from one panel
- access all options through the JOOMLA options toolbar icon
- Nested categories and ACL fully supported
- Worksheets
- Ajax powered, on-the-fly, syntaxerror check of your SQL query, directly in the worksheet form, while you write your SQL queries
- Show available tables and fields from the database to help you write your queries
- Get help on creating SQL queries directly from the database documentation pages
- Let MySQL explain the query statement
- Add additional cells with text and formulas, SQL queries or images anywhere in the worksheets
- Create your worksheets from multiple SQL queries - not just one
- Multiple worksheets in one workbook
- Make worksheets readonly (password protected)
- include Excel formulas and even Excel macros
- Use substitution variables in SQL queries - create dynamic queries based on user, time of day etc etc
- set autofilters for any range of cells
- include graphical charts directly within your data
- Workbooks
- compress (zip) your workbooks
- define parameters which can flow into the database query (let users pass in parameter values to control the report generation). Such parameters can be text, numbers, dates, times. And values can either be predefined or generated by querying your database(s).
- Databases
- Setup database connections and extract and include data from external databases. Built-in drivers for MySQL, MS SQL, Oracle, MaxDB, DB2, INGRES, postgreSQL, FireBird plus a custom driver allowing you to connect to any other database
- Schedules
- schedule automatic emails with attached reports (or not), run SQL queries on a schedule to perform automatic database updates and more using the built-in Scheduler
- Cache your reports to reduce server load
- Data Grid Plugin (embed a worksheet directly into your content items)
- Data Field Plugin (embed a single cell from any workbook/worksheet directly into your content items)
- Workbook Link Plugin (embed and CSS style link to your workbooks into your content items)
- Use the frontend preview mode to browse and adjust your reports before you download them
- Or create the reports in the background, and do some other work while your report is created and sent to you by email
- Or view your reports in Google DocViewer, or just prepare them without viewing them (for further automatic processing).
- Module for easy access to reports in frontend
- Module for easy access to reports in backend
- Advanced Formatting
- Set print margin
- Set paper size for printing
- Set paper orientation for printing
- Set grid lines visibility on/off (print and screen)
- Set horizontal/vertical alignment for printing
- text and background color choices
- Insert Images into your spreadsheets
- Alternate datarow background color (none / single color or two alternating colors with specified intervals)
- Horizontal and vertical Freeze Panes
- Copy Worksheets & Workbooks
- Multilanguage support for many languages (join in at our translation project with Transifex)
- color picker to easily select text and background colors
- define your own corporate-image respective colors for the worksheet layout
- finetune the styles of any frontend functionality by using own CSS styles
- and a lot more...
Further information
Subscribe now for only EUR 43,00 per year
This subscription is valid for 1 year and allows you to:
- access the download aera and get all software updates available
- access the full documentation for the product
- access our support forum and submit support requests
AND
- use the downloaded software forever - even after your subscription expired
- access our product forum forever - even after your subscription expired
- install the software on as many sites as you wish: one subscription - unlimited installations
Renewal discount: If you renew at least 15 days before your subscription expires you get a 25 % discount - and your new subscription will only start the day after your current subscription expires (so you don't lose a single day). This is our way to honor your ongoing support for this product.
Note: Prices are shown without VAT. On top of the listed prices, VAT (at the rate per your country of residence) will be charged unless you are a resident of a country outside the European Union or you are an EU resident outside Austria with a VIES-registered VAT number (in accordance to European Directive 2008/8/EU and its incorporation into EU member states' local laws).
Please note our genereal refund policy.
