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
Are you have a specific database manager: MSAccess, SQL Srv, other? Any particular lenguage to desvelop: .NET, other? Are Barcode a specific language like Zebra printers: EPL, ZPL, other? Contact me