[SOLVED] Export Option in CBSubs

I am not aware of any exporting options for CBSubs.

Are there any plans to include some export features. The advance searching is great, but it would be nice to be able export the lists it returns.

There are plans for exporting, but currently there is no exporting functionality. You'd need to use direct database queries then export the results using phpmyadmin at this time.

Hey Kyle,

That's unfortunate, particularly for those site owners who have have little no experience messing about in phpmyadmin.
CBSubs is very versatile and powerful. It's a shame some kind of exporting option hasn't been introduced by now.

Hopefully we'll see this feature soon.

BTW - It would also be nice to have something for CB itself. I've used CBJuice, but it has its limitations.

Cheers!

There's also 3rd party reporting extensions. I believe you'd typically supply them with a query and it'll build a table that you can export or just view.

BTW - It would also be nice to have something for CB itself. I've used CBJuice, but it has its limitations.

We've plans to implement a generic import/export solution into CB directly that core CB and its various plugins could utilize.

No experience with this but it looks good:

extensions.joomla.org/extensions/extension/core-enhancements/data-reports/alter-reports

Wondering if I could get some assistance with a query I'd like to pull from a database using the 3rd party export extensions. I'm not all that familiar with SQL query lingo

Looking to pull a list of expired subscribers whose expiration date is October 1, 2014 or earlier

SELECT id, status,user_id, plan_id, subscription_date, last_renewed_date
FROM wxyz_cbsubs_subscriptions
WHERE expiry_date ? (if I can add a range here it would be good, anything before October 1, 2014)
ORDER BY ?

It would be nice to also have the user name associated with the query to be part of the results.