We have an existing package which can output MS Excel Spreadsheet, and we are developing interface programs to be able to read MS Excel formatted spreadsheets as input to this sw. We want to add the functionality of using a portable computer, with a barcode reader (standard PDA preferred, Palm or Pocket PC, or Sharp Zaurus -Linux-), which can be hot synched from/to the Client PC, with an MS Excel format Spreadsheet, for reading/writing from the PC to the handheld PDA. The PDA is being used to capture the Inventory item/part number, which is printed on the item or the storage bin, as a barcode, and the quantity is keyed in. This data is stored in the PDA, and after a batch of data has been captured the file is sent to the PC, in an MS Excel format. The sequence /steps are: 1. Hot sync the PDA with the PC, and download the Excel spreadsheet to the PDA. 2. Attach the barcode reader to the PDA,Repeat these steps for each record in the spreadsheet: a. Read next record from spreadsheet anddisplay the Item number, description, bin location and Quantity to be issued/counted. b. Go to the bin location, scan the barcode of the bin's part number,record the scanned barcode# in the PDA spreadsheet. c. Count/pick the items. d. Enter/key in the qty. into the spreadsheet e. Display the results, click OK. f. Go to the next record. g. Repeat steps a-f till spreadsheet is done. 3. Go to the PC. hot sync the PDA to the PC, and upload the updated spreadsheet into the PC. Suitable backups would need to be thought out and builtin, to prevent loss of data etc.
1) Suggest a suitable PDA and barcode reader for the purpose. 2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. We will procure the PDA and barcode reader, or reimburse you for its cost. You have to develop the programs and check out /demo the working solution. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
PC could be a Win 2000, or Win XP, WIn98se, or even a Linux box. The PDA we are open on, you make a suggestion, kindly also give the suppliers website and cost per piece.