Joomla! Extensions Directory™

Download
Launch

jDBexport

48 reviews
Get jDBexport (v4.1.0)
logo
main-image-2
main-image-3
main-image-4
main-image-5
main-image-6
main-image-7

Introduction

Graphs and Charts, Core Enhancements, Data Import & Export, Data Reports, Tables & Lists

jDBexport allows you to deliver any data from your databases (JOOMLA and others) as Excel documents directly to your users. Write any valid SQL query in the administration of this component and combine such queries into multiple Excel worksheets/workbooks. Get help from ChatGPT to create your SQL query directly within the component. The query is executed when a user clicks the downloadlink (frontend or backend) and the current result of the query is delivered to the user as a downloadable Excel file (or any other of the below listed document formats). With the on-the-fly ajax-driven SQL syntax checker, the multitude of available export dataformats, formatting options and a great number of database drivers to get your data from, jDBexport is very likely the most exhaustive reporting instrument and data mining tool available on the market.

Main features

  • create data reports in various formats (xlsx, xls, ods, csv, html, pdf, json) from your databases
  • individualise these reports with variable substition (such as userid or current date) or parameters entered by the user
  • embed graphical charts (bar, pie, area, line, etc.) based on the requested data into your worksheets
  • format these reports with colors, fonts, backgrounds (also alternating backgrounds), images, headers and footers, borders and more
  • use a wide varity of conditions (including the result of SQL queries) for conditional formatting
  • add additional cells with text, images or results from additional SQL queries
  • define autofilter areas within your worksheets
  • add any additional files (e.g. Excel Makros in an *.xlmx file) along with your workbook when compressing is activated
  • deliver these reports regularly and fully automatically to your users, utilising our sophisticated scheduler
  • define SQL based rules whether to run the scheduled task or not
  • or let the users request these reports online or in the background or through the GoogleDocViewer
  • or let the users preview these reports in a HTML preview within your website
  • or prepare these reports (without showing them) for post processing with individual programs
  • include virtually any accessible database - local or remote - into your reports (MySQL, MariaDB, MS-SQL, ORACLE, SQLite3, DB2, INGRES, SAP MaxDB, PostgreSQL, Firebird and others)
  • let AI help you with creating your SQL query with our integrated ChatGPT prompt
  • check the validity of your SQL query with our on-the-fly (AJAX-driven) SQL syntax checker, while preparing the worksheet
  • get inline help on creating your SQL queries, or reference the SQL manual that corresponds to your environment

  • and many, many other features...

  • jDBexport is translated in many languages (you can help us here...)

-jDBexport comes with a set of additional tools (frontend and backend module for easy access to your workbooks, datagrid and datafield plugin to embed worksheets or a single cell from a worksheet into any Joomla content, workbook link plugin to style jDBexport workbook links according to your template, support for additional Truetype fonts in PDF creation)

...
If you are missing a specific feature, call us and we will find a solution...

jDBexport was originally forked from the well known (Joomla 1.5 data reports) extension SQL2Excel (actually SQL 2 Excel Pro).

For helping with the translation of jDBexport into your own language, please visit or translation project at TRANSIFEX.com
https://www.transifex.com/schultzitsolutions/jDBexport/

For more details, please visit our website at
http://it-solutions.schultz.ch/index.php/en/jdbexport

Write a review

Top Notch extension for excel exports



Posted on 14 October 2014
I am using this extension for over two years now, it has a bit of a learning curve, but after you get it, it really produces rich excels, which we use in a professional environment. Support request got answered in now time in the forum, even some skype consolidation was possible. So if you need enriched excels exported from your DB, not only plain csv's, this is the component you need. Don't know of a better one for the job.

Excellent Support



Posted on 20 May 2014
I work with my report that is littlebit unusual taken from Fabrik My report shown user ID in stead of Name and Surename I call support problem has been found and fixed durring a call, Wisch all companies to have such support.

Great Extension



Posted on 15 May 2014
I needed to extract several data from our site at regular interval to provide our key stakeholders with relevant informations.



I was able to arrange complex excel workbooks, update them very day and send them to the right user automatically.



The documentation should be improved but I have been always able to understand what to do with the support of the developer.



This is really a precious component.

Many thanks to Rüdiger.

Super Extension!



Posted on 01 May 2014
I used the previous version of this component and was disapointed when it was discontinued. This new forked version is still as good. I use it on an intranet site for mining data from other extensions. You do need to know SQL in order to write the queries, but to be honest, I use a graphical SQL query tool, then paste the resulting query into JDBExport and voila!

I also have scheduled exports running weekly that email the spreadsheets and downloadable reports on the site with user set parameters. all working with no issues. I will certainly be looking at the J3 version when it comes to upgrading my sites.

Excellent product and 1st Class Support



Posted on 29 April 2014
I purchased this extension because I had a need to create some report based on data I had captured from a custom form on my joomla site. I tried other extensions to do this based on pure SQL queries but that wouldn't work due to how my tables were structured in the MySQL database for my site. I then purchased and installed this extension and am amazed with its capabilities. By combining the regular SQL queries and leveraging Excel to create multiple worksheets and utilize standard excel functions, I was able to create extremely detailed reports, exactly as I needed them all from a single MySQL table.



Along the way I have run into a few bumps but between the support forum and direct email contact with the developer, Ruediger, all of my issues have been resolved in lightning quick fashion. I normally don't write reviews but felt the need to here simply because of the truly 1st class support I have received on this extension.

Extension quality is sufficient, but support is insufficient



Posted on 10 April 2014
This extension is pretty good (part which is working good).

However I have had some issues with this extension and I request support for it.

As first, reaction time of developer is very slow. Further I build a test site to show my problem and make possible to developer to test there. He did not do anything.

So I tried to get appropriate support for a year long, but without success.

Because my issue is not resolved I can not use this extension on my production site and is useless for me.

For me - pure waste of money.

Excellent Product / Excellent Support



Posted on 14 March 2014
The ability to generate reports - by administrators or end users - elevates Joomla! from a browser facility to an information system. In 1.5 the SQL2EXCEL product did the job. jDBexport recreates and improves the earlier one. The developer is very responsive to solving problems and receptive to suggestions for improvement. Top of the line!

Great component



Posted on 13 October 2013
This a great port of the old SQL2Excel and it delivers. I had a minor problem that was solved with more than one solution in a very timely manner. Anyone with a site with members or database records that need to be exported for use have to have this. I'm shocked that CBSubs or similar don't offer it built-in. This is what you need for your clients (or yourself) who need front end (or backend, of course) capabilities with user lists. Fantastic.

Drop in replacement for SQL 2 Excel 1.5 component



Posted on 12 October 2013
I had the 1.5 only SQL 2 Excel version from another developer on a site.



Moving to 2.5 I found this. Installed it, fast and easy configuration, copied over the code from SQL 2 Excel and presto, instant conversion, 100% compatible. Could not be easier.



This gives you huge flexibility in creating reports from tables. You'll find it replaces a lot of coding if you think of ways to present detail data to users.

Waste of money



Posted on 28 August 2013
Paid for this extension. Installed as you would with any extension. Immediately the Joomla admin panel began to throw a 500 error when accessing this component. Cannot configure, cannot use and author does not respond to messages nor offer a refund.
Owner's reply: Dear goldleviathan,
It seems as if you are trying to install jDBexport Version 3.0.3 on a JOOMLA 3.x system - as our product is not (yet) compatible with this version of JOOMLA, this is not a question of "not functioning software" but rather of prerequirements for the software that are not met on your system. You left our email from august 13 unanswered for more than two weeks - and claiming now that we do not respond is simply not true. I hope we can find a mutual solution for this dispute (by email, not here in the forum of course).
Have I been pwned - password checker
Paid download

Have I been pwned - password checker

By Schultz IT Solutions
User Management
With this plugin, you can notify your users if they intend to use a password that was previously compromised or "pwned" in a data breach. You can even define whether your website allows such passwords or rejects them. To provide this service the plugin refers to the "Have I been pwned" API ( https://haveibeenpwned.com/ by Troy Hunt). When a new user registers and submits a password (or an existin...
4.5
1 review
J4 J5
eps Ueberweisung (and giropay) for EventBooking
Paid download

eps Ueberweisung (and giropay) for EventBooking

By Schultz IT Solutions
Extensions Specific Non-sorted
Payment Plugin for EventBooking component, utilising the austrian eps and german giropay online payment methods for website owners with an austrian bank account. It allows your customers to pay your event registrations by autorising the payment within the online banking application of their own (austrian or german) bank.The plugin builds on the eps XML definition (by STUZZA.at) in its latest versi...
Not rated
J3 J4
eps Ueberweisung for HikaShop
Paid download

eps Ueberweisung for HikaShop

By Schultz IT Solutions
HikaShop extensions
This plugin integrates the austrian "eps Überweisung" online payment method into your Hikashop website. No Payment Service Provider needed, just the respective eps contract with your own bank. It is targeted at HikaShop webshop owners with an austrian bank account and allows your customers to pay your goods and services by autorising the payment within the online banking application of their own...
Not rated
J4 J5

jDBexport

Version:
4.1.0
Developer:
Schultz IT Solutions
Last updated:
Dec 09 2025
2 months ago
Date added:
Jul 07 2012
License:
GPLv2 or later
Type:
Paid download
Includes:
c m p
Compatibility:
J4 J5 (b/c plugin) J6 (b/c plugin)
Download

Uses Joomla! Update System

Demo Support Documentation

Score:

Functionality:
Ease of use:
Support:
Documentation:
Value for money:

Write a review