Full-Text Indexing questions...
-
Hello all,
First of all, very nice forum! This is my first time here and I like what I see, looks like this will be a good resource.
On with my question (and I hope this is the right forum to post it)...can SQL Server full-text index the contents of a Microsoft Publisher (.pub) file, or a web archive (.mht) file? We're currently in the process of implementing SharePoint Portal Server 2003, along with Windows SharePoint Services. The table that holds the information about all the documents (one row for each document) stored on SPS and WSS, has many columns, one of which happens to be an image column that contains the content of the document, thus, this column is full-text indexed. I'm having success in searching for text within documents of most file types in SQL Server, but I haven't had any luck searching for the content within .pub or .mht files using the CONTAINS() or FREETEXT() commands. Is searching for these file types not possible?
Thanks in advance for any help anyone can provide, would be much appreciated!
Tim
-
This was removed by the editor as SPAM
-
I think the word you're looking for is IFilter, we currently make use of various different ones to allow us to search documents (PDF, DWG, PLT, ZIP to name but a few) but to be honest i've never seen a publisher one.
Now that you know what you're looking for it may be slightly easier to search.
-
Yes I was aware that they are Ifilters...I actually did end up finding a few and installed one for Web archive files. Here's the site I found with a short list of ifilters... http://www.citeknet.com/
I've only tried the Web archive filter as of now, but if anyone is looking for information, happy downloading!
Tim
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply