Joomla! Extensions Directory

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. 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).

  • Get this

Main features

  • create data reports in various formats (xlsx, xls, csv, html, pdf, json) from your databases
  • individualise these reports with variable substition 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
  • 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
  • include virtually any accessible database - local or remote - into your reports (MySQL, MariaDB, MS-SQL, ORACLE, DB2, INGRES, SAP MaxDB, PostgreSQL, Firebird and others)
  • 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, support for additional Truetype fonts in PDF creation)

and many other features
...

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/projects/p/jDBexport/

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


Functionality

This component has a ton of features.

Ease of use

Extremely easy to use

Support

Support is the best I have ever seen. The developer assisted me to enable MSSQL support to this component for a nominal fee.

Documentation

Documentation is excellent!

Value for money

Very good value

I used this to: Reporting from a Remedy Database (MSSQL) and other reporting needs.

Functionality

Creates Excel Workbooks with multiple sheets and formatting from your Joomla and even external databases. Also can export worksheets as CSV.

Ease of use

Configuration is easy, setup of sheets also, even verifies your SQL queries.

Support

Brilliant. The developer is friendly, responds quickly and also implements additional features.

Documentation

Component is quite self-explanatory. Additional documentation is on the website. There could be more, but it is sufficient for most cases.

Value for money

Reasonable pricing. Well worth it.

I used this to: Exporting event attendees. Synchronisation of calendars across multiple sites.

Functionality

A lot of functionality to export data and format your data. You need to know SQL for ask the good. The result is very clean.

Ease of use

You need to read the documentation but it's useful after.

Support

Ruediger answer very quickly and delivery very good solution. Excellent!!!

Documentation

Some blank chapter in the documentation, but with the demo site and the forum you can find your question.

Value for money

Very very good

I used this to: Export data from Community Builder and some other extensions like forms...

Functionality

Exactly what I need. Couldn't find any other component with this functionality and all the features.

Ease of use

It is easy to use, the learning curve isn't that steep. If you have a problem, you will be helped in a matter of a few hours.

Support

Very very quick. Schultz IT came up with a solution for every single one of my problems.
If something is not possible the feature is added.

Documentation

The documentation is very actual, easy to use, with lot's of examples.

Value for money

Schultz IT will help you until your problem is fixed and this for a little over 30 Euros.

I used this to: Exporting data for example from Event Booking (Joomdonation) to Excel. The teacher receives a list of attendees with all needed information.
Address lists for all of our members from the component Fabrik.

Functionality

Export data from (joomla) tables to different formats. I use excel.

Ease of use

Relatively easy!

Support

Always fast and good support!

Documentation
Value for money

Great!

I used this to: I use this extension to create custom reports on my site. The extension allows me to use sql and create any query/report I want. By using access levels, I can define different reports for different users.

Functionality

Easy to create tables in a lot of different formats. Able to mine data from database and insert into content or send in email as attachment.

Ease of use

The live SQL syntax check, clear user interface makes the component easy to use.

Support

Support is excellent, fast and always delivers solution.

Documentation

Online documentation available directly from the component.

Value for money

Definitely great value for money.

I used this to: I bought the paid version of its great predecessor, which was discontinued, so I was glad to hear about its reborn.
Since then, the component has been completely rewritten, with improved database support, extended file format support, with always expanding features.

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.


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.


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.


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.

jDBexport

Version:
3.2.1
Developer:
Schultz IT Solutions
Last updated:
Jul 21 2015
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Uses updater:
Includes:
Compatibility:
Download Demo Support Documentation
  • Overall
  • Functionality

  • Ease of use

  • Documentation

  • Support

  • Value for money