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.

Restrictions

  • We recomment 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

Requirements

RequiredColumnDescription
Yes1Value – Barcode to validate (100 character limit – contact support for options if you need more characters)
No2Response – Simple text, structured text, HTML or web content you want the app user to see after a scan.
No3Validity -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

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. However, if you want them there, uncheck 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:

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

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.).

in Databases