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

  • Get this
  • Favourite
  • Report

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

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


Functionality

Used for getting data out of various Joomla products

Ease of use

You'll need a bit of SQL knowledge to get full use, but a keen amateur could probably find all the code they need on the web.

Support

Always there and willing to help when you need it.

Documentation

Fairly comprehensive, just a few gaps an maybe a few more examples would help.

Value for money

Excellent value

I used this to: Extracting reports from other extensions that have left reports as an after-thought.

Functionality

There is no way to add a password-to-open to the spreadsheet. Ruediger offered to custom develop this, but I came up with a workaround.

Ease of use

Very clear to use - I barely needed the manual.

Support

Unusually outstanding support - A+. Ruediger responded immediately to a minor issue I had, and quickly developed a patch.

Documentation

Very good, although not really needed for most use cases once you understand the basics.

Value for money

Well worth the money

I used this to: jDBexport was a great way for our club to transition from an Excel based membership database to an online Community Builder database. We still have many workflows that require the spreadsheet, but now they can be automatically generated/maintained from the database.

Support


Posted on 22 June 2016
Functionality

Super product with great features

Ease of use

Easy to use

Support

Excellent support in upgrading to the latest version 3.2.4.
Support was always very quick with the answers and the correct solution.

Documentation
Value for money

price-performance best note


MUST HAVE


Posted on 12 May 2016
Functionality

Brings everything it promises and more. Finally able to give an easy way for non-techies to get data-extractions from database!

Ease of use

Relatively easy to set up and once you get used to the system, really easy to use.

Support

First class. Had some issues and got always personal and timely support!

Documentation

Documentation in the web is easy to understand and covers all the bases. Perhaps a couple of more examples there would be ok but that's all.

Value for money

For this price this is a professional tool and absolute value for money!

I used this to: Allowing my "non-techies" to extract mailing-files for our organization for printing labels etc.

Functionality

Exceptional component for extracting data from you Joomla database and presenting the information to our clients in Excel workbook form.

Ease of use

Extremely easy to use this component. You must have basic knowledge of Structured Query Language (SQL). Easy to configure!

Support

The support for JDBExport is AWESOME! Worked with developer on a number of problems. He was very responsive and stayed on issue til fixed.

Documentation

Online documentation is available. I've used it a number of times. It is concise and to the point. I don't have to read mounds of content!

Value for money

This is a must have if you provide informational reports to your clients. Who doesn't use spreadsheets for analysis! Must have in toolbox!

I used this to: JDBExport is used as our general reporting tool. All of my clients use spreadsheets to analysis and provide listing to co-workers. It is used to generate workbooks that are used in updating our Microsoft Exchange distribution list via Powershell, and a multitude of other tasks!

Functionality

Gets the job done! A straight-forward way to create excel exports and reports from your sites database.

Ease of use

Install, create a category, worksheet, and workbook, then hook it to a menu item and, presto, instant reporting.

Support

Outstanding support via the forum and from the developer.

Documentation

Extensive documentation is on the website. If you have a question though, just jump in the forum for help.

Value for money

I have used this component for years. It is a really great tool. It is part of my "default" setup for new Joomla sites.

I used this to: creating reports for my custom ordering component. Saves me a tonne of time since I don't have to write a reporting module for my component. Looking forward to creating scheduling for reports and automating administrative tasks for my site managers.

Functionality

Does exactly what it says it will - and leads you through the process beautifully

Ease of use

You'll wonder why you ever used anything else - but make sure you at least skim-read the manual

Support

Haven't needed it yet - but the support I've has been timely, complete and clear

Documentation

Everything you need to know and best of all, clear and concise

Value for money

Excellent- a great time-saver. The product sold itself - I didn't bother with an evaluation copy first and I wasn't disappointed

I used this to: Database reporting, and probably a great deal more. Experimenting with a combination of this and Breezing Forms at the moment - so far, the two are complementary. This is the way software should be written - but usually isn't.

Awesome Product


Posted on 06 October 2015
Functionality

I have been using this product for over 6 years. Since its been taken over by Schultz IT, it has just been getting better and better

Ease of use

RTFM, its all there. Reasonably easy to use.

Support

Great support, Always responsive

Documentation

Better than most that I have seen

Value for money

Great value for money


Functionality

I have made several Workbooks that helped a lot. It always collects the latest data into a fresh Excel-sheet of html-output.

Ease of use

The possibilities of formulas and formatting are great. I must admit, knowledge of Excel and SQL is required to use it to the full extent.

Support

Direct support from the developer is simply perfect. Response is quick and solutions are round the corner.

Documentation

Extended documentation about the possibilities is available online, with lots of examples.

Value for money

It was totally worth it to buy the extension and support the developer. He's really committed to get you the solution you want.

I used this to: I use it for generating downloadable reports about filled in forms (made with BreezingForms) and to get latest data from my users (for sending a mailing for instance). I've been a happy user also when it was still SQL2Excel.

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.

jDBexport

Version:
3.2.7
Developer:
Schultz IT Solutions
Last updated:
Aug 08 2016
Date added:
Jul 07 2012
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