|
KLLASC
|
March 28, 2017 at 5:50 am
Hi, I am trying to export two CSV reports filtered by specific Event date/times but looks like they are both giving me the same results which I would like to see who are those attendees check-in within specific Event date/times
For example:
Sample event page screenshot – http://prnt.sc/epfnnc
Event A(Presentation 1 and 2 – Day 1: 9am to 5pm)
Datetimes:
Name: Day 1- Presentation 1 Event start: 9am to 1pm
Name: Day 1: Presentation 2 Event start: 2pm to 5pm
How can I export the report that will show and tell who are those attended the Presentation 1 or Presentation 2? Assuming that the Attendee has registered for this Event A.
Appreciate your support on this.
Thank you
|
|
Josh
|
March 28, 2017 at 8:47 am
Hi there,
You can export a registration list for one date time only by going to Event Espresso > Registrations, then you click on the Event Check-In tab. Then you select the event, then you click on Filter. Then you select a date time and click filter again. Then you click on the Filtered CSV Report button.
If you don’t see a Filtered CSV Report button below the table, that’s a good indication that you need to update to the current version of Event Espresso 4.
|
|
KLLASC
|
March 28, 2017 at 10:12 pm
Hi,
Thank you for your reply. I can see the Filtered CSV Report button. But the CSV report results that I have filtered showing me same.
After I select date time and click filter again. Then I click on the Filtered CSV Report button.
Here’s the scenario below:
Registrant:
Attendee 1: Yahoo John
Attendee 2: Robert Gmail
For Event A – with datetimes filtered:
https://snag.gy/YnAGSC.jpg
Name: Day 1: Presentation 1 Event start: 9am to 1pm (Robert Gmail – check-in)
https://snag.gy/u1JZCs.jpg
Name: Day 1: Presentation 2 Event start: 2pm to 5pm (both attendee not check-in)
When I export Filtered CSV Reports to Presentation 1 and Presentation 2,
The results are the same.
See screenshot
https://snag.gy/u5QySP.jpg
How to identify from the Filtered CSV reports that Attendee 1: Robert Gmail check-in the event datetime :Presentation 1 ?
How to identify from the Filtered CSV reports that Attendee 1 & 2 didn’t check-in the event datetime: Presentation 2?
|
|
Josh
|
March 29, 2017 at 8:47 am
It sounds like maybe your ticket options aren’t set up to allow access to the specific datetimes.
If you go into edit the event, then click on the advanced settings for the tickets, does only the corresponding datetime have its box checked there? Or do both datetimes have the boxes checked?
|
|
KLLASC
|
March 29, 2017 at 9:45 am
Are you referring to this setup?
https://snag.gy/C45t7H.jpg
Yes, both datetimes have the boxes checked.
As I only need to show one free ticket for all datetimes indicated.
Are my settings correct?
|
|
Josh
|
March 29, 2017 at 10:44 am
I’m afraid that may not be the correct settings if that one free ticket isn’t intended to give access to both datetimes. Each datetime should have its own corresponding ticket. Then the registrant will make their selection and they’ll only appear in the check-in list for the datetime they have a ticket for.
Now, if you intend for that one free ticket to actually give access to all three different datetimes, you will get the same registration list from the check in views and CSV reports. The only difference you’ll see with regard to checkins will be on the filtered check in list view in the WordPress admin, in the checkin column.
|
|
KLLASC
|
March 29, 2017 at 11:13 am
Yes, we intend to have one free ticket to give access to all three different datetimes because we want each attendee have one QR code only.
We understand about the check in views and CSV reports will get the same registration list from my current settings. So aside from viewing the filtered check in list view in the WordPress admin. Is it possible to include the checkin column or/perhaps add datetimes column to the exported filtered CSV report? How can we do that?
Thank you so much for your response.
|
|
Josh
|
March 29, 2017 at 1:33 pm
You can add a bit of PHP code a functions plugin. I updated an example in our code snippet library so it adds the Datetime name and/or Datetime ID to a column, in addition to the timestamp of the checkin. Here’s a link to that snippet:
https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/jf_ee_registration_report_add_checkin_timestamps.php
|
|
KLLASC
|
April 11, 2017 at 3:59 am
Thanks. Will try and let you know if we manage to implement the snippet correctly. 🙂
|
|
KLLASC
|
April 14, 2017 at 9:18 am
Hi, I’ve tested the snippet. It does added new column to get the Datetime name.
But If the atteddee checked-in to multiple Datetimes. The Datetime report shows into one column only.
https://snag.gy/SKZROH.jpg
But is it possible that for every Datetime name, it adds a new column instead? So that It will be easy to filter out the report.
see sample screenshot:
https://snag.gy/ZODaFc.jpg
Thanks
|
|
Josh
|
April 17, 2017 at 9:15 pm
Hi there,
Here’s a link to a github gist that shows another code example that will loop through each datetime and add a checkin column with an “x” if there’s a checkin for that registration:
https://gist.github.com/joshfeck/4a8ea5b02855ebd4d7cc720dd6112d5f
|
