[#5875] CBsubs total pending baskets

8 years 1 month ago - 8 years 1 month ago #279967 by beat
Replied by beat on topic CBsubs total pending baskets
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:
  1. Turn Site debug on
  2. Go to display the table you want to export (including all filters/searches you want)
  3. Look at bottom to expand SQL queries in debug zone and find the relevant query for displaying the columns in the table.
  4. Go to PHPmyAdmin or your prefered SQL program
  5. Paste the query (removing the LIMIT to get all rows)
  6. Click EXPORT (e.g. as CSV)
  7. 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 - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.175 seconds

Facebook Twitter LinkedIn