Welcome > Use Project Builder > Manage databases > Fuzzy databases > Modify Local Fuzzy Database properties

Modify Local Fuzzy Database properties

Once a Local Fuzzy Database is added, its properties can be modified by following these steps:.

  1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
  2. Click the Databases tab to view the databases settings.
  3. In the list of databases, select the database to be modified and click Properties.

    The Local Fuzzy Database Properties window is displayed.

  4. On the Local Fuzzy Database Properties window, set the following options.
    1. 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.

    2. In the Column Configuration group, for each column select Search and/or Filter to determine the column behavior during the fuzzy search.
    3. 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.

    4. 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.

    1. Optionally, add, delete, modify, or import string substitutions in the String Substitution group.
    2. 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.

  5. Click OK to save your changes.
  6. Optionally, click OK to close the Project Settings window.
  7. Save the changes to your project.