Membership QR code - Possibility to log/record when Member card is scanned?

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

Hi David

Could you please access to Membership Pro, then Tools -> Checkin Logs ? I think that's what you are looking for

Tuan

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

Hi David

1. The table is #__osmembership_checkinlogs

2. Unfortunately, there is no option to export that checkin logs data

Tuan

Thanks Tuan,
I can export the table
Kind regards
David

OK David. Happy to hear that.

Tuan

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.
 

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

Thanks Tuan for the information on the 2 data bases I need to join.
I will try that out 
Kind regards
David

OK David. Good luck !

Regards,

Tuan