Supported Document Formats

 

This appendix contains a list of the document formats supported by the Inso filtering technology. The following topics are covered in this appendix:

 

 

About Inso Filtering Technology

 

Oracle Text uses document-filtering technology licensed from Inso Chicago Corporation. This filtering technology enables you to index most document formats. This technology also enables you to convert documents to HTML for document presentation, with the CTX_DOC package.

 

To use Inso filtering for indexing and DML processing, you must specify the INSO_

FILTER object in your filter preference.

 

To use Inso filtering technology for converting documents to HTML with the CTX_DOC package, you need not use the INSO_FILTER indexing preference, but you must still set up your environment to use INSO filtering technology as described in this appendix.

 

To convert documents to HTML format, Inso filtering technology relies on shared libraries and data files licensed from Inso Corporation and Adobe Corporation.

 

The following sections discuss the supported platforms and how to enable Inso filtering on the different platforms.

 

Supported Platforms

 

Inso filter technology is supported on the following platforms:

 

 

Environment Variable Location

 

All environment variables related to Inso filtering must made visible to Oracle Text.

 

Set these variables in the following location:

 

         The operating system shell from where ctxsrv server is started. This makes the environment variables visible to the ctxsrv process, which does background DML.

 

Requirements for UNIX Platforms

 

The following requirements apply to Solaris, IBM AIX, HP/UX, Digital UNIX, SGI, and Linux platforms:

 

         Ensure the *.flt files have execute permission granted to the operating system user running the Oracle database and ctxsrv server.

         Set the $PATH variable to include the location of the *.flt files, in particular to the location of the file isunx2.flt, and to $ORACLE_HOME/ctx/lib which is the location of the shared libraries for Inso filtering

         Set the $HOME environment variable to allow Inso technology to write files to a sub-directory (.inso) in $HOME directory.

         Access to a running X-Windows server is required to perform vector graphics image conversion.

 

Solaris, SGI, and Digital UNIX

 

Set the systemís shared library path ($LD_LIBRARY_PATH) environment variable to include $ORACLE_HOME/ctx/lib.

 

Note: Since indexing is a trusted callout instead of a safe callout, it is not necessary to set variables in listener.ora file. Any Inso-specific variables set in the listener.ora file is ignored by the INSO_FILTER object.

 

IBM AIX

 

Set the systemís shared library path ($LIBPATH) environment variable to include $ORACLE_HOME/ctx/lib.

 

You must include /usr/lib:/lib in $LIBPATH, because these directories are not searched by default once $LIBPATH environment variable is set.

 

HP/UX

 

Set the systemís shared library path ($SHLIB_PATH) environment variable to include $ORACLE_HOME/ctx/lib.

 

Linux

 

Set the systemís shared library path ($LD_LIBRARY_PATH) environment variable to include $ORACLE_HOME/ctx/lib.

 

Filtering Vector Graphic Formats

 

Follow these steps to filter vector graphic formats on UNIX platforms:

 

 

OLE2 Object Support

 

There are platform dependent limits on what Inso filter technology can do with OLE2 objects. On all platforms when a metafile snapshot is available, Inso technology will use it to convert the object.

When a metafile snapshot is not available on UNIX platforms, Inso technology cannot convert the OLE2 object.

 

However, when a metafile snapshot is not available on the NT platform, the original application is used (if available) to convert the OLE2 object.

 

Supported Document Formats

 

The following table lists all of the document formats that Oracle Text supports for filtering. Document filtering is used for indexing, DML, and for converting documents to HTML with the CTX_DOC package. This filtering technology is based on Inso Corporationís HTML export technology and is licensed from Inso Corporation.

 

Note: This list does not represent the complete list of formats that Oracle is able to process. The external filter framework enables Oracle to process any document format, provided an external filter exists which can filter all the formats to plain text.

 

 

Word Processing Ė Generic

 

Format†††††††††††† †††††††††††††††††††††††††Version

ASCIIText (7&8bit versions)†††††††††††††††† All versions

ANSI Text (7 & 8 bit)†††††††††††††††††††††† All versions

Unicode Text††††††††††††††††††††††††††††††† All versions

HTML††††††††††††††††††††††††††††††††††††††† Versions through 3.0

IBM Revisable Form Text†††††††††††††††††††† All versions

IBM FFT†††††††††††††††††††††††††††††††††††† All versions

Microsoft Rich Text Format (RTF)††††††††††† All versions

 

Word Processing - DOS

 

Format††††††††††††††††††††††††††††††††††††† Version

DEC WPS Plus††††††††††††††††††††††††††††††† Versions through 4.1

DisplayWrite 2 & 3 (TXT)††††††††††††††††††† All versions

DisplayWrite 4 & 5††††††††††††††††††††††††† Versions through Release 2.0

Enable††††††††††††††††††††††††††††††††††††† Versions 3.0, 4.0 and 4.5

First Choice††††††††††††††††††††††††††††††† Versions through 3.0

 

Word Processing - International

 

Format††††††††††††††††††††††††††††††††††††† Version

Ichitaro††††††††††††††††††††††††††††††††††† Version 5, 6, 8, 9, and 10

 

Word Processing - Windows

 

Format††††††††††††††††††††††††††††††††††††† Version

AMI/AMI Professional††††††††††††††††††††††† Versions through 3.1

CorelWordPerfectforWindows††††††††††††††††† Versions through 9.0

JustWrite†††††††††††††††††††††††††††††††††† Versions through 3.0

Legacy††††††††††††††††††††††††††††††††††††† Versions through 1.1

Lotus WordPro (NT on Intel only)††††††††††† SmartSuite 96, 97 and Millennium

Lotus WordPro (all supported††††††††††††††† SmartSuite 97 and Millennium (Text

platforms except NT on Intel)††††††† †††††††only)

MicrosoftWindowsWorks†††††††††††††††††††††† Versions through 4.0

MicrosoftWindowsWrite†††††††††††††††††††††† Versions through 3.0

Microsoft Word 97†††††††††††††††††††††††††† Word 97

Microsoft Word 2000†††††††††††††††††††††††† Word 2000

MicrosoftWord forWindows††††††††††††††††††† Versions through 7.0

Microsoft WordPad†††††††††††††††††††††††††† All versions

Novell PerfectWorks†††††††††††††††††††††††† Version 2.0

NovellWordPerfect forWindows††††††††††††††† Versions through 7.0

Professional Write Plus†††††††††††††††††††† Version 1.0

Q&AWrite forWindows†††††††††††††††††††††††† Version 3.0

WordStar forWindows†††††††††††††††††††††††† Version 1.0

 

Word Processing - Macintosh

 

Format††††††††††††††††††††††††††††††††††††† Version

Microsoft Word††††††††††† ††††††††††††††††††Versions 4.0 through 6.0

Microsoft Word 98†††††††††††††††††††††††††† Word 98

WordPerfect†††††††††††††††††††††††††††††††† Versions 1.02 through 3.0

MicrosoftWorks (Mac)††††††††††††††††††††††† Versions through 2.0

MacWrite II†††††††††††††† ††††††††††††††††††Version 1.1

 

Spreadsheets Formats

 

Format††††††††††††††††††††††††††††††††††††† Version

Enable††††††††††††††††††††††††††††††††††††† Versions 3.0, 4.0 and 4.5

First Choice††††††††††††††††††††††††††††††† Versions through 3.0

Framework†††††† ††††††††††††††††††††††††††††Version 3.0

Lotus 1-2-3 (DOS&Windows)†††††††††††††††††† Versions through 5.0

Lotus 1-2-3 for SmartSuite 97†††††††††††††† SmartSuite 97 and Millennium

Lotus 1-2-3 Charts (DOS & Windows)††††††††† Versions through 5.0

Lotus 1-2-3 (OS/2)††††††††††††††††††††††††† Versions through 2.0

Lotus 1-2-3 Charts (OS/2)†††††††††††††††††† Versions through 2.0

Lotus Symphony††††††††††††††††††††††††††††† Versions 1.0,1.1 and 2.0

Microsoft Excel 97††††††††††††††††††††††††† Excel 97

Microsoft Excel 2000††††††††††††††††††††††† Excel 2000

Microsoft ExcelWindows††††††††††††††††††††† Versions 2.2 through 7.0

Microsoft Excel Macintosh†††††††††††††††††† Versions 3.0 - 4.0 and 98

Microsoft Excel Charts††††††††††††††††††††† Versions 2.x - 7.0

Microsoft Multiplan†††††††††††††††††††††††† Version 4.0

MicrosoftWindowsWorks†††††††††††††††††††††† Versions through 4.0

MicrosoftWorks (DOS)††††††††††††††††††††††† Versions through 2.0

MicrosoftWorks (Mac)††††††††††††††††††††††† Versions through 2.0

Mosaic Twin††††††††† †††††††††††††††††††††††Version 2.5

Novell PerfectWorks†††††††††††††††††††††††† Version 2.0

QuattroPro for DOS††††††††††††††††††††††††† Versions through 5.0

QuttroPro forWindows††††††††††††††††††††††† Versions through 9.0

PFS:Professional Plan††††††††††††† †††††††††Version 1.0

SuperCalc 5†††††††††††††††††††††††††††††††† Version 4.0

SmartWare II††††††††††††††††††††††††††††††† Version 1.02

VP Planner 3D†††††††††††††††††††††††††††††† Version 1.0

 

Databases Formats

 

Format††††††††††††††††††††††††††††††††††††† Version

Access††††††††††††††††††††††††††††††††††††† Versions through 2.0

dBASE†††††††††††††††††††††††††††††††††††††† Versions through 5.0

DataEase††††††††††††††††††††††††††††††††††† Version 4.x

dBXL††††††††††††††††††††††††††††††††††††††† Version 1.3

Enable††††††††††††††††††††††††††††††††††††Versions 3.0, 4.0 and 4.5

First Choice††††††††††††††††††††††††††††††† Versions through 3.0

FoxBase†††††††††††††††††††††††††††††††††††† Version 2.1

Framework†††††††††††††††††††††††††††††††††† Version 3.0

MicrosoftWindowsWorks†††††††††††††††††††††† Versions through 4.0

MicrosoftWorks(DOS)†††††††††††††††††††††††† Versions through 2.0

MicrosoftWorks(Mac)†††††††††††††††††††††††† Versions through 2.0

Paradox (DOS)†††††††††††††††††††††††††††††† Versions through 4.0

Paradox(Windows)††††††††††††††††††††††††††† Versions through 1.0

Personal R:BASE†††††††††††††††††††††††††††† Version 1.0

R:BASE 5000†††††††††††††††††††††††††††††††† Versions through 3.1

R:BASE System V†††††††††††††††††††††††††††† Version 1.0

Reflex†††††††††††††††††††† †††††††††††††††††Version 2.0

Q & A†††††††††††††††††††††††††††††††††††††† Versions through 2.0

SmartWare II††††††††††††††††††††††††††††††† Version 1.02

 

Display Formats

 

Format††††††††††††††††††††††††††††††††††††† Version

PDF - Portable Document Format†††† †††††††††Versions 1.0, 1.1, 1.2, and 1.3

††††††††††††††††††††††††††††††††††††††††††† including Japanese PDF.

 

Presentation Formats

 

Format††††††††††††††††††††††††††††††††††††† Version

Corel Presentations†††††††††††††††††††††††† Versions 8.0 and 9.0

Novell Presentations††††††††††††††††††††††† Versions 3.0 and 7.0

Harvard Graphics forDOS†††††††††††††††††††† Versions 2.x & 3.x

Harvard Graphics Presentation†††††††††††††† Windows versions

Freelance 96 forWindows 95††††††††††††††††† Freelance 96

Freelance forWindows 95†††††††††††††††††††† SmartSuite 97 and Millennium

Freelance forWindows††††††††††††††††††††††† Version 1.0 and 2.0

Freelance for OS/2††††††††††††††††††††††††† Versions through 2.0

MicrosoftPowerPointforWindows†††††††††††††† Versions through 7.0

Microsoft PowerPoint 97†††††††††††††††††††† PowerPoint 97

Microsoft PowerPoint 2000†††††††††††††††††† PowerPoint 2000

MicrosoftPowerPointforMacintosh†††††††††††† Version 4.0 and 98

 

Standard Graphic Formats

 

The following table lists the graphic formats that the INSO filter recognizes. This means that indexing a text column that contains any of these formats produces no error. As such, it is safe for the column to contain any of these formats.

 

Note: The INSO filter cannot extract textual information from graphics.

 

Format††††††††††††††††††††††††††††††††††††† Version

Binary Group 3 Fax††††††††††††††††††††††††† All versions

BMP(including RLE, ICO,CUR&OS/2DIB)†††††††† Windows

CDR (if TIFF image is embedded in it)†††††† Corel Draw version 2.0 - 9.0

CGM - Computer Graphics Metafile††††††††††† ANSI, CALS, NIST, Version 3.0

DCX (multi-page PCX)††††††††††††††††††††††† Microsoft Fax

DRW - Micrografx Designer†††††††††††††††††† Version 3.1

DRW - Micrografx Draw†††††††††††††††††††††† Version 4.0

DXF (Binary and ASCII) AutoCAD Drawing††††† Versions through 13

Interchange Format

 

EMF†††††††††††††††††††††††††††††††††††††††† Windows Enhanced Metafile

EPS - Encapsulated PostScript†††††††††††††† If TIFF image is embedded in it

FPX - Kodak Flash Pix†††††††††††††††††††††† No specific version

GIF - Graphics Interchange Format†††††††††† Compuserve

GP4 - Group 4 CALS format†††††††††††††††††† Types I and II

HPGL - Hewlett Packard Graphics Language††† Version 2.0

IMG - GEM Paint†††††††††††††††††††††††††††† No specific version

JPEG††††††††† ††††††††††††††††††††††††††††††All versions including

††††††††††††††††††††††††††††††††††††††††††† progressive JPEG

PBM - Portable Bitmap†††††††††††††††††††††† No specific version

PCD - Kodak Photo CD††††††††††††††††††††††† Version 1

PCX††††††††††††††††††† †††††††††††††††††††††PC Paintbrush

Perfect Works (Draw) Novell†††††††††††††††† version 2.0

PGM - Portable Graymap††††††††††††††††††††† No specific version

PIC†††††††††††††††††††††††††††††††††††††††† Lotus

PICT1 & PICT2 (Raster)††††††††††††††††††††† Macintosh Standard

PNG - Portable Network Graphics Internet††† Version 1.0

Format

 

PNTG††††††††††††††††††††††††††††††††††††††† MacPaint

PPM - Portable Pixmap†††††††††††††††††††††† No specific version

PSP - Paintshop Pro (NT on Intel only)††††† Versions 5.0 and 5.0.1

SDW†††††††††††††††††††††††††††††††††††††††† Ami Draw

Snapshot (Lotus)††††††††††††††††††††††††††† All versions

SRS - Sun Raster File Format††††††††††††††† No specific version

Targa†††††††††††††††††††††††††††††††††††††† Truevision

TIFF†††††††††††††††††† †††††††††††††††††††††Versions through 6

TIFF CCITT Group 3 & 4††††††††††††††††††††† Fax Systems

Visio†††††††††††††††††††††††††††††††††††††† Visio 4 (Page Preview only), 5,

††††††††††††††††††††††††††††††††††††††††††† 2000

WBMP††††††††††††††††††††††††††††† ††††††††††WAP graphics standard

WMF†††††††††††††††††††††††††††††††††††††††† Windows Metafile

WordPerfect Graphics [WPG and WPG2]†††††††† Versions through 2.0

XBM - X-Windows Bitmap††††††††††††††††††††† x10 compatible

XPM - X-Windows Pixmap†††††††††††††††† †††††x10 compatible

XWD - X-Windows Dump††††††††††††††††††††††† x10 compatible

 

Other

 

Format††††††††††††††††††††††††††††††††††††† Version

Executable (EXE, DLL)†††††††††††††††††††††† No specific version

ExecutableforWindowsNT††††††††††††††††††††† No specific version

Microsoft Project Project 98††††††††††††††† (Text only)

MSG Microsoft Outlook mail format†††††††††† (Text only)

vCardElectronicBusinessCard†††††††††††††††† No specific version

 

Unsupported Formats

 

Password protected documents and documents with password protected content are not supported by the Inso filter.