jDBexport

jDBexport is a Joomla component which allows you to export data from your databases (JOOMLA and others). The reports are generated on-demand into an Excel document, when the users request them.

Forked from the well known (Joomla 1.5 extension) SQL 2 Excel Pro data reports extension jDBexport allows you to deliver data from your databases directly to your users. Write any valid SQL query in the configuration of this component. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file.

Please note that

  • jDBexport versionbranch 3.1.x is developed for JOOMLA 3.0 and newer!
    However, this versionbranch is also compatible with JOOMLA 2.5.6 and newer.
  • jDBexport versionbranch 3.0.x is compatible with JOOMLA 2.5 (minimum 2.5.6) only!
  • jDBexport versionbranch 3.0.x will reach it's end-of-life in january 2015!

For users with active subscriptions

Please remember to login to our website here to have full access to all available resources.

Subscribe now for only EUR 32,00 per year

This subscription is valid for 1 year and allows you to:

  • access the download aera and get all software updates available
  • access the full documentation for the product
  • access our support forum and submit support requests

AND

  • use the downloaded software forever - even after your subscription expired
  • access our product forum forever - even after your subscription expired
  • install the software on as many sites as you wish: one subscription - unlimited installations

jDBexport - ONE YEAR Subscription NOW!

Renewal discount: If you renew at least 15 days before your subscription expires you get a 25 % discount - and your new subscription will only start the day after your current subscription expires (so you don't lose a single day). This is our way to honor your ongoing support for this product.

Note: Prices are shown without VAT. On top of the listed prices 20% VAT will be charged unless you are a resident of a country outside the European Union or you are an EU resident outside Austria with a VIES-registered VAT number (in accordance to European Directive 2008/8/EU and its incorporation into EU member states' local laws).

Please note our genereal refund policy.

Overview

 

Full feature list

  • Create Excel Spreadsheets directly from database queries
  • Create OpenXML Excel documents (*.xlsx), binary Excel (.xls) files ( 97-2003 format ), Comma separated Value files (*.csv), HTML pages, PDF documents, JSON files
  • Backend ControlPanel
    • access all features of jDBexport from one panel
    • access all options through the JOOMLA options toolbar icon
  • Nested categories
  • Worksheets
    • Ajax powered, on-the-fly, syntaxerror check of your SQL query, directly in the worksheet form, while you write your SQL queries
    • List available tables and fields from the database to help you write your queries
    • Get help on creating SQL queries directly from the database developer pages
    • Let MySQL explain the query statement
    • Add additional cells with text and formulas, SQL queries or images anywhere in the worksheets
    • Create your worksheets from multiple SQL queries - not just one
    • Multiple worksheets in one workbook
    • Make worksheets readonly (password protected)
    • include Excel formulas
    • Use substitution variables in SQL queries - create dynamic queries based on user, time of day etc etc
    • set autofilters for any range of cells
  • Workbooks
    • compress (zip) your workbooks
    • protect your zip files with passwords (requires PHP 5.6 or higher).
    • define parameters which can flow into the database query (let users pass in parameter values to control the report generation)
  • Databases
    • Setup database connections and extract and include data from external databases. Built-in drivers for MySQL, MS SQL, Oracle, MaxDB, DB2, INGRES, postgreSQL, FireBird plus a custom driver allowing you to connect to any other database
  • Schedules
    • schedule automatic emails with attached reports (or not),  run SQL queries on a schedule to perform automatic database updates and more using the built-in Scheduler
  • Cache your reports to reduce server load
  • Data Grid Plugin (embed a worksheet directly into your content items)
  • Data Field Plugin (embed a single cell from any workbook/worksheet directly into your content items)
  • Use the frontend preview mode to browse and adjust your reports before you download them
  •  
  • Module for easy access to reports in frontend
  • Module for easy access to reports in backend
  • Advanced Formatting
  • Set print margin
  • Set paper size for printing
  • Set paper orientation for printing
  • Set grid lines visibility on/off  (print and screen)
  • Set horizontal/vertical alignment for printing
  • text and background color choices
  • Insert Images into your spreadsheets
  • Alternate datarow background color (none / single color or two alternating colors with specified intervals)
  • Horizontal and vertical Freeze Panes
  • Copy Worksheets & Workbooks
  • Multilanguage support for many languages (join in at our translation project with Transifex)
  • color picker to easily select text and background colors
  • define your own corporate-image respective colors for the worksheet layout
  • finetune the styles of any frontend functionality by using own CSS styles
  • and a lot more...

Further information

Subscribe now for only EUR 32,00 per year

This subscription is valid for 1 year and allows you to:

  • access the download aera and get all software updates available
  • access the full documentation for the product
  • access our support forum and submit support requests

AND

  • use the downloaded software forever - even after your subscription expired
  • access our product forum forever - even after your subscription expired
  • install the software on as many sites as you wish: one subscription - unlimited installations

jDBexport - ONE YEAR Subscription NOW!

Renewal discount: If you renew at least 15 days before your subscription expires you get a 25 % discount - and your new subscription will only start the day after your current subscription expires (so you don't lose a single day). This is our way to honor your ongoing support for this product.

Note: Prices are shown without VAT. On top of the listed prices 20% VAT will be charged unless you are a resident of a country outside the European Union or you are an EU resident outside Austria with a VIES-registered VAT number (in accordance to European Directive 2008/8/EU and its incorporation into EU member states' local laws).

Please note our genereal refund policy.

Copyright 2014 Schultz IT Solutions, Alle Rechte vorbehalten     Kontakt Impressum AGB Refund policy

 

Joomla 1.7 templates by hostgator coupon