Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 6.x > Portal Engine > Smart Search cannot find numbers???

View modes:

Member

peter.postma-kiwa - 10/16/2012 8:38:57 AM

Smart Search cannot find numbers???

Hello,

I am using the Smart search results with full text search option. This works fine, except for one important thing. Smart Search seems to ignore numbers.

The website contains pdf reports. These reports have a so called report number. This number is in the filename of the document as well as in the document itself. Still Smart Search does not find the document if I search with this number. When I use a word that is in the filename or title, Smart Search will find it.

For example, I have a file with the following filename:
"Example report with reportnr 123456.pdf"

When I search on "Example" the document is found. But when I search on "123456" the document is not found.

Is there a solution for this problem? The normal SQL search has no problem with finding based on numbers, but I like to use Smart Search.
-

Member

peter.postma-kiwa - 10/17/2012 3:53:13 AM

RE:Smart Search cannot find numbers???

Oké, I have found the solution. Smart Search uses the index function from MS SQL Server for full text search. Microsoft tries to make this smart by excluding certain words. You can find these words in txt files, the so called noise pages. These files contain also numbers. In other words: numbers are excluded in the Full Text Search index. You can modify this by removing the numbers from these files and then rebuild the index. Here is what I did (MS SQL Server 2005 Express):

- Go to the MS SQL Server database directory and find the directory FTData
- In this directory you will find the noise files: text files where the name starts with noise and then some language indication. For instance noiseENG.txt.
- Make a backup of the noise file.
- Open the noise file with a texteditor and remove the numbers (or any other words you do not want to exclude).
- Stop and restart the SQL Server FullText Search service: I used SQL Server Configuration Manager.
- In Kentico: rebuild your Smart Search index.

This did the trick for me.

Kentico Customer Success

kentico_martind2 - 10/17/2012 5:55:32 AM

RE:Smart Search cannot find numbers???

Hi Peter,

excellent solution! You will probably save a lot of time for some other Kentico users in the future.

I have found also great articles related to the noise words in SQL Sever:
1. Noise Words files and their respective languages
2. SQL Server Full Text Search Noise Words and Thesaurus Configurations

Best regards,
Martin Danko

Top