Guide to Code Access Security in SharePoint Server 2007

Andrew Connell has published an article on CAS for SharPoint.
It will be very helpful for Developers. Click here to read more.

Developing on SharePoint 2010

Getting Started
Module 1: Getting Started: Building Web Parts in SharePoint 2010
Module 2: What Developers Need to Know About SharePoint 2010
Module 3: Building Blocks for Web Part Development in SharePoint 2010
Module 4: Accessing SharePoint 2010 Data and Objects with Server-Side APIs
Module 5: Accessing SharePoint 2010 Data and Objects with Client-Side APIs
Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010
Module 7: Developing Business Processes with SharePoint 2010 Workflows
Module 8: Creating Silverlight User Interfaces for SharePoint 2010 Solutions
Module 9: Sandboxed Solutions for Web Parts in SharePoint 2010
Module 10: Creating Dialog Boxes and Ribbon Controls for SharePoint 2010

SharePoint BI

A very good 6 Parts article on SharePoint's role in BI.

Part 1 – Getting to Know You – Intro to SharePoint BI

Part 2 – Sell! Sell! Sell! Why Build a Dashboard Anyway?

Part 3 – KPIs – Where do I Come From?

Part 4 – Dissecting Dashboards

[Awaited for the articles to release]

Part 5 – We Really Need to Talk – Scorecards & Reports

Part 6 – Beware the Bogeyman – Securing Dashboards

SharePoint 2010 Videos

http://channel9.msdn.com/Media/Videos/

Twitter Search WebPart

A very good article on Twitter Search in SharePoint with screen-shots from Woody on EndUserSharePoint.
Read more...

Creating mailing lists for SharePoint sites and blogs

This article gives you an idea on how you can create a mailing lists for blogs OOB.
Read more...

Business Data List Connector - BDC's alternate

This is a good solution provided by Layer2, which will be used as an alternate solution for BDC.
It connects a REAL SharePoint List Without Any WebPart to external business data.
Click here to learn more...

Using Excel’s AutoRepublishing to Create SharePoint Charts & Dashboards

I have found a good article on how to use Office Excel's feature for publishing Chart in SharePoint @ EndUserSharePoint.

SharePoint Branding Limitations

A very good article from SharePointMagazine on SharePoint Branding and its limitations.
This article will give the developer/graphical designers more insight into the effect of these design decisions.

Part 1, Part 2, Part 3, Part 4

Show Data from 2 Different Lists

Many of us have a questions on how to show data from a 2 different lists. Laura had provided an answer to that on EndUserSharePoint for the same. :)

Search As-You-Type

Today, at time of searching the net in my free time. I was looking at to improve some search feature in sharepoint like providing Search As-You-Type kind a functionality what Bing or Google is providing.
And you know what, Jan Tielens has already did this :).
Read more...

Item Level Permission for Document Library

There is an item-level permissions feature that can be a solution to this problem BUT it’s only available for lists, not Document Libraries and I found a way to do this provided by Toni on EndUserSharepoint, click here to read more.

SharePoint Farm Configuration and Deployment

This series of articles which I have found on SharePointMagazine, that provides guidelines and instructions of how to plan, build and configure SharePoint farm across organizations. Current practices are based on the different of SharePoint projects and can be used as step-by-step instructions helping to configure proper baseline for SharePoint farms.

Part 1 – Architecture and Logical Planning
Part 2 – Installation
Part 3 – Development Environment
Part 4 – Backup and Recovery Strategy
Part 5 – Virtualization
Part 6 – Post Deployment

Recommended SQL disk size for MOSS-2007

Few days back I started working on a new project for one of the client.
The current environment they have is having a lots of probelme and is kind of a mess. We decide to improve their current environment. And the first challenge comes up is to convience their DBA Team for the sizzing of the SQL Server for MOSS. Thanks to cleverworkarounds, we got a very good artilce.
This article helps us to make the decesions on Disk and I/O Sizing for MOSS2007. Read Part-1 & Part-2

Configuring MOSS's search for a Web Server

Again a very good post on MOSSHowto on the configuring the Search server for MOSS :)

Enumerate Roles and Groups from the site

In one of our application we have to create a Report which Enumerate Role Assignments to retrieve Groups and Users Permissions from the Site.
MOSSHowTo has provided a good solution for that. Click here...

Create a Report from an Analysis Services 2008 Database and deploy it in SharePoint 2007

I am trying to deploy the reports created using SSRS to MOSS.
I have found very good link which described with the screen-shots. Read more...

How CSS works with Master Page

This article from CleverWorkAround is one of the best article on the net to understand how css works with Master Page in SharePoint.

Setting View Column Width with JQuery

One of the very common requirement from the client is to setting up the column width for the Views.
I found very good article from Kjell-Sverre on this. Click here to view full article.

Item-Level Auditing with SharePoint Server 2007

Many companies and government agencies have policies and regulations that require them to track carefully where and how users gain access to important records and documents. In particular, they need to maintain audit logs that detail events that track data such as which users viewed and updated records and documents, and when these events occurred.

Now the solution is available with MOSS. Click here

STSADM in Graphical view

Find the STSADM commands reference in "graphical" form below for SharePoint 2007 and WSS 3.0.
http://technet.microsoft.com/en-us/windowsserver/sharepoint/dd418924.aspx (WSS 3.0)
http://technet.microsoft.com/en-us/office/sharepointserver/cc948709.aspx (MOSS-2007)

How to implement Live Chat

I am just going through SharePointKing's blog site after a long time and I found he has implemented a good feature to chat with him. I love this and he also describe the way to achieve this.

Combine Multiple Documents

Mark Miller has demonstrate a wonderful way to combine multiple document in a single document.
Take a look and see what I mean.

Multiple Pie Charts in a WSS Dashboard

I have found a good article on how to show multiple Pie Charts in a Dashboard.
Click here to see more...

Create your own RSS Viewer

A total No-Code Solution below from Laura Rogers.

Data View - Multiple Add, EDIT Items on a form

A very nice article by Laura Rogers on endusersharepoint, for how to add or edit multiple items on a single form using Data View WebPart instead of Datasheet view.

Custom Lists for More Effective Workflow Auditing

SharePoint Designer workflow doesn’t give us a lot of visibility into what’s happening with our workflow solutions. And, the visibility that we do get is hampered by a relatively poor interface and 60 day time window. Paul Galvin has provided a good workaround for that here...

Best Practice to use DataView WebPart

When you add a data view web part to a page in your site, you’ll notice that when you Save, you get the message, which is called “unghosting” a page, when you customize it away from the site definition. Click here to know the Best Practice to use DVWP.

Email a List of People with OWS with JQuery

We had also done very similar but by creating the WebParts.
For sending the mail or resizing the text size is very basic requirements for any branding sites.
Paul has again provided a solution to that based on JQuery...

Data View Web Part, The Basics - Add a Hyperlink (Screencast)

When a Data View Web Part is added to a page in SharePoint Designer, it is sometimes useful to include links to the content of the list. In a regular view of a list on your site in the browser, the list’s Title field is a link to open the item. In a data view web part, this functionality is not automatically included. Following is a step-by-step process for using SharePoint Designer to add a hyperlink to a field in a Data View Web Part.

Sharepoint Download Zipped Documents/List Items

This is one of the gr8 solution we found out for our client's requriment of downloading all the documents/list items in a single click in a zip format. Click here to know more...

12+ killer freebie SharePoint add-ons

SharePoint's popularity as a collaboration tool has exploded. So the time was right to look at add-on products for expanding its usability, management and customization. It was surprised, but happy, to find that many add-on tools for SharePoint is free. A good article I found which also talks about the area which I have decided to target. Click this or this to read more.

For a quick reference I am listing down all 12 free add-ons here as well.
AJAX Control Toolkt
Silverlight Control Toolkit
Podcasting Kit for SharePoint
Community Kit for SharePoint
30 Extra Features for SharePoint-2007
SharePoint Learning Kit
SharePoint Tool Basket
SmartTools for SharePoint
Role-Based Templates for MySite
SharePoint Branding Tool
Imtech Mobile SharePoint
Colligo Reader

The SharePoint Manager 2007 is a SharePoint object model explorer. It enables you to browse every site on the local farm and view every property. It also enables you to change the properties (at your own risk). This is a very powerfull tool for developers that like to know what the SharePoint holds of secrets.

SharePoint and Documentum integration

Documentum is a well know enterprise class document and records management solution. It seems no matter where I go, clients have it, want it or want to get rid of it.
Most of my customers keep there enterprise class document and records management toolset and use SharePoint for work in progress. You might be saying 'I thought SharePoint is enterprise class?'. There are several reasons why clients would keep their existing toolset but that is beyond the scope of this blog. So why Documentum? Here are a few points:

• Leader in ECM space (Gartner)
• Leader in compliance and regulatory platform
• Unified global platform allowing federation
• End to end content lifecycle management
• Proven scalability
• Robust security

Read More...

Coloring Calendar in MOSS

SharePointEndUser strikes again, but this time without any coding.
You can have a coloring calendar using OOB features. Click here to read more...

Leveraging the SharePoint Platform

After reading this six part series hopefully you’ll have a clearer understanding of what the SharePoint Platform can offer to you and your organization. It will also provide some direction in using the SharePoint Platform. I have broken the series down as follows:
Part 1 - What is the SharePoint Platform
Part 2 - What capabilities to start with
Part 3 - How to start with the SharePoint Platform
Part 4 - Levels of leveraging the SharePoint Platform
Part 5 - Why use SharePoint as a Development Platform
Part 6 - Lessons learnt from Leveraging the SharePoint Platform

How to remove(HIDE) the "title" column from a Sharepoint list

Have you asked yourself the question: How do I remove the 'title column' from a Sharepoint list? It can be annoying trying to figure out how to remove this column from default lists. Often, site admins want their audiences to click on "New Item" in a Sharepoint list and not have to fill out the default 'Title' column content type. Here is the way how to remove this from the view.

Embedding the SharePoint Version number into the Word Document

We've recently received a couple of requests from customers about how to embed the SharePoint document version number and other versioning information into the document itself. This solution does require some custom coding and that information can be found here:

http://blogs.msdn.com/joerg_sinemus/archive/2007/01/26/wss-version-number-in-the-word-2003-document.aspx

Accessing Infopath fields, a simpler way

Today I am working with my team on Migration of Lotus Note application to MOSS.
The form is so huge which kills the performance of InfoPath form.
And again we are at the edge of google :).

I have find one good article which help us, we have converted our "myschema.xsd" file to "myscehma.cs" file using "XSD.EXE" file.

Read this ,this & this for more information.

Best Practices For Building SharePoint Solutions

The challenges facing developers who work with Windows SharePoint Services 3.0 (WSS) and Microsoft Office SharePoint Server 2007 (MOSS) are as deep and wide as the SharePoint platform itself. If you're new to this platform, the practices Microsoft has explored in this article will lead you in the right direction. If you're an experienced SharePoint developer, these tips should help reinforce your knowledge, encourage discussion, and ultimately lead to building great SharePoint applications.

Audience Targeting with WSS 3.0

If you're like me and are fairly new to SharePoint you tend to rely on the Visual Studio extensions for Windows SharePoint Services. A lot of the examples out there assume you have a certain knowledge level or experience with SharePoint and therefore they can be confusing. I’ll discuss step-by-step how to set the Target Audience while using VSeWSS.
All-in-all though, this blog entry will cover multiple topics.

SharePoint Best Bets Search

One of the things that people are not aware of is that you can customize the search results coming from the SharePoint search engine. The results, which is XML, given by the engine are styled using XSLT. If you create your own XSLT you can customize/restyle your results page.
There is a 'Visual How To' by Patrick Tisseghem explaining the steps you need to do to customize the search page.
You can do the same trick with the Best Bets meaning, you can customize them by applying your own XSLT. Before we are going to customize the Best Bets, Kevin explains what they do an how you can use them.
Best Bets are used to promote some results depending on your search keywords. If you look at the screenshot below you see that when I type SharePoint in the search box, U2U and Microsoft are pushed forward as results where you definitely can find something about SharePoint. So if you think about it, Best Bets is a way for an administrator to earn some extra money, the one who pays the most gets on top of the list.

Configuring and Deploying Anonymous Publishing Sites for SharePoint Server 2007

Andrew comes with the article for Exploring and learning how to address security and performance issues of Microsoft Office SharePoint Server 2007 publishing sites before launching them as Internet-facing publishing sites. Read whole article

Print (Any) Web Part(s) Plugin

Print any WebParts from Paul again :)

Create a Pivot Table from a SharePoint List and Display it in SharePoint

Pivot Tables are a powerful capability of Excel, however MOSS now provides the capability to create a pivot table from data in a SharePoint list. This example will show you how to use a SharePoint list to create a pivot table and then display it back in SharePoint using the Excel Web Access web part.

How to remove "My Settings" and "Personalize this page" menu items from the "Welcome" menu

You will sometimes want to hide certain menu items from the "Welcome" menu in the SharePoint site.
You can do the following:
1. Go to the following folder at the MOSS server:C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\CONTROLTEMPLATES
2. Open file Welcome.ascx in the editor
3. There are more elements. For all those you don't want to display to the users, add the attribute:Visible="False"
For example:

Text="<%$Resources:wss,personalactions_personalinformation%>"
Description="<%$Resources:wss,personalactions_personalinformationdescription%>"
MenuGroupId="100"
Sequence="100"
ImageUrl="/_layouts/images/menuprofile.gif"
UseShortId="true"
Visible="False" />
This will hide "MySettings" menu.
WARNING: this is shared file on the Farm-level, so it means, if you do this, the items will not be visible at any SP site on your farm.
And, yes, of course, on the similar way you can add custom menu items under welcome. Just use the attribute
ClientOnClickNavigateUrl="BLOCKED SCRIPT..."
You can define JavaScript function to jump to the custom page or just use Window.Location() to write destination inline.

Chart, Print, SlideShow, BulkAction etc... WebParts for Free

Today I am searching for some free available WebParts and I came across SPElements.
There are couple of WebPart are available on the site for free....

Chart:Flash chart WebPart.
Print: Print lists & calendars from the 'Actions' menu
SlideShow: Beautiful Slide show (image rotation) WebPart
BulkAction: Add bulk actions such as bulk delete & bulk approval.
RSS Ticker: RSS Ticker/scroller WebPart.
List Constraint: List constraints feature: list size constraint, unique field constraint & foreign keys
ListAnyView: Display SharePoint list from any site in any site.

Configuring Single Sign On Service and Create WebPart

A good article on how to configure Single Sign On (SSO)
Once we setup the SSO on SharePoint server, you might need to develop a WebPart for SSO.
And here is the way to do that.
Some more links

http://www.sharepointblogs.com/llowevad/archive/2007/04/23/sharepoint-2007-single-sign-on-setup.aspx
http://blogs.msdn.com/roberdan/archive/2005/02/19/376629.aspx
http://geekswithblogs.net/tariq/archive/2004/09/07/10769.aspx
http://blogs.msdn.com/johnwe/archive/2005/02/16/374955.aspx
http://blogs.tamtam.nl/mart/ImpersonationSingleSignonAndSPS.aspx
http://www.sharepointblogs.com/charbel/archive/2007/05/01/moss-2007-single-sign-on-part-2.aspx
http://blog.u2u.info/DottextWeb/patrick/archive/2005/01/15/795.aspx

Migration from MCMS-2002 to MOSS-2007

Microsoft Content Management Server 2002 to MOSS 2007 Migration article is intended as a guide for technical person who are all working in migrating Microsoft Content Management Server (MCMS) 2002 applications to Microsoft Office SharePoint Server 2007. Click to read more...

SharePoint Content Deployment Wizard + APIs

Deployment of SharePoint artifacts is something that's perhaps more complex than it should be, and the standard tools provided don't always simplify this picture. Personally, over my past few MOSS projects, there have been several times when I've thought:
I just need to move this document library from A to B
I just need to move these selected files (e.g. master page, page layouts, CSS etc.) from A to B
I just need to move this web from A to B
I just need to move this site collection from A to B
I just need to move these 20 list items from A to B
Here is the answer to all the questions...
You can directly download it from CodePlex
==============API Base Approach=============
Stefan Goßner posted a great series of posts about the Content Migration API (formerly known as PRIME) for SharePoint (WSS 3.0 and MOSS 2007). In just 5 post he explains everything about this API and where SharePoint uses it. It's an excellent start point for many SharePoint administrators and developers out there. I also refer to this post in my training's about SharePoint as well.
Deep Dive Into the SharePoint Content Deployment and Migration API - Part 1
Providing some real world samples on export - Part 2
Providing some real world samples on import - Part 3
Advanced content deployment scenarios - Part 4
Avoiding common problems - Part 5

When You Need SharePoint Designer

Walk through a high-level summary of SPD's features and how these features should and should not be used. At the end of this article you should be able to identify those situations where SPD can be helpful and identify situations where using SPD may be more of a hindrance than a help. Read more...

Simplifying SharePoint debugging by creating the troubleshooting toolbox

This series of articles is intended to help you getting ramped up with SharePoint programming. It’s about writing, troubleshooting and debugging SharePoint code. First you need to have prerequisite skills in .NET Development and in particular ASP.NET Development, you should also have basic understanding of SharePoint and how to use it from the User Interface , you must be able to create and deploy features and you should have some experience in working with content types and site columns. Click to read more...

AJAX Enable Tabs Web part in Sharepoint

First I would like to thank Mehul Bhuva and Bob German for their wonderful article.
We have a requirement of having Tabs for the webpart on a homepage, and I found this wonderful article on how to implement AJAX Enable Tabs WebPart

Controlling Single Web Parts with CSS

I often get questions about how can a particular web part be branded separately from all the rest or be branded by type. For example you want every Contacts list to have a green header bar instead of a tan header bar. Or perhaps you want a column of web parts on a page to look different than the main area that contains other web parts. Thanks to Heather I found the answer...

Create a SharePoint Site plan in less than 5 minutes

The screencast below is a five minute quick hit on how you might choose to utilize Mind Manager to do on the fly site planning with your team or client

Add user ratings and rich HTML comments to SharePoint pages

Tony Bierman's Community Content web part and Top Rated Content web part allow user to quickly rate a page's content and easily add rich HTML comments to SharePoint 2007 pages. Using these web parts, your anonymous users can rate the page content's quality and logged-in users can submit their own comments using a rich HTML interface.

Run SQL Queries and Fetch List Data from SharePoint Database (WSS_Content)

The information in a list is stored in the UserData table (which is an odd name for the table), and the lists themselves are stored in the Lists table. A list in the database has a GUID representation. Read more...

Playing Video in List Items

The problem of SharePoint's Rich text field is that it filters out a lot of the embedded code. This simple-to-install JavaScript adds a workaround for inserting embeddable content (flash, iframes, etc.) into SharePoint's Rich Text Field. Also you get an additional button in the toolbar for easy inserting of this content. Read more...

Understanding Record Management Feature

Many organizations and business have need to maintain their momentum of work in nice and in a perfect way. Work may include maintaining of documents, items, their repository. When we talk about documents, we should think in a bigger picture. Documents are not only stored, but they are actually shared and collaborated. Sharing means many other people can view it, and collaborate means people work on it, updates it, take an action on it, publishes it, needs meta data (who created it, when created it, who modified it, when modified it), give comments on it, approves it, makes the versions of it, compares them, expire based on policy defined and many more. This is where MOSS comes in to the picture. All these functionalities are built-in given. so why not to explore them.

Understanding Record Management Feature Part 1 - Document Information Panel
Understanding Record Management Feature Part 2 - Labeling
Understanding Record Management Feature Part 3 - Barcode
Understanding Record Management Feature Part 4 –Expiration Policy
Understanding Record Management Feature Part 5 – Auditing

MOSS Faceted Search

MOSS Faceted Search is a set of web parts that provide intuitive way to refine search results by category (facet). The code is available on CodePlex.

Embed Video and Audio files in the SharePoint Environment

This article was written in reference to:
How to add a movie player to MOSS
Video streaming in SharePoint

Adding JavaScript Tabs to SharePoint

One of the most under-utilized web parts by designers inside SharePoint has to be the content editor web part. The reason why it's so powerful is because it allows us to embed any markup we want right in the page. We will utilize this web part as well as adding some markup with SharePoint Designer to add some functionality to our SharePoint site. Here is the way how you can add Tabs in the SharePoint using JQuery

Customizable Everyday Productivity Education

These simple, easy-to-use customizable job aids were created by Microsoft's internal IT group to help employees get started with learning more about using a technology or product effectively, selecting the right product or service, or reviewing best practices. The content for Windows Vista and the 2007 Office System were published a couple of months ago, and I (and likely most of you) somehow missed it. The EPE home page is at http://technet.microsoft.com/en-us/library/bb687781.aspx, but for your convenience, I've listed the SharePoint specific content below.
Collaboration Selection Guide
Collaborating with SharePoint Server 2007 Overview
SharePoint Server 2007 Sites and Workspaces Selection Guide
SharePoint Server 2007 Document Collaboration Get Started
SharePoint Server 2007 Team Sites Get Started
Customizing a SharePoint Server 2007 Site Get Started
SharePoint Server 2007 Web Parts Learn More
SharePoint Server 2007 Meeting Workspaces Get Started
SharePoint Server 2007 My Sites Get Started
SharePoint Server 2007 Site Access and Storage Learn More
SharePoint Server 2007 Surveys Get Started
Outlook 2007 and SharePoint Server 2007 Integration Overview
Outlook 2007 and SharePoint Server 2007 Integration Get Started
Using InfoPath 2007 Forms on a SharePoint Server 2007 Site Get Started

Content Type User Interface

If you haven’t worked with content types before you haven’t worked with SharePoint since WSS2 and the SPS2003 era. You may not realize this, but Content Types are the method by which you store data in SharePoint, whether you like it or not.
Content Types are schemas for information, defining what your items or documents should contain, how they should behave, and, most importantly for us in this article, how they should appear.
Before we go into user experience customization of content types, you should also know a few more things about content types

Creating & Adding Event Handler

In this article, author has create an event handler that captures the events of the document library and add an entry in the cell of the document added. It can add an event handler using code or as a feature. In order to write an event handler, we will first create a sharepoint site and create a document library. We will, then, capture the events of the document library.

Sample Event Handler to set Permissions

This is something I have been seeing the need for in the forums for quite some time, and today I found an hour to find this. A request is often made to have an event handler that automagically sets the permissions on a list item so that only the author of the item can edit it, while other people with contributor permissions on the library can only read it.Sometimes the logic is more complex, but I think this sample code should be enough to get anyone started!

InfoPath Value Submitting to a SharePoint List

Here very basic but very useful blog for submitting InfoPath 2007 values into SharePoint 2007and displaying the submitted values click here
For me this example working fine.wonderful example

Migrating Lotus Notes to SharePoint

This article discusses Lotus Notes Migration approach and how to use Quest Notes to SharePoint Migrator tool.

Customize Search Control in SharePoint

This example shows the basic process of creating and implementing a delegate control candidate to use for the search box that is displayed on site pages. The control specifies alternate text and an alternate image file to use for the search box in Web sites where you activate the control.

SharePoint Delegate Control

A DelegateControl is a SharePoint ASP.NET control that acts as a placeholder for content or other controls. Think regular ASP.NET content placeholders but with a SharePoint Feature deployment method, meaning you can activate content on a page as you would activate any other feature in SharePoint. You might have seen these already is you’ve looked into the default.master file of a standard SharePoint installation. Read more...

CSS Reference Chart for SharePoint 2007

The CSS reference guide highlights the major styles used in MOSS and WSS v3 sites. The guide is organized by area of the page and include the style name, function, CSS file name and approximate line number and a sample screenshot of the style location on the screen.
Additionally, there is a "Copy to Clipboard" function that will copy the source code for the style to your client machine's clipboard for use in your own CSS file. Use these guides to identify styles that can be overridden for your custom branding and installation or to quickly reference style name and CSS information for customization. Note, Copy to Clipboard ONLY WORKS in INTERNET EXPLORER. This functionality will not work in Firefox due to restrictions with the Firefox browser itself.

Custom Cross-Site Lookup Column Add-On

I have a requirement for using MS provided fantastic 40 templates in a way where I have to use Site A's List column in Site B's List as a lookup within same Site Collection. And thanks to SharePoint Forum I found this feature which is available for free.

Incorporating a Master Page into a SharePoint site definition

This article will discuss the creation of SharePoint site definitions, which are templates for SharePoint sites that will automatically create the master page feature on the site when created

Information Rights Management with SharePoint

Information Rights Management (IRM) provides an additional layer of content security over that provided by more traditional access control lists (ACLs). IRM establishes usage limitations on a file rather than limiting access. For example, you may grant a user access to a file but you may not want them to change the file on the client computer or forward it to someone else. IRM provides this additional level of security.

Implementing IRM security in SharePoint Products and Technologies requires additional software that is not shipped with either Windows SharePoint Server 3.0 or Office SharePoint Server 2007. You must install the Microsoft Windows Rights Management Services Client, version 1, on every Web front-end server in your server farm. In addition,Microsoft Windows Rights Management Services (RMS) for Microsoft Windows Server® 2003, service pack 1.0 or later, must be available on your network.

You can implement IRM on document libraries. When IRM is enabled on a document library, and a document of a type that can be rights-managed is downloaded from the server to a client application, the SharePoint Products and Technologies server encrypts the document and adds an issuance license. When the document is uploaded back to the server, the SharePoint Products and Technologies server decrypts the file and stores it in the library in unencrypted form, as content is not encrypted in the SQL Server database. This enables features such as search and indexing to operate as usual on the files in the IRM-protected document library. The IRM permissions that are applied to a document when users upload it to a document library are based on each user's permissions for the content in the SharePoint Products and Technologies server security settings.

Microsoft Windows SharePoint Services 3.0 does not have the Microsoft® Office protector files that are required to automatically rights-protect a document when it is uploaded. You must use Office SharePoint Server 2007 to do this. More...

IRM Framework Architecture in Windows SharePoint Services
MOSS2007 and IRM – Step by Step Part 1
MOSS2007 and IRM – Step by Step Part 2
How do you apply IRM to a SharePoint List or Library?
Plan Information Rights Management
Video: IRM Use with SharePoint and Office

Free WebParts

Free SharePoint Web Parts (3rd Party)

BDC Column for SharePoint List

This custom column type provides a BDC Column type that can be created at the Site Column level and therefore used in Site Content Types. Out of the box this is not possible, and the ability to reuse BDC columns across sites and content has been identified as a common requirement. At this stage there are a number of things that are not yet implemented, including related fields, refreshing and nicer admin UI. Read more...

You can download the WSP from here...

SharePoint Web Part for Google Search

One of our client is insisting us to implement Google Search on their Internet based SharePoint Site.
Here I found one link which help to implement Google Search within your SharePoint site.

Guidline to Create a MOSS 2007 VPC image

If you do not have a MOSS server available to you, you can follow Tony Zink’s lengthy but excellent 20 step guide to creating a MOSS 2007 VPC image at here...

Controlling publishing features from onet.xml

This entry explains the different options when you configure the standard publishing features in onet.xml. If you are interested concerning the navigation options for the MOSS sites, check the previous post with details concerning the different options on configuring the navigation settings within the site.
Custom site definition for Publishing site

Displaying SharePoint Fields by Permission Level

There are situations where certain fields in lists or libraries need to be hidden or displayed according to the permission level of the logged in user. Since there is really no out-of-box way to assign permissions to fields, here’s a way to do it using conditional formatting in SharePoint Designer. This is my favorite SP Designer trick.

How to Display Multiple Document Libraries?

It seems that one of the most commonly asked questions on discussion boards and forums is “How can I display documents from multiple document libraries all in one list?” So, I decided to enumerate some of the available options to achieve this goal. They each have their pluses and drawbacks.
And here is the answer to that...

Alerts Based on Views

In SharePoint 2007, alerts can be set up based on filtered (specific) data, using views!
This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.
This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.

Example Case

• An example hospital has different floors on their hospital. They have created a new field in the Patient Admissions list called “Floor”. Users are given a drop-down box of options for what floor a patient is admitted to. Users would like to know if they can set up Patient Admissions list alerts so that they are only notified when patients are admitted to THEIR floor. SURE THEY CAN!
• First, the appropriate VIEWS need to be created, one for each “floor”. Create 4 new views for: 1 North, 1 South, 2 North, 2 South
• The first view will have a filter of: Show the items when column Floor is equal to 1 NorthCreate the other 3 views with filtering for each of their appropriate floor names

Creating the Alerts.

• On the Patient Admissions list, click and choose
• In the Send alerts for these changes section, choose the very last option called “Someone changes an item that appears in the following view”
• Then, in the drop-down box for that option, choose the name of the floor for which you’d like to receive alerts.
• In summary, any data in any field of your list can be filtered into a View. Alerts can be created based on any *filtered* view, even “Personal” views.

Oh, and another good way to use this feature would be on an Announcements list. Each announcement would have a category, such as the department that the announcement is targeted to. Create a view for each category. This way, your users can set up their own alerts on the announcements list, and choose to only be alerted when a new one is added for their department.

The Best Workflow Tutorials

Just thought I’d let everyone know where I learned everything I know about workflows. This site is friggin awesome, and the tutorials are very detailed. You can tell that this guy, Stephen, put a lot of work into this.
http://office.microsoft.com/en-us/sharepointdesigner/HA102564171033.aspx
Then, just recently, by popular demand, he posted all of the associated files that he used in his demo!!
http://blogs.msdn.com/sharepointdesigner/archive/2009/01/27/visio-diagram-and-site-template-from-office-online-workflow-videos.aspx
It might take half a day, but I recommend that you go through all of his tutorials when you get a chance.

Best Practices: Using Disposable Windows SharePoint Services Objects

Learn best practices to follow when using Windows SharePoint Services objects to avoid retaining the objects in memory in the Microsoft .NET Framework.
Applies to: Windows SharePoint Services 3.0, Windows SharePoint Services 2.0, Microsoft Office SharePoint Server 2007, Microsoft Office SharePoint Portal Server 2003
Contents
Introduction to Using Disposable Windows SharePoint Services Objects
Finding Incorrectly Disposed Objects
Coding Techniques
SPSite Objects
SPWeb Objects
Other Objects That Require Disposal
Conclusion
Additional Resources

Best Practices: Common Coding Issues When Using the SharePoint Object Model

Applies to: Windows SharePoint Services 3.0, Windows SharePoint Services 2.0, Microsoft Office SharePoint Server 2007
Contents
Overview
Using SharePoint Data and Objects Efficiently
Working with Folders and Lists
Writing Applications that Scale to Large Numbers of Users
Using SPQuery Objects
Using Web Controls
Creating Timer Jobs
Conclusion
Additional Resources

SharePoint Developer Tips & Tricks

Tip #1: Adding Intellisense When Editing XML Files in WSS v3 / MOSS 2007
All XML files, or just about every XML file I've run across so far, in Windows SharePoint Services (WSS) v3 & Mirosoft Office SharePoint Server (MOSS) 2007 is validated by SharePoint using the WSS schema file found in the 12 hive: %12HIVE%/TEMPLATES/XML/wss.xsd.
Adding an XML Schema To a Specific File In Visual Studio 2005I think it is fairly common knowledge to most developers that you can specify an XML schema for a specific file in Visual Studio. To do this, when you have the XML file open, go to the Properties toolpane and click on the ellipses for the Schema field select the Add button in the XSD Schemas dialog, browse to the wss.xsd file in the 12 hive (location listed above) and OK out of the dialogs. Click to learn more...

Tip #2: Add Command Line Shortcut to "12 Hive"
I'm not talking about creating a shortcut to the 12 Hive (the directory where just about everything WSS v3 is installed) on your desktop/Quick Launch. Like most people, I create a "12" toolbar on my Start Menu (as shown in the image to the right)... not talking about that either.
When you're in a command prompt, sometimes you need to navigate to the 12 Hive directory. But no one wants to type the directory path to c:\Program Files\Common Files\Microsoft Shared\web server extensions\12. Wouldn't it be easier if you could just type the following to get there?
c:\>cd\c:\>cd %12hive%c:\Program Files\Common Files\Microsoft Shared\web server extensions\12
Here's how u can achieve that:
1. Create a new file called SharePointCommandPrompt.cmd and insert the following text in it (if you're on a 64 bit system, you'll want to make the appropriate changes): @echo offecho Setting 12HIVE environment variable.set 12HIVE="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12""C:\Program Files\Microsoft Visual Studio 8\VC\vcvarsall.bat" x86
2. After saving the file, create a new shortcut with the following target: %comspec% /k ""c:\[Path To The File You Just Created]\SharePointCommandPrompt.cmd""
3. To put a cherry on top, drag the shortcut onto your Quick Launch toolbar... should work like a champ!
To try it out, click the shortcut and type CD %12HIVE% at the command prompt. You should change directories to the root of the 12 Hive.

Tip #3: Access STSADM.EXE From any Directory in a Command Prompt
STSADM.EXE, the main administration utility for SharePoint, is still just a command line utility. You'll find it in %12HIVE%\BIN. To run it, you have to actually be in that directory... an inconvenience to me! Instead, add the directory to the PATH environment variable so you can type STSADM.EXE from any directory on your system. To do this:
1. Start -> All Programs -> Control Panel -> System
2. On the Advanced tab, click the Environment Variables button.
3. Select the variable Path and click the Edit button.
4. Add the following to the end of the Variable value field (don't forget the semicolon... the Path environment variable is a semicolon delimited string of directories):;C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
5. OK out of all the dialogs.
Next time your system restarts, you'll be able to type STSADM.EXE at a command prompt from any directory on your system.
Tip #4: Overcome Save Site Template size limitation in SharePoint
Once I was working with a client and they mentioned that they were trying to save a site template and move it to another server while retaining the content but the size of the site prohibited this. By default there is a 10MB size limitation built in. Something clicked in my head because I recently found a fix that will increase the size limitation to whatever value you want to make it. Type the following using the STSADM utility
stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000
I think its pretty self explanatory with what you can do here… if you have a site that is in excess of 50MB you will use 75000000 or whatever number you come up with. But this is not the recommended practice by Microsoft.

Working with Reporting Services Using Microsoft Sharepoint

There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display the reports stored under SQL Reporting Services on the SharePoint site. Microsoft does provide two Web parts with SQL Reporting Services SP 2. In this section I will share information on using the current web parts provided by Microsoft and then explain what exactly happens behind the scenes to display the report. Click to learn more how???

SharePoint 2007 Maximum Limitations

This will tell you about MOSS-2007 figures and numbers which helps you for better performanc of SharePoint sites.

Workaround for Lookup field in SharePoint list templates

If you have ever tried to save a list as a template that contains a Lookup field for one of the columns, you have undoubtedly discovered that the template once implemented on another site will be unable to properly lookup a field for that column. Instead the column will have to be deleted and recreated for each instance of the list.
Todd Bleeker has posted a cool workaround for this issue that can be used on a singular basis (it is not for solving this problem with custom created list definitions). Thanks Todd!
FULL POST HERE
01. Browse to the source Web's lookup list and choose Modify settings and columns.
02. Copy the source lookup list GUID from the URL.
03. Browse to the destination Web's lookup list and choose Modify settings and columns.
04. Copy the destination lookup list GUID from the URL.
05. Save the source Web's list that contains a lookup column to the lookup list as a list template called [yourlist].stp.
06. Export the list template STP from the source list template gallery to the file system.
07. Rename the [yourlist].stp file to [yourlist].cab so Windows can open it.
08. Open the file, right click on the manifest.xml file and export it to
the file system.
09. Edit the manifest.xml file; find the source Web's lookup list GUID and replace it with the destination Web's lookup list GUID.
10. Save the manifest.xml file.
11. Open a VS.NET command prompt.
12. Run the makecab command as follows:
makecab manifest.xml [yourlist].stp
13. Import the new STP into the destination Web's list template gallery. You will need to delete it if it has previously been imported.
14. Create a new list based upon the new STP file.

The lookup column on the new list should retain all the data that was in
the source list.

Trend Reporting Against a SharePoint List

A programme manager I work with wanted to view trend information regarding the projects in his portfolio. His problem was that weekly reports were all well and good but with around a dozen projects under his wing he could not readily visualise where projected milestone delivery dates were, in general, getting worse or better.
To meet this requirement I knew that we had to create a 'snapshot' record on a regular basis, which would be completed by individual project managers. Some information would need to be recorded each week, with one variable field - the Forecast Date.

Hide/Show Navigation Panel on SharePoint Site

I am very thankful to Paul Grenier for all his articles for using JQuery with SharePoint.

Lot many time User will ask you: I never use that, can’t you just hide it?
Using JQuery, you can reply: Others may need it. I’ll give you check boxes to turn it on and off.

PreSaveAction to EditForm.aspx

The creators of that script added a “hook” for custom validation called PreSaveAction. This function gets called during the submit action but was never defined so we can create our own. We have a simple strategy: identify Tasks surfaced through our Linked Tasks web part and stop the submit action if Issue status = ‘Closed’ and number of Tasks > 0. Translating that “simple” logic into javascript takes patience and testing. Add the PreSaveAction to the EditForm.aspx page

Data View WebPart example

Although, the Data View Web Part is not part of the Web part galleries via WSS or MOSS, it is nonetheless one of the most important and useful webparts available. Just recently I had a real world business request and the DVWP came in handy.
Pat Iovanella has provided very nice example on that

Email and SharePoint Designer Workflow

Many business workflow scenarios call for us to send an email at different parts of the process.
Like many things with SharePoint Designer workflow, this is relatively easy to accomplish, but is sometimes harder than it would seem. In this article two tricky scenarios were addressed

Porting WorkFlow from One List to Another List

Every first-time SharePoint Designer workflow author faces this problem:
Design a workflow solution.Create a new workflow solution.Test it.Gain user acceptance and sign off.
At this point, everything is going swimmingly until it’s time to … 5. Move to production … full stop.Today, there is no End User friendly way to move a functioning SharePoint Designer workflow solution from

Porting a Simple SharePoint Designer Workflow One List to AnotherOverviewThis tutorial style article describes how to port a SharePoint Designer workflow from one list to another. It assumes a business case where we want to move a dead simple workflow from a development environment to a production

Searching Site Collections Using a Tabbed Search Center

It is now time to put all of our resources together to build a more complex search center that can be used to search multiple team sites housed in their own site collections. You will need to have MOSS standard edition to complete all of these steps.
Since this is a project needed to accomplish within his organization, Chris Quick had documented the steps as he complete them himself!

Employee of The Day Slide Show

Some time very clear and easy requirement pinch us for developing a new webpart as lake of knowledge of all the OOB WebParts or some don't care attitude caused that.
The requirement I came across is showing the employees on the portal's home page.
We found the easy steps to do that.

1. Convert each slide to a .jpg image (can be done very easily using PowerPoint 2007)
2. Create a Picture Library named ‘Meet the Team’
3. Upload the images to the ‘Meet the Team’ library
4. Move to the page where you would like the slide show link created
5. Insert the ‘This Week in Pictures’ web part onto the page
6. Modify the Shared Web Part
7. Change Image Library Name from “This Week in Pictures Library” to “Meet the Team”

Customized views of a SharePoint Survey

This article try to mitigate the problems around survey views. It has documented two techniques: one describes how to surface data using just the UI; the other shows you an easy way to add a view using SharePoint Designer (SPD).

Dynamic Loading of Content on Mouse Hover

Few lists on your page and a central Preview Pane, you can display a variety of content without clicking the mouse.
If you have SPD, you can make your own simple ASPX pages then link to them so you can load them dynamically in your pages. The possibilities are endless, have fun with this one!
Click “Read more” for setup instructions and the code sample…

Display Preview Pane for Calendar View

Many of our basic “tools” are missing from the Calendar View. The preview pane works great on other lists, so this little ditty gives you one for the Calendar too.

To make this work, place the Calendar in a large Web Part Zone–large enough to display the Calendar View, edit the view on the web part (it will default to a list). Place this code snipped in a Content Editor Web Part to the side, in the smaller zone.

How to Display SharePoint Blog Post Archives

Most blog engines allow you to display a list of blog posts grouped by month. Unfortunately out of the box SharePoint blog sites do not give you that ability. Here is a simple solution on how to overcome that limitation.
Please note that it only works with the default SharePoint Blog site template.

Accordion-style left navigation menu for SharePoint Sites

If you can copy/paste, you can see it in action. Since I used Google’s API to load jQuery, you don’t even need to download the library file.
First, look at your left nav. If you changed it from the out-of-the-box setup, make sure you have “headers” and “submenus” that make sense. Click to get the more idea on this...

Visual Indicators for the Masses: KPIs in WSS

All of us must measure something in order to see if we are meeting our goals. They can be financial goals, customer satisfaction goals, or amount of work done measurements. KPIs (Key Performance Indicators) are a way to quickly gauge how you are doing, not by having to go through and analyze measurements through a spreadsheet, but through some simple visual indicators.
Putting KPIs into your dashboard allows you and your team to get an immediate view into how you are doing on your goals and measurements.

SharePoint comes with really cool web parts for presenting key performance indicators, but these are only available in the Enterprise edition. If you are running Windows SharePoint Services or SharePoint Server Standard, it is not available.

The only limitation of this concept is that you can only build KPIs on top of data stored in SharePoint lists.