Setting Up Search Collections

This chapter provides an overview of PeopleSoft CRM searching and discusses how to:

Click to jump to parent topicUnderstanding PeopleSoft CRM Searching

This section discusses:

Click to jump to top of pageClick to jump to parent topicSearch Collections and Their Uses

Several PeopleSoft CRM transactions incorporate a search that is powered by Verity, a third-party search and retrieval tool. The system searches against a Verity collection, a separate set of files that contain data that is copied from the PeopleSoft CRM database. The subset of data that is included in a collection is based on search index templates that you define.

PeopleSoft CRM includes these collections:

You must update the product catalog collection and the solution and error message collection regularly to ensure access to current data. The system automatically updates the unstructured email collection every time it processes newly arrived emails.

See Also

Solution and Error Searching

Understanding Product, Pricing, Proration, and Catalogs

Process Instantiation

Click to jump to top of pageClick to jump to parent topicSolution and Error Searching

You can use the solution and error message search collection in various ways.

Solution Advisor for Cases

In the three PeopleSoft CRM call center applications (PeopleSoft Support, HelpDesk, and HelpDesk for Human Resources), Solution Advisor is used to search for objects that can help resolve a case. Search groups determine which objects are searchable in agent-facing and self-service versions of Solution Advisor:

Both versions enable users to associate selected solutions with the case from which the Solution Advisor was invoked. The self-service version additionally enables self-service users to search for solutions outside the context of a case.

Solution Advisor for Service Orders

In PeopleSoft Integrated FieldService, Solution Advisor is used to search for solutions that are relevant to a service order. PeopleSoft Integrated FieldService does not track solution usage for service orders; search results are informational only.

Similar to Solution Advisor for cases, the type of object that gets searched (solutions only) is controlled through search group configuration. As delivered, Solution Advisor for service orders searches only solutions.

Solution Management Searches

Two solution management operations incorporate searches:

Both processes use searching to find solutions that are similar to a base solution that you indicate.

Error Validation Searches

Error validation searches enable PeopleSoft Support and PeopleSoft HelpDesk users to search for known error messages that are similar to an error message that callers report. This helps users match reported information to a known error even when callers provide incomplete or misspelled information about the message.

This functionality is available only if error tracking is enabled for the call center business unit.

See Also

Managing Solutions

Solution Search Templates

Processing Cases

Working with My Service Orders

Defining Call Center Business Units and Display Template Options

Click to jump to top of pageClick to jump to parent topicEnhanced Search Capabilities

Enhanced search capabilities enable you to provide the user with a robust, knowledge management solution.

Enhanced search capabilities include:

HTML Indexing

You can configure Verity search to include external content using the web through the use of the spider/crawl HTTP indexing capability. This feature allows data to be collected from external websites. The spidering capability indexes the structure of the site and builds a reference index that becomes searchable through Verity. These HTML files become searchable through Solution Advisor, without physically pulling the content into the Verity collection. The system returns results in the form of URL links with content summaries for those pages in the search results. The system displays the stored summaries in cases in which the referenced URL is no longer accessible.

When a customer service representative (CSR) is presented with a list of links to external content, the CSR can navigate to the external content and view the content on the remote system. If the CSR believes that the content is relevant and useful to the case, the CSR can choose to use this information as they would an attempted solution. External content can be converted into a new solution containing a complete copy of the text of the page as it existed at that moment in time.

If the CSR deemed the information not relevant or useful to the problem, the external content is not converted into a solution and no associated content is brought into the solution database. External web content is converted into a solution the first time that an agent finds the information valuable to a case. For all future searches in which the content of this page is deemed relevant by Solution Advisor, the system returns the solution and not the corresponding external link.

File Indexing

You can configure Verity to include collections that reside on file servers or directories. The system uses Verity's file system capability for the spider/crawl index to gather data from select files or directories (for example, a network drive share) and return links and summaries of those files in the search results. This enables agents to search for documents and other files that are related to the search criteria. The agent can create a relationship between the selected file and the transaction (case) to retain usage characteristics and track the document's contribution to the successful resolution of the customer issue. When an external file is deemed relevant and attempted for the first time, it can be converted into a new solution so that it can be associated with the case.

Thesaurus

You can configure the Solution Advisor search to consider alternate words for one or many of the words in the search field. The accuracy and relevancy of the search results are improved when alternate words are considered in the search. For example, a search criteria that included the word PC would also consider terms such as desktop, laptop, personal computer, and computer in returning a set of solutions or other results that are related to the entered search criteria. You can create custom thesaurus for the keyword search, use the thesaurus that Verity delivers, or both.

Noise words

You can configure the Solution Advisor search to ignore noise words in order to reduce the number of matches on trivial words from the search text. Examples of possible noise words might be and or for.

Word Variations

Solution Advisor can be configured to allow a number of word variations, including the ability to search against alternate spellings of common words, search for words with similar sounds, search for derivative variations, and so on. Users can optionally disable spell check if performance suffers by the introduction of this feature.

Click to jump to top of pageClick to jump to parent topicSearch Index Templates

Search index templates control the records and fields that are included in a collection.

Search Index Template Configuration

You create a separate search index template for each table or view that is included in a search collection. For example, users of Solution Advisor for cases need search index templates for cases, solutions, and troubleshooting guides.

PeopleSoft delivers search index templates for the search collections that are described in the preceding sections. You can modify these templates to change the fields that are searched, although it is not normally necessary to do so.

Search templates can include an optional SQL where clause to filter out data that you don't want added to the search collection. This improves the performance of the process that builds the collection. They also include field-level options that determine which fields are searchable and which fields are returned to the originating application.

You can improve performance for both the collection build process and for searching by:

You can also improve the efficiency of the build process by basing search index templates on views that contain only the fields to include in the collection. In the background, the PeopleCode is carrying out a %SelectAll command on the record, so if fewer fields are in the record, the build is faster.

Delivered Search Index Templates

This table lists the records for which PeopleSoft delivers search index templates for the product catalog collection (CRM_RB_PRODCAT):

Record

Description

RX_CATSRCH_VW

Product catalog

RX_CATSRCH2_VW

Product catalog external descriptions

This table lists the records for which PeopleSoft delivers search index templates for the solution and error message collection (CRM_RB_SRCHDB):

Record

Description

RC_CASE_VW2

Call center cases

RC_ERROR_TBL

Call center error records

RC_PST_VW

Troubleshooting guides

RC_ASOLPRSRH_VW

A view of solutions that enables the agent-facing version of Solution Advisor for cases to filter solutions based on related products

RQ_DEFECT_VW

Quality defects

RQ_FIX_VW

Quality fixes

This table lists the record for which PeopleSoft delivers search index templates for the unstructured email collection (CRM_RB_ERMS):

Record

Description

RB_UNSTR_VW

Inbound emails

This table lists the records for which PeopleSoft delivers search index templates for the defect and fix collection (CRM_RB_DEFECTFIX):

Record

Description

RQ_DEFECT_VW

Quality defects

RQ_FIX_VW

Quality fixes

This table lists the record for which PeopleSoft delivers search index templates for the self-service case collection (CRM_RC_CASE_SS ):

Record

Description

RC_ASOLPRSRH_VW

A view of solutions that enables the customer-facing version of Solution Advisor for cases to filter solutions based on related products

This table lists the records for which PeopleSoft delivers search index templates for the solution collection for PeopleSoft FieldService (CRM_RF_SRCHDB):

Record

Description

RC_SOLUTION_VW2

Solutions

RF_SO_SOL_SRH_V

Service order's header information

This table lists the records for which PeopleSoft delivers search index templates for the email workspace collection (ERMS_SRCHDB):

Record

Description

RB_SRCH_DOC_VW

Template definitions that are used for email response.

RC_SOLPRSRCH_VW

Solutions

This table lists the record for which PeopleSoft delivers search index templates for the solution collection for chat (SEARCH_SOLUTIONS):

Record

Description

RC_SOLPRSRCH_VW

Solutions

Click to jump to top of pageClick to jump to parent topicThe Build Collection Process

After you set up index templates for collections, you use the Build Collection process (RB_SRCH_BLD) to build the collection.

Building the Product Catalog Collection

When building the Product Catalog collection, run the Load Catalog Cache process (RO_CAT_PUSH1) before the Build Collection process.

The Product Catalog Collection job (BLD1CAT) incorporates both required processes.

Building the Unstructured Email Collection

You do not explicitly build the unstructured email collection. Instead, the Unstructured Content Analysis job incorporates both the Build Collection process and the process that analyzes and routes newly arrived inbound email.

Building Collections for External Contents

To search for information that exists outside the CRM system, such as external web pages and file systems of the enterprise, you need to build search collections for them as well. The procedure is the same as setting up a record-based collection. In the run control definition of the Build External Content process (RB_BLD_EXTCT), specify the type of external content (file or HTTP) and the index definition that is used to build the search collection.

Building Collections on Multiple Application Servers

The search collection resides on an application server. If you have multiple application servers, build the collection on each one. Having each application server access the collection files locally ensures optimum performance and simplifies the application server configuration.

You can manage multiple application servers in two ways:

Create and Update Modes

The Build Collection process has two modes: create a new collection and update the existing collection. The Update mode is faster, but it has certain limitations. Be sure to use the Create mode the first time that you build the collection and after you create a new search index template.

When collections are built in Update mode, the collection is totally locked by Verity This is called an exclusive lock. When an agent tries to access a collection that is in an exclusive locked mode, it may take longer to get results back. Also, doing an update forces Verity to maintain the old document as well as the updated document, thereby increasing the document file size.

To always keep a copy of the collection online while it's being built in Create or Update mode, the system uses a temporary name for the collection that is being built, leaving the current collection available to users during the build process. When the build is complete, it exchanges the active collection name with the temporary collection name so that the newly built collection is the one that is used for searches. The older version of the collection remains on the system, but only the newly built one is accessed during searches.

If the Build Collection process is run in update mode and no new data is added to the collection, the process finishes with a success status (log information is available in the message log) instead of returning an error message. It ensures that the update process doesn't get interrupted by the error, especially for customers who set the Build Search Collection process (RB_SRCH_BLD) to recur regularly.

Steps in the Process

The Build Collection process performs this sequence of steps:

  1. Accesses the setup files, the style files, and the index templates.

    PeopleSoft CRM leverages the style files that are delivered by PeopleTools so that no additional CRM-specific style files need to be installed separately. To make the style files work for CRM, the Build Search Collection modifies the style.uni file when it runs on a particular PeopleSoft Process Scheduler server for the first time.

  2. Creates the BIF (binary interchange file) and DAT (data) files for the data rows that meet the Where clause criteria.

    An incremental update gathers changes to the index templates and new information that was added to the database since the last collection update. These new rows are used to create new BIF and DAT files that are added to the collection. This creates a new partition within the search collection and makes the data available in the search results.

  3. Builds a BAT (batch) file or shell script that copies the Style.ufl file as well as other style files into the collection, based on language code.

  4. Runs the MKVDK executable program that builds the collection.

    The file is located in the PS_CFG_HOME\appserv\prcs\database\files directory in Microsoft Windows and in the PeopleSoft Process Scheduler home directory in UNIX.

  5. Updates the Date/Time field to indicate when the collection was created or updated.

  6. Resets the usage count and the last usage Date/Time field if you selected the Reset Usage Count check box for the build.

  7. After the process is finished (succeeded or failed), the log information of the MKVDK program is captured in a file called VerityOutput.Dat; the log is posted in the report repository. The log information is also displayed in the message log and the redirected terminal output on the View Log/Trace page. The content of the new collection is available in the <search collection name>.dat file on the same page. The same log process is also available to the collection building process for external context.

Note. Most search transactions do not track usage counts. Solution Advisor does count usage for solutions, but it is based on associating the solution with a case, not on the usage count fields that you set up in Verity. If you accidentally reset usage counts, the PeopleSoft call center applications provide an update usage count process that can recount solution usage.

When the Build Collection process is complete, you can find the collection on the server's Verity search collection path in the directory with the same name as the collection in the appropriate language-specific directory.

Performance and Optimization

To reduce the number of partitions in the database, configure search settings so that the collection is optimized on a regular basis. An optimization maximizes the size of the partitions that are in the collection. In most cases, optimize the collection after five incremental updates. Because the optimization frequency is set on the Search Settings page, you do not have to do anything when you run the build process.

Factors that affect performance of the Build Collection process include:

Errors During the Build Collection Process

The build process fails under these conditions:

Click to jump to top of pageClick to jump to parent topicSystem Configuration

This section discusses system configuration considerations.

PeopleSoft Process Scheduler Configuration

When you initiate the Build Collection process, you select the PeopleSoft Process Scheduler server that will run the process and provide a path to the collection files on the application server. Because the path is relative to the PeopleSoft Process Scheduler server, the setup is greatly simplified if you set up a PeopleSoft Process Scheduler server on each application server.

This configuration means that whenever you build a collection, you provide the same (local) path regardless of which PeopleSoft Process Scheduler server runs the process. It also ensures that the PeopleSoft Process Scheduler server has access to the disk where the collection files reside.

Note. We strongly recommends that the PeopleSoft Process Scheduler server and application server reside on the same server. If you have multiple application servers, we recommend that you set up a PeopleSoft Process Scheduler server on each one.

A PeopleSoft Process Scheduler that runs the Build Collection process must use a sign-in ID that has administrative abilities to create and remove the files and directories that are created as part of the Build Collection process.

To enable PeopleSoft Application Engine programs that call the Search API to locate collections, add the following section to the PeopleSoft Process Scheduler configuration file, making sure to modify it with the appropriate collection name and path.

[Search Indexes] CRM_RB_SRCHDB=c:\pt880\data\search\cr880dvl ;====================================================================== ; Search index settings ;====================================================================== ; Search indexes can be given alternate locations if there is an entry here. ; Entries look like: IndexName=fs location (ie EMPLOYEE=c:\temp)

Please refer to the Supplemental Installation Instructions for PeopleSoft 9.1 Applications (available in My Oracle Support) for step-by-step instructions on how to set up Verity searching in PeopleSoft CRM.

Application Server Configuration

Each search collection must have an entry in the Search Indexes section of the application server configuration file (PS_CFG_HOME\APPSERV\DomainName\psappsrv.cfg). The following example shows entries for the three PeopleSoft CRM collections.

[Search Indexes] CRM_RB_PRODCAT=C:\VERITY\DATA\SEARCH\DatabaseName CRM_RB_SRCHDB=C:\VERITY\DATA\SEARCH\DatabaseName CRM_RB_ERMS=c:\VERITY\data\search\DatabaseName

For Windows and UNIX operating systems, make sure that the PS_HOME environments variable points to the current tools home directory; for example, PS_HOME= c:\pt880 on Windows, or /ps/psasgrp/casb on UNIX. The batch or shell file that builds or updates the collection uses this variable. It should not contain an ending slash or backslash.

For UNIX, make sure that the Verity executable programs are part of the path-defaulting set of directories. Make sure that the MKDVK executable is part of the path. You must also make sure that chmod and sh are located in the home directory for the PeopleSoft Process Scheduler server or set a soft link pointing to those commands. For example:

ln -s /bin/chmod $PS_HOME/chmod ln -s /bin/sh $PS_HOME/sh

See Also

Supplemental Installation Instructions for PeopleSoft 9.1 Applications

Click to jump to top of pageClick to jump to parent topicThe Universal Search Tool

When you use the universal search tool, you first select the type of object that you're looking for; values are based on the objects for which you have defined search index templates.

Once you've selected a record, there are two ways to define search criteria. You can use either method by itself, or you can use both of them together.

You can enter record-level search criteria. The system searches for matching text in all of the fields included in the record's search index. The system ranks the search results according to how close the match is. If you enter record-level search criteria, you can use a natural-language search or a keyword search.

Alternatively, you can enter field-level search criteria. After you select a search record, the system displays a list of searchable fields. For each field, you can enter a search operator and search text. You can also decide whether to limit the results to records that meet all field-level criteria or whether to accept records that meet any individual field-level search specification.

This table describes each of the search operators available for field-level searching:

Operator

Description

<

The value that you enter is less than the field value.

<=

The value that you enter is less than or equal to the field value.

<>

The value that you enter is not equal to the field value.

=

The value that you enter is equal to the field value.

>

The value that you enter is greater than the field value.

>=

The value that you enter is greater than or equal to the field value.

BETWEEN

The field value is between the two values that you enter. You must enter and between the two values that you enter. For example, if you select BETWEEN and enter 100 and 200, the search returns values from 100 to 200, inclusive.

ENDS

The value that you enter matches the final characters of the field value.

IN

You enter a comma-delimited series of values, and the system finds field values that match any one of the values you entered.

LIKE

The value you enter sounds like or has a similar spelling to the matched field. When you select LIKE, you can use wildcards in the search criteria.

STARTS

The value that you enter matches the first characters of the field value.

CONTAINS

The word or phrase that you enter is embedded within the field that you are searching.

SUBSTRING

The word, phrase, or partial word that you enter is embedded within the field that you are searching.

Note. Searching is not case-sensitive.

Click to jump to parent topicDefining Thesaurus and Noise Words

To define thesaurus and noise words, use the Manage Thesaurus (RB_MNG_THESAURUS) and Manage Noisewords (RB_VRTY_STOPWORDS) components.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define Thesaurus and Noise Words

Page Name

Definition Name

Navigation

Usage

Load Verity Noise Words and Thesaurus

RB_LOAD_VRTY_FILES

Set Up CRM, Utilities, Search, Load Verity System Files, Load Verity Noise Words and Thesaurus

Load thesaurus and noise words that are provided by Verity to the CRM system.

Custom Thesaurus

RB_CSTM_THESAURUS

Set Up CRM, Utilities, Search, Manage Thesaurus, Custom Thesaurus

Define custom thesaurus entries for use in searching.

Delivered Thesaurus

RB_DLVD_THESAURUS

Set Up CRM, Utilities, Search, Manage Thesaurus, Delivered Thesaurus

View all thesauruses that are supplied by Verity and loaded on the system.

Manage Thesaurus

RB_ALL_THESAURUS

Set Up CRM, Utilities, Search, Manage Thesaurus, Manage Thesaurus

View and manage thesaurus entries from both delivered and custom sources.

Custom Noisewords

RB_CSTM_NOISEWORDS

Set Up CRM, Utilities, Search, Manage Noisewords, Custom Noisewords

Define custom noise-word entries for use in searching.

Delivered Noisewords

RB_DLVD_NOISEWORDS

Set Up CRM, Utilities, Search, Manage Noisewords, Delivered Noisewords

View all noise words that are supplied by Verity and loaded on the system.

Maintain Noisewords

RB_ALL_NOISEWORDS

Set Up CRM, Utilities, Search, Manage Noisewords, Maintain Noisewords

View and manage noise word entries from both delivered and custom sources.

Click to jump to top of pageClick to jump to parent topicLoading the Verity Thesaurus and Noise Words

Access the Load Verity Noise Words and Thesaurus page (Set Up CRM, Utilities, Search, Load Verity System Files, Load Verity Noise Words and Thesaurus).

Specify the type of data that you want to load from files that are provided by Verity into the CRM database: thesaurus, noise words, or both. Based on the data and language selection, the AE process (RB_LOAD_VRTY) reads the respective Verity files and loads data into the CRM database.

This is not a mandatory step. Run this AE process only if you want to take advantage of the thesaurus and noise word lists that Verity provides.

Click to jump to top of pageClick to jump to parent topicDefining a Custom Thesaurus

Access the Custom Thesaurus page (Set Up CRM, Utilities, Search, Manage Thesaurus, Custom Thesaurus).

Synonym For

The word for which the synonym will be defined.

Synonym List

Enter a list of possible synonyms for the word. Separate the synonyms with a comma.

Click to jump to top of pageClick to jump to parent topicWorking with a Delivered Thesaurus

Access the Delivered Thesaurus page (Set Up CRM, Utilities, Search, Manage Thesaurus, Delivered Thesaurus).

The system displays all thesauruses that are supplied by Verity and loaded on the system. Deselect or delete the ones that you don't want to use in the verity search. To delete the entire thesaurus, click Select All and then click Delete All.

Note. To improve performance when a large delivered thesaurus is loaded, PeopleSoft limits, by default, the display of delivered thesaurus synonyms to the first 100 entries. To view all of the entries, click the View All Delivered button. Clicking this button, however, can slow down system performance.

Click to jump to top of pageClick to jump to parent topicManaging the Thesaurus

Access the Manage Thesaurus page (Set Up CRM, Utilities, Search, Manage Thesaurus, Manage Thesaurus).

Select the types of thesaurus that you want to view. The system displays a list of entries for each type of thesaurus that you select.

Click to jump to top of pageClick to jump to parent topicDefining Custom Noise Words

Access the Custom Noisewords page (Set Up CRM, Utilities, Search, Manage Noisewords, Custom Noisewords).

Enter the words that you want the system to identify as noise words. Separate words with a comma. Select the language code. Click Add Noise Word(s). The grid displays all the noise words that you added.

Note. All custom noise words should be entered using lower case letters.

Click to jump to top of pageClick to jump to parent topicWorking with Delivered Noise Words

Access the Delivered Noisewords page (Set Up CRM, Utilities, Search, Manage Noisewords, Delivered Noisewords).

The system displays all Verity-delivered noise words. Deselect or delete the ones that you don't want to use in verity search.

Click to jump to top of pageClick to jump to parent topicMaintaining Noise Words

Access the Maintain Noisewords page (Set Up CRM, Utilities, Search, Manage Noisewords, Maintain Noisewords).

Select the type of noise word list to view. If you select All, the grid displays the source of the entry.

Click to jump to parent topicDefining Record-Based Indexes

To define record-based indexes, use the Search Settings (RB_SRCH_PARMS) and Search Index Template (RB_SRCHIDX_TMPL) components.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define Record-Based Indexes

Page Name

Definition Name

Navigation

Usage

Search Settings

RB_SRCH_PARMS

Set Up CRM, Utilities, Search, Search Settings, Search Settings

Define search collections and specify search settings that are used to build them.

Search Index Template

RB_SRCHIDX_TMPL

Set Up CRM, Utilities, Search, Search Index Template, Search Index Template

Define record-based search index templates and identify record fields to include in the search collection.

Delete Confirmation

RB_DEL_CONFIRM

Click the Delete Index Template button on the Search Index Template page.

Confirm deletion of the current index template.

Click to jump to top of pageClick to jump to parent topicDefining Settings for Building Search Collection

Access the Search Settings page (Set Up CRM, Utilities, Search, Search Settings, Search Settings).

Maximum Number per Document

Specify the maximum number of permitted attachments per solution

Images enbedded in solution details will not be counted toward the attachment limit.

Search Collection Name

Displays the name of the search collection.

Aging Interval in Days

Not used in PeopleSoft CRM searches.

Optimize Frequency

Enter the frequency for optimizing the collection. Optimization maximizes the size of the partitions that are in the collection. The default value is 5. This means that every fifth time you build the collection, it is optimized to reduce the number of partitions and maximize the amount of data that is stored in each partition.

Usage Increment and Usage Decrement

Not used by PeopleSoft CRM. Solution usage counts are based on actual associations with cases.

Documents per BIF File

Indicate the maximum allowable number of documents per XML/BIF file. The default value is 5000. Setting the maximum size of the XML input to the mkvdk Verity job with this limit assists performance when building a search collection.

Schedule Name and Job Name

Select the schedule and job that you established for this collection if you use a JobSet to build the collection.

See Defining JobSets for the Build Collection Process.

See PeopleTools 8.52: PeopleSoft Process Scheduler PeopleBook

Click to jump to top of pageClick to jump to parent topicDefining Record-Based Search Index Templates

Access the Search Index Template page (Set Up CRM, Utilities, Search, Search Index Template, Search Index Template).

Warning! PeopleSoft delivers one predefined search collection for Solutions (SEARCH_SOLUTIONS). Do not change this collection record index as there are codes tied to its record index (RC_SOLPRSRCH_VW). To format search results correctly, the system checks this record index. If you decide to change the record index of the Solutions search collection, you will also need to change the underlying code.

Collection Name

Displays the collection that the search index template is associated with. Establish search collections and parameters that are used to build them on the Search Settings page.

Record Name

Displays the record (a table or view) with the data that is to be added to the collection.

Where Clause to Append

Enter an optional Where clause to limit the data that is accessed when the collection is built.

Attachment Record Name

Specify the name of the attachment record (the table that stores the file attachment names).

Attachment URL Identifier

Specify the URL ID used to download attachments from the ftp server.

Search Collection Fields

The grid lists all of the fields in the record that are associated with this search index template. Do not remove any fields on the product catalog collection or the unstructured email collection.

Search Index

Select fields to include in the collection as searchable fields.

When you configure Solution Advisor search groups, only these fields are available for field-level searching.

Search Results

Select fields to return to the searching application.

Only key fields need to be returned to the searching application. The system uses SQL to access any other data that is shown in the search grid.

Has Attachments

This field is reserved for future use and is not currently used in release 9.1.

Delete Index Template

Click to delete the search index template. This brings up the Delete Confirmation page, where you can confirm the deletion.

Click to jump to parent topicDefining HTTP-Based Indexes

To define HTTP-based indexes, use the HTTP Index Definition (HTTPIDX_DEFN) component.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define HTTP-Based Indexes

Page Name

Definition Name

Navigation

Usage

HTTP Index Definition

RB_HTTPIDX_DEFN

Set Up CRM, Utilities, Search, HTTP Index Definition, HTTP Index Definition

Catalog the web pages to include in the HTTP collection.

Mime Types

RB_HTTPIDX_MIME

Set Up CRM, Utilities, Search, HTTP Index Definition, Mime Types

Include or exclude specific MIME types for the collection.

File Names

RB_HTTPIDX_FILE

Set Up CRM, Utilities, Search, HTTP Index Definition, File Names

Include or exclude specific file types for the collection.

Click to jump to top of pageClick to jump to parent topicDefining HTTP-Based Indexes

Access the HTTP Index Definition page (Set Up CRM, Utilities, Search, HTTP Index Definition, HTTP Index Definition).

HTTP Index name

The name of the HTTP index. You can have more than one HTTP index.

Depths of links for crawling

Depth of links

Determines to what extent the Verity crawler should crawl into the URLs that are listed on this page. The recommended depth is 2.

Proxy Server

Proxy Host Name and Proxy Port

Enter the address of the server and the number of the port that is acting as a proxy for your HTTP index.

URL Options

URLs which contain the ? symbol typically lead to a CGI or other similar processing program. By default, these URLs are excluded from the build external content index process. Use this group box to enable indexing for URLs with the ? symbol.

Allow CGI (allow common gateway interface)

Select to allow CGI scripts to interact with the CRM database and applications. The system also allows URLs that are dynamically generated by a CGI program.

For example, http://h20180.www2.hp.com/apps/Nav?h_pagetype=s-001&h_lang=en&h_cc=us&h_product=18703&h_client=S-A-R163-1&h_page=hpcom&lang=en&cc=us

Append to Verity Command Line

This field allows you to specify additional command line processing options to pass to the Verity spider at run time.

This is an optional field.

Starting URLs

URL

List the URLs that the Verity crawler should start crawling from.

Stay in Domain

Select to restrict the spidering to URLs in the same domain as the starting URL.

Note. If you select this option for one URL, you must select it for all other URLs as well.

Stay in Host

Select to restrict the spidering to URLs on the same web server as the starting URL.

Note. If you select this option for one URL, you must select it for all other URLs as well.

Click to jump to top of pageClick to jump to parent topicSelecting MIME Types

Access the Mime Types page (Set Up CRM, Utilities, Search, HTTP Index Definition, Mime Types).

Select to include specific MIME types. Any document type that is not selected will be ignored during the indexing process.

Click to jump to top of pageClick to jump to parent topicSelecting File Names

Access the File Names page (Set Up CRM, Utilities, Search, HTTP Index Definition, File Names).

Filenames

Include All Filenames

Select to index all file types.

Include Specific Filenames

Select to index only specified filenames. Specify the filename in the Filename field. You can specify multiple file types by separating names with a space.

Exclude Specific Filenames

Select to exclude specific filenames from the index. Specify the filename in the Filename List. You can specify multiple file types by separating names with a space.

Click to jump to parent topicDefining File-Based Indexes

To define file-based indexes, use the File Index Definitions (RB_FILEIDX_DEFN) component.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define File-Based Indexes

Page Name

Definition Name

Navigation

Usage

File Index Definition

RB_FILEIDX_DEFN

Set Up CRM, Utilities, Search, File Index Definitions, File Index Definition

Catalog the files to include in the collection.

File Index Filenames

RB_FILEIDX_FILES

Set Up CRM, Utilities, Search, File Index Definitions, File Index File Names

Include or exclude specific files for the collection.

Click to jump to top of pageClick to jump to parent topicDefining File-Based Indexes

Access the File Index Definition page (Set Up CRM, Utilities, Search, File Index Definitions, File Index Definition).

File System Path

Enter the file paths of file indexes to be searched at runtime.

Click to jump to top of pageClick to jump to parent topicManaging File Index Filenames

Access the File Index Filenames page (Set Up CRM, Utilities, Search, File Index Definitions, File Index File Names).

File Index Filenames

Include All Filenames

Select to index all file types.

Include Specific Filenames

Select to index only specified filenames. Specify the filename in the Filename List. You can specify multiple file types by separating names with a space.

Exclude Specific Filenames

Select to exclude specific filenames from the index. Specify the filename in the Filename List. You can specify multiple file types by separating names with a space.

Click to jump to parent topicConfiguring Search Options

To configure search options, use the Search Page Definition (RB_VRTY_PG_CFG) component.

This section provides overview on search behavior and word variations and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Search Behavior

This table describes each of the search behaviors that are available for searches:

Note. All search behaviors use the OR operator to process search requests. For example, if you enter the word computer for the with all words search behavior and you select both the Solution Description and Solution Summary fields as searchable fields, the system returns solutions that have the word computer found in their solution description or solution summary. Similarly, if the search behavior is without the words (and everything else remains the same), the system returns solutions that do not have the word computer in either the solution description or solution summary. In this case, if the word computer appears in the solution description but not the solution summary, the solution returns as a result of the search.

Search Behavior

Definition

Example

With all words

Search documents having references to all the words.

Computer crashed returns documents containing both computer and crashed.

With any words

Search documents having references to any of the words.

Software error returns documents containing either software or error.

With the exact phrase

Search documents having references to the exact phrase.

Application Server returns documents matching the exact phrase Application Server.

Without the words

Search documents excluding all the words.

DSL Modem returns documents that do not contain either DSL or Modem.

Words in proximity

Search documents containing two or more words within n words, where n is an integer that is defined by the system administrator.

Cell phone returns documents with cell and phone within the specified number of words.

Words in a sentence

Search documents having all the words in one sentence.

Office 2000 returns documents with Office and 2000 within one sentence.

Words in a paragraph

Search documents having all the words in one paragraph.

Clear cache returns documents with clear and cache in one paragraph.

Words in same order

Search documents having all the words in the same order.

Meta data returns documents with meta and data in the same order.

Click to jump to top of pageClick to jump to parent topicUnderstanding Word Variations

This table describes each of the word variations that are available for searches:

Word Variation

Definition

Example

Alternate spellings

Search documents ignoring typos in the search text.

Temperaturee returns documents with temperature by ignoring the typo.

Use stemmings

Search documents for stemmed or derivative variations.

Film returns documents with film, films, and filmed.

Exact words

Search documents for exact words in search text.

Film returns documents with film only.

Include synonyms

Search documents for word and include words with the same meaning.

Unix returns documents with linux, Unix, and AIX.

Words with similar sounds

Search documents for words with similar letter patterns.

Sale returns documents with sale, sail, sell, shell, and scale.

Click to jump to top of pageClick to jump to parent topicPages Used to Configure Search Options

Page Name

Definition Name

Navigation

Usage

Search Definitions

RB_VRTY_PAGE_CONFG

Set Up CRM, Utilities, Search, Search Page Definitions, Search Definitions

Define the search behavior and word variation options for the basic and advanced modes.

Record Index List

RB_VRTY_PAGE_RIDX

Set Up CRM, Utilities, Search, Search Page Definitions, Record Index List

Indicate all the record-based indexes to be searched at runtime when the search is invoked from this page.

HTTP Index List

RB_VRTY_PAGE_HIDX

Set Up CRM, Utilities, Search, Search Page Definitions, HTTP Index List

Indicate all the HTTP-based indexes to be searched at runtime when the search is invoked from this page.

File Index List

RB_VRTY_PAGE_FIDX

Set Up CRM, Utilities, Search, Search Page Definitions, File Index List

Indicate all the file-based indexes to be searched at runtime when the search is invoked from this page.

Click to jump to top of pageClick to jump to parent topicConfiguring Search Definitions

Access the Search Definitions page (Set Up CRM, Utilities, Search, Search Page Definitions, Search Definitions).

Default Settings

Search Mode

Select Basic or Advanced to set the default search mode.

Results to display

Enter the number of search documents to display.

Basic Search Options

The Basic Search Options group box sets the values of search options if the page searches in Basic mode.

Search Behavior

Select the default search behavior to use in Basic mode.

Word Variations

Select the word variation options to use in Basic mode.

Proximity factor

If the search behavior is Words in proximity, enter the maximum number of words that can be between the two search words.

Maximum Transformations

If the word variation type is Alternate spellings, enter the maximum number of words you want the system to return when the user enters a search word with a typo.

Case Sensitive

Select to make searches case sensitive.

Display Noise Words

Select to display noise words.

Advanced Search Options

The Advanced Search Options group box sets the values of search option if the page searches in Advanced mode.

Search Behavior

Select all search behaviors to use in Advanced mode.

Word Variations

Select all word variations to use in Advanced mode.

Additional Options

Select the word variation options to use in Advanced mode.

Click to jump to top of pageClick to jump to parent topicConfiguring the Record Index List

Access the Record Index List page (Set Up CRM, Utilities, Search, Search Page Definitions, Record Index List).

One page can have more than one record index list and more than one record can be associated with a record index. The check box label corresponds to the record that is associated with the search index. Select check boxes that correspond to record zones within the record index.

Click to jump to top of pageClick to jump to parent topicViewing the HTTP Index List

Access the HTTP Index List page (Set Up CRM, Utilities, Search, Search Page Definitions, HTTP Index List).

Select the HTTP spiders that you want to use for indexing web pages on a specific search page. The spiders that are configured for this page are the only ones available at runtime when search text is entered.

Click to jump to top of pageClick to jump to parent topicDefining the File Index List

Access the File Index List page (Set Up CRM, Utilities, Search, Search Page Definitions, File Index List).

Select the file index that you want the system to search at runtime. If the files are on an FTP server, select the FTP check box and an FTP server URL.

Click to jump to parent topicBuilding and Testing a Search Collection

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Build and Test a Search Collection

Page Name

Definition Name

Navigation

Usage

Build Search Collection

RB_SRCH_RUN_INDEX

Set Up CRM, Utilities, Search, Build Search Collection, Build Search Collection

Specify run control parameters for and run the build collection process.

Build external content index

RB_EXT_CONTENT_RUN

Set Up CRM, Utilities, Search, Build ExternalContent, Build external content index

Specify run control parameters for and run the build external content collection process.

Search Query Test

RB_SEARCH_DEMO

Set Up CRM, Utilities, Search, Query Test, Search Query Test

Test a search string to determine whether the data that is returned is what you expect from the collection.

Click to jump to top of pageClick to jump to parent topicSpecifying Run Control Parameters and Running the Build Collection Process

Access the Build Search Collection page (Set Up CRM, Utilities, Search, Build Search Collection, Build Search Collection).

Note. Normally, you can run a process immediately after defining the process parameters. However, if you use a JobSet, you must define the JobSet between setting up the run control and running the process.

See Defining JobSets for the Build Collection Process.

Run Control ID

Create a run control for each application server that is in the environment. Use a naming convention that identifies both the collection and the PeopleSoft Process Scheduler server name.

Run Control Details

Request ID and Description

Enter descriptive information about the run control parameters.

Collection Name

Select the collection to build.

Collection Directory

Enter the directory path for the collection. The path is relative to the PeopleSoft Process Scheduler server where the process runs, not to the computer where the request is made. Therefore, this path matches the Verity collection path on the application server (PeopleSoft Process Scheduler is assumed to be running on the application server computer). If these paths do not match, you cannot create the collection. You can enter the path either in the UNC (universal naming convention) name format (which is the absolute path) or in the logical drive notation (which is relative to the machine where PeopleSoft Process Scheduler runs).

The PS_HOME environment variable must include any mapped drives.

Server Operating Environment

Windows NT

Select if Windows NT is the server operating environment.

UNIX / Linux and $PS_Home Directory

Select if UNIX or Linux is the server operating environment, and enter the value for the PeopleSoft Process Scheduler home directory. This directory is used to create the shell script for building the collection.

Search Collection Selection

Create New

Select this option to run the Build Collection process in Create mode. The process creates a new search collection and overwrites the existing one.

Update Existing

Select to run the Build Collection process in Update mode. This process gathers all additional information and changes to the index template records that have date/time stamps after the last update time for a collection. Choose this option only after the collection is created.

Reset Usage Count/Date

Select to set the usage count on all objects in the collection to zero and the last usage date to null. This option is available only when you are creating a collection.

The only usage counts that the system maintains are solution usage counts, and a separate process manages those. Normally, you should not reset usage counts as part of the Build Collection process.

Language Selection

All Installed Languages

Select to create collections for every language that is installed on the system. The languages that are built are based on the INSTALLED flag in the PSLANGUAGES table.

Single Language and Language Code

Select to create a collection for only the language code that you select.

Search Index Templates

This group box displays information about the search index templates that belong to this collection.

Additional Page Elements for Running the Process

Run

Click to access the PeopleSoft Process Scheduler Request page and build the collection on a single application server. The Process Scheduler Request page lists two processes:

  • Select Product Catalog Collection to run both the Load Catalog Cache process and the Build Collection process.

  • Select RB_SRCH_BLD to run just the Build Collection process.

To ensure that the collection is regularly updated, associate either process with a recurrence definition.

Click to jump to top of pageClick to jump to parent topicSpecifying Run Control Parameters and Running the Build External Content Collection Process

Access the Build external content index page (Set Up CRM, Utilities, Search, Build External Content, Build external content index).

To build a collection for external content, specify the external content type, the index name, the directory where the collection resides, and the languages for which the collection is built.

External Content Type

Select the type of external content for which the collection is built. Values are HTTP Index and File Index.

External Content Name

Select the index definition to use to build the collection. If you select HTTP index as the external content type, only HTTP index definitions are available for selection in this field. The same is true for the file index type.

Click to jump to top of pageClick to jump to parent topicTesting Searches

Access the Query Test page (Set Up CRM, Utilities, Search, Query Test, Search Query Test).

Search Collection Name

Select the collection to test.

Parser

Select the parser to use for the query. Values are: Keyword Parsing, Free Text Parsing, and Query By Example Parsing.

Text to Search For

Enter sample text to search for. If you are testing the keyword parser, enter a keyword string into the field. If you are testing the free text parser or the query by example parser, enter a natural language string.

Search Using Verity Scoring

Click this button to view the results sorted according to the Verity internal scoring algorithms.

Search Using Usage Scoring

Click this button to view the results after they have been sorted using the usage count and last usage date and time calculations.

Click to jump to parent topicDefining JobSets for the Build Collection Process

To define JobSets and associate them with build collections:

  1. Create run control records for the processes to run.

    Access the Build Search Collection page. For each collection that you maintain, create a run control record for each application server that is in the environment. Use a naming convention that identifies both the collection and the PeopleSoft Process Scheduler server name.

  2. Create the jobs to include in the JobSet.

    Select PeopleTools, Process Scheduler, Jobs to access the Job Definitions page.

    1. Create a job that runs the Build Collection process once for each application server that is in the environment.

      For example, if you have four application servers in the environment, then the job needs to have four processes, each running the Build Collection process. Set the job run mode to parallel so that the job items can run concurrently on the different servers.

      PeopleSoft delivers a sample job, PRODCAT, that you can use as a model.

    2. If you are building the Product Catalog collection, create a job that runs the Load Catalog Cache process and the job that you defined in the preceding step.

      The Load Catalog Cache process loads the product catalog cache with the current contents of all catalogs. You must load the catalog cache before the collection is built, so put this process before the Build Collection process, and set the job run mode to serial.

      PeopleSoft delivers a sample job, BUILDCAT, that you can use as a model.

  3. Create the JobSet.

    Select PeopleTools, Process Scheduler, Schedule Job Set Definition to access the JobSet Definitions page.

    Give the JobSet a meaningful name: If this is for the Product Catalog, then give it the name of the job that you created in the second step; otherwise, give it the name of the job that you created in the first step.

    The Run Control ID that you enter is overridden in the next step, so you can enter any value.

    If you want this JobSet to run automatically at regularly scheduled intervals, you can optionally attach a recurrence definition to this JobSet.

  4. Set up JobSet items.

    Select PeopleTools, Process Scheduler, Schedule Job Set Definition to access the Schedule JobSet Items page.

    Add the jobs that you created in step 2 to the JobSet process list. Enter the following parameters for each:

    1. On the General Settings tab in the process list, enter the run control ID that is specific to a PeopleSoft Process Scheduler server.

      For example, if you have two PeopleSoft Process Scheduler servers named PSNT and PSNT2, and you're building the CRM_RB_SRCHDB collection (for solutions), then you might have run control IDs called SRCHDB_PSNT and SRCHDB_PSNT2.

    2. On the Server Settings tab in the process list, enter the PeopleSoft Process Scheduler server name in the Server Name field. Remember, each job runs on a separate PeopleSoft Process Scheduler server.

  5. Associate the JobSet with the collection.

    Access the Search Settings page.

    Enter the schedule name and job name next to the search collection to which the search settings apply.

See Also

PeopleTools 8.52: PeopleSoft Process Scheduler PeopleBook

Click to jump to parent topicUsing the FTP Option to Index Files

This section provides an overview on using the FTP option and discusses how to set up the FTP option to index files.

Click to jump to top of pageClick to jump to parent topicUnderstanding the FTP Option

When you set up the FTP option to index files, keep these considerations in mind:

Click to jump to top of pageClick to jump to parent topicSetting Up the FTP Option to Index Files

Follow these procedures when setting up the FTP option to index files:

  1. Go to PeopleTools, Utilities, Administration, URLs.

  2. Create a new URL by entering ftp://anonymous:anonymous@yourservername/CRM in the URL field.

    Note. Depending on the depth of your FTP file path, create as many URLs as you need.

  3. Go to Set Up CRM, Utilities, Search, File Index Definition.

  4. Create a file index name. For example, CRM_FILE.

  5. Enter \\yourservername\CRM in the File Path field.

  6. Go to Set Up CRM, Utilities, Search, Search Page Definitions, File Index List.

  7. Select the CRM_FILE file index name on the File Index List page.

Click to jump to parent topicPerforming Search on the Universal Search Tool

This section discusses how to perform search on the universal search tool.

Click to jump to top of pageClick to jump to parent topicPage Used to Perform Search on the Universal Search Tool

Page Name

Definition Name

Navigation

Usage

Universal Search Tool

RC_ST_SEARCH

Set Up CRM, Utilities, Search, Universal Search Tool, Universal Search Tool

Search the CRM search collection for desired information.

Click to jump to top of pageClick to jump to parent topicPerforming Search on the Universal Search Tool

Access the Universal Search Tool page (Set Up CRM, Utilities, Search, Universal Search Tool, Universal Search Tool).

Record

Select the record to search. Values include records for which you have defined search index templates. Selecting a value causes the Additional Search Information group box to appear.

Search

Enter record-level search text.

Display

Select the number of rows of data to appear in the Search Results grid. You can select 10, 25, 50, 75, 100, or 250.

Search Type

Select Phrases to perform a natural language search. Select Keywords to perform a Boolean search.

If you select Keywords, click the Search Tips link for an explanation of the proper syntax for the search text. This setting applies only to record-level search criteria, not to field-level search criteria.

Match On

Select All Fields (AND) to search for data that meets all the field-level search requirements that you specify. Select Any Fields (OR) to search for data that meets any one of the field-level search requirements.

This setting applies only to the field-level search criteria that you enter in the Additional Search Information group box, not to any record-level search criteria.

Search

Click to perform the search. The system searches the specified record for data that meets search criteria and then displays the matching rows of data in the search results grid.

Search Tips

Click to view tips for constructing keyword searches. For example, the search tips provide information on the use of and and or in searches and on searching for entire phrases.

Additional Search Information

This group box lists the fields in the record's search index so that you can enter field-specific search criteria.

Field

If there are multiple labels defined for a field, the default label appears.

Operator

Select one of the following search operators: <, <=, <>, =, >, >=, BETWEEN, CONTAINS, ENDS, IN, LIKE, STARTS, or SUBSTRING.

Search Text

Enter the search criteria for the field.

Search Results

The following page elements appear regardless of the search record.

Click the Details button to display a page with more information about an entry in the Search Results grid.

Score

Displays a rating between 1 and 100 that represents how closely the entry matches search criteria.

All other columns in the Search Results group box vary depending on the record that you searched and how you defined the search index template for that record. (On the Search Index Template page, select the Search Results check box to identify the fields that are to appear in the search results grid.) The columns display the data found by the search.