Print Mutiple Copies Of Labels In Database Order 追蹤

0
Avatar
Legacy Poster

Using Automation version 10.0

 

We have an SQL database joined to a text file.  The records in the text file that match the part number from the database are to be printed.

 

The problem is when printing multiple copies, all the copies of record 1 will print then all the copies of record 2, etc.  Is there a way to get bartender to print the records in the order that they appear in the file the number of times requested?

 

For example print record1, record2, record3, record1, record2, records3, etc.

5 意見

0
Avatar
Michael Toupin (mtoupin
評論操作 永久連結

What you'll want to do is to put the label into Batch Maker.  There's a selection at the bottom that says 'batch repeat count' that will let you select how many times the whole print job gets run.  Then you can either run the job from Batch Maker, or use it from within BarTender or Print Station.

0
Avatar
Legacy Poster
評論操作 永久連結

There were a couple of problems when I tried this:

 

We use Print Station in manufacturing for all printing and there no access to the batch repeat count from Print Station.

 

If I use Batch Maker, then when the batch repeat count is set to a certain number, the query prompt asks for the data entry for every repeat, even though it is the same information.

0
Avatar
Domingo Rodriguez
版主
評論操作 永久連結

You can save your Batch Maker .btbat file and print it out with Print Station.

 

The prompt frequency for the query prompt dialog is once per print job. If you're using the text database file as a query for your SQL Server database, is there really a need for doing a "Query Prompt" under the "Query" tab? If yes, why is this required?

0
Avatar
Legacy Poster
評論操作 永久連結

The batch quantity will need to change from work order to work order.  It looks like the batch repeat count is fixed when using print station to print a .btbat file.

 

The query prompt is for the entry of the work order number.  This query goes to the SQL database for our ERP system to find the part number that is being built.  Then this is matched to the part number in the text database to find the labels that should be printed out for that part number.

0
Avatar
Domingo Rodriguez
版主
評論操作 永久連結

With regards to only showing the query prompt once when batch copies is > 1, this is a feature request in our system which might get implemented in a newer version of BarTender.

 

With regards to the "Set batch copies" via Print Station, I will write this up as a feature request.

 

Perhaps your best bet is to develop your own third-party application which automates BarTender in the background via our .NET SDKs:

http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-C-Sharp-and-VB.NET(English).pdf

登入寫評論。