Indexing Word Custom Document Properties

[y***@googlemail.com]

I'm trying to index a custom document property setup in Word, but
without sucess.

The custom document property is called "Reviewdate" and is defined as a
"Date" in word.

In the index server reviewdate has been setup to be cached as type
"VT_Date". The index server has been stopped and restarted with a full
rescan requested on all the documents.

I'm then using ASP to query the database and have added the line:

Q.DefineColumn "ReviewDate (VT_FILETIME) =
d5cdd505-2e9c-101b-9397-08002b2cf9ae reviewdate"

However, I can't search on reviewdate and I can't write out the value
either (I just get a blank).

I have tried changing VT_FILETIME above to DBTYPE_DATE but that didn't
make any difference.

I do know the document is being indexed because the the ASP code can
find the document if I search on the document's text (rather than
searching on ReviewDate).

Does anybody have any ideas as to what I'm doing wrong?

[Zach Nelson]

Post by y***@googlemail.com
I'm trying to index a custom document property setup in Word, but
without sucess.
The custom document property is called "Reviewdate" and is defined as a
"Date" in word.
In the index server reviewdate has been setup to be cached as type
"VT_Date". The index server has been stopped and restarted with a full
rescan requested on all the documents.
Q.DefineColumn "ReviewDate (VT_FILETIME) =
d5cdd505-2e9c-101b-9397-08002b2cf9ae reviewdate"
However, I can't search on reviewdate and I can't write out the value
either (I just get a blank).
I have tried changing VT_FILETIME above to DBTYPE_DATE but that didn't
make any difference.
I do know the document is being indexed because the the ASP code can
find the document if I search on the document's text (rather than
searching on ReviewDate).
Does anybody have any ideas as to what I'm doing wrong?

I'm having a similar problem with date ranges. I have custom meta
properties for publish and expiration dates and I'm trying to limit the
results on documents with dates that fall between those.

My html props look like this:

<o:publishdate-html dt:dt="string">2006-01-01
12:00:00</o:publishdate-html>
<o:expirationdate-html dt:dt="string">2006-12-12
12:00:00</o:expirationdate-html>

They are set to cache as VT_FILETIME

My query looks like this:

({prop name=roleids-html}0 or 32{/prop}) and ({prop
name=keywords-html}keyword{/prop}) and ({prop name=publishdate-html} >
'2005/10/1 12:00:00'{/prop} and {prop name=expirationdate-html} <
'2007/10/1 12:00:00'{/prop})

I'm running out of ideas here. Thanks for your help!

[Hilary Cotter]

use filtdump to see how the date is being emitted by the iFilter.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Post by y***@googlemail.com
I'm trying to index a custom document property setup in Word, but
without sucess.
The custom document property is called "Reviewdate" and is defined as a
"Date" in word.
In the index server reviewdate has been setup to be cached as type
"VT_Date". The index server has been stopped and restarted with a full
rescan requested on all the documents.
Q.DefineColumn "ReviewDate (VT_FILETIME) =
d5cdd505-2e9c-101b-9397-08002b2cf9ae reviewdate"
However, I can't search on reviewdate and I can't write out the value
either (I just get a blank).
I have tried changing VT_FILETIME above to DBTYPE_DATE but that didn't
make any difference.
I do know the document is being indexed because the the ASP code can
find the document if I search on the document's text (rather than
searching on ReviewDate).
Does anybody have any ideas as to what I'm doing wrong?

[Zach Nelson]

Hi Hilary,

I can't find the Indexing Service SDK anywhere.. is it still available?

Regards,

Zach

[Zach Nelson]

For future reference, the Indexing Service SDK is part of the Platform
SDK, available here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/psdktoolsanchor.asp