Page 1 Of X Help
I am setting up a label in Bartender 10.0 and it is required to count the number of packages (1 of x, 2 of x, etc)
I have it already serialize the first number 1, 2, 3, etc. But the count, "x", I cannot get to work. I am using an excel spreadsheet to populate my data.
There is a field "# of cartons" and lets say the choose to print 5 of the different cartons.
Item # of Cartons
Item1 5
item2 3
item3 4
item4 3
item5 1
item6 7
etc.... etc....
If the user wants to only print items 1-5 I need it to show: 1 of 16, 2 of 16, etc.... I cannot figure out how to count based on the number of user selections.
-
Hello Cali88,
Can I understand that the total "x" value needs to come from the database and will also mark the number of serialized labels? Or is the latter something the user will need to enter manually at print time?
In any case, you need to enter the "File>Print..." dialog, click on the options button for "serial numbers" and change the quantity source to be from a data source. You can then name that data source and share it across your document.
For example you can relate that data source with the database field with the number of cartons so each record will automatically be serialized according to the value of that database field. You can then also use that same named data source on your text object so the "y of x" prints properly.
On the other hand, if you wish the user to enter the appropriate number of serialized labels for each record you only need to relate that data source to a data entry control.
Regards.
0 -
My goal is to have it print "y of x" as you mentioned. In the excel sheet you input how many copies you want of Item 1, item 2, etc...
For example: you have an excel spread sheet that looks like the following
NAME Quantity
Item1 2
Item2 3
With this information, it would serialize as follows:
1 of 5, 2 of 5, 3 of 5, 4 of 5, 5 of 5
I followed the steps you outlined and they make it do this:
1 of 2, 2 of 2, 3 of 3, 4 of 3, 5 of 3
basically, it is only using the "quantity" tab but is not Adding each one up
0 -
Hello Cali88,
Thanks that clarifies things, but I'm afraid that what you wish to get won't be directly supported.
The main problem is that BarTender goes through the database records only once, so it cannot calculate the total quantity of labels specified until the last record is processed (considering that the desired value is the sum of the quantity on each record).
Alternatively you could set up the "x" value to sum the quantity for each record once it reaches it. But that is not exactly what you require:
1 of 2, 2 of 2, 3 of 5, 4 of 5, 5 of 5...
Another option would be to reset the serial number for each record:
1 of 2, 2 of 2, 1 of 3, 2 of 3, 3 of 3...
If you wish to get the final result, you would need to develop your own front end application that access the database by itself, sums the value of each record before BarTender start printing, and sets the appropriate value to the "x" data source. this can be done with one of our automation methods (Commander, .NET SDKs, ActiveX...) or maybe with a VB script on your document.
Regards.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare