Properties of Associative Search Database window

Use this window to configure an Associative Search Database. This window has the following properties:

Import Source

This group has the following settings:

Import from a semicolon-separated CSV file

Browse to and select a CSV file.

First line contains captions

Select this setting if the first record of the input file contains the column headers. (Default: Selected)

Automatic update from import file

Select this setting to update the Associative Search Database when the source file is updated. (Default: Cleared)

If this setting is selected, the database is updated when Server runs during production.

This automatic update feature is not supported by Azure.

Field Configuration

The table lists the following columns:Field Name, Search, and Filter columns for the selected CSV file. Selecting the Search value for a record includes that field in the search. Selecting the Filter value makes that field available for filtering via script.

• Field Name.

• Search.

  If this value is selected for a field, it is used in the search.

• Filter.

  If this value is selected for a field, it is possible to filter the data before searching to reduce the number of possible records. The application of filtering is possible only using scripting.

This menu has the following setting:

Column used as record identifier

Select a column from the list to be used to help identify the records. This column must contain a unique alpha-numeric identifier for each record. The first column of the database is selected by default.

The following buttons are available at the bottom of this window:

Button	Description
OK	Closes the window and saves your changes.
Cancel	Closes the window without saving your changes.
Help	Displays the help for the open window.

Related topics:

• Databases tab - Project Settings window

• Manage databases

• Add an Associative Search Database