Thursday, December 29, 2011

BackUp and Restore sites using PowerShell

Site Collection:

Backup-SPSite http://server_name/sites/site_name -Path C:\Backup\site_name.bak

Restore-SPSite http://server_name/sites/site_name -Path C:\Backup\site_name.bak -Force


Export-SPWeb http://site –Path C:\site_name.cmp

Import-SPWeb http://site –Path C:\site_name.cmp –UpdateVersions -Overwrite

Wednesday, December 21, 2011

Change the 'Add new' link in document library

  • First find the ID of the <a> tag.. then
  • Add the following code to the current page either using SharePoint designer or by adding a Content query webpart
         document.getElementById("<id of the control>").innerHTML="Sample Text"

Progress Bar for Tasks List in SharePoint 2010

Progress Bar for Tasks List in SharePoint 2010

Now we are going to see how to show the progress of tasks in SharePoint

We are going achieve this with the help of Calculated Columns.

The [% Complete] is a default column in tasks lists. We just need to add – in a calculated column - the formulas for this specific use case. Here they are:

Progress Bar 1 :

=”<DIV style=’background-color:blue; width:”&([% Complete]*100)&”%;’>&nbsp;</DIV>”

Progress Bar 2 :

=”<DIV style=’background-color:red;’><DIV style=’background-color:LimeGreen; width:”&([% Complete]*100)&”%;’>&nbsp;</DIV></DIV>”

Progress Bar 3:

="<DIV style=’position:relative;padding-top:2px;
border:1px solid Gainsboro; background-color: "
&CHOOSE(RIGHT(LEFT(Priority,2),1), "LightSalmon", "LemonChiffon", "Chartreuse")&";’>
<DIV style=’margin:0;padding:0;font-size:0px;border-top:12px solid "
&CHOOSE(RIGHT(LEFT(Priority,2),1),"Crimson","orange","green")&"; width:"
&IF(Status="Not Started","1%",
IF(Status="Completed","100%",TEXT([% Complete],"0%")))&";’></DIV>
<DIV style=’position:absolute; top:2px;left:2px;’>"
&IF(Status="Not Started","0%",IF(Status="Completed","100%",TEXT([% Complete],"0%")))&"

Note: the &nbsp; character is mandatory to make this work in Firefox.

Once you have done this, your tasks list looks like this

To achieve our expected result, we have to do one more thing

Add a HTML Form Web Part and enter the below script


<script type="text/javascript">
if(typeof jQuery=="undefined"){
var jQPath="";
document.write("<script src='",jQPath,"jquery.min.js' type='text/javascript'><\/script>");

<script type="text/javascript">

var tempDIV = document.createElement ("DIV"); = "pointer";
tempDIV.innerHTML = $(this).text();


Now your SharePoint List look like


It works now,  you can do many more things using jQuery and Calculated column.

If you are looking for other colors, here is a very good reference:

do let us know your experience with this post.

Monday, December 19, 2011

Data Connection Exceeded Maximum Limit Error in InfoPath 2010 Browser Form

  • Open the SharePoint 2010 Central Administration,
  • Go to General Application Settings => Configure InfoPath forms services
  • Change the Data connection response size.

Error : Exceeds the list view threshold

  • Open the SharePoint 2010 Central Administration,
  • Go to Application Management => Manage Web Applications
  • Then select your web application
  • In the Ribbon, select the General Settings => Resource Throttling
  • There you can see the threshold limit 5000, edit the value as you need and save it.

How to launch a document by clicking a link to the file?

Word: <a href='ms-word:ofe|u|path/to/web/word/document.docx'>Link to document</a> Excel: <a href='ms-excel:o...