Welcome > Use the Transformation Designer > 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 properties in any order:
    1. Select where the Referenced import file (text or csv file) is located, either Filesystem or Web.
    2. If you selected Filesystem, 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.

    3. If you selected Web, click Browse URL and type in the desired web address.
    4. Optionally, select Yes for the Use Authentication if the specified file is protected and provide a User Name and Password.

      A copy of the source database file is imported into the file system hierarchy for the project.

    5. Click Test to ensure that the URL is available.
    6. Optionally, if case does not matter, select the Ignore case option in the Import Options group.
      All strings are automatically converted to lower case when a search is performed and case is ignored when this option is selected.
    7. Optionally, if the first record entry in the Local Fuzzy Database contains the column header names, select the First line contains caption option in the Import Options group.
    8. Type the field delimiter character that separates entry fields into the Field delimiter option in the Import Options group.
    9. Type the characters that separate compound words in an entry field into the Word separation characters option in the Import Options group.
    10. Type a list of characters to be ignored and excluded when a database entry or field value is returned into the Characters to ignore option in the Import Options group.
    11. Optionally, add, delete, modify, or import string substitutions in the String Substitution group.
    12. Optionally, to update the imported copy of the database automatically when the source database is modified, select the Automatic update from import file option.
    13. Optionally, if you want to store the Local Fuzzy Database in memory, select the Load database in memory option.
    14. Optionally, select the Database processing level to optimize your database searches.
    15. If any of the fields are not present on a document, right-click a database field header in the Field Names group, and select Not present on document.
  5. Click OK to save your changes.
  6. Optionally, click OK to close the Project Settings window.
  7. Save the changes to your project.