The purpose of Joomla.bid to offer you test extensions that will work, If you find an extension to be useful, we recommend purchasing it directly from the owner to receive support. Our 100% satisfaction guarantee. If for any reason you are not happy with your purchase, simply contact us within 30 days. contact us

Skip to main content
Free Registration Get Free 2 Euro & 6 Months Free Updates
jDBexp

jDBexport

 Demo  

jDBexport  v4.0.8

Version v4.0.8
Compatibility J3 & J4 & J5
Developer site Schultz IT Solutions external
License Read Rules external
Views 3,371
Dev Price € 38
Price € 3.3 6 Months Free Updates

See What's Inside

Only registered users can download. Free Registration! Get Free 2 Euro & 6 Months Free Updates Register
Remember to extract zip file!
Joomla.bid
Joomla.bid
Joomla.bid
Joomla.bid
Joomla.bid
Joomla.bid

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.

 

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

 
 
“REWARDS PROGRAM | WE PAY TO YOUR WALLET”
1 Euro for any new or updated item you share with us. *Read Rules
Get 50 Cents for every review you add.
We’d love to hear how satisfied with your download, please give it a rate of stars and leave a review. We will be grateful.
(2 reviews per day, we pay only if the item is downloaded)