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 module. 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 requires JOOMLA 2.5.6 or later.
  • jDBexport version branch 3.0.x is compatible with JOOMLA 2.5.x only!
  • jDBexport version branch 3.1.x is developed for JOOMLA 3.x only!

Subscribe now for only EUR 29,80 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
  • Export binary Excel (.xls) files ( 97-2003 format ) / CSV files / HTML
  • 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
    • Let MySQL explain the query statement
    • Add additional cells with text and formulas 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
  • Workbooks
    • compress (zip) your workbooks
    • 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 and postgreSQL 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 data tables into your content items)
  • Browsable reports in the Joomla frontend
  • Module for publishing reports in frontend
  • ControlPanel Module for publishing Administrator only reports in the 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 Bitmap Images into your spreadsheets
  • Data row background color (none / single color or two alternating colors with specified intervals)
  • Horizontal and vertical Freeze Panes
  • Copy Worksheets & Workbooks
  • Multilanguage support for (currently) the following languages
    • german (de-DE)
    • ... more to come soon ...
  • new color picker to easily select text and background colors

Further information

Subscribe now for only EUR 29,80 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