Variable Number Of Labels
I'm not sure if this can be done within BarTender itself, but we are going to be creating box labels (with line art drawing of product) and a pallet label. A box will have a fixed number of items based on a database field except where the quantity produced does not completely fill the last box. We are prompting for a Work Order and the total quantity produced.
Example:
Query Prompts:
Work Order 1003334
Total Produced 83
db Field: Qty per box = 9
Number of duplicate labels: INT(83/9) = 9
Partial Box Label Quantity: 83 MOD 9 = 2
Database field says we can get 9 items per box. Therefore we would need 10 boxes, that last box having only 2 items in it. Each box label would show have a label with the item information (from database view) and the box quantity (calculated) on it.
Finally the pallet label will have the total (83) on it.
The question is, how can I leverage VBScript within BarTender to accomplish this? If not is the alternate a .NET application?
Example:
Query Prompts:
Work Order 1003334
Total Produced 83
db Field: Qty per box = 9
Number of duplicate labels: INT(83/9) = 9
Partial Box Label Quantity: 83 MOD 9 = 2
Database field says we can get 9 items per box. Therefore we would need 10 boxes, that last box having only 2 items in it. Each box label would show have a label with the item information (from database view) and the box quantity (calculated) on it.
Finally the pallet label will have the total (83) on it.
The question is, how can I leverage VBScript within BarTender to accomplish this? If not is the alternate a .NET application?
0
-
[quote name='Craig McD' timestamp='1348172285' post='3318']
I'm not sure if this can be done within BarTender itself, but we are going to be creating box labels (with line art drawing of product) and a pallet label. A box will have a fixed number of items based on a database field except where the quantity produced does not completely fill the last box. We are prompting for a Work Order and the total quantity produced.
Example:
Query Prompts:
Work Order 1003334
Total Produced 83
db Field: Qty per box = 9
Number of duplicate labels: INT(83/9) = 9
Partial Box Label Quantity: 83 MOD 9 = 2
Database field says we can get 9 items per box. Therefore we would need 10 boxes, that last box having only 2 items in it. Each box label would show have a label with the item information (from database view) and the box quantity (calculated) on it.
Finally the pallet label will have the total (83) on it.
The question is, how can I leverage VBScript within BarTender to accomplish this? If not is the alternate a .NET application?
[/quote]
Basically what you'd have to do is do the scripting in a fashion that after it's been processed it would pass back the total number of copies to the 'copies' dialog in the Print Setup window. To do that:
Select File>Print
Select the box next to 'Copies'.
Set the radio button to 'Get quantity from data source'
Select the 'data source' button on the left. From there you can change it to a VB script object, and use that to process the scripts that you create to be able to change the number of copies of the label to match what the output of the script is.0 -
[quote name='Mike T - Seagull Support' timestamp='1348264419' post='3329']
Basically what you'd have to do is do the scripting in a fashion that after it's been processed it would pass back the total number of copies to the 'copies' dialog in the Print Setup window. To do that:
Select File>Print
Select the box next to 'Copies'.
Set the radio button to 'Get quantity from data source'
Select the 'data source' button on the left. From there you can change it to a VB script object, and use that to process the scripts that you create to be able to change the number of copies of the label to match what the output of the script is.
[/quote]
Thanks Mike. Now, from within BarTender vbScript, how does one gain access to the value entered in a query prompt? There are many .NET examples, but I haven't seen many examples of vbScript code used within BarTender. Like, we shouldn't have to open the label from within BarTender because we are basically in it already.0
Please sign in to leave a comment.
Comments
2 comments