Welcome > Use Project Builder > Manage databases > Associative Search Databases > Add an Associative Search Database

Add an Associative Search Database

You can add an Associative Search database 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 Databases group, click Add. The Add New Database window is displayed.
  4. In the Database Name field, type a descriptive name for the new fuzzy database.
  5. On the Database Type list, select the Associative Search Database type.
  6. Click OK. The Properties of Associative Search Database window is displayed.
  7. Select a CSV file by browsing to its location.

    The Column name and Search details are loaded into the Column Configuration table.

  8. Optionally, select the First line contains captions if the first line of your chosen CSV file is a column header.
  9. Optionally, if your chosen CSV file is updated regularly, select the Automatic update from import file option.
  10. Update the Column Configuration table as needed. Clear the Search column for any fields that you do not want to include in your search.
  11. In the Column used as record identifier list, select which database column to use as the record identifier.
  12. Click OK to save the Associative Search Database.

    The properties window is closed and the new Associative Search Database is displayed in the list of databases in the Databases group.

  13. Optionally, click OK to close the Project Settings window.
  14. Save the changes to your project.