SharePoint Server 2010 Phonetic and Nickname Search | Kristof Kowalski

In Sharepoint 2010 one of the new features is phonetic search. This works also in People Search. There are some caveats in multilanguage. Kristof Kowalski has written a good article to this topic with a lot of background information.

SharePoint Server 2010 Phonetic and Nickname Search | Kristof Kowalski.

SharePoint Server 2010 Usage Best Practices White Paper

Gutes Paper welches man auch einem Endbenutzer zum Umgang mit Sharepoint 2010 abgeben kann. Leider nur auf Englisch vorhanden.

Summary:

In this white paper, you will learn how to manage content effectively, how to choose the best option for displaying content, and the most effective way to find your content later.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5c562f71-3aa9-46fd-abac-7d381813f2b8

Download details: SharePoint Server 2010 Usage Best Practices White Paper.

Sharepoint 2010 – Content of Access Services Database

In Sharepoint 2010 it is possible to have published Microsoft Access 2010 Databases. These are rendered in the web (including Forms and Reports). For simple Database-Applications this is a really good thing!

On first sight there is no possiblity to see how the website is structured. Although the Website is access services based, all the data are saved in Standard Sharepoint Lists. To get the normal overview over the lists, document libs etc. do the following.

Take the normal Access Services DB URL which could look like this

http://pub2010.lab.ch/AccessTest/default.aspx

and transform it to the following

http://pub2010.lab.ch/AccessTest/_layouts/viewlsts.aspx

So you get the normal overview. And you can open the lists and get the normal features (like data export feed…).

Sharepoint Search XSL

There is a possiblity to show a link to the corresponding Document Library or Explorer Directory in Sharepoint Search. You have to change the XSL which defines the Visual Search in the Core Search Webpart.

This is the XSL Template:

 <!-- Display a folder for opening the Document Library or Folder -->
  <xsl:template name="DisplaySite">
    <xsl:param name="title"/>
    <xsl:param name="url" />
    <xsl:param name="isdocument" />
    <xsl:if test='$isdocument = 1'>
      <xsl:variable name="siteUrl" select="foo"/>
      <xsl:if test='string-length($url) &gt; 0'>
        <xsl:choose>
          <xsl:when test="starts-with($url, 'file://')">
            - <xsl:element name="a">
              <xsl:attribute name="href">
                <xsl:call-template name="strip">
                  <xsl:with-param name="relfile">
                    <xsl:value-of select="url"/>
                  </xsl:with-param>
                </xsl:call-template>
              </xsl:attribute>
              <img src="/_layouts/images/folder.gif" alt="Dokumentenbibliothek öffnen" style="border:none; vertical-align:bottom;"/>
                Ordner im Explorer öffnen
            </xsl:element>
          </xsl:when>
          <xsl:when test="starts-with($url, 'http://')">
            - <xsl:element name="a">
              <xsl:attribute name="href">
                <xsl:call-template name="strip">
                  <xsl:with-param name="relfile">
                    <xsl:value-of select="url"/>
                  </xsl:with-param>
                </xsl:call-template>
              </xsl:attribute>
              <xsl:attribute name="target">blank</xsl:attribute>
              <img src="/_layouts/images/itdl.gif" alt="Dokumentenbibliothek öffnen" style="border:none; vertical-align:bottom;"/>
                Zugehörige Dokumentbibliothek öffnen
            </xsl:element>
          </xsl:when>
        </xsl:choose>
        <br/>
        <xsl:value-of select="$siteUrl"/>
      </xsl:if>

    </xsl:if>
  </xsl:template>
  <!-- Utility function to remove the document from the URL -->
  <xsl:template name="strip">
    <xsl:param name="reldir"/>
    <xsl:param name="relfile"/>
    <xsl:choose>
      <xsl:when test="contains($relfile, '/')">
        <xsl:call-template name="strip">
          <xsl:with-param name="relfile">
            <xsl:value-of select="substring-after($relfile,'/')"/>
          </xsl:with-param>
          <xsl:with-param name="reldir">
            <xsl:value-of select="concat($reldir, substring-before($relfile,'/'), '/')"/>
          </xsl:with-param>
        </xsl:call-template>
      </xsl:when>
      <xsl:otherwise>
        <xsl:value-of select="$reldir"/>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

To call this template in the location where every search result is processed, use this snippet:

 <xsl:call-template name="DisplaySite">
        <xsl:with-param name="title" select="title"/>
        <xsl:with-param name="url" select="sitename" />
        <xsl:with-param name="isdocument" select="isdocument"/>
      </xsl:call-template>

Credits for this useful extension goes to the Sharepoint XSL  Samples Project on Codeplex. Thx!
http://sctxsl.codeplex.com/
http://sctxsl.codeplex.com/releases/view/12070 (look there for the Open Document Library File under Downloads)



													

SQL Server RBS Performance with SharePoint Server 2010 and StorSimple Storage Solution

SQL Server RBS Performance with SharePoint Server 2010 and StorSimple Storage Solution.

This paper explains the RBS feature as it applies to SharePoint Server 2010 and analyzes its performance impacts on key attributes of a SharePoint farm such as database size, database backup size, transaction response times, and backup/restore time.

Configure Excel Services 2010 for data refresh | Howard @ MSFT selling BI

This was the instruction which helped me to configure Excel Service working together with the Secure Store Service and Unattended Account.

Important: In the Excel Sheet on the connection you have to set the Authentication Settings to none!

Configure Excel Services 2010 for data refresh | Howard @ MSFTselling BI.

EComic – Sharepoint 2010 Gebote Grundlagen Sharepoint

Mit dem ersten TurboComic der Welt Die SharePoint 2010 Gebote – 1. Du sollst lernen die Grundlagen, lernen Sie effizient und rasch die Handhabung von SharePoint 2010. Entdecken Sie es mit dem Abzug unten. Kaufen können Sie es hier, auf iTunes, bei Amazon und mehr.

TurboComic > Home.

How to solve Missing Server Side Dependencies – 8d6034c4-a416-e535-281a-6b714894e1aa Error? » SharePoint Insight

Had the problem that on a clean (single Box!) Sharepoint 2010 I got the Error Message “Missing Server Side Dependency GUID”. This is an error which is there since Beta and was not fixed by microsoft.

See here for the – strange – solution…

How to solve Missing Server Side Dependencies – 8d6034c4-a416-e535-281a-6b714894e1aa Error? » SharePoint Insight.

Head-to-Head: SharePoint Migration Tool Demo Videos | EndUserSharePoint.com

Comparison (Video Presentations of the Developing Companies) of Sharepoint Migration Tools.

Head-to-Head: SharePoint Migration Tool Demo Videos | EndUserSharePoint.com.

XSL Sort on DateTime

<xsl:template match='callEvent/response/interaction_list'>

   <xsl:apply-templates>
      <xsl:sort select='./interaction/timestamp'
                order='descending'
                data-type='number' />
   </xsl:apply-templates>

</xsl:template>

<!-- timestamp NODE Template -->
<xsl:template match="timestamp">
   <!-- Pull the pieces apart -->
   <xsl:variable name='datetime' select='.' />
   <xsl:variable name='year'  select='substring( $datetime, 0 , 5 )' />
   <xsl:variable name='month' select='substring( $datetime, 6 , 2 )' />
   <xsl:variable name='day'   select='substring( $datetime, 9 , 2 )' />

   <td valign='top'>
      <!-- put the date together in American order -->
      <xsl:value-of select="concat($month, '/', $day, '/', $year )" />
      <!-- Seperate the date and Time -->
      -
      <!-- Display the Time -->
      <xsl:value-of select='substring( $datetime, 12 , 9 )' />
   </td>
</xsl:template>

Source: xsl sort datetime – RE: Q on.