Automate Barcode Print Qty
-
There are many ways you can source the number of copies/quantity to print via the Integration Platform. Since you are using a Database Integration, you can probably source the quantity from a database field. I would suggest looking at our Database Integration example here. You may also find our other Integration examples here.
0 -
Permanently deleted user
★ BarTender Hero ★
The problem I have is the database is locked and I have no access to edit fields; and the number of prints varies instance to instance from 1-500 depending on how many items we are making in a given week. I really want to make the process as simple as possible by just being able to scan a barcode which no only identifies the record but also set a print qty
0 -
That is possible Chris, but you would need to set up some "intelligence" on the form to differentiate where the product code (or whatever the lookup is) stops and the quantity starts. A simpler way would be to have two barcodes.
0 -
Permanently deleted user
★ BarTender Hero ★
Can you send me a link to an article on how to set up this intelligence?
0 -
There isn't one, you would have to create something dependent on your data. There are a couple of ways you maybe able to achieve this such as encode a tab in between the database lookup and the quantity so the input prompt moves between the two on the data entry field or else, where you have a fixed length field for one of the parts (either lookup or quantity) then you could use truncation on the data entry fields to either ignore or keep certain number of characters although for this they would need to scan the same code twice.
0 -
Permanently deleted user
★ BarTender Hero ★
All just trying to resurrect this...what we have done thus far is:
- We have a unique product code which can be used to lookup data form a database
- We need to dynamically change the print qty order to order...this data is not available in the database
We current controls the print qty in the print dialogue, which then triggers a query prompt, which allows the user to scan a Code128 barcode which has the product code encoded within it.
We have modified our system to now encode as a code 128 barocde:
The product code (123456 for example)
Carriage return (~013)
The print quantity (10 for example)
So now when i scan the bar code it reads in:
123456
10
I would like to know how i could design a form / enhance the query prompt to process both code and print qty. I have tried the data entry form and i can link an input to the print qty...but i cant work out how to select a record from a data input form????
Or could this be done via a VB script on the query prompt
0 -
Create a filter/lookup in your database setup and then on the Data Entry From add a Text Input box and go into the Properties of the box and adjust the Linked Data Source and so it is connected to Query Prompt.
I am just wondering if you are better to use a TAB in your barcode to move the cursor to the next entry in case BT doesn't pick up the quantity whilst doing the database lookup. You may need to give a try and see.
0 -
Permanently deleted user
★ BarTender Hero ★
Ok this has moved on...i have a form with both a data entry linked to the query prompt and the print qty.
The problem though is the print qty field is locked until you have entered a valid entry int he query prompt box.
The act of scanning seems to fast, as the form takes a micro second to register a valid query prompt value has been entered.
Is there any way to make the print qty entry field editable on form open
0 -
Depending on you r scanner you maybe able to set an inter-character delay in it so that the scanner sends each character in the string with a slight pause in between (a few milliseconds) and that may get round the issue.
0
請登入寫評論。
評論
9 條評論