Solved

INDEX SERVER SEARCH ON MULTI DOC TYPES

Posted on 2003-11-14
1
203 Views
Last Modified: 2012-06-27
I need to create an index search for a site that will return everything in the site directory.

This means indexing all types of documents and all asp and htm(l) files (i'll also need to access data in a SQL DB but can handle this on a separate search if not possible with index searching.)

I have created a search for a specific folder containing ONLY .pdf docs that works OK but need advice on how to extend this to the rest of the site.
0
Comment
Question by:jfriel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
subtext101 earned 150 total points
ID: 9749011
If you're using ADO to do the query, then the answer will be in the select statement, which might be along the lines of:

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write FROM SCOPE()
WHERE CONTAINS(Contents, 'SomeKeyword AND SomeOtherKeyword')
ORDER BY RANK DESC

The key thing's "Scope()" which should give you results from the whole catalogue.  In the Index Server MMC, you want to make sure that the catalog is set to track files from a specified virtual server, rather than explicitly adding a directory.  You may also want to check the boxes that say something like Index Files with Unknown Extensions.

In practice, you don't really want every file - especially if there are frontpage extensions on the website.  You can be more specific with the query, e.g.

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write
FROM SCOPE('"D:\Somefolder\Webfolder"') WHERE
NOT CONTAINS(VPath, '"_vti" OR ".xml"') AND
(CONTAINS (Contents, 'SomeKeyword AND SomeOtherKeyword') OR " & _
CONTAINS (DocKeywords, 'Contents, 'SomeKeyword AND SomeOtherKeyword') OR      
CONTAINS (DocSubject, 'SomeKeyword AND SomeOtherKeyword') OR        
CONTAINS (DocTitle, 'SomeKeyword AND SomeOtherKeyword'))
ORDER BY RANK DESC

If a catalog's not returning the correct results then it more often than not seems to be the catalog configuration which is screwy.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBSCRIPT string remove all characters to the right after extension 4 72
Questions about INCLUDE FILES 2 43
Diminish Pop-up  in 3 seconds 7 70
Validating Date Part2 2 28
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question