BARCODE GENERATOR-PRINTER SETUP-DATA RETRIEVAL

BARCODE GENERATOR-PRINTER SETUP-DATA RETRIEVAL We need a program that can perform customized sequence barcode printing(Eg. Input fields- Default text options-(FO/LO/CLO/Others) Barcode Sequence-23052001 Duplicate-3 Output format-<today'sdate>-<Today's counter>-<duplicate> Output barcodes-(if possible smaller formats) 23052001-01-S-FO 23052001-01-P-FO 23052001-02-S-FO 23052001-02-P-FO 23052001-03-S-FO 23052001-03-P-FO BARCODE WITH SUFFIX-(“S”) Will be pasted on a sample bottle BARCODE WITH PREFIX-(“P”) Will be pasted in the papers(document) came along Usually there are multiple bottle and one paper that is exception we will paste all the barcode in the sample SAMPLE BOTTLE Picture taking:(.jpg) To Use webcam that is available in the PC to take sample bottle picture and save in the designated local folder on today’s date, If no folder available for today’s date create new folder when some one starts the process. Naming convention 23052001-01-I-001-FO 23052001-01-I-002-FO (If multiple pictures taken) 23052001-02-I-001-FO 23052001-03-I-001-FO PAPER(DOCUMENTS) PAPER WILL BE SCANNED AND NAMED AS PER BARCODE PASTED ON THE PAPER AND SAVED IN LOCAL DRIVE DATABASE: READ THE LOCAL FOLDER FOR IMAGES(IF ANY) AND DOCUMENTS(IF ANY) IN THE PC AND UPDATE THE DATA BASE AS BELOW UNIQUE KEY |TYPE |SAMPLES |PAPERS | Registration number(will explain below) 23052001-01|FO |23052001-01-B|23052001-01-P| 23052001-02|FO |23052001-02-B|23052001-02-P| 23052001-03|FO |23052001-03-B|23052001-03-P| Process flow: Screen one: 1. Barcode Give input: Default text options-(FO/LO/CLO/Others)-------one time set till it is changed Number of bottles- ____ Press print button 2. Print barcode (as provided above) 3. Prompt take photo(can be disables if not needed) and save in local folder Background Process 4. Read local drive for matching paper(documents) Screen Two: Database screen of number of samples received and all the data in rows Search function(when the sample bottle is scanned related papers and images should pop up when ever any one of the barcodes scanned SCREEN THREE: UPLOAD A CSV: REGISTRATION NUMBER | SAMPLE BOTTLE NUMBER S200000001 |23052001-01 S200000002 |23052001-02 Update the Registration number to the database