- Posts: 647
- Thank you received: 31
Membership QR code - Possibility to log/record when Member card is scanned?
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
1 year 8 months ago #159896
by David Unwin
Membership QR code - Possibility to log/record when Member card is scanned? was created by David Unwin
Hi Tuan,
Our membership team have asked if it is possible to record when a membership card has been scanned. The reason I ask is that some of our events are not bookable and we want to record when a member comes to one of these events. At the moment we do a manual check of their membership. It would be really nice if this could be recorded somewhere in our Joomla data base so we can analyse who and when a member is checked in.
I can't see anywhere how we can do this, so I assume it would need to be a 'future' enhancement.
Kind regards
David
Our membership team have asked if it is possible to record when a membership card has been scanned. The reason I ask is that some of our events are not bookable and we want to record when a member comes to one of these events. At the moment we do a manual check of their membership. It would be really nice if this could be recorded somewhere in our Joomla data base so we can analyse who and when a member is checked in.
I can't see anywhere how we can do this, so I assume it would need to be a 'future' enhancement.
Kind regards
David
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
1 year 8 months ago #159901
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership QR code - Possibility to log/record when Member card is scanned?
Hi David
Could you please access to Membership Pro, then Tools -> Checkin Logs ? I think that's what you are looking for
Tuan
Could you please access to Membership Pro, then Tools -> Checkin Logs ? I think that's what you are looking for
Tuan
The following user(s) said Thank You: David Unwin
Please Log in or Create an account to join the conversation.
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 647
- Thank you received: 31
1 year 8 months ago #159902
by David Unwin
Replied by David Unwin on topic Membership QR code - Possibility to log/record when Member card is scanned?
Hi Tuan,
Yes, I can see the Action Log which Gives Username Name, Plan and Check-in Date.
I looked in Joomla DB tables and could not find any _osmembership log table, so I assume it is not stored there?
It looks like I can sort the logs by any of the headings. Also select the records, but only Delete them.
I don't think there is anyway to export it, am I right?
David
Yes, I can see the Action Log which Gives Username Name, Plan and Check-in Date.
I looked in Joomla DB tables and could not find any _osmembership log table, so I assume it is not stored there?
It looks like I can sort the logs by any of the headings. Also select the records, but only Delete them.
I don't think there is anyway to export it, am I right?
David
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
1 year 8 months ago #159905
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership QR code - Possibility to log/record when Member card is scanned?
Hi David
1. The table is #__osmembership_checkinlogs
2. Unfortunately, there is no option to export that checkin logs data
Tuan
1. The table is #__osmembership_checkinlogs
2. Unfortunately, there is no option to export that checkin logs data
Tuan
The following user(s) said Thank You: David Unwin
Please Log in or Create an account to join the conversation.
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 647
- Thank you received: 31
1 year 8 months ago #159910
by David Unwin
Replied by David Unwin on topic Membership QR code - Possibility to log/record when Member card is scanned?
Thanks Tuan,
I can export the table
Kind regards
David
I can export the table
Kind regards
David
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
1 year 8 months ago #159913
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership QR code - Possibility to log/record when Member card is scanned?
OK David. Happy to hear that.
Tuan
Tuan
Please Log in or Create an account to join the conversation.
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 647
- Thank you received: 31
1 year 8 months ago #159914
by David Unwin
Replied by David Unwin on topic Membership QR code - Possibility to log/record when Member card is scanned?
Just spotted a problem.
the check-in log has Subscriber id and Check-in date and time but no name or user name or plan name unlike the display of the Check-in log you can display in the back end
See screen shots
So exporting of check-in log does not give useful information as we can't see the plan name or user name in the exported data.
Maybe a future feature of Membership Pro 'Export of check in logs' for further analysis.
the check-in log has Subscriber id and Check-in date and time but no name or user name or plan name unlike the display of the Check-in log you can display in the back end
See screen shots
So exporting of check-in log does not give useful information as we can't see the plan name or user name in the exported data.
Maybe a future feature of Membership Pro 'Export of check in logs' for further analysis.
- Tuan Pham Ngoc
- Offline
- Administrator
-
1 year 8 months ago #159926
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership QR code - Possibility to log/record when Member card is scanned?
Hello David
It's not a problem but that's how database table is designed. You need to join the table with other tables like #__users and #__osmembership_plans to get necessary information.
Regards,
Tuan
It's not a problem but that's how database table is designed. You need to join the table with other tables like #__users and #__osmembership_plans to get necessary information.
Regards,
Tuan
The following user(s) said Thank You: David Unwin
Please Log in or Create an account to join the conversation.
- David Unwin
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 647
- Thank you received: 31
1 year 8 months ago #159938
by David Unwin
Replied by David Unwin on topic Membership QR code - Possibility to log/record when Member card is scanned?
Thanks Tuan for the information on the 2 data bases I need to join.
I will try that out
Kind regards
David
I will try that out
Kind regards
David
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
1 year 8 months ago #159940
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Membership QR code - Possibility to log/record when Member card is scanned?
OK David. Good luck !
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2025 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.