john kane

Sander,
1. Yes, you should run a Full Population. While a Full Population will
depending upon the total number of rows in your FT enable tables, it is
necessary for it to re-index all of your table's data.

2. Could you define what you mean by "attributes in our XML's"? Perhaps an
example of the data and a SQL FTS query with expected results?

Thanks,
John

john kane

You're welcome, Sander,
Yes, you MUST store the XML data in an IMAGE column with the correct value
(xml) in the row's column for the file extension!!
The SharePoint Portal Server (SPPS) XML IFilter is called by the MSSearch
daemon based upon the file extension column (xml in this case) and if the
XML is stored in a char/varchar or TEXT/NTEXT column then it is FT Indexed
as normal text. This and other 3rd party IFilters, such as Adobe's PDF
IFilter ONLY work with SQL Server 2000 when storing the text/file in an
IMAGE column with the correct associated file extension value in the column.

FYI, you might also want to checkout Quilogic's XML IFiter at
http://www.quilogic.cc/ifilter.htm

Regards,
John

hilary cotter

The XML iFilter will index
* values of sub-elements of the root element when
the sub elements have no child elements.
* attributes of the root element and attributes of
sub-elements of the root element
Consider a sample XML do***ent:
<?xml version="1.0" ?>
<book title="MyBook">
This a sample book
<author>
First Last
<AGE>
20
</AGE>
</author>
<ISBN>
11111111111
</ISBN>
</book>
The attribute Title of the element Book, and ISBN would be
the only values that would be indexed and query able in
this case.

HTH


on WK2

does not index my

mean 1 day of


too short)? We use a

Is there a way to

sander

i found that my attributes are indexed, but only one xml level deep. So
attributes of sub elements of the root element are indexed, but any level
deeper and mssearch does not index the attributes any more.
ps I do not need any property mappings, i just want mssearch to index my
attibute values and my element values, as were they text.

Sander