Implementing Barcode in Webi

system · March 15, 2013, 1:31am

I just want to know …How can I get barcode on webi reports

rmallyala (BOB member since 2013-03-15)

system · March 15, 2013, 1:17pm

If a barcode font is enough to your needs, you can add it on the BO server and all clients. On the server (and Rich Client installations), that implies hacking fontalias.xml (2 files on BI4). That sometimes works…

KFonMurphi (BOB member since 2007-10-16)

system · March 18, 2013, 2:42pm

Hi,

I tried adding barcode font in fontalias file in BO and also updated I18N in scripts . Now my format Text tool bar in webi is disabled. Any quick solution.

rmallyala (BOB member since 2013-03-15)

system · April 4, 2013, 1:22pm

We have had the same request and managed to get Barcode up and running in BOXI4, hence some minor obstacles…
when starting a new report, the barcode list shows [][][][] where the barcode name should be .Saving the document and reopening it shows the real barcode name.

In richt client we see nothing, not the [][][] nor the barcode name
but most of all, we can see the barcode in webi, we can export to XLS with barcode, but when exporting to PDF (or printing) the barcode is replaced with the ‘code’ behind (numerical value )

A case is logged with SAP , they already called back but could not even manage to explain clearly how to counteract the issues above. Our current documentation on how to do this was based on our experience with BOXI2 and BOXI3 SP5, on both all is working correctly, printing barcodes trough PDF works like a charm, hence it seems for BOXI4 ‘somehting’ has changed causing the barcode to disappear when using Print or export to PDF .

any help/advice welcome

best regards
Luc

electric4fun (BOB member since 2013-04-04)

system · April 4, 2013, 2:27pm

@electric4fun: Did you modify both fontalias.xml files?

We’ve seen something like this ourselves, on SP2. We didn’t try to solve this problem, we had enough problems with BI4 elsewhere.

Do you have a later SP?

KFonMurphi (BOB member since 2007-10-16)

system · April 4, 2013, 2:54pm

BOXI4 SP4

i know there is a BOXI4 SP5 but that is not yet deployed on our PRODUCTION/TEST only on DEV

regs,
Luc

electric4fun (BOB member since 2013-04-04)

system · April 4, 2013, 3:18pm

I believe that Webi Rich Client uses a local font file, the following path is for a version 3 install, obviously this may not be the same as version 4.0:-

Mak 1 (BOB member since 2005-01-06)

system · April 4, 2013, 3:26pm

The 3 fontalias.xml files (2 on the server and one of each desktop with Rich Client ) must be kept in sync:

Server:
\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\fonts
\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\fonts

Desktop:
\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\fonts

KFonMurphi (BOB member since 2007-10-16)

system · April 5, 2013, 7:14am

we are using the barcode font CIA Code 39 , it is installed as font on the server and the desktop.

we edited then following files

edit the Fontalias.xml in the following directorys:
:\ Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\fonts
:\ Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\fonts

in both we added

  <FONT NAME="CIA Code 39 Medium Text">
	<FONTFAMILY PLATFORM="ttf" NAME="CIA Code 39 Medium Text">
	<FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="CIA Code 39 Medium Text" PHYSICAL="cia_c39c.ttf" />
	</FONTFAMILY>
	<FONTFAMILY PLATFORM="win" NAME="CIA Code 39 Medium Text" />
	<FONTFAMILY PLATFORM="java" NAME="CIA Code 39 Medium Text" />
	<FONTFAMILY PLATFORM="html" NAME="CIA Code 39 Medium Text" />
</FONT>

we also edited the file i18n.xml in the :\ Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\scripts.

added

<font name="CIA Code 39 Medium Text">
<os type="all">
<Attributs style="0"filename="cia_c39c.ttf"encoding=""aliaspsname="cia_c39c" />
</os>
</font>

restarted all services…
strange thing is that we did almost the same a year ago on our BOXI3 server and there all works correctly , i can export (and print) the same bacrode font from BOXI3 via Webi .
the only difference was that BOXI3 hat the Bullzip PDF printer, so I added this one also to the BOXI4 but no change … BOXI4 still prints the fields as is .

[Moderator Edit: Added code formatting - Andreas]

electric4fun (BOB member since 2013-04-04)

system · April 5, 2013, 7:58am

Well, I have no idea why it should not work.

Except harassing SAP until they tell you why it worked before and does not work now. Perhaps you’ll get an ADAPT and a bugfix planned for 2015.

KFonMurphi (BOB member since 2007-10-16)

system · January 15, 2016, 8:48pm

Did anyone ever get barcodes to display in a PDF exported from WEBI 4.1?
It is not working for us in 4.1 SP6 patch 4. It does work in 3.1 SP7.
I made the changes to fontlias.xml but there is no i18n.xml file in our system. Also made sure the font is installed and restarted the box.

richardcottave (BOB member since 2006-03-30)