JSON Export

Be sure to check out the admin interface of the extension, too. 

 

How to use CSV Export? You must call the frontend of the site with a query URL, like:

 

http://demo.joocode.com/index.php?option=com_jsonexport&table=o29t1_content

 

The URL parameters you can add the the CSV query are:

  • table (required): defines the name of the table you want to export
  • fields (optional): defines one or more fields you want to export. If you want to export everything, don't add this parameter.
  • limit (optional): limits the query to a value
  • offset (optional): starts the query with the specified offset

 

The latest 2 are useful when you need to export a lot of data, so you can do it in chunks.

 

Here you can try some examples. If the result is empty, someone else played with the demo and set the authentication ON, or changed username and password. In this case, try going in the admin interface and change the options.

 

 

http://demo.joocode.com/index.php?option=com_jsonexport&table=o29t1_content

http://demo.joocode.com/index.php?option=com_jsonexport&table=o29t1_content&fields=id,title&limit=1 (limit to 1, only list id and title)

http://demo.joocode.com/index.php?option=com_jsonexport&table=o29t1_content&limit=1&offset=3 (start with an offset)

http://demo.joocode.com/index.php?option=com_jsonexport&table=o29t1_categories&table=com_categories (shouldn't work, it's not enabled - unless another user enabled it. Try enabling/disabling it from the admin interface)

http://demo.joocode.com/index.php?option=com_jsonexport&table= o29t1_content&user=x&password=y (try enabling the authentication, or changing username / password)