User's Manual

KDC350 User Manual
90
DB Lookup Application
The DB Lookup application allows you to download a database to the KDC which can then be utilized for
advanced AUTO-ID applications like displaying additional data after scanning a barcode. For example,
using our DB Lookup application, you could download a product database including information such as
description, price, and stock quantity. With the advanced data functionality built-in to the KDC, you could
easily display product price, description, and stock level after the product’s barcode is scanned.
Functionality of DB Lookup Application
 The database size cannot exceed 800 records.
 The maximum record size is 128 bytes.
 Each record can have up to 4 fields including the barcode which is the primary key.
 The maximum field size is 39 characters.
 Quantities can be entered by pressing the UP or DOWN scroll buttons after DB fields displayed.
 Quantity can be 1 to 128.
 User can create a database using Microsoft Excel.
o Excel file must be saved as .txt.
o Records should be separated by CR/LF
o Fields should be separated by TAB.
o Database should end with CR/LF.
o Last 4 bytes of database should be CR/LF/CR/LF.
DB Lookup Fields and Settings
 Download DB to KDC - Downloads user created database to KDC.
 Starting Quantity - Enter predefined start quantity for each scanned barcode. The start quantity
can be defined from 1 to 128 and is modifiable using up or down scroll buttons.
 Barcode Field - Select the position of barcode field in database from 1 to 4.
 Stored Barcode Start Position - Select the numeric position of start substring character of
barcode in database from 1 to 39.
 Scanned Barcode Start Position - Select the numeric position of start substring character of
scanned barcode from 1 to 39.
 Comparing Barcode Length - Number of characters to be compared from 0 to 255 where 0 is all
characters.
 Display on KDC - Define database fields to be displayed on KDC. KDC can display one to three
fields. KDC will display one field in two or three lines if same field is specified in line entering option.