Catch Print Job S’abonner

0
Avatar
Legacy Poster

Hello,

We started use the Bartender for generating internal kabans and it's great. Now I'm facing another problem. We receiving data from customer in access file on daily basses. The access file have GUI for user and we can use just three buttons for direct print. When used clicked on one button, the print job is generated and sent on the Windows default printer. We're using this for printing the kanbans labels for boxes. Created print job from the access generates all kanban labels and sorted it on A4 pages, three kanbans on every page. The problem is that this is not possible to printout on Zebra, because Zebra printed out just first label of every page. Now we're printing kanbans to pdf file and the PDF file is cutted by some script on three partes. Not nice, but working. Unfortunately the kanbans labels have 2D PDF417 code and sending it over PDF make the code unreadable.

 

Uff, it's little complicated I know. Is there any sollution, ideally with bartender, how to catch print job generated by Access and sort it (cut it) for zebra printer? That's mean cut the A4 pages on thirds and remain all codes readable.

 

THank you for any sugestion.

Martin  

6 commentaires

0
Avatar
Shotaro Ito
Actions pour les commentaires Permalien

Hello Vilca,

Do you print label from BarTender + Seagull driver, connecting Access database then print to Zebra Printer?

In that case, when the label format document(btw file) designed to print one page per a record, when 3 records of access table data to be printed, it should print 3 pages with each record data.

 

If you print from Access report to the Zebra printer - I'm not sure what's going on - I recommend to use BarTender for print such case.

To create database connection in BarTender, see video below:

http://www.seagullscientific.com/label-software/training-video-(reading-data-from-database).aspx

 

Another thought is, if you can modify Access form (button macro), export required data as text file (CSV) at button click.

http://msdn.microsoft.com/en-us/library/office/aa220768(v=office.11).aspx

http://office.microsoft.com/en-us/access-help/export-data-to-a-text-file-HA010006905.aspx

 

BarTender Automation or above comes with Commander middileware, it catches the CSV file and print BarTender label using that data.

See example 2 in Commander white paper.

http://www.seagullscientific.com/label-software/whitepapers/overview-of-commander-new-201406.pdf

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Hello Shotaro,

thank you for your answer. I guess I described our problem too complicated. Sorry for that. I know how to connect the Bartender to the database, I'm using this way for generating internal kanbans and it's working pretty well. Reason why I want to catch print job from Access is simple. I don't want to generated the label again. At this moment we don't have describtion of the data format in Access. The Access data file comming every day from customer and kanban labels are generated and printed it self by Access. 

 

With "catching" the print I mean something like "Bartender virtual printer" which have an ability to read the print job which is sent to the printer and do some defined actions. In this scenario the bartender operates like a PDF printer. I'm affraid this is not possible. Am I right?

 

I have a another idea how to solve this problem, I opened another thread in different part of this forum.

http://forums.seagullscientific.com/index.php?/topic/3097-cut-the-large-page-on-thirds/ 

 

Thank you for your help

0
Avatar
Shotaro Ito
Actions pour les commentaires Permalien

I see.. no, bartender or its sdk doesn't reprocess print job which created other application (access) in spooler.

Label printer cuts after page - so cutting in the middle of page is not very easy (no such option in BarTender.)

I feel the original problem is the printer doesn't print 2nd page - is that because the access report created to a A4 size page, rather than 3 pages?

modify access report would be the solution then.

 

If impossible to modify access report,

I would try print to one bitmap (PNG?) by Bullzip printer etc, then divide batch image process software to divide into 3 images, then somehow print image.

 

perhaps you can use commander..

BarTender Document connects a dummy access DB. create a query prompt QueryPrompt1. set custom sql 

 

SELECT '?QueryPrompt1' As IMG

 

Doing this, you can input an image file name via query prompt. use datasource picture to take this image.

In commander, set to detect the image file (rename when detect), then in BarTender command, /?QueryPrompt1='%Trigger File Name%' to pass trigger name to query prompt.

 

I haven't tried the method - so this is just a wild guess.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Thank you for your suggestions. Now I printing the labels in similar way.From access to PDF, cut it on thirds with script and print on Zebra. PDFis created without compression. Unfortunately modifying the report is impossible. I'm looking for another way because we need to keep the information about 2D codes for Zebra and this's a problem with PNG or PDF.

 

It's look like that I found only possible way :-)

0
Avatar
Shotaro Ito
Actions pour les commentaires Permalien

Thank you for your suggestions. Now I printing the labels in similar way.From access to PDF, cut it on thirds with script and print on Zebra. PDFis created without compression. Unfortunately modifying the report is impossible. I'm looking for another way because we need to keep the information about 2D codes for Zebra and this's a problem with PNG or PDF.

 

It's look like that I found only possible way :-)

Order label roll (media) which has about A4 size, with 3 labels a page. Print from Access, cut every page. Manually remove 3 labels from liner.

 

(I guess this is first thing you've considered and - the cost of media makes you try everything else)

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Exactly :-) So only possible way is to create the kanbans ourself from Access file. We can close this thread.

Thank you for your time.

Vous devez vous connecter pour laisser un commentaire.