Index: openacs-4/packages/acs-content-repository/www/doc/intermedia.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/www/doc/intermedia.html,v diff -u -N -r1.1.1.1 -r1.1.1.1.30.1 --- openacs-4/packages/acs-content-repository/www/doc/intermedia.html 13 Mar 2001 22:59:26 -0000 1.1.1.1 +++ openacs-4/packages/acs-content-repository/www/doc/intermedia.html 22 Jun 2016 07:40:41 -0000 1.1.1.1.30.1 @@ -1,104 +1,104 @@ - -
-Even if you follow the instructions in the installation notes, content searches may -inexplicably fail to work. This document describes how to create a -simple test case independent of the content repository to verify that -Intermedia is indeed functioning properly.
- -Create a simple table to hold some test documents:
- -create table cr_test_documents ( - doc_id integer primary key, - author varchar2(30), - format varchar2(30), - title varchar2(256), - doc blob -);- -
Create an Intermedia preference to specify INSO filtering:
- -begin - ctx_ddl.create_preference - ( - preference_name => 'CONTENT_FILTER_PREF', - object_name => 'INSO_FILTER' - );- -
If this preference has already been created, this step will cause an -error that you can ignore.
- -Create an Intermedia index on the test table with INSO filtering:
- -create index cr_test_documents_idx on cr_test_documents ( doc ) - indextype is ctxsys.context - parameters ('FILTER content_filter_pref' );- -
You can use SQL*Loader to load some documents into the test table. -First create a control file named cr-test-docs.ctl: - -
load data -INFILE 'cr-test-docs.data' -INTO TABLE cr_test_documents -APPEND -FIELDS TERMINATED BY ',' -(doc_id SEQUENCE (MAX,1), - format, - title, - ext_fname FILLER CHAR(80), - doc LOBFILE(ext_fname) TERMINATED BY EOF)- -
Copy any number of documents (Microsoft Word, PDF, text, HTML, -etc.) to the file system of your database server. Create a data file -with an entry for each document you would like to load. This is -simply a comma-separated text file:
- -word, Simple Story,sample-docs/simple.doc, -excel, Simple Spreadsheet,sample-docs/simple.xls- -
Load the documents from the command line:
- -$ sqlldr userid=cms/cms control=cr-test-docs.ctl log=cr-test-docs.log - -SQL*Loader: Release 8.1.6.2.0 - Production on Thu Nov 9 13:36:56 2000 - -(c) Copyright 1999 Oracle Corporation. All rights reserved. - -Commit point reached - logical record count 2- -
Once the documents have been loaded, rebuild the index and run some -test queries:
- --SQL> alter index cr_test_documents_index rebuild online parameters ('sync'); -SQL> select score(1), doc_id from cr_test_documents - where contains(doc, 'cars', 1) > 0; - - SCORE(1) DOC_ID ----------- ---------- - 4 1 -- -
Even if you follow the instructions in the installation notes, content searches may +inexplicably fail to work. This document describes how to create a +simple test case independent of the content repository to verify that +Intermedia is indeed functioning properly.
+ +Create a simple table to hold some test documents:
+ +create table cr_test_documents ( + doc_id integer primary key, + author varchar2(30), + format varchar2(30), + title varchar2(256), + doc blob +);+ +
Create an Intermedia preference to specify INSO filtering:
+ +begin + ctx_ddl.create_preference + ( + preference_name => 'CONTENT_FILTER_PREF', + object_name => 'INSO_FILTER' + );+ +
If this preference has already been created, this step will cause an +error that you can ignore.
+ +Create an Intermedia index on the test table with INSO filtering:
+ +create index cr_test_documents_idx on cr_test_documents ( doc ) + indextype is ctxsys.context + parameters ('FILTER content_filter_pref' );+ +
You can use SQL*Loader to load some documents into the test table. +First create a control file named cr-test-docs.ctl: + +
load data +INFILE 'cr-test-docs.data' +INTO TABLE cr_test_documents +APPEND +FIELDS TERMINATED BY ',' +(doc_id SEQUENCE (MAX,1), + format, + title, + ext_fname FILLER CHAR(80), + doc LOBFILE(ext_fname) TERMINATED BY EOF)+ +
Copy any number of documents (Microsoft Word, PDF, text, HTML, +etc.) to the file system of your database server. Create a data file +with an entry for each document you would like to load. This is +simply a comma-separated text file:
+ +word, Simple Story,sample-docs/simple.doc, +excel, Simple Spreadsheet,sample-docs/simple.xls+ +
Load the documents from the command line:
+ +$ sqlldr userid=cms/cms control=cr-test-docs.ctl log=cr-test-docs.log + +SQL*Loader: Release 8.1.6.2.0 - Production on Thu Nov 9 13:36:56 2000 + +(c) Copyright 1999 Oracle Corporation. All rights reserved. + +Commit point reached - logical record count 2+ +
Once the documents have been loaded, rebuild the index and run some +test queries:
+ ++SQL> alter index cr_test_documents_index rebuild online parameters ('sync'); +SQL> select score(1), doc_id from cr_test_documents + where contains(doc, 'cars', 1) > 0; + + SCORE(1) DOC_ID +---------- ---------- + 4 1 ++ +