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.
- Video title: "(1) Intro to jDBexport with Ruediger Schultz - 👀 WMW 227 - YouTube"
- Tim Davis, host of the Basic Joomla Tutorials YouTube channel, introduces Ruediger Schultz, the guest.
- Tim Davis shares his experience with Joomla and mentions his work on Joomla sites, extensions, and tools.
- The video is sponsored by MySites.Guru, promoting a free site audit for Joomla sites.
- Ruediger Schultz discusses his history with Joomla, including developing the JDB Export extension.
- JDB Export allows users to export data from the database and create documents using SQL queries.
- Ruediger Schultz demonstrates JDB Export's features, including connecting to different databases and writing SQL queries.
- He showcases the ability to export data from a Joomla database and an additional Nations database.
- The extension supports various database types, including MySQL, Oracle, Microsoft, PostgreSQL, IBM DB2, and more.
- Ruediger demonstrates a practical example of using JDB Export to answer a user's question about exporting user login history.
- He shows how to write SQL queries, including wildcards and date filters, with the help of Chat GPT.
- The video concludes with a demonstration of creating a workbook, running parameters, and automated email delivery of exported data.
Note: The transcription appears to be cut off towards the end, and some information might be missing.
SUBSCRIBE TODAY! â–º https://goo.gl/N6y5bH
Watch Me Work live streams â–º 
• Find and Replace ...
Here are some of the links mentioned in this Live Stream - and some others:
Contact Tim Davis â–º
Joomla Training Cohort â–º https://cybersalt.com/jtc
mySites.guru â–º https://mysites.guru
MigrateMe 4 â–º https://www.php-web-design.
Stageit for Joomla ► • First Look at Sta...
Backing Up Your Joomla Site with Akeeba ► • How to Backup a J...
Better Frontend Link â–º https://regularlabs.com/
FOLLOW US ON TWITTER! â–º @basicjoomla
Like Us On FaceBook! â–º https://www.facebook.com/
Add comment