Using the Full Text Search

In Citavi for DBServer it's possible to add a full text search feature to the SQL Server. This feature can be used with Citavi to index attached files either in the Attachments folder or those saved locally similar to how an online search engine would do it. As a result searching across thousands of attached files is very fast.

By default Citavi indexes PDF and EPub files. For other file types, it depends on which iFilters are available on the client computers (not on the server). Ideally, the same iFilters will be installed and enabled on all client computers. To view iFilters, click Control Panel > Indexing Options > Advanced > File Types.  

As long as Office is installed, the iFilters for the corresponding file types (for example, .docx and .pptx) will also be installed.

In Citavi DBServer Manager check under Actions > Database > Configure full text search if the SQL Server full text search is already installed or not. If you see the notification The full text search is not installed on the SQL server, enable or install the feature.

Please note:

If you used the Citavi program "SQL Server Express for Citavi Setup" and if you're using Microsoft SQL Server Express version 2016 or later, the SQL Server Full Text search is already installed and enabled. If not, please follow the steps below according to your MS SQL server version.

Enabling the SQL Server Full Text Search

If your Microsoft SQL Server is installed with Advanced Services, open the SQL Server installation center and follow the steps under Install Microsoft SQL Server Express with Advanced Services starting from step 6.

Installing the SQL Server Full Text Search

Install Microsoft SQL Server Express with advanced services

  1. Log in to Windows using a domain account with administrator rights.
    Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.
  2. Download the appropriate Setup from the Microsoft website.
  3. Select the appropriate advanced Setup file, for example ExpressAdv 64-bit\SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.
  4. Extract the Setup file by double-clicking the .exe file you just downloaded. The Setup asks you to select a folder for the extracted files. Usually you will use the Setup program to create a folder in the same folder you saved the Setup file in that has the same name as the Setup program, for example SQLEXPRADV_x64_ENU.
  5. After some time the SQL Server Installation center finishes the extraction and opens automatically.
  6. Under Installation, click New SQL Server stand-alone installation or Add features to an existing installation.
  7. Select Add features to an existing instance of SQL Server and then select the instance from the drop-down menu, for example CITAVISERVER. Click Next.
  8. In the next step you will see an overview of the available features. Under Instance Features select the Full-Text and Semantic Extractions for Search checkbox and then click Next.
  9. Continue through the rest of the installation.