Printing Qty Does Not Match With Actual Printout
I am using excel as datasource and using quantity to print number of labels. When I preview, it shows correctly with 13 pages but when I print, only 5 pages are printed.
Here are my settings:
Bartender 10.0 Automation License.
Datasource: Excel XLSX format
Paper Size: A4 with 12 x 5 (Layout rows x columns) = total 60 labels per page.
Print Copies: Using excel column "QTY".
The Excel file contains 4 rows (excluding column header).
Row 1 (Label 1) : Qty=1
Row 2 (Label 2) : Qty=208
Row 3 (Label 3) : Qty=1
Row 4 (Label 4) : Qty=549
When I preview, it generate 13 pages.
Page 1 = Label 1 (1 pc) & Label 2 (59 pcs)
Page 2 ~ Page 3 = Label 2 (60 pcs)
Page 4 = Label 2 (29 pcs), Label 3 (1 pc), Label 4 (30 pcs)
Page 5 ~ Page 12 = Label 4 (60 pcs)
Page 13 = Label 4 (39 pcs)
When I print, it printed Page 1, Page 2, Page 4, Page 5 and Page 13 (total 5 pages only).
It seems to recognize Page 3 is same as Page 2 and was not printed, and Page 6-12 is same as Page 5 and not printed.
I tried this on 2 different printers (1 HP and 1 Fuji Xerox) with same result so it can't be a printer issue.
Is this some sort of setting? I want to print the same as shown in preview and same qty of labels as indicated. Please help.
-
Ian Einman
★ BarTender Hero ★
Actually, it can be a printer issue - many drivers do not support the concept of changing the number of copies dynamically during a print job, it is particularly common with laser printer drivers, unfortunately, and perhaps you have two drivers with the same issue.
Fortunately we encounter this often enough that we have a setting that may fix it. Go to the Administer menu in BarTender, and choose Advanced Printer and Driver Setup. In that dialog, choose the printer with this problem. Then check the box called Override Default Settings, and then toggle the box called "Use alternate method to control data sourced copies". Press OK to save changes. See if that helps.
0 -
Legacy Poster
★ BarTender Hero ★
We had a similar problem, when we printed say 80 labels, we'd got only 36 and it was down to how the printer/PC handled the qtys being sent.
We configured the btwprn.ini file, which is found in ('documents and settings' 'All Users' 'Seagull' 'Bar Tender' on XP machines) & (C:\Program Files (x86)\Seagull\BarTenderSuite on Vista/7 machines)
You need to add your printer model to the list of 'Incapable' printers, so the section looks like this:
[Copy Incapable Printers]
Printer1=HP LaserJet 1100 (MS)
Printer2=HP LaserJet Series II
Printer3=HP LaserJet 1200 Series PS
Printer4=5D PDF CreatorPrinter5=YOURMODELPRINTERHERE
This fixed our random printing issues
Hope this helps
p.s. sorry to keep writing in red, i can't revert it back to black!!!!!
0 -
Legacy Poster
★ BarTender Hero ★
I'm resurrecting this thread as all of my printers have now reverted back to printing whatever qtys it feels like.
They are on 10.1 SR2 and printing from XP machines.
Example is: if one page of labels has 18 labels on it, and I ask for say 67. Its will give me a sheet of 18, then a sheet of 10, then another sheet of 18 then another random qty. What it should AND used to do was print 3 pages of 18 first, then a page of 13 to make the 67 required.
Please note, this is printing via Print Station
Regards
Ryan
0 -
Legacy Poster
★ BarTender Hero ★
*** UPDATE ***
This IS an issue with SR2
Ive uninstalled 10.1 SR2 and installed 10.1 SR1 and all works perfectly again.
So maybe the btwprn.ini file is either ignored in SR2 or its in a different place
Please advise
Regards
Ryan
0 -
Fernando Ramos Miracle
★ BarTender Hero ★
Hello Ryan,
Did you try installing SR3? We did add a number of fixes and improvements to it. You can download it from the below webpage:
http://www.bartenderbarcodesoftware.com/label-software/fixes_101.aspx
0 -
Legacy Poster
★ BarTender Hero ★
Hello again Fernando,
I'll try SR3 now...............it can't have been out long as I check quite regularly
Regards
Ryan
0 -
Legacy Poster
★ BarTender Hero ★
Tried SR3 and still no different, so for the time being I shall have to downgrade to SR1
Regards
Ryan
0 -
Try to make use of the "Use alternate method to control data sourced copies" checkbox as instructed previously by Ian Einman on this same topic. The setting needs to be disabled. Make sure that the changes under the "Administer > Advanced Printer and Driver Setup" stick after you close and reopen BarTender.
0 -
Legacy Poster
★ BarTender Hero ★
Sorry to resurrect an old thread.
But furthering my investigation as to why the print qty differs to what's required. I've noticed that version 10.1 SR2 and SR3 don't actually put the btwprn.ini file where it's supposed to be. In SR1 it puts it in the locations I mentioned above. Could this be why I've had to re-install SR1 onto all of our machines for it to work properly?
If so, could this be fixed in SR4 so I can keep updated.
Regards
Ryan
0 -
If you've 10.1, then you should be really doing these changes via the "Administer > Advanced Printer and Driver Setup" Menu entry in BarTender. Modifying the btwprn.ini file is more intented for older versions of BarTender where this "Advanced Printer and Driver Setup" feature didn't exist.
0 -
Legacy Poster
★ BarTender Hero ★
I've deployed 10.1 onto our systems in the main warehouse as at least then I know it works and gives correct qtys without wasting ALOT of paper/ink.
Tested SR2 with the advice and still no different, I got random qtys. It's as if it keeps repeating the last page after each individual page
Should the 'use alternate method to control data sourced copies' be ticked or unticked? <----the answer to this is NO
So now working, I'm going to deploy SR3 onto a test machine and see how that goes
Regards
Ryan
0 -
Legacy Poster
★ BarTender Hero ★
Is it too late to revive this thread? I have checked the "Use alternate method to control data sourced copies" box in Advanced Printer and Driver Setup but it has no apparent effect. Using BarTender 10.3 Professional
0 -
Michael Toupin (mtoupin
★ BarTender Hero ★
You should be unchecking the 'use alternate method' box for the particular printer that you're trying to use. 0 -
Legacy Poster
★ BarTender Hero ★
Well now I just feel stupid. Thanks!
0 -
Legacy Poster
★ BarTender Hero ★
Server2008R2 with Bartender 10.1 SR3
I have the exact same problem as Ryan.Davis. I selected "Administer > Advanced Printer and Driver Setup" Menu entry in BarTender for my 2 printers. Great that fixed the erratic quantities however it slows the print spooling down to a crawl. I'm using two Xerox ColorCube printers and both ColorCubes have the same issue no matter what driver I try to use. I have also updated the printers firmware. Checking and un-checking the "override default settings" option is the issue. For me its like night and day as far as the spooling speed goes. What is this check box overriding and why is it making the printing so slow?
Thanks,
RB
0 -
Legacy Poster
★ BarTender Hero ★
Anybody have any advice or experiencing this same issue?
0 -
Legacy Poster
★ BarTender Hero ★
Update:
By choosing the "over ride default settings" for the printer in the label settings, it was multiplying the spool file size drastically. It fixed my irractic quantities but also took an 80 meg file and made it 400 meg. Installing the latest SR4 beta (pre-release) for Bartender fixed this issue and its printing as fast as it was before. Thanks to Manny at Seagull for the help and persistence with this issue.
0
請登入寫評論。
評論
17 條評論