Automate Barcode Print Qty フォローする

0
Avatar
Chris Thompson

We have a manufacturing system which print a production plan for our staff; they then trigger the printing of labels for specific products by scanning a code128 barcode form the paperwork of a job which is just a code 128 representation of a unique product number, this then triggers bartender to print a label via a database integration. However at present the user still has to select the qty of labels to print manually. I would like to know if there is any way to automate this I.e. encode the print qty into the scanned barcode as a suffix or along those lines...so the user just has to scan a barcode form a job sheet which then trigger the print not only of the the specific label for that product but the correct qty as well.

8 コメント

0
Avatar
Jasper Wen
モデレータ
コメントアクション Permalink

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
Avatar
Chris Thompson
コメントアクション Permalink

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
Avatar
Peter Thane
コメントアクション Permalink

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
Avatar
Chris Thompson
コメントアクション Permalink

Can you send me a link to an article on how to set up this intelligence?

0
Avatar
Peter Thane
コメントアクション Permalink

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
Avatar
Chris Thompson
コメントアクション Permalink

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
Avatar
Peter Thane
コメントアクション Permalink

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
Avatar
Chris Thompson
コメントアクション Permalink

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

ログインしてコメントを残してください。