Multiple Copies And Changing User Variables For Each Record S’abonner

0
Avatar
Legacy Poster

Hello,

 

I'm going to struggle to explain this one, but here goes!

 

What we want to achieve:

 

1) User enters an order number.

2) BarTender queries a database and retrieves multiple lines (records) from the order.

3) User chooses which order lines they wish to produce labels for.

4) For each line, the user chooses the 'quantity' and 'copies'. I.e. for one line they might want to print 2 copies with a quantity of 100 and 1 copy with a quantity of 200. The total line quantity, for instance, would have been 400.

 

We are guessing this can be done with VBScript but as we are completely new to BarTender, the implementation is stumping us. Any pointers would be very much appreciated.

 

We can get BarTender to ask for copies and quantities ONCE per record, but not multiple times.

 

Thank you.

 

Best Regards,

 

Elliot

6 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Since we've had no takers yet, I thought I would ask a more specific question:

 

How can we tell BarTender to loop through print dialogs until certain criteria are met. E.g. How can we get BarTender to continuously ask the user for a quantity, then print a label, until the total quantity on the labels printed equals the quantity on on the actual record (i.e. on the order).

 

So, like:

 

TtlQtyPrinted = 0

 

START LOOP:

BT displays print dialog.

User changes quantity on label to 100

BT prints label

TtlQtyPrinted = TtlQtyPrinted + 100

If TtlQtyPrinted < mytable.quantity then REPEAT

 

How can we do this in BT?

 

Thank you!

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

I don't really understand what you mean by " want to print 2 copies with a quantity of 100 and 1 copy with a quantity of 200". If the label design doesn't change, then why would you not want directly to enter "400" copies of the label to be printed, and you would then do some VBScripting in the background in order to calculate the values you're after?

 

 

 

If instead for the same database record, you're wishing to print a quantity of labels with design A, and then a different quantity of labels with a slightly different label design B, then you should take a look at BarTender multiple templates per document and multiple layers per template features introduced in v10 and 10.1 respectively. Both templates and layers can be conditionally printed (by a data base field or named data source value e.g.)

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Hi Domingo.

Are you saying in the same record you can print different templates or layers?

From my understanding in v10 you can change layers as the records change based on field conditions...

But based of 1 record how do you print multiple templates?

In my situation, if the quantity to print in one record is 1000, every 100 records I would like Bartender to print 1 label of a different (template or layer). This is so that we can pack every 100 labels. The current solution we are using right now is we are printing 100 labels at a time, stop the printer then pack... But ideally we would like to have the printer running continuously with a "separator" every 100 labels. 

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

You can also conditionally print templates / layers based on different conditions, such as based on a shared data source value. The second template / layer would only print if a certain data source on your label (which could be serialized) reaches 100 or a multiple of 100.

 

You can directly create a data source in BarTender's Toolbox under the "Data Sources" tab. During the data source creation process, you can give it a shared name under the "Name" Field and use this named data source as the condition for printing your templates.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

I follow the steps above. Unfortunately it does not work with me. The template selector only seems to pick up the first serialized number. When I set the condition of one template on number 3 this template will not print. I have also placed the data source on the template that is always printed. So I can see the value of the serialized number. This number ascends. What goes wrong?

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Can you attach your template.

Vous devez vous connecter pour laisser un commentaire.