Many of you will have seen the Administrator module on the Template manager in the E Business Suite ... the new properties UI is great and much easier to use but you can now also manage those troublesome MICR, Barcode and other fonts through the manager too.
Thanks to Kevin McDermott from Oracle Support for laying out the following very useful instructions:
XML Publisher 5.6 has a new tab: Administration. This replaces the xdo.cfg configuration file. Now fonts can be uploaded and stored in the database instead of stored on the file system.
Under the Administration tab are sub tabs: Configuration, Font Mappings and Font Files and Currencies.
To install a font requires only a few steps.
1. Log in as XML Publisher Administrator.
2. Navigate to Administration->Font Files->Create Font File.
3. Fields are Font Name and File.
For Font Name choose any descriptive name.
File will browse your PC to locate the font file.
4. Navigate to Font Mappings->Create Font Mapping Set.
5. Mapping name is the name you will give to a set of fonts.
6. Mapping code is the internal name you will give to this set.
7. Type: 'PDF Form' for PDF templates. 'FO to PDF' for all other template types.
8. Create Font Mapping (this allows you to add multiple fonts to a set).
9. Font Family is the exact same name you see in Word under Fonts.
If you don't use the same name the font will not be picked up at runtime.
10. Style and weight must also match how you use the font in windows.
Normal and Normal are good defaults.
12. Navigate to Configuration General-> FO Processing->Font Mapping Set.
Can also be done at data def and template level under Edit Configuration.
Hierarchy is Site-> Data Def -> Template.
13. Select your new mapping set.
14. Make sure the font is not referenced under File->Properties->Custom in the RTF template file.
15. Upload a template that uses your special font and test using preview.
Comments (6)
Hi,
We are on 12.0.6 and I followed your steps to install MICR fonts. I uploaded GnuMICR, but couldnt get it to display in my PDF output. My template is type RTF. Can you please help?
Thanks,
Suresh
Posted by Suresh | June 12, 2009 6:33 AM
Posted on June 12, 2009 06:33
Hi,
I've setup my font mappings and the preview of my RTF -> PDF works fine with the fonts. However, I also create an xsl file which I use to preview the document from forms and workflow.
What I do is download the RTF to an XSL file using
RTFProcessor rtfP = new RTFProcessor(rtfTemplate.getBinaryStream());
rtfP.setOutput(lDirectory);
rtfP.process();
And to preview I use the following, where I first fetch the XML output in the CLOB and pass that with the XSL to the processor.
oracle.sql.CLOB eventData=statement.getCLOB(1);
ByteArrayOutputStream bout = new ByteArrayOutputStream();
fpro.setData(eventData.getCharacterStream());
fpro.setTemplate(lDirectory);
fpro.setOutput(bout);
fpro.setOutputFormat(FOProcessor.FORMAT_PDF);
fpro.process();
byte[] arr = bout.toByteArray();
InputStream [] inStream= new InputStream[1];
inStream[0] = new ByteArrayInputStream(arr);
OutputStream fOs = new BufferedOutputStream(response.getOutputStream());
PDFDocMerger pdfMerger = new PDFDocMerger(inStream,response.getOutputStream());
pdfMerger.mergePDFDocs();
Now the problem I encounter is that it only shows the default fonts, not the fonts I've uploaded.
Any thoughts/experience on this??
Posted by Pam | July 9, 2009 1:04 PM
Posted on July 9, 2009 13:04
Hi, I found the solution. I needed to place the font files somewhere on the server and create an XDO Config file (xdo.cfg) to point to the font files. The font mapping setup is not enough if you are using preview with the FO Processor apparently.
Posted by Pam | July 10, 2009 5:35 AM
Posted on July 10, 2009 05:35
How do you define non truetype fonts, like opentype fonts?
If you specify Type 1 you cannot select your font file, you must pick one of the values from the predefined list, so how would I link my opentype Font Family to my actual Font File?
Posted by Pam | July 13, 2009 2:18 AM
Posted on July 13, 2009 02:18
Pam,
Did you ever find a solution to this issue:
"How do you define non truetype fonts, like opentype fonts?
If you specify Type 1 you cannot select your font file, you must pick one of the values from the predefined list, so how would I link my opentype Font Family to my actual Font File?"
I am having the same issue and would like to know if you found a solution to defining non truetype fonts, like opentype fonts?
Thanks,
Mark
Posted by Mark | November 2, 2009 11:13 AM
Posted on November 2, 2009 11:13
Hi,
We are creating the XML Publisher reports with Arabic Transparent font.It is coming in the xml publisher (win word) but if I selected that arabic transparent font I am not able to select the font,automatically it is changing to Times New Roman font.
Can anybody help me to solve this problem? I followd this post but am not able to select the font name from the browse filed it is giving error like "control.ini File not found Please verify the correct file name was given"
Sahul
Posted by Sahul Hameed | November 16, 2009 5:15 AM
Posted on November 16, 2009 05:15