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.

Note: We highly recommend creating an Export Template for your exports and optionally filter them as needed for each export. To select your template(s) use the Output Format drop-down menu.

Export a CSV screenshot

Without a template, the default format for the CSV file you receive is as follows:

Column Number Description
1 Scan ID – The unique numeric ID which codeREADr has assigned to the scan.
2 Service ID – The numeric ID of the service the scan belongs to.
3 Service Name – The plaintext name of the service the scan belongs to.
4 Device ID – The numeric ID of the device which submitted the scan.
5 Device Name – The plaintext name of the device which submitted the scan.
6 User ID – The numeric ID of the user who submitted the scan.
7 Username – The plaintext ID of the user who submitted the scan.
8 Barcode – The ID of the code submitted for the scan.
9 Scan Status – The validity status of the scan. 1 = Valid, 0 = Invalid, -1 = Saved Without Validation
10 Result – The response text returned for the scan.
11 Timestamp – The time at which the scan occurred. Formatted as “YYYY-Mmm-DD [24HH]:MM:SS”. (Example: 2011-Dec-25 23:59:59)
12 Question 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.
13 Answer 1 – The answer submitted for the first question.
14 Question 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.
15 Answer 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