Introduction

Data Import & Export, Database Management, Data Reports, Users Import & Export

How?

  • Favourite
  • Report

Get your data in CSV format

Export any table to CSV: transform your Joomla Database into a Excel file or Google Spreadsheet!

Pick one or more tables you want to expose, and enable them in the admin interface

That's it! Then just call index.php?option=comcsvexport&table=yourtable

Export any custom SQL query

How?

Create a MySQL View and execute any SQL query you want

The result will be exportable like a normal table.

Major advantages provided

  • choose which tables you want
  • optionally add a password to protect your data
  • select all fields (*), or just a few
  • set LIMIT and OFFSET parameters to the query URL to paginate the results

The results are sent using JSON to the requester.

Examples of what can it be used for

  • Integration with other sites
  • Integrations with ecommerce tools: extract your orders!
  • Create email lists
  • Backup and export data
  • Sync with other software or websites
  • Basically any custom integration you might think of.

Nice Extension



Posted on 29 June 2013
I used this extension to query tables on an e-commerce site. I needed a quick way for my customer to pull a list of products so I simply added the query string to an external URL, made it available on a menu item once they logged on and it worked like a charm.



I had some issues up front (mine not products) and contacted developer. He was very responsive and helped tremendously. This product is easy to use and does what it supposed to.



Thanks.
Map Locations
Paid download

Map Locations

By joocode
Maps & Locations
The most powerful maps extension for Joomla!. Provides over 130 different map designs, multiple maps, places listing, responsive design, custom markers, Street View and more! Provides over 130 different map designs Create multiple maps Responsive design Over 700 custom markers already included - and you can upload your own! Add places from our modern admin interface that shows the list of pla...
JSON Export
Paid download

JSON Export

By joocode
Data Import & Export
Export any table to JSON: transform your Joomla Database into a JSON API Export any table to JSON: transform your Joomla Database into a JSON API! Pick one or more tables you want to expose, and enable them in the admin interface That's it! Then just call index.php?option=comjsonexport&table=yourtable Export any custom SQL query How? Create a MySQL View and execute any SQL query you want Th...

CSV Export

Version:
2016.12.05
Developer:
joocode
Last updated:
May 23 2017
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Includes:
c
Compatibility:
3
Download

Uses Joomla! Update System

Score:


Write a review