An Oracle blog about BI Publisher

  • September 29, 2008

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.

Join the discussion

Comments ( 7 )
  • Paul Monday, September 29, 2008
    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. "
  • tim Tuesday, September 30, 2008
    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)
  • mike smedberg Tuesday, March 24, 2009
    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.
  • BRIGIDA Wednesday, July 14, 2010
    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
  • scetmoosy Monday, August 23, 2010
    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
  • love mugs Wednesday, September 22, 2010
    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.
  • guest Friday, October 18, 2013

    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

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.