Problems with META TAG PROPERTY MAPPINGS

Question

Hello,

 

I'm search after a solution how to display the keywords of a searched web site via XML search query. I mean the keywords in the meta tag of my html web site:

 

<meta name="keywords" content="myKeywords" >

 

When putting 'keyWords' in the SQL select query I got NO results, that means the 'keywords' column is always empty!

 

So what is the problem?!

 

Thanks for reply!!

 

Regards from Germany,

Steven***

 

 

Answer 1

Did you created a custom managed property for Keywords?

Answer 2

Going in the Search Server Administration under 'Metadata Properies' there are still two properties:

- Keywords

- DocKeywords

 

Inserting them into my SQL query only a 'keywords' column appears, but it is always empty!

 

Do I have to create a custom managed property?! And how do I fill it with my HTML Keywords from the web site (NOT sharepoint site)?!

 

Thanks for reply!

 

Steven***

Answer 3

Going in the 'Metadata properties', mapping 'Office:5(Text)' to property 'Keywords' and editing crawled property 'Office:5(Text)' so that values for this property will be included in the search index will result that my set keywords will be found!

 

However, the column 'Keywords' disappears in my result table after these settings. Why?!

 

And where can I find a description what hides behind the crawled properties like 'Office:5(Text)' and so on. I only discovered by chance!

 

So thanks for reply...

 

Steven***

Answer 4

 

Well, I'm always asking the same question as you do. It's quite hard to get those people to tell you the truth...

Answer 5

Hello,

 

as already mentioned above I have found out that when searching a HTML site and wanting to get the metatag 'keywords' I have to add a mapping to Office:5(Text) (as it is already in the attribute docKeywords).

 

Now I want to crawl and search after the html metatag page-type. Unfortunately I can't find any information what attribute I have to map. I have tried all Office:XX attribute, but no success...

 

Is there anyone that can give me some infos about these attributes like Office:3(Text) or Web:5(Text). A very strange thing is that there are some attributes duplicated... Why can I find 3 Office:3(Text) and other duplicates? That makes no sence...

 

By the way, I'm using WSS with Search Server Express, not a MOSS system...

 

Does anyone other have same problems?!

 

Thanks for reply!

 

Steven***

Answer 6

since you've mapped and full crawl, you have to use Keywords or DocKeywords in your sql statement, depends on which managed properties you've mapped. 

for example:
select  title, path, fileextension,  HitHighlightedSummary, DocKeywords , created , enddate, FileName, size, rank, author, write, sitename 
from scope()
where freetext('testing')  
and sitename = 'http://mytestingsite'
and (fileextension = 'HTML' or fileextension = 'HTM' or fileextension = 'ASP' or fileextension = 'DOC' or fileextension = 'XLS' or fileextension = 'PDF'  )
order by rank desc