7.0

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 15

Create a New Search Profile that Uses an Access Database 16

Create a New Search Profile that Uses a MySQL Database 17

Build the Contents of a Database for the First Time 17

Rebuild the Contents of a Database 19

Refresh the Contents of a Database 20

Save a Search Profile 21

Load a Search Profile 21

Edit a Search Profile 21

Copy or Rename a Search Profile 22

Delete a Search Profile 22

Determine the Currently Loaded Search Profile 22

Delete a Database 22

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 42) 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:

l An SQLServer driver must be installed on the system (this is available by default in any supported version of Windows)

l The currently logged on user must have access to the SQLServer instance through the network.

l A database must be created on the SQLServer. It is suggested to call the database Search.

l Ausername and password must be defined in the user options and this username must have access to the SQLServer

and its Search database (see Set User Options).

Search Profiles And Databases