Tuesday, April 15, 2008

SharePoint administrative and development Tool

SharePoint SUSHI

SUSHI is a powerful, user-friendly SharePoint application enabling you to accomplish common SharePoint administrative and development tasks. You can think of SUSHI as a Swiss army knife for SharePoint.
What does the name SUSHI stand for?
SUSHI = SharePoint Utility with a Smart, Helpful Interface


Wednesday, April 09, 2008

Display raw XML returned by SharePoint Search

On Search page, modify the XSLT of "Search Core Results" web part to

#?xml version="1.0" encoding="UTF-8"?>
#xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
#xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
#xsl:template match="/">

Replace # with <

Thursday, April 03, 2008

NumberToWord Function

private string[] _englishDigitMatrix = new string[]{"", "Second", "Third", "Fourth","Fifth", "Sixth", "Seventh", "Eighth","Nineth"};

public string changeNumericToWords(int number)


      string ret = _englishDigitMatrix.GetValue(number - 1).ToString();

       return ret;



Wednesday, April 02, 2008

Using Database Mirroring with Office SharePoint Server and Windows SharePoint Services

Database mirroring is a new technology in Microsoft® SQL Server™ 2005 database software that can deliver high availability and high performance solutions for database redundancy. In database mirroring, transactions are sent directly from a principal database and server to a mirror database and server whenever the principal database’s transaction log buffer is written to disk. This technique can keep the mirror database nearly up to date with the principal database. You can optionally use a third server, a witness server, to enable automatic failover from the principal server to the mirror server.
The update includes more prescriptive information on the type of supported topologies. It also recommends SQL connection aliasing for failover within a farm.


SharePoint Branding Tool (Themes, Master pages, Site Logos...)

This tool can be used apply the following actions for multiple Site Collections, and Child Sites:

modify Themes
modify MasterUrl (Master Page)
modify CustomMasterUrl (System Master Page)
modify SiteLogoUrl (Site Logo)
modify SiteLogoDescription (Site Logo Alternative Text)
modify AlternateCssUrl (Custom CSS Style Sheet)
view various properties of sites and themes at a glance
Selection of sites can be filtered by the Site Template used.


Tuesday, April 01, 2008

Add White space in XSLT

Add and display Custom Column in SharePoint Search Result

The results in SharePoint Search are displayed by Search Core Results Web Part. This web part have “Selected Columns” property under “Results Query Options” category which contains an XML string that defines all of the columns that are to be displayed in the search results.

The following is the default list of columns shown in the search results:

Now, we will create a new mapped property named “ListItemId”. Managed properties map to one or more of the crawled properties. They group together the related crawled properties and expose them to the user

The Search Settings in the administrative site of the Shared Services Provider has a Metadata Property Mappings link. Clicking on it brings you to the Metadata Property Mappings page

Now, click on “New Managed Property”
Enter, the property name as: “ListItemId” and make sure you select “Integer” and “Allow this property to be used in scopes”
Note: By default “Type of Information “is set to Text

Now, you need map to the crawled properties. The Add Mapping button pops up a dialog box where you can navigate through all of the crawled properties and select the ones you want to map to the managed property
Enter ows_id and press Find, select the property and click OK.

Note: If you didn’t selected “Type of Information “as Integer, SharePoint is not able to search this property.
Now, start a full Crawl of your content and you should now see your List Item in search results