Joomla! Extensions Directory™

Download
Launch

jDBexport

47 reviews
Get jDBexport (v4.0.8)
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

Awesome Extension with Numerous Features



Posted on 27 October 2024
Functionality
All functions work as expected, and the extension can be used for various types of applications.
Ease of use
It takes some practice to get used to, but once you understand the setup process, everything runs smoothly and becomes much easier to manage
Support
The developer is extremely helpful and provides great support when needed.
Documentation
It provides comprehensive information, and the samples make it easy for me to understand and adapt the features to suit my needs.
Value for money
Well worth the investment. We won’t regret spending on this, as the comprehensive functionality it offers delivers excellent value and meets
I used this to: I use it to run reports in Joomla 5, where I combine different types of tables and select various fields. Everything runs smoothly, and the flexibility allows me to customize reports exactly as needed.

Excellent and useful, but doesn't work on latest J4



Posted on 24 July 2023
Functionality
Prior J3 versions worked well. Current version fails on latest J4 version.
Ease of use
The user interface is a bit dense and non-intuitive, but after some study of documentation, it becomes easier.
Support
Developer hasn't issued an update in seven months since notified of J4 issue. Prior J3 versions worked well. Current version fails on J4.
Documentation
Very good and extensive with many examples. Prior J3 versions worked well. Current version fails on latest J4 version.
Value for money
Very valuable, if it worked... Prior J3 versions worked well. Current version fails on latest J4 version.
I used this to: producing user reports and Excel extracts from CB tables. I am researching alternatives, hoping the developer will fix the J4 version.

Exceptional Extension - works perfectly in Joomla 4



Posted on 30 August 2021
Functionality
This amazing extension enables you to produce reports for viewing or export based on your Joomla SQL database.
Ease of use
It is easy to use assuming you have some SQL knowledge. Google has many examples if you get stuck.
Support
Outstanding. My queries have been answered the same day with precision.
Documentation
Excellent. It covers all aspects of the extension including the many advanced features.
Value for money
Exceptional. What is it worth to be able to produce reports that you really need.?
I used this to: Producing reports that we require that are not provided by our extensions. Fixing Joomla database issues such as deleting orphan records. Producing reports for a filter specified by the user such as year. Displaying in articles values or text derived from the Joomla database.

Easy way to export your data to Excel



Posted on 22 July 2021
Functionality
A lot of functions to format the outcome according to your needs.
Ease of use
Has a small learning curve, but once you have done your first export, it's quite easy.
Support
Had some problems with formatting, but the developer was very helpful and took care of this.
Documentation
Documentation for this extension is quite detailed and easy to understand.
Value for money
Good value for money as you can save time compared to manually doing this with some Php2Excel library.
I used this to: I used it for exporting data from different Mysql databases into sevaral Excel files.

Awesome product and support!



Posted on 30 June 2021
Functionality
Robust toolset that is great for reporting in Excel or PDF across multiple databases.
Ease of use
A bit of SQL knowledge is required, but otherwise easy and intuitive.
Support
I recently needed support. Not only did I receive timely responses, but the issue was solved within 24 hours! Awesome!
Documentation
Value for money
I've been a long time user and this product has been able to provide endless reporting capabilities.
I used this to: Reporting capabilities for time sheets, events, and member information

Great Extension with Excellent Support



Posted on 24 October 2019
Functionality
It is a great extension for generated exportation, full compatibility with excel
Ease of use
The component is not very friendly to use but it has a SQL checker that help
Support
The support is great! The support quickly answers to e-mails, he is very professional.
Documentation
Value for money
Good Value, worth every penny spent even just for the really punctual and decisive support
I used this to: I use it for export data from multiple tables in excel, with really complex targeted database queries

Excellent Product with Excellent Support



Posted on 13 March 2019
Functionality
A great way to display information from an external database
Ease of use
It is a bit complicated by virtue that it is so feature rich. Once you understand how it works there is no problem
Support
This is probably the best part of a very good product. Definitely 5 stars
Documentation
The documentation is detailed .
Value for money
Good Value
I used this to: Displaying data from external databases

Fantastic Extension



Posted on 03 May 2017
Functionality
Fully compatible with Excel, it allows you to generated files with filters, conditional, etc..
Ease of use
Needs some knowledge specially when linking more than two tables. SQL checker is of great help. Help given in the forum and sql forum.
Support
Assistance given by the developer is amazing. He responds immediately to emails and provide the necessary assistance.
Documentation
Consistent and useful.
Value for money
100%
I used this to: To generate email list for my users and to extract data required for the instructors of my sport club.

Essential part of business reporting



Posted on 28 April 2017
Functionality
conditional formatting based on cell contents, customized texts and logo, charts, PDF, full compatibility with excel, I am blown away!
Ease of use
it's very easy, it includes the SQL checker, and it is not overwhelming. You use what you need, without having to repeat the same steps
Support
The author quickly answers your e-mails, he provides you with all the information you need, very kind and very professional
Documentation
There is an extensive documentation, and it was written for new users. I just wonder how to do something, and I find it already explained
Value for money
It is not just Excel export, it allows you to create charts, PDF files, in other words a complete package! Outstanding value!
I used this to: I use it to develop automatic monthly reports in Excel, where the cells are custom-formatted based on their contents, so the users can use Excel filters and calculations. I use many databases, which is why this extension is perfect!

Perfektes Werkzeug für umfangreiche Datenbankabfragen



Posted on 06 February 2017
Functionality
Funktioniert tadellos.
Ease of use
Intuitiv bedienbar.
Support
Exzellenter Support mit sofortiger Antwort innerhalb kürzester Zeit. Problemlösung innerhalb weniger Stunden!
Documentation
Sehr umfangreich.
Value for money
Sehr gut
I used this to: Datenbankabfragen mit Benutzereingabe und Download in Excel
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
J3 J4
eps Ueberweisung (and giropay) for J2Store
Paid download

eps Ueberweisung (and giropay) for J2Store

By Schultz IT Solutions
J2Store extensions
This plugin integrates the austrian "eps Überweisug" and the german "giropay" online payment solutions into your J2Store webshop. It is targeted at 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 (austrian or german) bank.The plugin builds on the eps XML definition (...
Not rated
J3
eps Ueberweisung and giropay payments for Joomla!
Paid download

eps Ueberweisung and giropay payments for Joomla!

By Schultz IT Solutions
Payment Gateway
This plugin integrates the austrian "eps Überweisug" and the german "giropay" online payment solutions into your JOOMLA website (if you do not use a webshop software). It is targeted at website 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 (austrian or german) bank.The plu...
Not rated
J3
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

jDBexport

Version:
4.0.8
Developer:
Schultz IT Solutions
Last updated:
Jan 07 2024
10 months ago
Date added:
Jul 07 2012
License:
GPLv2 or later
Type:
Paid download
Includes:
c m p
Compatibility:
J3 J4 J5 (b/c plugin)
Download

Uses Joomla! Update System

Demo Support Documentation

Score:

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

Write a review