Re: Crawling Custom Metadata Using SPS 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: rdcpro (rdcpro_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 12:15:06 -0800

I have not yet been able to get anything but strings back from the query.
CAST does not work in the WHERE clause, though it does work in the SELECT
clause.

I am still working with my PSS engineer on this, but the 2003 Platform SDK
was supposed to provide a sample dll called htmlprop.dll that you use to
override the nlhtml.dll filter that SPS uses by default. It contains a
number of methods to handle various date-time formats, but it's very
difficult to get the SDK to compile. You have to make sure you don't have
multiple include paths, but even after hacking up the makefile extensively,
the resulting dll seems to be missing the entry point, and regsvr32 fails.
Anyway, I've tried a December 2000 version of the DLL, and I'm still unable
to use anything other than strings in the WHERE clause. Installing this DLL
is tricky, too, but in the end I was able to get the mssearch.exe process to
load the dll.

If PSS comes up with something, I'll post my solution. Frankly I find it
very frustrating that I can't even do a simple integer comparison on HTML
meta data.

Regards,
Mike Sharp

"Niklas E" wrote:

> Is it possible to set type="dateTime" to be able to use it as dateTime?
>
> I too have trouble searching pages with my customexpirydate metatag and
> compare it in the where clause to find the old pages.
>
> Any solutions to be able to use "where MyMetaTagWhichIsADate < date" in the
> search.asmx?
>
> Best regards
> Niklas E
>
>
> "rdcpro" <rdcpro@discussions.microsoft.com> wrote in message
> news:14419F42-31A2-4357-B79B-BAB7A64E475F@microsoft.com...
> > Hi Bill,
> >
> > I've been running into a real problem in this area (specifically with
> > integers and dates), but I'll share what I have.
> >
> > First you have to install the CMS Content Connector for Sharepoint on the
> > Portal Server. Among other things, this provides an XML document you can
> use
> > to define your custom properties. The document is called
> > SearchPropertyCollection.xml, and you add new PropertyDefinition elements
> for
> > each custom property you want to index. For example, this adds a custom
> > metatag to the index:
> >
> > <PropertyDefinition
> > uri="urn:schemas.microsoft.com:htmlinfo:metainfo:POSTINGTYPE"
> > type="string"
> > name="CMSPOSTINGTYPE"
> > indexable="1"
> > retrievable="1" />
> >
> > Once you've updated the file, you need to run SearchPropertiesSetup.exe.
> > For example:
> >
> > C:\Program Files\MCMS Connector for SharePoint
> > Technologies\WSS\Bin>SearchProper
> > tiesSetup.exe -file "C:\Download\Sharepoint
> > Stuff\MCMSContentConnector\WssIntegr
> > ation\SearchPropertyCollection.xml" -portalurl "http://DevVsMichaels01"
> >
> > Ok, now you can re-crawl your content, and then you'll see those custom
> > properties in your SPS "Manage properties for crawled documents" page, and
> > you can now search them. For example, a query with a where clause like:
> >
> > where (Contains("urn:schemas.microsoft.com:htmlinfo:metainfo:POSTINGTYPE",
> > '"Grant"')
> >
> > turns up documents that have the meta tag:
> >
> > <META NAME="PostingType" CONTENT="Grant">
> >
> > The bad news is that it seems like all custom properties can only be
> strings
> > (even though there's an attribute to set the type). If you try a CAST in
> > your query, you can change a string to a date, for example, but not within
> > the where clause -- it causes an internal server error. I have a PSS case
> > open on this, and I'm hoping there's a hotfix.
> >
> > Regards,
> > Mike Sharp
> >
> > "Bill" wrote:
> >
> > > Hi,
> > >
> > > I have read document about "Crawling Custom Metadata using SharePoint
> > > Portal Server 2001"
> (http://www.microsoft.com/sharepoint/server/techinfo/development/metadata.as
> p)
> > >
> > > However I cannot find "document profile" SPS 2003. How can I crawl
> > > custome metadata in SPS 2003?
> > >
> > > Regards,
> > > Bill Ng
> > >
>
>
>

Relevant Pages

  • Re: passing a string to a dll
    ... bool DLLRect::PullWhisker ... The interface for the DLL exported function could be like so: ... based on _UNICODE flag, e.g. ... I think that in these days those ANSI strings are something from the ...
    (microsoft.public.vc.mfc)
  • Re: D6 and COM
    ... descriptions of the IDL, right? ... Dolphin discovered in the DLL are not? ... Unicode strings. ...
    (comp.lang.smalltalk.dolphin)
  • Returning pointer to array of char* from DLL
    ... typedef NameType char; ... Memory space for the strings is allocated by the DLL, ... static public extern int ReadList(int db, out IntPtr names, ref int count); ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Using strings in a case construct
    ... that clause are evaluated as an implicit progn, ... So properly I need to do something special to use strings. ...
    (comp.lang.lisp)
  • Re: Using strings in a case construct
    ... "If the test-key is the SAME as any key for that clause, ... So properly I need to do something special to use strings. ...
    (comp.lang.lisp)