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. Also, you can use TXT files if they follow the proper format. Not following this format will result in an upload failure.
- We recommend column headers when using Excel to create your CSV file
- The system will reject CSV files with more than 3 columns
- You must save it as a comma delimited CSV file or TXT file
|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. Then, merge those columns into one field before importing into codeREADr.
CSV File Format Example
TXT File Format Example
Advanced – Trim Values
Trim Values (the default) means that the server will remove any leading or trailing spaces that appear in the barcode value. However, if you want them there, un-select 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 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:
Languages and Special Characters
You need to use UTF-8 character formatting. Thus, 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.).