Creating a CSV File

CodeREADr supports the extension CSV (Comma Separated Values) to quickly add barcodes to a database. These CSV files must meet the standards below. Not following this format will result in an upload failure. Also, it is recommended that header lines should not be used, as they will also import as a separate entry. Note: uploading CSV files with more than 3 columns will be rejected.

Requirements

Required Column Description
Yes 1 Value – Barcode to validate (100 character limit – contact support for options if you need more characters)
No 2 Response – Simple text, structured text, HTML or web content you want the app user to see after a scan.
No 3 Validity -Status of the value when scanned.
“1” for a valid response.
“0” for an invalid response.
Valid by default (even if Column C has a value that is not 0 or 1).

Hint for Column 2 text

If you want to present the app user with text from multiple columns within your CSV file, use the concatenate function of your Excel, Sheets or other database programs to merge those columns into one field before importing into codeREADr.

Advanced – “Webify”

The Response text can be text; or text with clickable URLs; or presented using HTML (online or offline).

Advanced – Contextual Variables

The Response text can also present specific information to the app-user based on SCAN_VALUE, USER_NAME, USER_ID and SERVICE_ID. For further information on how to customize the response text using contextual variables, please look here.

in Databases