While we don't have integrated exports, I'm wondering if the following is not even better as it can be automated better:
It is quite easy to export a displayed table in CBSubs, CB or Joomla today with a little trick:
- Turn Site debug on
- Go to display the table you want to export (including all filters/searches you want)
- Look at bottom to expand SQL queries in debug zone and find the relevant query for displaying the columns in the table.
- Go to PHPmyAdmin or your prefered SQL program
- Paste the query (removing the LIMIT to get all rows)
- Click EXPORT (e.g. as CSV)
- Done!
5.b. You can even change the query, e.g. in Tax Report change the WHERE from "Completed" to "Pending" right now (in that case the Ordering should be
ORDER BY DATE_FORMAT(time_initiated, '%Y-%m')
), or remove unneeded columns in the SELECT, reorder them for import in the SELECT, and export to your favorite format.
Then you can also use it as stored query for your periodic exports as CSV.
Or include it as subquery into an INSERT IGNORE statement and automate the query.
There are probably Joomla extensions (or a CB query field to display only) that can be used to display or export SQL query results.
beat
