Kentico CMS 7.0 Developer's Guide

Overview

Overview

Previous topic Next topic Mail us feedback on this topic!  

Overview

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

Kentico CMS allows you to search the content of files (document attachments) uploaded into the database. The attachment search uses the standard Microsoft SQL Server full-text search engine, which supports a wide variety of files. The search is available for all supported versions of SQL Server:

 

SQL Server 2005

SQL Server 2008

SQL Server 2008 R2

SQL Server 2012

 

Prerequisites

 

Full-text search support must be installed on your SQL Server. The full-text search is available for all supported editions of Microsoft SQL Server, including the Express Edition with Advanced Services.

 

Your Kentico CMS website must be configured for storing files in the database (Site Manager -> Settings -> System -> Files -> Store files in database).

 

devguide_clip1138

 

Use one of the following guides to configure your installation of Kentico CMS for search in files:

 

Manually configuring full-text search on MSSQL Server

Enabling full-text search on MSSQL Server (Script)

 

 

InfoBox_Information

 

Supported file types

 

The standard full-text search engine delivered with Microsoft SQL Server can search TXT, HTML, DOC, XLS and PPT files.

 

To search in PDF files, install a free driver from Adobe: Searching PDF files

To search Microsoft Office Open XML documents, such as DOCX or XLSX, install a free IFilter pack: Searching Microsoft Office documents

 

If you want to search other types of documents, you need to install appropriate IFilter libraries. You can download or purchase IFilter libraries from third-party vendors.