jDBexport
Version
3.0.3 (last update on Feb 15, 2013)
Rating
Compatibility
Reviews
8
License
GPLv2 or later
Commercial
Type
Date Added
24 June 2012
Editor's Note
- This extension requires registration to download.
jDBexport is forked from the well known (Joomla 1.5 data reports) extension SQL2Excel (actually SQL 2 Excel Pro).
Main features:
- on-the-fly, Ajax driven syntax check for your SQL queries
- scheduled automatic creation and delivery of workbooks to users by email
- include external databases (not only the JOOMLA database)
- use variable substitution to create individual reports (e.g. per user-id)
- use parameters to create individual reports on user demand
- format your reports with a wide varity of possibilities (color, fonttypes, fontsize, image inclusion, additional cells/columns/rows, and many others)
new features
- new color picker
- multilanguage support
...
jDBexport is available with a backend module and a frontend module (to provide quick links to workbooks) and a datagrid plugin (to embed worksheets in any content) and a datafield plugin (to embed a single cell from a worksheet in any content).
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/)
With SQL experience, my requirement was to extract the Information from the mysql database to Excel Worksheets using SQL.
I would have saved lots of time if I would have spent the Money at the beginning.
Meanwhile, I discover more and more Features.
In this case, I payed Little for that what I get.
Thanks!
I would have saved lots of time if I would have spent the Money at the beginning.
Meanwhile, I discover more and more Features.
In this case, I payed Little for that what I get.
Thanks!
User recently I liked at first this extension because she allowed me to make what I wanted, at least in main lines. Then, my need being very specific, I asked for help on the forum and the developer spent a lot of time to find a viable solution.
I thus recommend very warmly this extension, you can take it without fear
I thus recommend very warmly this extension, you can take it without fear
What can I say, SQL2Excel was amazing, the support and development stopped.
I can't express how gratefull I am that Schultz took it over, added already some small items ...
This is just another amazing product that everyone can use.
One thing might be usefull, but maybo not allowed due to copyrights, the manual idsn' completelly finished and i don't have a Sql2Excel version anymore ....
I hope that as soon as they have time they can complete it.
I can't express how gratefull I am that Schultz took it over, added already some small items ...
This is just another amazing product that everyone can use.
One thing might be usefull, but maybo not allowed due to copyrights, the manual idsn' completelly finished and i don't have a Sql2Excel version anymore ....
I hope that as soon as they have time they can complete it.
Owner's reply
Dear HLEBOEUF,
thanks for your kind words. The extensive documentation for jDBexport is next on our priority list (before adding any new features), however this will be done in a step-by-step task. Meanwhile you as customer can login to our website and navigate to the jDBexport -> Legacy issues, where you will find some helpful resources concerning the predecesor product sql2excel-pro.
This is, by far, the best reporting tool for Joomla! With full SQL support, use of dynamic parameters in SQL querries and cron scheduling this component fills a gap that is missing in the standard Joomla! release. The folks as Shultz have been responsive and proactive in solving issues relating to the move to 2.5+ and we thank them profusely for rescuing this component and bringing it into the newer versions of Joomla. Thank you Ruediger and team!
This extension is pretty much the same as SQL2Excel in J1.5
After a few problems I had with the settings I asked for support from Schultz. Their response is fast, and the help is good! Make sure You've got yr rights structure set properly, otherwise Joomla is not showing the download button. This is a Joomla thing, and does not mean the extension is not working!!
Ones I've got my settings and rights set the right way, the extension is working great!
You can't do without it if you wanne give yr website visitors a chance to download excel files!!!
After a few problems I had with the settings I asked for support from Schultz. Their response is fast, and the help is good! Make sure You've got yr rights structure set properly, otherwise Joomla is not showing the download button. This is a Joomla thing, and does not mean the extension is not working!!
Ones I've got my settings and rights set the right way, the extension is working great!
You can't do without it if you wanne give yr website visitors a chance to download excel files!!!
