Solved

Search using Microsoft Indexing Server does not return titles

Posted on 2009-07-10
14
368 Views
Last Modified: 2012-05-07
Hi all,
We are using Microsoft Indexing Server for our website search. The query we are using brings back the results we want with the exception that most of them are missing the title(doctitle). I noticed that the few search results that do show the title are pdfs only, but not all pdfs searched include the title.  What could we be missing?
Also, is there a easier way to exclude file types instead of having to filter out the results through the query using "filename not like '%.cs' and filename not like '%.config'"??

Thanks in advance.
System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection("Provider=\"MSIDXS\";Data Source=\"TEST\";");
        System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
        cmdSearch.Connection = odbSearch;
 
        string searchText = txtSearch.Text.Replace("'", "''");
        cmdSearch.CommandText = "select doctitle, filename, vpath, rank, characterization from scope() where FREETEXT(Contents, '" + searchText + "') and filename not like '%.master' and filename not like '%.cs' and filename not like '%.config' order by rank desc ";
 
        odbSearch.Open();
 
        try
        {
            OleDbDataReader rdrSearch = cmdSearch.ExecuteReader();
            while (rdrSearch.Read())
            {
                getpagelink(rdrSearch["DOCTITLE"].ToString(), rdrSearch["VPATH"].ToString(), rdrSearch["CHARACTERIZATION"].ToString());
                //getpagelink(rdrSearch[0].ToString(), rdrSearch[2].ToString(), rdrSearch[4].ToString());
            }
 
        }

Open in new window

0
Comment
Question by:UKSystemSupport
[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
  • 6
  • 3
14 Comments
 
LVL 12

Expert Comment

by:topdog770
ID: 24864985
Do the documents missing titles, really have titles?
 
0
 

Author Comment

by:UKSystemSupport
ID: 24871136
I am able to update each documents' (such as pdfs, word docs, excel, etc) title property so that they display properly. However, webpages (ASPX, HTML, etc) title  does not show up. Each page has its title property/tag setup in the code, but the search does not pick it up.
0
 

Author Comment

by:UKSystemSupport
ID: 24934331
Can someone please help me with this?? We are planning on launching our site ASAP and this is the last piece we have left to get working....
Any suggestions will be appreciated

Thanks
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:UKSystemSupport
ID: 25036121
The question was posted almost a month ago and we have recieved very little help (only 1 comment ! ). We need an answer to this, it is important so that our site works properly. There has to be some expert(s) that could give us a lead or an idea on why all our .ASPX webpages won't display their title. If this question is deleted I will be forced to open a new question for my unresolved issue.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 25038154
found this: http://articles.techrepublic.com.com/5100-10878_11-1049760.html
DocTitle:
The document titlefor HTML documents, it is the text contained in the <TITLE> tag

so, do your .aspx web pages contain that tag?
if yes, did they so from the first index search on? I am not sure the indexing service does an update ...
0
 

Author Comment

by:UKSystemSupport
ID: 25046546
Our .aspx pages do not have a <title> tag since they all reference a master page. What they do have is the title property defined within the <page> tag, but the search does not pick it up.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 25046727
well, according to the above, that is the reason, then...
0
 

Author Comment

by:UKSystemSupport
ID: 25062950
Is there any workaround?? Or another way I could query the <%@ Page Title="page title"%> property?? Or maybe even the files' title property?
If so, that would work for us instead of getting blank search titles for the doctitle...
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 25062996
>Is there any workaround??
not that I know (of course, short of writing your own indexing service ...)
0
 

Accepted Solution

by:
UKSystemSupport earned 0 total points
ID: 25068180
I solved my dilemma by using the filename as the title in those cases where doctitle wasnt being generated. Along with some formatting we managed to make this our 'workaround' for now.

Thanks angelllll for your help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

737 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