Part of Tendenci 6 ‘s push for greater openness is making it easier to get your data.
We’ve talked about the django-sql-explorer from ePantry in a previous post, but it can be overkill in some cases. A much simpler process is to use the prebuilt reports and exports!
For example on your Tendenci 6 site there is a page at: /memberships/reports/ accessible from the “apps” menu here (number 7 – requires super-user access):
Current Members
- Current Members Roster
- Current Members Quick List
- Current Member Totals by Company
Membership Trends
- Memberships Over Time
- Active Members YTD
- Members YTD by Type
Member Data
- Membership Joins Report Summary
- Active Memberships, filterable by join date
- Expired Memberships, filterable by expire date
- Renewed Members, filterable by renew date
- Pending Memberships
- Members in Renewal Period
- Expired Members in Grace Period
- Active, Pending & Expired Members by Type
Financial Reporting
- Membership Invoices
User Reports
- Administrators
- Site Users Added
- User Activity Summary
- User Access
- Contacts Report
- Corporate Membership Summary
- Top Spenders
- Users not in Groups
Management Tools
- Similar Users List
- User Import
- User Export
- Membership Import
- Membership Export
On screen it looks like this:
And of course you can still use the Django-SQL-Explorer on your site at /explorer/ and there is a help file on how to use SQL Explorer with your Membership Web Site.