- Posts: 646
- Thank you received: 31
Export Membership Pro Checkin Logs for offline analysis
- David Unwin
- Topic Author
- Offline
- Platinum Member
Less
More
1 year 4 months ago #159915
by David Unwin
Export Membership Pro Checkin Logs for offline analysis was created by David Unwin
Membership Pro has a very useful feature (QRCODE Scanner) Where you can place a QR Code on the users membership card.
You can then scan this QR Code each time a member say attends one your events. The scan is then recorded and you can see the details in the backend of MP under Tools> Checkin logs
It shows the Username Name Plan Checkin Date ID
So you can see when each member has been checked in.
However, if you want to do further analysis such as a count of how many times a user or plan type has been checked in you can't do that as there is no export function
You can via PHPMyAdmin export the osmembership_checkinlogs table, but that only contains a subscriber id and checkin date, not the plan, name or user name
What is needed is to be able to select and export the data to say excel or CSV for further analysis
So what would be good is to be able to select say Name, Plan and/or a range of dates and then export the data so that you can do further analysis.
KInd regards
David
You can then scan this QR Code each time a member say attends one your events. The scan is then recorded and you can see the details in the backend of MP under Tools> Checkin logs
It shows the Username Name Plan Checkin Date ID
So you can see when each member has been checked in.
However, if you want to do further analysis such as a count of how many times a user or plan type has been checked in you can't do that as there is no export function
You can via PHPMyAdmin export the osmembership_checkinlogs table, but that only contains a subscriber id and checkin date, not the plan, name or user name
What is needed is to be able to select and export the data to say excel or CSV for further analysis
So what would be good is to be able to select say Name, Plan and/or a range of dates and then export the data so that you can do further analysis.
KInd regards
David
Please Log in or Create an account to join the conversation.
- David Unwin
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 646
- Thank you received: 31
1 year 1 month ago #161923
by David Unwin
Replied by David Unwin on topic Export Membership Pro Checkin Logs for offline analysis
This feature was implemented in MP version 3.4.2 November 1, 2023
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
1 year 1 month ago #161924
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export Membership Pro Checkin Logs for offline analysis
Yes. I was about to inform you that this feature was implemented
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- David Unwin
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 646
- Thank you received: 31
1 year 1 month ago #161926
by David Unwin
Replied by David Unwin on topic Export Membership Pro Checkin Logs for offline analysis
Thanks Tuan,
For us this is a very useful feature where we have events that members come to and we don't use Event Booking. Before we had to do manual logging of members attending these events.
Great support as usual.
For us this is a very useful feature where we have events that members come to and we don't use Event Booking. Before we had to do manual logging of members attending these events.
Great support as usual.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
1 year 1 month ago #161930
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export Membership Pro Checkin Logs for offline analysis
OK David. I'm glad it helpful. Honestly, you are the only one asked for this feature, but I decided to implement it to help you handle things easier
Tuan
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.