SHAREPOINTSearch.com

hello there. anyone able to give someone in desparate need a little assistance?  :)  thanks!

I have been struggling with trying to get a FirstName Field from a custom list/scope to be displayed on my search results page. We set up Ontolica Wild Card Search on a client's server and the only Mapped Property not displaying is First Name.

I think i have everything set up correctly but since I'm pretty new to all of this I may not.  However, other properties that I set up appear as long as there is data for those fields.

I have a

I am using athe people style gallery, and slightly modified it.  I have Department, Fax, Mobile, email, job title,   all displaying correctly.  Lastname (TITLE) also displays ok but it's weird since it is NOT a Searchable Property.  Is Title just standard?  why doesn't firstname show up?

i'm starting to work in circles so any help is appreciated very much!

Hi.

So I am assuming you already went into the tab properties configuration and added FirstName to the the default property group. Correct.

Change the search results style sheet to the xmloutput one so you can see if at least it is getting returned. To do this run a search (so that you are on the defaultresults.aspx page) edit the page and edit the search results webpart.

Let me know if it shows up there.

hey thanks again. appreciate the pointers!  below is the raw xml output for a search on one person returning one result.  I did check the mapped properties for FirstName and I see it saying 1000+ results

also FirstName is in the Default Property group for search and search results.  BTW, how come the lastname/TITLE field works and is NOT in the default property group?   

<Results group="OSR">
<LayoutTableStyles>margin-top:10px;width:100%</LayoutTableStyles>
<BaseUrl>/OntolicaSearchCenter/</BaseUrl>
<Target>_self</Target>
<DefaultImage>/_layouts/images/no_pic.gif</DefaultImage>
<ImageStyles>height:75px;</ImageStyles>
<SearchExpression>John Doe</SearchExpression>
<SearchScope>Search Employees</SearchScope>
<Offset>0</Offset>
<Count>1</Count>
<Hits>1</Hits>
<Result id="OSR_1" row="1">
<Columns>
  <Column id="WorkId">14186</Column>
  <Column id="Rank">1000</Column>
  <Column id="Title">Doe</Column>
  <Column id="Author">JDoe</Column>
  <Column id="Editor"></Column>
  <Column id="Size">0</Column>
  <Column id="Path">http://hostname/departments/HIS/Lists/Contacts/DispForm.aspx?ID=81</Column>
  <Column id="Description"></Column>
  <Column id="Created">10/16/2007 8:54 AM</Column>
  <Column id="Modified">11/15/2007 10:28 AM</Column>
  <Column id="Filename">Doe</Column>
  <Column id="SiteName">http://amhintranet01/departments/his</Column>
  <Column id="SiteTitle">HIS</Column>
  <Column id="CollapsingStatus">0</Column>
  <Column id="HHSummary" hithighlighted="true"><span class="o-srchhh0">Jack</span> <span class="o-srchhh0">Jack</span> <span class="o-srchhh2">Doe</span> jdoe@xyz.org Network Analyst 215-555-1212 215-000-0000 HIS System Account <span class="o-srchhh2">Doe</span> <span class="o-srchhh2">LASTNAME</span> HIS</Column>
  <Column id="HHTitle" hithighlighted="true"><span class="o-srchhh2">Doe</span></Column>
  <Column id="HHUrl" hithighlighted="true">http://hostname/departments/HIS/Lists/Contacts/DispForm.aspx?ID=81  </Column>
  <Column id="ContentClass">STS_ListItem_Contacts</Column>
  <Column id="IsDocument">0</Column>
  <Column id="ContentType">Contact</Column>
  <Column id="objectid"></Column>
  <Column id="PictureURL"></Column>
  <Column id="WorkEmail"></Column>
  <Column id="JobTitle">Network Analyst</Column>
  <Column id="Department">HIS</Column>
  <Column id="WorkPhone">215-555-1212</Column>
  <Column id="MobilePhone">215-000-0000</Column>
  <Column id="Fax"></Column>
  <Column id="Skills"></Column>
</Columns>
<CustomPropertyGroups>
  <CustomPropertyGroup id="Default">
    <Name>Default</Name>
  </CustomPropertyGroup>
  <CustomPropertyGroup id="ContactInfo">
    <Name>Contact Information</Name>
    <Property id="JobTitle" type="Text">
     <Name>Job Title</Name>
     <Value>Network Analyst</Value>
    </Property>
    <Property id="Department" type="Text">
     <Name>Department</Name>
     <Value>HIS</Value>
    </Property>
    <Property id="WorkPhone" type="Text">
     <Name>Phone</Name>
     <Value>215-555-1212</Value>
    </Property>
    <Property id="WorkEmail" type="Text">
     <Name>E-mail</Name>
    </Property>
    <Property id="MobilePhone" type="Text">
     <Name>Mobile Phone</Name>
     <Value>215-000-0000</Value>
    </Property>
    <Property id="Fax" type="Text">
     <Name>Fax</Name>
    </Property>
  </CustomPropertyGroup>
</CustomPropertyGroups>
<ImageUrl>/_layouts/images/STS_ListItem16.gif</ImageUrl>
</Result>
</Results>
 

not sure if you need this, but can't hurt.  it is the modified People style for Ontolica wildcard

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt">
    <xsl:import href="~sitecollection/OntolicaStyles/Common/SearchResult.xsl"/>
    <xsl:output omit-xml-declaration="yes"/>
    <xsl:template match="Results">
        <xsl:apply-templates select="ActionDefinitions"/>
        <table id="{@group}" border="0" cellpadding="0" cellspacing="0" style="{LayoutTableStyles}" baseUrl="{BaseUrl}">
            <tr>
                <td></td>
            </tr>
            <xsl:apply-templates select="Result"/>
        </table>
        <xsl:apply-templates select="Message"/>
    </xsl:template>
    <!-- ========================================================================== -->
    <!-- People Result Template                                                     -->
    <!-- ========================================================================== -->
    <xsl:template match="Result">
        <tr>
            <!-- Image Column -->
            <!-- <td width="1%" class="o-srch-people-col1">
        <xsl:choose>
          <xsl:when test="string-length(Columns/Column[@id='PictureThumbnailURL']) &gt; 0">
            <a href="{Columns/Column[@id='Path']}" target="{/Results/Target}">
              <img src="{Columns/Column[@id='PictureThumbnailURL']}" style="{/Results/ImageStyles}" border="0"/>
            </a>
          </xsl:when>
          <xsl:when test="string-length(Columns/Column[@id='PictureURL']) &gt; 0">
            <a href="{Columns/Column[@id='Path']}" target="{/Results/Target}">
              <img src="{Columns/Column[@id='PictureURL']}" style="{/Results/ImageStyles}" border="0"/>
            </a>
          </xsl:when>
          <xsl:otherwise>
            <xsl:if test="/Results/DefaultImage">
              <a href="{Columns/Column[@id='Path']}" target="{/Results/Target}">
                <img src="{/Results/DefaultImage}" style="{/Results/ImageStyles}" border="0"/>
              </a>
            </xsl:if>
          </xsl:otherwise>
        </xsl:choose>
      </td>
      -->
            <!-- Text Column -->
            <td valign="top" class="o-srch-people-col2">
        <table cellpadding="0" cellspacing="0">

          <xsl:call-template name="RenderResultRowBegin"/>

          <td width="1%">
            <table cellpadding="0" cellspacing="0" >
              <tr>
                <td>
                  <xsl:if test="Columns/Column[@id='WorkEmail']">
                    <img id="IM_{@id}"
                         align="absmiddle"
                         border="0"
                         height="12" width="12"
                         src="/_layouts/images/imnhdr.gif"
                         onload="IMNRC('{Columns/Column[@id='WorkEmail']}')"
                         ShowOfflinePawn="1"
                         style="margin-right:5px"/>
                  </xsl:if>
                </td>
              </tr>
            </table>
          </td>

          <td class="srch-Title">
            <table cellpadding="0" cellspacing="0" class="o-menu-unselectedtitle ms-selectedtitle" onmouseover="OSR_OnResultItem(this)" ItemId="{@id}">
              <tr>
                <td style="padding:3px">
                  <xsl:call-template name="RenderUrlBegin">
                    <!-- IMPORTANT! DO NOT CHANGE THIS ID. It is needed by the query logging framework. -->
                    <xsl:with-param name="id">
                      <xsl:text>OSR_T_</xsl:text>
                      <xsl:value-of select="@row"/>
                    </xsl:with-param>
                    <xsl:with-param name="href">
                      <xsl:value-of select="Columns/Column[@id='Path']"/>
                    </xsl:with-param>
                    <xsl:with-param name="contentClass">
                      <xsl:value-of select="Columns/Column[@id='ContentClass']"/>
                    </xsl:with-param>
                  </xsl:call-template>
                 <xsl:value-of select="Columns/Column[@id='Title']"  disable-output-escaping="yes"/>    <---- this works AND IS NOT in the Default Property group or results.
                  <xsl:call-template name="RenderUrlEnd"/>
                  </td>
                <!--<td>
                  <img src="/_layouts/images/blank.gif" width="13" style="visibility:hidden" alt=""/>
                </td>-->
              </tr>
            </table>
          </td>
          <xsl:call-template name="RenderResultRowEnd"/>

          <!-- HIDE SUMMARY INFO
          <tr style="padding-top:2px;padding-bottom:2px">
            <td colspan="2" class="srch-description">
              <xsl:value-of select="Columns/Column[@id='FirstName']" disable-output-escaping="yes"/>
            </td>
          </tr>-->
           
          <xsl:apply-templates select="CustomPropertyGroups/CustomPropertyGroup[@id='Default']"/>

        </table>
      </td>
            <xsl:apply-templates select="CustomPropertyGroups/CustomPropertyGroup[@id='ContactInfo']"/>
        </tr>
        <tr style="height:15px">
            <td colspan="2"></td>
        </tr>
    </xsl:template>
    <xsl:template match="CustomPropertyGroup[@id='Default']">
        <tr style="height:7px">
            <td colspan="2"></td>
        </tr>
        <xsl:for-each select="Property[Value]">
            <tr>
                <td colspan="2">
          <xsl:value-of select="Name"/>
          <xsl:text>: </xsl:text>
          <span class="o-srch-people-propvalue">
            <xsl:value-of select="Value"/>
          </span>
        </td>
            </tr>
        </xsl:for-each>
    </xsl:template>
    <xsl:template match="CustomPropertyGroup[@id='ContactInfo']">
        <td valign="top" class="o-srch-people-col3">
      <table cellpadding="1" cellspacing="0">
        <tr><td></td></tr>
        <xsl:for-each select="Property[Value]">
          <tr>
            <td style="padding-left:5px;padding-right:5px" nowrap="nowrap">
              <strong><xsl:value-of select="Name"/></strong>
              <xsl:text>:</xsl:text>
            </td>
            <td class="o-srch-people-propvalue" style="padding-right:5px">
              <xsl:value-of select="Value"/>
            </td>
          </tr>
        </xsl:for-each>
      </table>
    </td>
    </xsl:template>
    <xsl:template match="Message">
        <table border="0" width="{LayoutTableWidth}">
            <tr>
                <td>
          <img src="{Icon}" alt="{@type}"/>
        </td>
                <td class="o-{@type}">
          <xsl:value-of select="Text"/>
        </td>
            </tr>
        </table>
    </xsl:template>
</xsl:stylesheet>
 

So if you go into http://YOURSERVER/_layouts/Ontolica/SearchResultProperties.aspx?SearchConfig=People

verify that you are definitly seeing FirstName property listed in the default group. I just verified on two servers and this makes it show up with that xslt.

NOTE: that there are some hard coded properties that always are included in the result set. Title is one of them. First and Last Name are not.

 check it out, yep, FirstName is listed in Default group.  also ran another Full Crawl

 i wonder why FirstName is giving me difficulties.  if i hardcoded another field, ie, department.  it shows up right in front of Title (lastname).  so that's telling me it's something whacky with the FirstName mapping? you thinking the same?

But then, WHY would the mapping work in my old search method?  non wildcard search.  i had custom XSLT working

 here is some more info about how I'm getting the names:

Property Name        Mappings

FirstName            People:FirstName(Text), ows_FirstName(Text), ows_First_x0020_Name(Text)


Also as a client request we are using scopes set up from lists containing phone directories. client wanted it this way so a person in each department can keep their own phone/contact list up to date.  so not pulling from SP or AD.



Does it matter if my Searchable Properties only has a DefaultProperty group and then the search

results properties has two property groups?  Default and Contact Information

I also created a new mapping called Nickname and mapped to People:FirstName   still nothing worked after adding to Default group.

thanks for all the help.  if this doesn't get resolved soon i have to figure out something else.  ahhh.

oh BTW, thank you for running this site, it's the only place I could find any sort of info regarding the wildcard search! 

Hmmm. Ok.  Here is what I would do:

1. stick with the xml output so you can look at the raw dataset and you only need to work with the Search Results properties to display, The Searchable ones are for the advanced search form
2. Open up a profile (sharedservices, view profiles) and verify that there is in fact Firstname data.. THIS IS THE MOST LIKELY ISSUE
3. if still not working, turn on Ontolica logging, run a query and look at the log file for anything interesting. the logs are located under the standard crawl log location /ontolica.

If you still have problems I will involve Lars in this discussion. He wrote Ontolica.

do i need to reply through the forum or can I do so to you emails?  also, we are interested in becoming Mondosoft/Ontolica Partner or reseller and would like more information. Can I get that through you?

now back to my issue 

Ok, if I do a search for People and search term is Firstname:Jack  it knows that I am searching for the firstname and returns all people with firstname of Jack…but still no FN shows.  Just thought I’d add that to my issue.

Also, I did something to see if it would work and on the Search Result Prop for Default Prop mapped Department to First Name and then on my results page the first name field was populated with the Department data.  And the Raw dataset showed Column ID FirstName.

So this def is something with the FirstName mapping. As for sharedServices, view profiles…did you mean User Profiles? If so, I did see First name in there and filled out but not every one has a profile, the client isn’t really using SharePoint to the level it should be used and not sure if they were going to be telling many people about profiles, etc. Was this what you meant by looking at profiles?

Sorry but again, I am pretty new to SP and figuring this out as I go.  I have some SMEs here to back me up but they are typically in training all day, we’re a training/consulting co.

I did the logging too and could see my search and the query it was producing, it just leaves the FirstName field out.

Question:  how come other fields (if empty) still are queried on and are listed in raw xml?  For example, Fax and Mobile phone.  Some lists do not have those field fully filled in but they are still showing in the xml??  Why wouldn’t there at least be ColumnName = FirstName showing?

You have been a great help and appreciate this very much!!

Let's continue to use this forum. I will now bring Lars in to see if he has any insight.

 were you able to get in touch with Lars and have any further insight?  I'm still at a loss with this issue.  I think i've looked in the correct areas and nothing seems odd or incorrect.

 could there be an issue with pulling the information for People (name, email, phone, etc etc etc) from a SP List using Custom Scopes?  doubtful, but just asking.  All the other fields are being returned properly. just FirstName.  which if it was something like birthdate I would really care  :)  

Hi Jeff

Lars here. I am afraid the missing result property is because you are using the Wildcard license and not a full license. The Wildcard license does not support custom properties in the search results. I know FirstName is a standard property and it should actually have been supported. The Wildcard license only supports the following result properties:

author, accountname, contentclas, contenttype, birthday, department, fax, homephone, interests, jobtitle, memberof, memberships, mobilephone, path, officenumber, responsibilities, size, sitename, sitetitle, skills, username, website, workaddress, workcity, workcountry, workemail, workphone, workstate, workzip, write

The Ontolica Wildcard edition checks the configured result properties against this list and ignores all not in it. Ultimately, this is a bug in the product. FirstName need to be added to this list to fix your problem.

But I am afraid I cannot fix it for you as I have moved on to new ventures. Please try and contact the Ontolica support team on mssupport[at]surfray.com and ask for a fix.

Cheers
Lars Fastrup