How to Print QR Code using BI Publisher?

vgsharma

Member
Hi List,

I want to Print QR Code(Multi-Dimensional Bar-code) in BI Publisher using JDE.
I tried searching but couldn't find the solution.

Could anyone of you please help?

Vishal
 
The source of the image holder in your RTF will have to be something that a QR Code API will return.
http://chart.apis.google.com/chart?cht=qr&chs=500x500&choe=UTF-8&chld=H&chl=http://www.jdesource.com

Ideally for dynamic images we use the URL
File System: url:{concat(../IMG_DIR_PATH,'/',IMGFILE)}
URL: url:{concat(../IMG_SERVER,'/',../IMG_DIR,'/',IMGFILE)}

For our case
URL: url:{'http://chart.apis.google.com/chart?cht=qr&chs=500x500&choe=UTF-8&chld=H&chl=http://www.jdesource.com'}

More info on the google apis - https://developers.google.com/chart/infographics/docs/qr_codes
 
Thanks Abhishek.. I gone through Suggested blog, that blog was for Oracle BI Publisher but i am Using BI Publisher Desktop with JDE.

Is there any solution with BI Publisher Desktop?
 
The article is actually written specifically for the BI Publisher Desktop. A close following of the instructions should result in success.

For use from the JDE application your CNC will need to deploy to the JDE Enterprise server in a similar fashion but the JAR file and xdo.config file locations are different than the BI Publisher Desktop.

Note that the blog post mentions a QR font from IDAutomation. It is a commercial font. I have used it successfully along with a few other bar code types from them. Their fonts and encoders have been reliable and worth the price in my opinion. There may be a free or open source QR fonts/encoder out there. You would need to use the same approach to integrate with BIP i.e. compile the encode into a .jar file, copy the .jar file into the BIP Desktop JLIB, upload the font TTF files and then add the fond to the xdo.config file.
 
I have followed all the step mention by Tim and I got following output for string:

AHEEEHAPBMKNBPAHEEEHA
BNFFFNBPFOEKAPBNFFFNB
DMPGEBFCEMCODAPOGLAFB
ENFNFNEPIFMKIAOPJAELD
APBBBPAPDBKDDIMEBHGMM
HHHHHHHPHPHHPHPPPPHPP

When I apply the IDAutomation2D font to it and re- run the report but it’s not printing QR code. I have also cross verified the xdo.cfg file where all the font property is in place.

Please help me, how to print the QR Code?
 
Is the xdo.cfg updated on E1 sever? Also, jar where it is deployed?
 
Hi JEMiller,

We are 9.2 but we fail to find steps to install QR Code font on BIP server ,Can you let em know how to deploy the 2 Jars to the BI-Publisher server and where to modify the classpath on BIP Server?
 
Hi all,

I am trying to implement the solution offered by Tim but I am not getting the desired output. The template viewer keeps giving me java.lang.ClassNotFoundException on my wrapper class which I added in the jlib of the BI publisher and I created an environment variable CLASSPATH pointing to the jar file. Any ideas?

Thank you in advance,
Catherine
 
I have a solution to print the QR code with BI publisher .
Hi Robert,

In our case we are using JD Edwards embedded BIP where we don’t have access to BIP Console. Is your solution applicable? if yes can you share it with us?

Regards,
Catherine
 
I did similar solution for Datamatrix encoded, I use internal BSSV for id automation java package. So, I call bssv with string and it return a string array, later print in BIPublisher and set ID Automation 2D Font (configured xdo.cfg). It's works fine ;)

You could call directlly to java class from BI Publisher too.

Regards,
Alfre.
 
I have followed all the step mention by Tim and I got following output for string:

AHEEEHAPBMKNBPAHEEEHA
BNFFFNBPFOEKAPBNFFFNB
DMPGEBFCEMCODAPOGLAFB
ENFNFNEPIFMKIAOPJAELD
APBBBPAPDBKDDIMEBHGMM
HHHHHHHPHPHHPHPPPPHPP

When I apply the IDAutomation2D font to it and re- run the report but it’s not printing QR code. I have also cross verified the xdo.cfg file where all the font property is in place.

Please help me, how to print the QR Code?
Dear vgsharma,
have you reached to solution, because i have the same issue
thanks

 
Back
Top