Help Documents - Version 5 Event Check-in OptionsHow to scan to a .CSV file of Event Attendees

How to scan to a .CSV file of Event Attendees

You will need one of the scan devices listed here:

  • Obtain a scan gun that exports a .CSV file - not all do. If you are purchasing a scan gun, be sure that it saves scans to an SD card or other memory device.
  • Obtain a smart phone app that exports scans to a .CSV file. Our recommended list contains 2 scan apps (iPhone and Android) that export a .CSV file of registrant IDs.

Scan attendee's barcodes as they enter your event with the scan gun or smartphone app. When finished scanning ...

  • Scan gun - remove the SD card from the gun and import the .csv file to your computer.
  • Email the .CSV file from the smartphone to yourself.

1. Scan attendee's barcodes as they enter your event with the scan gun or smartphone app.

When finished scanning ...

  • Scan gun - remove the SD card from the gun and import the .csv file to your computer.
  • Email the .CSV file from the smartphone to yourself.

2. Get the exported .CSV file on to your computer where it can then be uploaded into rsvpBOOK.

Depending upon the scan method you used, save the .CSV file to a known folder on your computer  The next step will upload it and mark your attendees Attended.

3. From your event's Admin Dashboard, open the Event Attendance Manager screen ...

The upload screen opens ...

  1. Browse to the .CSV file on your computer
  2. Check the box if your file has column labels - if you're not sure, open the file with a text editor and visually check it
  3. Click the Upload .CSV File button
  4. You can re-upload your .CSV file in case you have added registrant IDs to it.  If registrants are already marked attended, they will remain so.

Now map the Registrant ID field ...

The upload confirmation screen opens ...

This example had 7 registrant IDs in the .CSV file.  All 7 were marked attended.

The Attendance List has been updated and registrants in the .CSV file have been marked "Attended"

To verify, click the View Attendance Report screen on the Session Attendance Manager screen. The "No Shows" were not in the .CSV file; therefore their registrant status remains "Not Attended," the red Xs.

Including registrant status "Attended" in custom reports.

You can create your own "attendance" reports with the Report Wizard. After defining the fields you want included in the report, add a filter to the report for the Registrant Status LIKE attended.

You can also send post-event surveys to event attendees.  Since you know who attended now, the email wizard has the tools you need to send post-event surveys to both groups (attended and no-shows).

0 Comments

Add your comment

E-Mail me when someone replies to this comment