Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Not solved and closed]PDF AND ARABIC CHARACTERS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Not solved and closed]PDF AND ARABIC CHARACTERS
 Login/Join
 
Guru
posted
Hi,

I am able to retrieve ARABIC data stored in a sql server able to disply it correctly in HTML format.

But as soon as I change the output to PDF everything looks strange.

Any idea about what could be the reason

This message has been edited. Last edited by: Majid Jeddi,


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
Expert
posted Hide Post
If a matching font does not exist in the list of fonts available to WebFOCUS for PDF, then you will have to add a new one.

Check out this solution.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
Hi,

Thank you for this information. However i have no idea on what to put in those files in order to have Arabic dispay correctly.

Regards


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
<JG>
posted
The article is actually quite clear about what you need to do.

However if you are having a problem then you should raise a case with IBI support who will be able to walk you through it.
 
Report This Post
Guru
posted Hide Post
Hi JG,

I did not say the document is not clear. I understand the Syntax and how to add lines to that pdf.fmp file.
The question what metric file and what parameter we should insert there to have PDF report show Arabic Characters.
Also we have added lines to this file in the past tu support some polish.... characters.

Regards.

This message has been edited. Last edited by: Majid Jeddi,


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
<JG>
posted
quote:
The question what metric file and what parameter we should insert there to have PDF report show Arabic Characters.

First you must have the true type font and the .afm and .pfb files

the entry you make is totally dependant on the name of the font for example windows has a font called Simplified Arabic

if you have the required files you would add

font="Simplified Arabic", style=normal, metricsfile="Simplified Arabic" AFM *, fontfile="Simplified Arabic" PFB *, $


However WebFOCUS has an arabic PDF font (in 77 at least) called "Traditional Arabic"

try using that as your font= in your stylesheet.
 
Report This Post
Guru
posted Hide Post
quote:
AFM

Hi JG,

Is that mean with this release of webfocus we have an AFM file and pfb file for traditional Arabic.
Is that the case can you please tell me what are the names.

Thanks


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
<JG>
posted
quote:
Traditional Arabic

As of WebFOCUS Version 7 Release 6.7
quote:

Default Fonts for PDF and PS Output in Hebrew and Arabic
The default fonts used for PDF and PS output formats for Hebrew and Arabic are based on
the server language (LANG) parameter.
Assuming that the StyleSheet does not specify a
font name and that no default font is set in the PDF font mapping file, the defaults are:
Hebrew. Lucida Sans Unicode.
Arabic. Traditional Arabic.
For more information about how to use the PDF font mapping file,
see the Creating Reports With WebFOCUS Language manual.


As you are on 7.6.5 according to your profile Traditional Arabic will not
be available for you.

Download and read the Creating Reports with the WebFOCUS language manual (DN4500804.0909)
Using Print Display Formats: PDF, PS. starts section 10 on page 440 in this version.

If this does not get you working, raise a case with support. They have specialists available
who deal with National Language and Character support.
 
Report This Post
Guru
posted Hide Post
quote:
Using Print Display Formats

Hi JG,

I have also that webfocus release 7.7.x installed in a test environment. Do you know the AFM file's name?

Thanks


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
<JG>
posted
It's a standard font already configured in 7.7

You do not need to know anything about the .afm or .pfb files.

Do yourself a favour and read the documentation.
 
Report This Post
Guru
posted Hide Post
Hi JG,

I read the the documentation you mentionned and did not find anything talking about ARABIC text rendered in PDF format.
Also if I do not need to know anything about those files and if everything is pre-configured why it is so difficult to display a simple filed containing Arabic text in a PDF format.
I will just close this issue even if i do not have a solution to it and will write my text by hand.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
<JG>
posted
Madjid, The documentation is generic and treats all NONE American language in the same way.

When you add in characters outside of 0 to 9, a to z and A to Z, that’s a potential issue,
code pages, LANG setings, (no mix and match, either this script or that (for PDF)) .

For you the issue is quite simple.
You have data in a non English character set.

The questions that must be resolved is quite simple.

? How can I display, correctly, in PDF what the user needs to see when the
Data to be displayed is sourced from a dbms that correctly stores Arabic characters

quote:
if i do not have a solution to it and will write my text by hand."


If you take the easy way out, it will never work.

Raise a hottrack, then you might get help and a solution.

This is not really a forum issue.

It's actually an

"I need IBI's help" issue.

I can not change the status thet you have now put on this thread.

I feel sorry for whoever you are working for, because you are not
Looking for a solution to the problem, you are looking for the easy way
Out of it.

This message has been edited. Last edited by: <JG>,
 
Report This Post
Guru
posted Hide Post
Hi JG,

Just one easy question.
Do I need to read hunderd of pages out of a documentation just to find how to render the content of a field as it is stored in table?
Is this the first time WF is dealing with characters other than the usual one?
Before coming to this forum and ask for help, i did a lot of research and read the documentation but could not find it out.
That is why i am tired and will not spend months finding it.

Thanks any way


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
Expert
posted Hide Post
May I make a simple suggestion....

If you can display the arabic text in say, WORD, what font are you using ?

If its a True Type font, then it can be loaded into WebFOCUS, and be used.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<JG>
posted
quote:
That is why i am tired and will not spend months finding it.

Your company
quote:

•Ensuring that the Quality Pledge is understood, implemented and maintained among all Guardian employees.

I'm very sorry.
But to me, you do not appear to want to do the job you are being paid for.

If you have a valid maintenance agreement with IBI do as I suggested, raise a case with support.

Or pay for some consultancy to solve it for you.

If you need specific training to handle NLS/NCS the company needs to pay for it.

There many WebFOCUS customers in the world quite happily using Scandinavian, Arabic, Hebrew, Chinese, Korean, Japanese,
German, French, Spanish and many other none English fonts for Report output in PDF.

IB have the resources, but if you are not prepared to ask them, then you are the person responsible for
The failure, not them.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Not solved and closed]PDF AND ARABIC CHARACTERS

Copyright © 1996-2020 Information Builders