Exporting Scans as CSV File

It’s easy to export exactly the scans you want into a CSV file. After signing into codeREADr, click the “Scans” link in the navigation bar at the top of the page.

Screen_Shot_2011-11-17_at_6.27.02_PM_normal

 

Whenever you would like to export the scans you are currently viewing, click one of the buttons on the left of the page, under the heading “Export a CSV File”. You can either download the CSV directly to your hard drive, or have it emailed to you.

The default format for the CSV file you receive is as follows:

Column NumberDescription
1Scan ID – The unique numeric ID which codeREADr has assigned to the scan.
2Service ID – The numeric ID of the service the scan belongs to.
3Service Name – The plaintext name of the service the scan belongs to.
4Device ID – The numeric ID of the device which submitted the scan.
5Device Name – The plaintext name of the device which submitted the scan.
6User ID – The numeric ID of the user who submitted the scan.
7Username – The plaintext ID of the user who submitted the scan.
8Barcode – The ID of the code submitted for the scan.
9Scan Status – The validity status of the scan. 1 = Valid, 0 = Invalid, -1 = Saved Without Validation
10Result – The response text returned for the scan.
11Timestamp – The time at which the scan occurred. Formatted as “YYYY-Mmm-DD [24HH]:MM:SS”. (Example: 2011-Dec-25 23:59:59)
12Question 1 – The text of the first question displayed. Questions appear in the CSV in the order they were asked. See the Data Collection API documentation for more details.
13Answer 1 – The answer submitted for the first question.
14Question N – Subsequent questions will appear under the corresponding numbered column up to N, where N is the total number of questions attached to the scan.
15Answer N – Subsequent answers will appear under the corresponding numbered column up to N, where N is the total number of question answers collected.
in Scans