We are looking to be able to use a Bluetooth barcode scanner and an Android app to find information about products in our customer's stores. There are a few Bluetooth scanners out there that are compatible with the android, and basically act as a keyboard. When it scans a UPC, it transmits that data as keystrokes to the device. We would like to use the bluetooth barcode scanner, scan a UPC, and have an app that will lookup and display that particular UPCs'
attributes from a reference file (item masterfile). The masterfile should reside on the android and not remotely on a cloud. We would like to be able to load it onto the device using a laptop through USB cable.
Here is a sample of the reference file. It is a comma delimited file with the following fields:
000000000000,PLSTC FRAME SUNS,4.49,2.59,24.2,14 - Dairy
000000008372,BIB BIG RED,0.00,43.05,39.2,2 - Other Tobacco Products
000000008808,BIB DR. PEPPER,0.00,42.05,15.3,3 - Other Tobacco Products
The top row is a header row...I can have the file with or without this.
Every field is seperated by a comma, and records are seperated by a carriage
return (1 item per line). The sample only has a few items, but normally
there are about 11,000 records, and run around 500kb - 1mb in size. The
itemmaster file will be different every day (same formatting, but different
items). So the app needs to have the flexibility of loading new files. We
would like the results to show up practically instantly or under 3 seconds.
I want to be able to scan upc after upc...and not have to click on the
screen. If a UPC is scanned that is not in the masterfile, a simple popup
saying "Item not found" would be suffice.
We are not looking for something extravagent...we just need something simple
and FAST-running. We don't need the ability to edit the data on the
device...we just need an inquiry tool.