Generating reports from Membership Pro

Hi
We have a requirement to generate some reports based on (say) looking for all of the subscribers to a plan based on the value of a custom field and probably export the list to a csv. I don't have a complete spec for the reports yet but am happy to write our own Joomla module to create them if they can't be done as standard in Membership Pro. Before I start looking at this I wondered if you have a published API (sorry if there is one and I haven't found it), or failing that, any documentation that you were prepared to make available on the database tables?
Thanks, Zoe

Hi Zoe

We do not have documentation for that. However, you can give you some useful information:

- The main subscriptions data is stored in #__osmembership_subscribers table
- The data for custom fields for subscriptions is stored in #__osmembership_field_value table
- You can look at administrator/components/com_osmembership/model/subscriptions.php file to see how we query code from database for subscriptions data

Hope this helps

Tuan

Hi Tuan
Thanks! I already found those two tables but code the PHP code - that's very helpful.
Zoe

There is no special PHP code. You would have to write code to query database directly to get the data you want

Regards,

Tuan