XSL Code to develop custom Search Result Page

XSL Code to develop custom Search Result Page

For those who are looking to develop custom search result page, here is the XSL which alone you to get a XML dump of the results (so you can put it into Sharepoint Designer to edit the look and feel)

<xsl:stylesheet version=”1.0″

xmlns:xsl=”http://www.w3.org/1999/XSL/Transform”&gt;

<xsl:output method=”xml” version=”1.0″ encoding=”UTF-8″ indent=”yes”/>

<xsl:template match=”/”>

<xmp><xsl:copy-of select=”*”/></xmp>

</xsl:template>

</xsl:stylesheet>

 

Building Dashboard in Sharepoint using Sharepoint search (with no custom code)

Building Dashboard in Sharepoint using Sharepoint search (with no custom code)

Build a custom dashboard the other day base on the Sharepoint search, want to share with you all how I did it.  Hope someone else will also find this useful.

  • I need to get data from various site collections
  • The users wants to make a Announcements in a site collections and certain Announcements needs to roll up into a page to form a dashboard.
  • These Announcements can be anywhere on the farm.

The good old way to do this would be to create a custom app that loop thru all the pages to Identify all content marked to include in the dashboard.  BUT here is a new way to approach this with NO CUSTOM CODE:

  • Create a new content type for Announcements (its optional, but this way you can save it as a List Template and reuse it)
  • Add a column to the Announcements list, for the purpose of this article we will call it “Announcements Type”, have this as a Choice and set the choice as “Include in Dashboard” and “Exclude in Dashboard” (the name and field type is entity up to you)
  • Let the Sharepoint Search runs a crawl
  • The new column “Announcements Type” should now be available in SSP.  Add this to Metadata Property Mappings in your SSP.  Call it “AnnouncementsTypeData”.  Check the box to allow this metadata to be usable in Scope.
  • Go to the place where you want to have the dashboard and create a “search result page” (or blank  page and then add the Search Core Result web part)).
  • Modify the Search Core web part.
  • Modify the Results Query Options and add AnnouncementsTypeData to Selected Columns in the Search Core Result Web.
  • Create a scope call “Dashboard” and set the rule to include all contents base on the following rule “AnnouncementsTypeData = Include in Dashboard”
  • The Core Search Result should now be able to understand AnnouncementsTypeData.
  • Set the Cross-Web Part query ID not to use User Query, but manually define the Query.
  • Set the Scope in this web parts to “Dashboard”.
  • Save your changes and Exit
  • Now whenever you access this page, you should only see all Announcements that the user mark as Include in Dashboard.
  • To make your dashboard looks better, edit the XSL in the core result (I highly recommend you edit the XSL so it doesn’t look like the sharepoint out of the box search.  I made it so no one notice the back end was base on the sharepoint search J, by editing the XSL you can make it look and feel like a “fancy” dashboard.)

Sharepoint (MOSS) Licensing – MOSS, Search Server, and Forms Server

Sharepoint (MOSS) Licensing – MOSS, Search Server, and Forms Server.

Here is the Sharepoint (MOSS)’s licensing model in simplified term and all everything you need to know related MOSS licensing (SQL, Windows, WSS, etc).
Microsoft Office Sharepoint Server 2007, Server License (MOSS)
  • Basic MOSS server license.
  • One license for each MOSS server.  One server license for each installation of the MOSS software.
  • If you have this type of license, you will need to purchase CAL for each user/device connecting to the server.
Microsoft Office Sharepoint Server 2007 Client Access License (CAL), Standard Edition
  • Client license to access the MOSS server.
  • One license for each devices or name user (will explain the differences between “device” and “name user”later in this post)
Microsoft Office Sharepoint Server 2007 Client Access License (CAL), Enterprise Edition
  • Client license to enable the MOSS server enterprise feature.
  • One license for each devices or name user which will be accessing the enterprise features (will explain the differences between “device” and “name user” later)
  • This is an add-on license to the Standard Edition, if you want to enable Enterprise function; you need to purchase one Standard plus one Enterprise CAL for each user!
  • Example if you want to have a MOSS with enterprise function for a user:
    • 1x MOSS 2007, Server License
    • 1x MOSS 2007 CAL, Standard Edition
    • 1x MOSS 2007 CAL, Enterprise Edition
  • As you can see from the above example, there isn’t really an MOSS Enterprise Server (unlike other Microsoft product such as SQL and Exchange which have a official version of Enterprise edition); however the term MOSS Enterprise Server are widely use on the Internet, which is a bit misleading from a licensing prospective. MOSS Enterprise Server is basically a MOSS Server with Enterprise CAL. With Enterprise CAL you can then “legally” enable the Enterprise function on the MOSS Server (when you enable the enterprise function it does not ask for proof of Enterprise CAL… so check your licensing before enabling it!)
Microsoft Office SharePoint Server 2007 for Internet sites (this is the replacement license for External Connector license available in 2003)
  • MOSS server license design for use as an Internet site. It is licensed per server. With this license, you can have unlimited Internet user connected to the server (unlimited number of authenticated or anonymous user). This is the license to use if you plan to build a extranet using MOSS communcation between your clients, vendors, or contractors (Microsoft define this as “non-employees”).
  • Comes with all Enterprise features.
  • Note:  All internal users will still need to puchase CAL for and the MOSS Server
  • Example if you want to have a MOSS extranet which you use to mange invoices with your clients.  You have two accountatns uploads and manges invoices on the same extranet site.
    • 1x MOSS 2007, Server License
    • 2x MOSS 2007 CAL, Standard Edition
    • 2x MOSS 2007 CAL, Enterprise Edition
    • 1x MOSS 2007, Internet Site License
Microsoft Office SharePoint Server 2007 for Search (Enterprise Edition), Server License
  • This is a subset of the functionality that is offered in the full MOSS product. All the function in Search Enterprise is already included in MOSS Enterprise (therefore, do not purchase both)
  • If you only plan to use MOSS for Search, then purchase this licensing. It is licensed per server.
Microsoft Office SharePoint Server 2007 for Search (Standard Edition), Server License
  • Same as Search Enterprise but does not allow for load balancing, search is limited to indexing 500,000 items.
Microsoft Forms Server 2007, Server License
  • This is a subset of the functionality that is offered in the full MOSS product. All the function in Forms Server is already included in MOSS Enterprise (therefore, do not purchase both).
  • If you only plan to use MOSS for Forms (anything have to do with InfoPath), then purchase this licensing.
  • You can also mix the Forms Server with Standard Edition. Example: you want to have Sharepoint Form services, but don’t  need the entire Enterprise Suite, then you will purchase: MOSS Standard + Forms Server.
Microsoft Office Forms Server 2007 Client Access License (CAL)
  • Client license to access the MOSS Forms server.
  • One license for each devices or name user (will explain the differences between definition of “device” and “name user” later)
Microsoft Forms Server 2007 for Internet sites
  • Forms Server license design for use as an Internet site. It is licensed per server. With this license, you can have unlimited Internet user connected to the server (unlimited number of authenticated or anonymous user). This is the license to use if you plan to build a extranet using Forms server for your clients, vendors, or contractors (Microsoft define this as “non-employees”).
  • All rules listed in MOSS 2007 Internet Site license also applies to Forms Server 2007 Internet Site license
Windows Server External Connector
  • Windows SharePoint Services (WSS) is included with Windows Server. If you plan to use WSS to build extranet, this is the license you need to allow a unlimited number of clients, vendors, or contractors to access your site.
  • Note: your internal users still need additional CAL to access the site.
Device CAL (Per Device)
  • You purchase CAL for each device that accesses your server, regardless of the number of users who use that device to access the server.
  • This is ideal if you have a environments which multiple users share a single terminals (shifts, call center, etc)
User CAL (Per Name User or Per User)
  • You purchase the CAL each name user that accesses your server, regardless of the number of devices used by the user.
  • This is ideal if you have a environments which a single users access the servers from multiple devices (PDA, laptop, desktop, etc). You only need one CAL regretless of how many devices he/she have.
Mix of Licenses
  • You can mix both an Internet Site license and a Server license within the same farm.
  • Example: You can have a single farm operates both the corporate public web site, the intranet, and the extranet,
    • If you configure the two site to runs on its own individual servers within the farm, you can purchase one the Internet license and one server license for each server (If this makes more economy sense for your farm and design)
    • If you configure the two site to load balance on all the web front end servers within the farm, you need to purchase Internet site license and Server licenses for all the server in your farm (as the two site are shareing resources on the entire farm).
      • If you have 3 web front end server and 1 app server you will need the following:
        • 4x Internet Site license
        • 4x Server license
        • Plus CAL for all internal user
  • Note: Microsoft Office Forms Server and Microsoft Office Forms Server for Internet Sites cannot be mixed with Microsoft Office SharePoint Server and Microsoft Office SharePoint Server for Internet Sites. (as Sharepoint Server already have Forms server included)
Enable MOSS Enterprise Features
  • Once a Server’s enterprise function is enable you must acquire enterprise CAL for all user on using the server.   (this is a farm level central administration setting, so you can’t disable it per site)
Microsoft SQL Server CAL licensing model
  • Same as MOSS’s CAL model.
  • One license for each devices or name user.
  • You need a SQL CAL for each MOSS user if you plan to use this licensing model for the SQL server in your MOSS Farm.
  • Example for a MOSS Farm: 
    • 1x MOSS 2007, Server License
    • 1x MOSS 2007 CAL, Standard Edition
    • 1x SQL 2007 Server, (either Standard or Enterprise)
    • 1x SQL 2007 CAL, (either Standard or Enterprise depending on your SQL edition)
Microsoft SQL Server Internet Connector
  • Same as MOSS 2007 for Internet Site.
Microsoft SQL Server Processor licensing model
  • Licenses are purchase base on the number of processors you have on the server.
  • Licensed per processor.
SQL Server Active and Passive Model
  • If you have two SQL server and one of your SQL server is configure in passive model, then you are not require need to purchase SQL licenses for both servers. You only need licenses for one.
  • Unless the passive server has more processors than the active server, and the active server is licensed under the per processor model.
Virtual Machine and Microsoft Windows Server 2003 Enterprise Edition
  • With Enterprise Edition, you are license up to four virtual machines under one physical license. That means with one copy of Windows Server 2003 Enterprise, you can have up to 4 virtual servers running.
Windows Server 2003 Web Edition
  • Licensed per server. Allow unlimited number of user (both internal and external user)
Per Server CAL Licensing Mode for Windows Server
  • With this mode, each CAL is associated to an individual server.
  • Ex: if you have two Windows Server and 20 users access both server, you need 40 CAL (20 for each server)
Per Seat CAL Licensing Mode for Windows Server (or Per Device or Per Users)
  • With this mode, each CAL is associated to the individual devices/user. A user with a single CAL will have access to unlimited number of servers.
  • Ex: if you have five Windows Server and 20 users access all five of the server you only need 20 CAL.
Here is a sample configuration for a MOSS Server farm licensing:
  • MOSS Internet, Intranet, and Extranet Sites. 5 servers farm configuration running MOSS 2007 and SQL 2005 (1 SQL with two process on the server, 2 MOSS front-end, and 1 MOSS backend Index). You have 20 employees which will utilize Enterprise features. Here is what you need
  • 5x Windows Server 2003
  • 2x Microsoft SQL Server 2005 Standard Edition – Processor Licenses (no CALs required)
  • 2x Windows Server 2003 External Connector Licenses
    • You have two MOSS front-end server running on Windows Server 2003, therefore, you need to purchase External Connector license for each server!
  • 3x Microsoft Office SharePoint Server 2007 for Internet Sites
    • All three servers are used by extranet, in this case. The three sites are sharing resource across all three servers so you will need an Internet Sites licenses for all three servers.
  • Three (3) Microsoft Office SharePoint Server 2007 (MOSS)
  • 20x MOSS CALs, Standard Edition
  • 20x MOSS CALs, Enterprise Edition