Add a Local Fuzzy Database
In order to use a Local Fuzzy Database in a locator or in a script, it first needs to be added to the project. Before adding a Local Fuzzy Database to your project, ensure that the .CSV or .TXT file is formatted correctly.
You can add a Local Fuzzy Database 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 Databases group, click Add. The Add New Database window is displayed.
- In the Database Name field, type a descriptive name for the new fuzzy database.
- On the Database Type list, select the Local Fuzzy Database type.
- Click OK. The Local Fuzzy Database Properties window is displayed.
-
On the
Local Fuzzy Database Properties window, set
the following properties in any order:
- Select where the Referenced import file (text or csv file) is located, either Filesystem or Web.
-
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.
- If you selected Web, click Browse URL and type in the desired web address.
-
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.
- Click Test to ensure that the URL is available.
-
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.
- 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.
- Type the field delimiter character that separates entry fields into the Field delimiter option in the Import Options group.
- Type the characters that separate compound words in an entry field into the Word separation characters option in the Import Options group.
- 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.
- Optionally, add, delete, modify, or import string substitutions in the String Substitution group.
- Optionally, to update the imported copy of the database automatically when the source database is modified, select the Automatic update from import file option.
- Optionally, if you want to store the Local Fuzzy Database in memory, select the Load database in memory option.
- Optionally, select the Database processing level to optimize your database searches.
- 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.
-
Click
OK to save the Local
Fuzzy Database.
The properties window is closed and the new Local Fuzzy Database is displayed in the list of databases in the Databases group.
- Optionally, click OK to close the Project Settings window.
- Save the changes to your project.