7.5

Table Of Contents

Search Profiles And Databases

In order to give the ability to search your document archives, PlanetPress Searchmust use a database in the background, with

which it connects using a Profile. While you may have multiple profiles on one or more computers connecting to a single data-

base, a search profile can only connect to a single database.

This chapter explains how to set up and manage profiles and databases.

Create a New Search Profile that Uses an SQL Server Database 19

Create a New Search Profile that Uses an Access Database 20

Create a New Search Profile that Uses an Oracle Database 21

To create a search profile connected to an Oracle database 21

Create a New Search Profile that Uses a MySQL Database 22

Build the Contents of a Database for the First Time 22

Rebuild the Contents of a Database 24

Refresh the Contents of a Database 25

Save a Search Profile 26

Load a Search Profile 26

Edit a Search Profile 26

Copy or Rename a Search Profile 27

Delete a Search Profile 27

Determine the Currently Loaded Search Profile 27

Delete a Database 27

Creating a Search Database

When you create a search database, you first define the set of PlanetPress Image folders you want to include in the database,

and whether you want to include their subfolders. PlanetPress Search then examines the FormName entry in all the PDI files

in those folders, and creates a record in the database for each distinct document referenced by the FormName entry. The

value of the FormName entry, minus the file name extension, also becomes the name of the record for that document in the

database. For example, if the FormName entry is survey.ps4, the corresponding database record bears the name

survey. See "PDI File Structure" (page 43) for a description of the FormName entry.

After PlanetPress Search creates a record for each distinct document it found in the folders, you populate each record with the

index information found in the PDI files for that document. See Build the Contents of a Database for the First Time.

Create a New Search Profile that Uses an SQL Server Database

This procedure describes how to create a search profile that uses an SQLServer database.

Pre-Requisites for SQLServer database connectivity:

Search Profiles And Databases