Join us as Ruediger Schultz shows us Joomla extension: jDBexport. 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.
00:06:22 Hands-on Demonstration
00:24:03 Advanced Features
00:39:25 Specialized Functionality
00:51:40 Business Insights
01:09:41 Q&A Closing
✅ Summary
1. Introduction to JDB Export & Rudiger's Background
Rudiger shares his journey with Joomla and the motivation behind developing JDB Export as a powerful data reporting tool.
2. Overview of JDB Export Features
The extension enables database exports, supports automation, and offers workbook/worksheet structures with rich formatting options.
3. Demo: Exporting Data with SQL Queries
A live demonstration shows how to export data (e.g., nations by area) using SQL queries—with help from tools like ChatGPT.
4. SQL Assistance & ChatGPT Integration
JDB Export supports users with limited SQL knowledge through built-in tools and encourages leveraging ChatGPT for query generation.
5. Exporting User Login History
An example shows how to extract and refine login event data using SQL and ChatGPT—filtered by date and keywords.
6. Automation & Scheduling
Users can automate exports (e.g., hourly, monthly) and send data via email, ideal for recurring tasks like sales reports.
7. Formatting Excel Output
Extensive options allow users to format exports with custom headers, colors, merged cells, logos, charts, and more.
8. Exporting to HTML & Website Display
JDB Export can create HTML reports and display data via plugins like Data Grid or Data Field, even pulling from external apps.
9. Real-World Use Cases & Pricing Talk
Rudiger explains JDB Export’s versatility, its value compared to enterprise tools, and Joomla users’ expectations around pricing.
10. Future Plans & Closing
Plans for Joomla 5/6 redesign, backend data tools, and extension maintenance challenges wrap up the session—with encouragement to ask questions and stay curious.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment