Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Adding Fonts for use with Oracle Reports 2.5

Adding Fonts for use with Oracle Reports 2.5

From: Andrew Cooper <alcooper_at_mail-g.deakin.edu.au>
Date: Tue, 17 Nov 1998 14:49:23 +1000
Message-ID: <3650F243.5CA855D9@mail-g.deakin.edu.au> 





Hi All,



I have been working on adding a font for use with Oracle Reports
(Server) (Sun Solaris 5.1).


It is a Barcode Font  (Code39HalfInch-BT). (TYPE 1 - Postcript)



Basically we are trying to create a report which is in a postscript file
format and have it printed. The printer we are using is an Apple
Laswerwriter 16/600. We have managed to down load the font into the
printers RAM.



After consultation with Oracle Support we have not yet had any success.



I have edited the PPD files to include the font as follows:



PPD File:  $ORACLE_HOME/guicommon2/tk23/admin/PPD/aplwgri2.ppd




*% Font Information =====================


*DefaultFont: Courier


*Font Code39HalfInch-BT: Standard "(001.000)" Standard      ---- Is this


correct ?  ---


*Font AvantGarde-Book: Standard "(001.006S)" Standard ROM


*Font AvantGarde-BookOblique: Standard "(001.006S)" Standard ROM


*Font AvantGarde-Demi: Standard "(001.007S)" Standard ROM


*Font AvantGarde-DemiOblique: Standard "(001.007S)" Standard ROM


*Font Bookman-Demi: Standard "(001.004S)" Standard ROM


*Font Bookman-DemiItalic: Standard "(001.004S)" Standard ROM


*Font Bookman-LightItalic: Standard "(001.004S)" Standard ROM


*Font Bookman-Light: Standard "(001.004S)" Standard ROM


*Font Courier: Standard "(002.004S)" Standard ROM


*Font Courier-Bold: Standard "(002.004S)" Standard ROM


*Font Courier-BoldOblique: Standard "(002.004S)" Standard ROM


*Font Courier-Oblique: Standard "(002.004S)" Standard ROM


*Font Helvetica: Standard "(001.006S)" Standard ROM


*Font Helvetica-Bold: Standard "(001.007S)" Standard ROM






The AFM file  'Code39HalfInch-BT' is located in
'$ORACLE_HOME/guicommon2/tk23/admin/AFM' directory



The 'uifont.ali' file is located in the
$ORACLE_HOME/guicommon2/tk23/admin/' directory. We have edited this to
look like :


#===============================================================


[ Printer:PostScript1 ]  # Put mappings for PostScript level 1 printers
here.



# Sample Kanji font mappings

...UltraLight..JEUC = "Ryumin-Light-83pv-RKSJ-H"...Light..JEUC
...UltraLight..SJIS = "Ryumin-Light-83pv-RKSJ-H"...Light..SJIS
...ExtraLight..JEUC = "Ryumin-Light-83pv-RKSJ-H"...Light..JEUC
...ExtraLight..SJIS = "Ryumin-Light-83pv-RKSJ-H"...Light..SJIS
...Light..JEUC      = "Ryumin-Light-83pv-RKSJ-H"...Light..JEUC
...Light..SJIS      = "Ryumin-Light-83pv-RKSJ-H"...Light..SJIS
...DemiLight..JEUC  = "Ryumin-Light-83pv-RKSJ-H"...Light..JEUC
...DemiLight..SJIS  = "Ryumin-Light-83pv-RKSJ-H"...Light..SJIS
.....JEUC           = "GothicBBB-Medium-83pv-RKSJ-H"...Medium..JEUC
.....SJIS           = "GothicBBB-Medium-83pv-RKSJ-H"...Medium..SJIS

# Mapping from MS Windows
Roman             = palatino
Script            = "itc zapf chancery"
FixedSys          = courier
System            = helvetica

# Mapping from Macintosh
"Avant Garde"     = "itc avant garde gothic"

# Mapping from Motif display
fixed             = courier
clean             = times
lucidatypewriter  = courier
lucidabright      = times





#Mapping for BarcodeFont



Courier         = "Code39HalfInch-BT"







These are all of the thing we were told to do by Oracle Support.



The script being used to generate and run this report is:




#!/bin/sh



TK2_PRINT_STATUS='lpq'


TK23_FONTALIAS=/opt/oracle/product/7.3.2/guicommon2/tk23/admin

# PRINTER='its_s_lp11'
# ORACLE_PRINTER='its_s_lp11'
# TK2_PRINT='lpr -Pits_s_lp11'
# TK23_PRINT='lpr -Pits_s_lp11'
# TK23_PRINTER='its_s_lp11'
# TK23_PRINT_STATUS='lpq'




export TK2_PRINT_STATUS


export TK23_FONTALIAS

# export PRINTER
# export ORACLE_PRINTER
# export TK2_PRINT
# export TK23_PRINT
# export TK23_PRINTER
# export TK23_PRINT_STATUS





rm ft.rep


r25convm userid=/ stype=rdffile source=ft.rdf dtype=repfile batch=yes
chmod 750 ft.rep


r25run ft MODE=BITMAP DESTYPE=File DESNAME=ft.ps DESFORMAT=dflt USERID=/
BACKGROUND=YES BATCH=YES







At the present time we are not getting barcodes: i.e we get   *281*  or
something along those lines.. This number corresponds to a barcode, but
is in the 'Courier' font.... At the top of the post script file is:


%!PS-Adobe-3.0
%%Creator: Oracle Toolkit 2 for Character-Mode 2.3.7.0.0 PRODUCTION
%%Version: 2.3 7
%%CreationDate: (Tue Nov 17 12:38:17 1998)
%%For: (Student Information System (siserver@<unknown host>))
%%Routing: (Student Information System)
%%Title: 'ft.ps' (Oracle Toolkit Application)
%%LanguageLevel: 2
%%Requirements: numcopies(1)
%%DocumentData: Clean7Bit
%%PageOrder: Ascend
%%Pages: (atend)
%%Orientation: Portrait
% NOTE: This file was generated with the PPD file default.ppd
%%DocumentNeededResources: font Code39HalfInch-BT font AvantGarde-Book
%%+ font AvantGarde-BookOblique font AvantGarde-Demi
%%+ font AvantGarde-DemiOblique font Bookman-Demi font


Bookman-DemiItalic

%%+ font Bookman-LightItalic font Bookman-Light font Courier
%%+ font Courier-Bold font Courier-BoldOblique font Courier-Oblique
%%+ font Helvetica font Helvetica-Bold font Helvetica-BoldOblique
%%+ font Helvetica-Narrow font Helvetica-Narrow-Bold
%%+ font Helvetica-Narrow-BoldOblique font Helvetica-Narrow-Oblique
%%+ font Helvetica-Oblique font NewCenturySchlbk-Bold
%%+ font NewCenturySchlbk-BoldItalic font NewCenturySchlbk-Italic
%%+ font NewCenturySchlbk-Roman font Palatino-Bold
%%+ font Palatino-BoldItalic font Palatino-Italic font Palatino-Roman
%%+ font Symbol font Times-Bold font Times-BoldItalic font Times-Italic
%%+ font Times-Roman font ZapfChancery-MediumItalic font ZapfDingbats
%%DocumentSuppliedResources: font AvantGarde-Book-ISL
%%+ font AvantGarde-BookOblique-ISL font AvantGarde-Demi-ISL
%%+ font AvantGarde-DemiOblique-ISL font Bookman-Demi-ISL
%%+ font Bookman-DemiItalic-ISL font Bookman-LightItalic-ISL
%%+ font Bookman-Light-ISL font Courier-Bold-ISL
%%+ font Courier-BoldOblique-ISL font Courier-Oblique-ISL
%%+ font Helvetica-ISL font Helvetica-Bold-ISL
%%+ font Helvetica-BoldOblique-ISL font Helvetica-Narrow-ISL
%%+ font Helvetica-Narrow-Bold-ISL font Helvetica-Narrow-BoldOblique-ISL

%%+ font Helvetica-Narrow-Oblique-ISL font Helvetica-Oblique-ISL
%%+ font NewCenturySchlbk-Bold-ISL font NewCenturySchlbk-BoldItalic-ISL
%%+ font NewCenturySchlbk-Italic-ISL font NewCenturySchlbk-Roman-ISL


%%+ font Palatino-Bold-ISL font Palatino-BoldItalic-ISL
%%+ font Palatino-Italic-ISL font Palatino-Roman-ISL font Times-Bold-ISL



%%+ font Times-BoldItalic-ISL font Times-Italic-ISL font Times-Roman-ISL


%%+ font ZapfChancery-MediumItalic-ISL
%%EndComments
%%BeginProlog

-------------------





As can be seen from this the 'Code39HalfInch-BT' font is being
recognised as a Required resource but not a Supplied Resource.  Does
anyone know where the 'ISL' tag comes from?



Does anyone out there know where Oracle would be looking for these fonts
when it generates this postcript fil?  I am at a loss. We have tried
installing the font on Unix, but later found that Oracle does not look
there for it..



Am i missing a step here.



If anyone out these has done this sort of work before please Email me,
we are getting quite desperate for these Reports.



I can be contacted on Email: alcooper_at_deakin.edu.au.



Thanks in advance for any help, it will be greatly appreciated.



Regards,



Andrew Cooper


Database Administrator


Information Technology Services


Deakin University


Geelong, Australia.








Received on Mon Nov 16 1998 - 22:49:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US