Creating a CSV File

CodeREADr supports the CSV (Comma Separated Values) file type, allowing you to quickly add barcodes to a database. These CSV files must be in the proper format or they will not be read correctly.  TXT files may also be used if they follow the proper format. Not following this format will result in an upload failure.

Restrictions:

  • Header Lines should not be used
  • CSV files with more than 3 columns will be rejected
  • Must be saved as a comma delimited CSV file or TXT file

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 so you can upload only 2 columns

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.

CSV File Format Example:
CSV File Format
TXT File Format Example:
TXT File Format
Advanced – Trim Values
Trim Values (the default) means that the server will remove any leading or trailing spaces that appear in the barcode value. If they are meant to be there, then un-check that option.

Advanced – “Webify”
The Response text can be text; or text with clickable URLs; or presented using HTML (online or offline).

Advanced – Invisible Formatting
Sometimes the formatting in a CSV file adds invisible characters, polluting the data. Simply move the values into a TXT file, either by opening it in a text editor like Notepad or copy and pasting the values manually. Then, find the formatting errors, delete them, and move the values back into the file.

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 follow these steps:

  1. Branding and Customizing the App
  2. Creating a Database
  3. Importing a CSV file

Languages and Special Characters
UTF-8 character formatting is required. If you are not sure how to save and export as UTF-8, please use Google Search for instructions.  They will vary depending on the database service you use (e.g. Excel Google Sheets, etc.).

in Databases