IBM Content Manager Server missinterprets object format stored by IMiS/Scan

Product:	IMiS/Scan, IMiS/Scan++, IBM Content Manager
Release:	5.x
Date:	10/10/2005

Case:

IBM Content Manager Client displays <Text Document> in File Type column for PDF objects. Full Text Indexing and other file-format-based services will not work correctly on such objects.
Here is a screenshot of an ODMA search dialog that shows stored PDF document class as <Text Document> instead of <PDF Document> (as seen by IBM Content Manager Server/Client):

This article covers steps to remedy this situation on IBM Content Manager version 8.x.

Description:

When IMiS/Scan is using ODMA compliant Servers for storage, it uses 2 different document classes:

a) when storing TIFF object, document class is set to IMiS.Document
b) when storing PDF object, document class is set to IMiS.Document.PDF

These document classes are not registered with your ODMA Server by default and need to be added manually. IMiS/Scan may be able to store and/or retrieve objects even if these modifications are not performed but some file-format oriented services such as Full Text Indexing Service and other may not work correctly. Since IBM Content Manager Server doesn't provide an user-friendly way of updating document classes this is achieved by editing its databases directly. Updating these tables has no bearing on other IBM Content Manager Server functions.

Prerequisites:
a) You need to ensure administration rights (username / password) to your IBM Content Manager Server (icmadmin:password).
b) If running these commands from a client machine, you need to have DB2 client installed and a IBM Content Manager Database alias created (icmnlsdb).

Steps to add these two document classes to IBM Content Manager v 8.x Database:
1. Open DB2 client either on your server or from a client machine.

2. Connect to your IBM Content Manager Database using CM Administrator account (icmadmin). The picture below shows a successful opening of the database:
db2 => connect to <icm-database> user <icm administrator username> using <password>
e.g:
db2 => connect to icmnlsdb user icmadmin using password

3. Update MIME type table with following lines:
db2 => update icmstmimetypes set suffixes=rtrim(suffixes) concat ' IMiS.Document' where mimetype='image/tiff'
db2 => update icmstmimetypes set suffixes=rtrim(suffixes) concat ' IMiS.Document.PDF' where mimetype='application/pdf'

4. Terminate session to apply recent changes.
db2 => terminate

Result:
After these modifications have been made updates can be observed in tables IBM Content Manager System Administration Client->Content Manager->icmnlsdb->Data Modeling->MIME Types.

When accessing documents from IBM Content Manager Client, file formats are now categorized correctly (the same search dialog as before Database patch):

Related Documents:

| Back | Main view