How to make Dataview Web Part Portable?

When working with SharePoint DataView Customizations, by default you can not just copy paste the data view pages into new environment or even restore them from backup. This is because: The Data View Web Part uses List ID instead of List Name. So, How to make the Dataview Portable from one envi…

Building Branding Solution with Feature Stapler for SharePoint 2007

Feature Staplers are the best way to build branding solutions in SharePoint. Once deployed branding will be automatically applied based on Site definition. Overall Steps: Create a WSP Project and add 2 features in it. One for actual Branding with Feature handler code - Applies Branding on ac…

Workflows Inventory Report for SharePoint

Requirement from my CIO: Salaudeen, Get me a SharePoint Workflows Report with Total No. of workflows wherever its running, for our intranet SharePoint site with Site Name, List Name, Workflow Name, and No. of Instances, etc. Solution: As usual dive into the object model code (This can be achi…

What is my SQL Server Version, Service Pack, Edition

Requirement: Wanted to check the installed SQL Server version service pack level. SELECT @@version ? It didn't give me the Service pack information. Query to Check SQL Server version, Service pack and Edition: SELECT SERVERPROPERTY('productversion') [Product Version], …

Install PowerShell in Windows 2003

Need PowerShell in Windows 2003?  Install "Windows Management Framework core" which includes Windows PowerShell 2.0. You need to have SP2 or later in Windows 2003. Go the KB: http://support.microsoft.com/kb/968929 , download and install the appropriate KB for your environment (such a…

Version History Size Report for Entire SharePoint Web Application

Ever wanted to get a report on versioning sizes on SharePoint? Unlimited No. of versions enabled in various document library across web application. As part of regular auditing, wanted to generate report for the entire web application ,with Number of versions, Amount of storage consumed by versio…

Using owssvr.dll to retrieve List data in XML format

Owssvr.dll is a traditional Remote Procedure Call method to remotely invoke functions in SharePoint. It can be used to retrieve data from SharePoint list as well. syntax: http://sharepoint.com/_vti_bin/owssvr.dll?Cmd=Display&List=<<LIST-GUID>>&XMLDATA=TRUE E.g. https://i…

How to Deploy and Activate Sandboxed Solutions in SharePoint 2010

Sandboxed solutions brings the benefit of deploying solutions to SharePoint Server without affecting any other process outside the sandbox. SharePoint 2010 Sandboxed solution can be deployed by Site collection administrators. Here is the guide on How to Deploy and activate sandboxed solution in …

Fix "The site collection containing this sandboxed solution has exceeded its daily resource usage quota."

When trying to activate a sandboxed solution, Got below error message: "The site collection containing this sandboxed solution has exceeded its daily resource usage quota." Solution:  This is because of the Sandbox solution resource limit. To fix this issue, just increase the site …

Create List Instance Feature for SharePoint 2010 in Visual Studio

Requirement:  Create a new Link list with pre-populated list items as a feature based solution. Steps: 1. Lets create a SharePoint 2010 list instance feature with Visual Studio. Create a New Empty SharePoint Project , Give it a name, I've named it as Crescent.Portal.DashboardLinks 2. …

Get the List Settings Page of any List

Problem: There was a List in a site collection without any tool bars (They were removed purposefully). Had to change some columns in the list. Since the toolbar is disabled, could not get into : List settings from SharePoint Interface. Solution: For user created lists, the simplest way is, n…

Find Large Lists & Generate Report in SharePoint

Requirement: SharePoint was running with serious performance issues and wanted to get the report, where more than 2000 items stored in List/Library for the entire web application. When users store a large number of items in List or Library, SharePoint will definitely run into serious performanc…

Copy Webpart Pages between SharePoint Site Collections

Had a requirement to copy web part pages from one site collection to other. These options failed, I got the page with out any web parts placed: Explorer view copy paste Download a copy and upload SharePoint Designer copy-paste The worked trick is: Using SharePoint Designer - "New from…

Assembly microsoft.sharepoint.intl.dll security permission grant set is incompatible between appdomains

Suddenly, SharePoint 2003 site gave an error :  " Assembly microsoft.sharepoint.intl.dll security permission grant set is incompatible between appdomains " when trying to add users to the site. Fix:   Ran an IISRESET fixed the problem!

Playing Videos in SharePoint using JWPlayer

Requirement :  To play a .MOV video file in SharePoint site. Solution: Used the JWPlayer in SharePoint. Here are the detailed steps. Step 1:  Download the JWPlayer files from http://www.longtailvideo.com/jw/upload/mediaplayer-viral.zip Extract and open the jwplayer.js file, Search for  /j…

"Alert me" Missing in SharePoint 2010?

In an odd case, received complaints from users "SharePoint alert me missing!". Usually "Alert me" link will be there under documents tab of the SharePoint 2010 Ribbon. End-Users were unable to get "Alert me" link. W hen I checked, Yes, alert me button missing in Sha…

SharePoint Search Scope Force Update

After updating SharePoint Search Scope, it said: wait 14 Minutes to update. How to instantly update the scopes? Do we have to wait for 14 Minutes? Is there a  way to force SharePoint search scope update on-demand? Definitely, Yes! We can force update SharePoint 2010 search scope. Just go back to…

SharePoint Alert Notifications Not Working - Checklist for Troubleshooting

Before proceeding with the checklist, analyze and isolate the issue: Whether E-mail Infrastructure is working on your environment Whether in all SharePoint web applications alerts are not working? SharePoint alerts not working for one site? SharePoint alerts not working after upgrade or migr…

SharePoint Topology for 5000 users - Virtual

Had a requirement to provide SharePoint 2010 Topology for 5000 intranet users. End-users will be using SharePoint 2010's collaboration features, Nintex workflows with SQL Server Reporting services and the Management wants to go for Visualization as it reduces the Cost! Here goes my recommen…

"Unable to complete this operation. Please contact your administrator" Error when trying to upload a file in SharePoint

I was troubleshooting an issue with uploading files to SharePoint Site. When I tried uploading a file to the document library, I got this error: "Unable to complete this operation. Please contact your administrator" Enabled Stack Trace and Disabled Custom error tags in web.config …

Find Remaining of Days in XSL

Scenario: I have a List for keeping track of my Outsourced resources with fields: Resource Name, Skills, Contract Start Date, End Date, etc. What I want is: Display the No.of remaining days in a page. So Added a calculated field , applied the formula : =IF(Today>=[End Date],0,INT([To Date]-…

Unable to upload files or add users. Receiving HTTP 403 Forbidden error

Users were unable to upload files or add users to SharePoint sites. Moreover they received  HTTP 403 Forbidden error message when trying to upload or add users. Fix: This is a known issue and needs the hot fix http://support.microsoft.com/kb/934793/ applied on the server! In some cases,…

"New" Icon Indicator in SharePoint - Disable, Replace, Set Duration

Lot of folks asking me on SharePoint " ! New " Indicator. By default SharePoint 2007/2010 shows " ! New" Indicator for 2 days from the creation of an List item/document. It simply indicates it's newly added content such as document or list item! How to Replace New tag …