Search This Blog

Friday, May 8, 2009

Using 3 of 9 Barcodes in XML Publisher

I am using Code 39(3 of 9) Barcode font for my report. Every thing seems to be fine and barcode seems to be displayed correctly, but not recognized by the barcode reader/gun?
          For code 39 barcode fonts asterisk(*) is used as a start and end delimeter. So any text which is displayed as barcode should have * at the start and end.

E.g. 12345 should be displayed as *12345*

28 Comments:

chinna said...

Hi Suresh,

I am also facing same issue, but in my case i am using IDAutomationSC128.ttf Barcode. I am also add * in both ends. Like *123456* but not recognizing barcode reader. Is there any specific if you have solutions or i have to do further work for reading barcode in RTF or is it required to install in Server. font is laready installed in server.

If you have any solutions Please forward to me (Gmail:raghavendraprasad37@gmail.com)

Suresh Vaishya said...

If you are using font 128, then * are not needed. The barcode should directly read the value without any further formatting. Make sure barcode reader settings are correct. Print some 128 barcodes text from internet and check if they are recognized by the gun.

Regards,
Suresh

Gaurav Bandi said...

Hi Suresh,

I am trying to print barcode for the invoice no using xml Publisher. I am using oracle standard report and BI publisher to enhance the quality of report.

My client requirement is to print the barcode parallel to invoice no.

I have downloaded 3of9 font and Copied and paste the attached “Free 3of9” font in machine directories..“C:\WINDOWS\Fonts” and
configuration file "xdo" to “XML Publisher Desktop\Template Builder for Word\config”.

I am able to see font in MS word.
I have also used * at front and at end of invoice.

But while running the report instead of seeing barcode for invoice no(eg:1500) , I see *1500*

Can u please help me out regarding this.
I would be really thankful if you could send me any step-by-step document/material to my emailid gauravbandi7@gmail.com

Thanks
Gaurav

Suresh Vaishya said...

Gaurav,
You are almost in correct direction
Validate your steps
1) Copy code39 font in Windows/Fonts directory.
2) Copy xdo.cfg in C:\Program Files\Oracle\XML Publisher Desktop\Template Builder for Word\config directory.
3) Right click the font file and go to properties. Copy the .ttf file name
4) Open the xdo.cfg file and paste as follows (My filename is IDAutom0.ttf and font family is IDAutomationHC39M)

[font family="IDAutomationHC39M" style="normal" weight="normal"]
[truetype path="C:\Windows\fonts\IDAutom0.ttf" /]
[/font]
Note: replace brackets([ & ]) with angle brackets as was unable to paste due to HTML restriction in comments.

5) Try your report should work fine now.

Let me know if any problems.

Suresh

invinci said...

Hi Suresh,

I am trying to print a barcode for an Assembly name field in one of my custom reports. I m using XML publisher RTF template for this and the font is IDAutomationHC39M. I am able to see the barcode when i provide the output format as RTF while running a report. But i unable to see the barcode in PDF output format.

It would be great if you can help me out in this.

Thanks in advance.

Regards,
Savitha

Suresh Vaishya said...

There is xdo setting that needs to be done in computer to achieve that.
I will try to post something related to this at the earliest.
Thanks,
Suresh

Suresh Vaishya said...

Savitha,
Check my post http://sureshvaishya.blogspot.com/2010/01/cannot-view-barcodes-in-when-previewed.html for steps

Regards,
Suresh

invinci said...

Hi Suresh,

Thanks a lot for your help.
The barcode fonts are seen when the report is previewed in PDF format from .rtf file.

But i m unable to view the barcode fonts in PDF Format when i print the report through Submit Requests in Oracle Apps.

invinci said...

Hi Suresh,

To make it more clear. Below are the steps i have done so far.

To check barcode in desktop publisher:

• Placed the barcode true type font(IDAutomationHC39M) in the fonts folder
• Modified the xdo.cfg file in C:\Program Files\Oracle\XML Publisher Desktop\Template Builder for Word\config

[font family="IDAutomationHC39M" style="normal" weight="normal"]
[truetype path="C:\WINDOWS\Fonts\IDAutomationHC39M.ttf" /]
[/font]

• Now when I preview the template with the field having barcode font, the output has the barcode in both PDF and RTF format.

To view barcode in the reports while running it from apps

• Created a font file in XML administration.
Navigation: XML Publisher Administrator --] Administration --]Font FilesCreate Font File

• Created a font mapping set. Navigation: XML Publisher Administrator--] Administration--]Font Mappings

• In the template screen , edit configuration--] FO Processing--] Font Mapping Set , provided the corresponding font mapping set


Now When I run the report through Submit --] Requests and view the output in PDF format, the barcode doesn’t appear.

Suresh Vaishya said...

you are pretty close to it .. now one last thing that you might have missed is define territory as united states when you define your template and data definition. Hope this should work.

invinci said...

Hi Suresh,

Yes I missed to define the territory in the Template definition. Now,its working.

Thanks a lot for your help.

Regards,
Savitha

Suresh Vaishya said...

Glad that its working fine now.

Anonymous said...

Suresh, Thanks for the instructions for Bar code setup. I followed all the steps and double checked again. I am still not able to see the bar code on my Pick Slip. I am using IDAutomationHC39M font. We are on version 11.5.9. Can you please help?.

Jay

Suresh Vaishya said...

Jay please refer to my post http://sureshvaishya.blogspot.com/2010/01/cannot-view-barcodes-in-when-previewed.html where I have discussed the steps to view barcodes in the output.

Anonymous said...

We figured it out. It was an expired security policy for Xvfb (X virtual framebuffer) on the Linux box which was preventing connections. Once the policy was updated, Bar codes started printing out. whew!
BTW, I tried all the steps that you have listed both on Client and on APPS server to get the bar code working. It did not.
This might be something for users running APPS on Linux to check if Bar codes won't display even after trying all the steps listed here.

Thanks
Jay

Sharad said...

Dear Suresh ,

I done all the setup except server setup(apps) till now.


But when I am trying to perview the data in PDF format I am not able to see the barcode but able to see in the excel format/html.

Please guide me to get rid of from this issue.

Regards,
Sharad

Suresh Vaishya said...

Please refer to post http://sureshvaishya.blogspot.com/2010/01/cannot-view-barcodes-in-when-previewed.html

Sharad said...

Dear ,

I have already visited this URL.

and done the all steps as said there.

I beleive there should be some thing missing or might be in version.

I have checked the FONT property of PDF it is not showing code 39 font. It means it is not considering or not picking those font.

Looking for your guidance

Sharad

Suresh Vaishya said...

The steps listed should have fixed the problem. Could you please provide the steps that you have followed.

You are unable to see fonts when previewing from template or from application or both.

Sharad said...

Thanks for your support.

I missed the setup in xdo.cfg file and also did not enclose the data with * so that the scanner will read the data

Regards,
Sharad

Suresh Vaishya said...

Glad to hear that its working fine now.

Anonymous said...

Hi I am facing the same issue discussed here. I am using R12 apps. I did the setup in XMLP Administrator and also in rtf template. I am using IDAutomationHC39M font but still PDF output is not showing the barcode.,instead it shows some boxes Please guide me to rectify the issue

invinci said...

Hi,

I have an issue with bursting the Excel formatted output of BI publisher report. If the size is less than everything works fine. If the output file size is 33 MB, i am not able to view the output in the request form and also bursting is not working. Can you please let me know if there is any restriction in the size of excel output for bursting.

Thanks in Advance

Deirdre said...

Hello,

We are using code 3 of 9 and our underscores (___) are appearing as dashes (---). Does anyone have any idea as to how to resolve this issue?

Thank you

Anonymous said...

Dear Suresh,

I am having an issue where our Barcode Scanner is not reading IDAutomationHC39M font in the PDF. I have tried with the * before and after and without the *. The barcodes show up on our report but when we scan them the barcode reader does not scan them. When using a Barcode generator using either 39 or 128 fonts the scanner works. Any suggestions?

Thank you.

Sudheer M said...

Hi Suresh,
How is the barcode being generated in the invoice isit at the header part or body part of the xml template.Please share me if you have a example to m.l.sudheer@gmail.com.in our template we have used word properties and written a logic using page of pagenuumber when we view in word barcode is coming correctly but when previewed in pdf it is printing the bar code but with a constant value.
Any logic such page of pagenumber is used for bar code generation?if you have a example please fwd me

Fiona Sharon said...

Hi Suresh,

I am using IDAutomationSC39S.ttf font to print barcode in oracle report(RDF). It is working fine in Local Machine. But it is not so in applications server. Please guide me to install font in the server.

Thanks in advance.

Regards,
Sharon

FlyHigh said...

For this, I had been using this and it's great.
It has instructions which can help you.
BARCODE GENERATOR EXCEL
Just visit the site for more info.
They also have a live support to help you with your questions/concerns.

Copyright (c) All rights reserved. Presented by Suresh Vaishya