Export Membership Pro Checkin Logs for offline analysis

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
1 year 4 months ago #159915 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
 

Please Log in or Create an account to join the conversation.

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
1 year 1 month ago #161923 by David Unwin
This feature was implemented in MP version 3.4.2 November 1, 2023

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

  • David Unwin
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
1 year 1 month ago #161926 by David Unwin
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.

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.