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.