SharePoint Diary

How to make Dataview Web Part Portable?

February 27, 2012 Backup/Restore, SharePoint, Tips and Tricks

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

February 27, 2012 Branding, Master Page, SharePoint, 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

February 26, 2012 Admin Reports, Administration, CSV, SharePoint, Workflows

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

February 24, 2012 SharePoint, SQL Server

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

February 23, 2012 PowerShell, SharePoint

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

February 19, 2012 Admin Reports, CSV, SharePoint, SharePoint 2007, SharePoint 2010, Version History

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

February 17, 2012 PowerShell, SharePoint, SharePoint 2007, SharePoint Online, Tips and Tricks

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

February 17, 2012 Deployment Guides, Sandboxed solutions, SharePoint, 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."

February 17, 2012 Errors, Known Issues, Quotas and Locks, Sandboxed solutions, SharePoint

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

February 16, 2012 SharePoint, SharePoint 2010, SharePoint Development

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

February 15, 2012 SharePoint, Tips and Tricks

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

February 15, 2012 Admin Reports, Architecture / Planning, C#, CSV, Object Model, SharePoint, SharePoint Development

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

February 14, 2012 SharePoint, Tips and Tricks, Web Parts

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

February 13, 2012 Known Issues, SharePoint

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

February 13, 2012 Integration, SharePoint, SharePoint 2010, Utilities

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?

February 12, 2012 Alerts, Known Issues, SharePoint, 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

February 10, 2012 Search, SharePoint, SharePoint 2010

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

February 08, 2012 Alerts, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, 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

February 08, 2012 Architecture / Planning, SharePoint, SharePoint 2010, SharePoint Development

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

February 07, 2012 Quotas and Locks, SharePoint, SQL Server, Troubleshooting, web.config

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

February 07, 2012 SharePoint, 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

February 02, 2012 Known Issues, SharePoint

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

February 02, 2012 Reference, SharePoint, SharePoint 2010, Tips and Tricks

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 …

Disclaimer