Modify Local Fuzzy Database properties
Once a Local Fuzzy Database is added, its properties can be modified by following these steps:.
-
On the
Project tab, in the
Configuration group, select
Project Settings
.
- Click the Databases tab to view the databases settings.
-
In the list of databases, select the database to be modified and click
Properties.
The Local Fuzzy Database Properties window is displayed.
-
On the
Local Fuzzy Database Properties window, set the following options.
-
Select where the
Referenced import file (text or csv file) is located, either
File system or
Web.
Depending on your selection, do one of the following.
Selection
Action
Web
Click Browse URL and type in the desired web address.
If the selected file is protected, select Yes and provide a User Name and Password.
Click Test to ensure that the URL is available.
A copy of the source database file is imported into the file system hierarchy for the project and a list of column is displayed in the Column Configuration group.
File system
Click Browse and navigate to the required .txt or .csv file.
A copy of the source database file is imported into the file system hierarchy for the project and a list of column is displayed in the Column Configuration group.
- In the Column Configuration group, for each column select Search and/or Filter to determine the column behavior during the fuzzy search.
-
Optionally, in the
Column Configuration group, it is possible to rename a column name by first selecting its row
and then clicking on the column name. Press Enter to save the change.
After renaming a column, the preview below is updated automatically.
-
In the
Import Options group, configure the following options as needed.
Option
Behavior
Ignore case
Select this option if case does not matter in your database. This means that all strings are converted to lower case automatically when a search is performed. This option does not apply to filtering.
Filtering is case sensitive
This option is available when one or more fields in the Column Configuration table have the Filter option selected.
Select this option in case you want the filtering value entered into the script to match the entries in the database exactly.
First line contains caption
Select this option if your Local Fuzzy Database contains the column header names.
Field delimiter
Enter the field delimiter character that separates entry fields in your database source file. The value for this option is set to ; by default.
Optionally, select Tab to use the Tab character as an additional field delimiter.
Word separation characters
If your database contains compound words, enter the characters that separate compound words. The value for this option is set to -, by default.
Optionally, select Tab and Space to use these characters to also separate words.
Characters to ignore
Enter the characters to be ignored. These characters are excluded from the database fields during import, and from the search text before processing. The value for this option is set to ."'! by default.
Optionally, select Space as an additional character to ignore.
- Optionally, add, delete, modify, or import string substitutions in the String Substitution group.
-
In the
Optimization group, configure the following options as needed.
Option
Behavior
Automatic update from import file
Select to update the database automatically when the source file changes. The automatic update occurs when the project gets loaded. This option is cleared by default.
Load database in memory
Select to keep the fuzzy database in memory that helps process the fuzzy search more efficiently. Clearing this field reduces the memory usage but also significantly slows fuzzy searches. This option is selected by default.
If this option is cleared, the Filter option in the Column Configuration group is no longer available.
Database processing
Select the quality of database processing to optimize your database searches.
If this is set to Basic, the Filter option in the Column Configuration group is no longer available. The `Basic option also uses an older algorithm that delivers results with less precision. especially for large databases. However, the speed of processing smaller databases may be quicker when using this option.
-
Select where the
Referenced import file (text or csv file) is located, either
File system or
Web.
- Click OK to save your changes.
- Optionally, click OK to close the Project Settings window.
- Save the changes to your project.