The Joomla Training Cohort has been launched!

Please send any feedback or bug reports to tim@cybersalt.com (opens new link)  

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.

Watch Me Work Live Streams 227

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 ► This email address is being protected from spambots. You need JavaScript enabled to view it.

Joomla Training Cohort ► https://cybersalt.com/jtc

mySites.guru ► https://mysites.guru

MigrateMe 4 ► https://www.php-web-design.com/Joomla...

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

FOLLOW US ON TWITTER! ► @basicjoomla

Like Us On FaceBook! ► https://www.facebook.com/basicjoomla


Interesting blog? Like it on Facebook, Post it or share this article on other bookmarking websites.

Written by:
Tim Davis is the founder and owner of Cybersalt.
Log in to comment

Add comment

Submit