Article sections

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

    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, 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:

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