How to scan using an iPhone - .CSV file export
There are many apps on the market for scanning bar and QR codes. Scan to SS is the only one we have found that exports a properly formatted .CSV file.
If you're scanning attendees as they arrive for your event, then you will only need to make one spreadsheet (this scan app creates spreadsheets) which will contain scanned data. If you're scanning attendees as they arrive for a session, then you will need a new spreadsheet for each session. This app allows you to create and save many spreadsheets (ultimately, a .CSV file).
CAVEAT: Scanning with a phone app will not be able to verify that the attendee has actually registered for the event/session. However, the scan gun, connected to a computer with wi-fi access, will be able to verify whether or not the attendee actually registered.
Where do I obtain this scan app?
Go to this link on your iPhone: http://berrywing.com/
Click the Scan to Spreadsheet icon and make the purchase.
Open the Scan to SS app on your iPhone
Name the new spreadsheet ...
When choosing a name for the spreadsheet, make it meaningful. For example,
- If you're scanning event attendees, include the name of the event (or a portion of it so that you don't get mixed up when uploading the .CSV file)
- If you're scanning session attendees, include the name of the session (or a portion of it so that you don't get mixed up when uploading the .CSV file)
Set the .CSV file delimiter ...
Now we need to set the delimiter for the .CSV file. What is a delimiter? A delimiter is a character that is used by a .CSV file to separate the data so that each datum goes into it's own column when imported into a spreadsheet program.
rsvpBOOK uses the pipe character to separate cells of data: | <-- (this key is just above the Enter key - its the character above the backslash)
The scan screen opens
Point the iPhone to the bar or QR code. It will autofocus and then automatically scan the code and save it to a new row in the spreadsheet. It will beep, indicating a successful scan.
After a scan, it will be ready to scan the next code. Continue scanning attendees as they come through the door. When finished scanning, tap the X in the upper left corner.