Friday, January 13, 2017

How to setup Synonymous based search in SharePoint 2013



How to setup Synonymous based search in SharePoint 2013
Scenario
Currently we have achieved synonyms based search query and got relevant search results in SharePoint 2013
Ex. if I search for Vacation, Day Off, Holidays, Shutdown, as a keyword in SharePoint Enterprise search, Holidays.xlsx file need to show in the search result.
Solution
We have to use a thesaurus file to specify synonyms for a single word or multiple words that occur in queries. The query is expanded based on the entries in the thesaurus. We have to create and maintain the thesaurus file in a system external to SharePoint 2013 before we import it into SharePoint 2013 to make the synonyms available to the search system.
Note : We can deploy only one treasure in a single SharePoint farm
Format : csv file
Csv file format
Key,Synonym,Language
Holidays, Vacation,en
Holidays, Day Off,en
Holidays, Shutdown,en
Holidays, Ferien,de
Holidays, Freier Tag,de
Holidays, Herunterfahren,de

How to import csv to SharePoint Farm using Powershell
$searchApp = Get-SPEnterpriseSearchServiceApplication 
Import-SPEnterpriseSearchThesaurus -SearchApplication $searchApp -Filename <Path>