OOW Thursday & Label Printing

I know, it's Monday, what happened on Thursday? A hectic morning on the demo grounds is what, lots of folks wanting to know more about BIP for Apps and lots of 'follow the leader' to get the folks interested in standalone or BIEE BIP through the demopod maze to get to the standalone pod and vice versa.

Here's what I mean, you can see the BIP for Apps pod on the right hand corner (great location, thanks Nadia) and the BIP Standalone pod circled on the left.


Do you take the easier route 1 or go for the more scenic route 2? Route 2 is more fun, but fraught with the imminent danger of losing the 4 people trailing behind you, as you move through the crowds of people around the intermediate pods. We should have had a sign on a pole that we could carry above our heads to ensure folks knew where we were and could not get lost. OK, I have beaten that train of thought to death but you get the picture - it was busy!

During the week, Wednesday I think, I bumped into Rick Pollina from Arrow Electronics. A hot topic recently has been getting BIP content to label printers, whether they be Zebra, Intermec or others. Im hoping to get an entry out on a more 'conventional' approach soon, but Rick came up with a neat solution - eText templates.

For those of you that have not come across eText templates yet, they are another template type, built in MSWord but are for 'electronic' output e.g. EDI messages or EFT - basically position or delimited based content. In recent months I have seen folks using them to generate flat file output - not what they were designed for, but they work.

I'll let Rick explain the problem and their final approach:

The first approach the team was working used BI Publisher loaded with the proper barcode fonts and would generate a PDF that looked exactly as the label would print. They were then going to use a PASTA driver to convert the image to postscript and send it to the ZEBRA printer that accepts postscript.) Basically this approach eliminated the need for ZPL coding and just send an image to the printer. For some reason they were not able to get this to work, not sure why as it appears the old ZEBRA printers seem to accept postscript. (Tim: this is the conventional approach, I had not heard that Zebra could accept PS, the solution we have worked on finally generates a Raster image of the label that Zebra supports)

The alternative approach and the one we ultimately chose was to build the template with the ZPL code's embedded in the template and send the RAW text image to the ZEBRA printer. On a Linux/Unix platform you define the printers as RAW and you can run it through CUPS or local define the printer. On windows you can probably setup the printer as Text, although I did not try this.

Attach find the sample template I built using etext format supported by BI Publisher. I choose this over native XSL-FO template (also supported by BI Publisher), because the development team was already using ms-word for the development of all their other templates.

To view the template as it would be created you need to install the BI Publisher desktop (free download from Oracle) and use the template viewer--but you probably new this already :)

The advantage to this approach is that the new ZEBRA printers are Accepting XML and the old ones like we have still require ZPL so you can account for both types with the same SQL and a different Template.

I also noticed that ZEBRA got an award here this week along with presenting. It looks like they already have a nice design tool that they could probably extend to produce the XSL-FO that can be used for the template. (looks like they already support SAP through there smartform client tool to design labels.

You can get the sample files Rick kindly provided here.

To fill in the gap you might have spotted, 'how do I know the ZPL format?'
Rick used the label creation application that Zebra provide with their printers to build a label layout, more information available from Zebra - I'll try and get more info on this for you. He then exported it to the ZPL format and then built the eText template to create the skeleton of the ZPL and filled in the data items. not for everyone I know but it was a quick and straightforward solution and still leverages the one data source, multiple layout templates mantra that I keep pushing to all of you.


Thought I'd mention for your information, Intermec printers particularly the PM4i have been Oracle XML enabled for some time. Here quote from www.intermec.com web site: "XMLReady printers from Intermec provide an easy way to bar code enable your Oracle MSCA/WMS, SAP Auto-ID infrastructure or other compatible systems. Lowers the Total Cost of Ownership, by bypassing middleware, as printers are ready for XML printing out-of-the-box. "

Posted by Paul on September 29, 2008 at 02:35 PM MDT #

hi Paul Thanks for the comment. I think the XML printer enablement is a given. It's the 1000's of customers on the older printers that we need to help :0)

Posted by tim on September 30, 2008 at 10:18 AM MDT #

FYI... most CUPS releases on/after 1.2 ship with a ZPL CUPS filter that was written by apple and published with a GPL license. It's the "rastertolabel" program in the CUPS directory tree. This allows you to send PDF/PostScript/plain-text/??? to a CUPS queue configured for a zebra printer. The CUPS queue handler handles the RIP to turn the PDF first into Postscript, then into CUPS raster image, then finally into ZPL. If your UNIX environment has the "rastertolabel" program in the CUPS directories, then this should work fine. If you test and have problems then download the most recent zebra.ppd from the apple OS X source code website as this fixes many printing problems with the zebra printers. We use this approach with Zebra 105SL printers and XDO on both AIX and linux. It works _great_ and. We also have a large install-base of Intermec IPL label printers for which these is no CUPS PPD or driver. We had to build our own CUPS filter and PPD to enable the Intermec printers to work with XDO. Summary...it's pretty straightforward to get a modern UNIX CUPS to print PDF documents to a ZPL printer.

Posted by mike smedberg on March 24, 2009 at 02:31 PM MDT #

Interesting read. My weblog has opened up several chances that I do not believe I’d nevertheless be self-employed if I didn’t publish on the web. Quite of luck with your personal online endeavors

Posted by BRIGIDA on July 14, 2010 at 01:16 PM MDT #

Mr. Hermann considers the home ground, called the Representation Pavilion, his “opus.” When he builds in the Hollywood Hills or Beverly Hills, Mr. Herman says he is as workaday restricted to a stylish lot. This loads measures about three-and-a-half acres and gave him the play he needed to bring into being a to the vivacious featuring walls of glass. _______________________________________ my oil blog

Posted by scetmoosy on August 22, 2010 at 08:31 PM MDT #

I have been involved in the printed mug industry for about 10 years. I always find in quite interesting all the different ways corporations find to use mugs. The traditional mug from years past has evolved into thermal travel mugs, mugs that change color when they get hot, to disposable mugs. I can only image what the future hold for mugs. I appreciate your time and wish you all the luck with your online business.

Posted by love mugs on September 22, 2010 at 04:49 AM MDT #

Hi ,
How can i print barcode using etext template for intermec printers.
like here in etext template for zebra printer we have set font for barcode , what command we can use to set font for barcode for intermec printer

Posted by guest on October 18, 2013 at 12:49 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« July 2016