Exporting CSV for guest check-ins

  • Resolved timb111

    (@timb111)


    4 years, 12 months ago

    I want to check in guests as they arrive by just asking for their names and manually checking each one in on my phone, and not requiring them to produce a QRCode or booking email. Is there a way to do this with EME?

    I tried using [eme_attendees_report_link] to generate a CSV file so that I can open the CSV in the Google Sheets app and tick them off there, but I can’t get this shortcode to produce anything. I created an event template (#_EVENTNAME #_STARTTIME) and also an attend template (#_ATTENDFIRSTNAME #_ATTENDLASTNAME) and used the shortcode [eme_attendees_report_link event_template_id=6 attend_template_id=7] but it doesn’t output anything.

    Or is there a clever way to check guests in that I haven’t found yet?

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Franky

    (@liedekef)

    4 years, 12 months ago

    This shortcode requires the user to be logged in (and to have the capability to list EME registrations).
    If you want to have a list of attendees for an event, you could also use [eme_attendees] inside the single event template format (and use the correct options for this shortcode).

    Thread Starter timb111

    (@timb111)

    4 years, 12 months ago

    I am logged in as the WordPress admin, and I still don’t see anything with eme_attendees_report_link.

    Yes I made a page with eme_attendees and that looks good but I can’t tick people off the list.

    Plugin Author Franky

    (@liedekef)

    4 years, 12 months ago

    Well, start with just “[eme_attendees_report_link]” (the extra template options were currently ignored, fixed in dev), but it should give a link. If not: check your php logfiles for errors/hints. It works fine here.
    Also, best is to go in the backend and click on CSV report per event there, the attendees CSV list generated via that shortcode will not be what you expect (it is for all future events, and per event in 1 cell all attendees). I’m planning on reworking the output for that option completely …
    And if you want the link to the CSV link to appear in the frontend, best is to use #_EVENTCSVBOOKINGSLINK or #_EVENTCSVBOOKINGSURL in your single event template (see the doc on those placeholders).

    • This reply was modified 4 years, 12 months ago by Franky.
    • This reply was modified 4 years, 12 months ago by Franky.
    Thread Starter timb111

    (@timb111)

    4 years, 12 months ago

    Thank you, I’ll try to test further with [eme_attendees_report_link].

    Also, best is to go in the backend and click on CSV report per event there

    Yes I’ve used this but I had to fiddle with it before the event. I also have a couple of people who help run the events but I don’t want to give them access to EME which is why I was looking for an alternative for when I’m not attending the event.

    And if you want the link to the CSV link to appear in the frontend, best is to use #_EVENTCSVBOOKINGSLINK or #_EVENTCSVBOOKINGSURL in your single event template (see the doc on those placeholders).

    Yes, front end would be best so I don’t need to give other organisers access to the back end. I’ll try out these placeholders.

    • This reply was modified 4 years, 12 months ago by timb111.
    • This reply was modified 4 years, 12 months ago by timb111.
    Plugin Author Franky

    (@liedekef)

    4 years, 12 months ago

    Well, in all cases (the shortcode, the backend or the placeholders) you need the correct rights. In the case of [eme_attendees] (or [eme_bookings]) this is not needed (as those purely work on the frontend) and you could generate a html-table that could be easily copy-pasted in excel, but that’s a little less practical .

    Thread Starter timb111

    (@timb111)

    4 years, 12 months ago

    Ok thanks, it sounds like none of the solutions is ideal for checking in guests. Maybe I need to get the CSV from the back end before an event, insert it into Excel or Google Sheets, then send it to the people who help run the events to check off people as they arrive.

    Plugin Author Franky

    (@liedekef)

    4 years, 12 months ago

    It all depends on what you want to achieve. If it is for noting down who was present and not, you could do the csv thing, or as a logged-in user scan the qrcode that can be generated per booking (that will increase a counter per booking too, next to keeping attendance info in general).
    If you only want to check if they booked/paid: scan the qrcode (even when not logged in) and it will give you the info (and there’s an option per event that allows you to decide what to show when scanning the qrcode and not logged in).

    Thread Starter timb111

    (@timb111)

    4 years, 12 months ago

    Thanks for explaining about the qrcodes. I want to note who is present as well as the total attendee count.

    I find that event guests can be disorganised and so if I have a queue of people to check in we’d all be waiting for someone to go through their phone to find the correct confirmation email and then someone else wouldn’t have internet connection and it slows things down. So I’d rather just ask their name as I can process people quicker without relying on them to produce anything.

    Plugin Author Franky

    (@liedekef)

    4 years, 12 months ago

    Well, that’s why the CSV export in the backend was originally intended 🙂
    Small hint: configure your event to stop accepting RSVP’s 1 hour before the event starts or so (if not sold out), so if you take your CSV export 1 hour beforehand, it is ‘stable’.

    Thread Starter timb111

    (@timb111)

    4 years, 12 months ago

    It’s good when events are full beforehand then I can use the CSV. But if there’s a shortage of people booking then I prefer to leave the bookings open until the event start, even sometimes until the event ends as some people may turn up even without booking.

    Thanks for the ideas 🙂

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Exporting CSV for guest check-ins’ is closed to new replies.