SharePoint Sandeep

Powershell to update multiple items with specific condition

noreply@blogger.com (Sandeep) — Thu, 12 Feb 2015 11:45:00 +0000

Scenario:
Client wanted to restructure the data and wanted to update all the items in a list with particular value to a new value.

Solution:
Quick PS script did the magic

Code:

cls

#Load SharePoint Snap In
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

function xUpdateAll-SPItems
{  
 param ($Url, $ListName,$ColumnName,$OldValue,$NewValue) 

$web = Get-SPWeb $Url 
$list = $web.Lists.TryGetList($ListName)

$items = $list.Items
foreach ($item in $items)
{
    $existingValue  = $item[$ColumnName]
    If($existingValue -eq $OldValue)
    {  
       Write-Host "Updating item : " + $item.ID      
     
        $item[$ColumnName] = $NewValue
        $item.Update()     
     }     
}  

 $web.Dispose()
 Write-Host "Updated all items successfully" -foregroundcolor Green  
 
}


#$url=Read-Host "Enter site url"
#$listName=Read-Host "Enter list library name"
#$columnName=Read-Host "Enter column name"
#$oldValue=Read-Host "Enter old value"
#$newValue=Read-Host "Enter new value"

$url="http://server:37788"
$listName="mylist"
$columnName="Column Name"
$oldValue="Bad Value"
$newValue="Other"


xUpdateAll-SPItems $url $listName $columnName $oldValue $newValue

Article:

Search display templates not present on site collection

noreply@blogger.com (Sandeep) — Tue, 27 May 2014 07:38:00 +0000

Scenario:
When you configure a Search Result via CA, you might see the following error in the Preview panel:

The Search display templates are not present on this site collection. To add them, you need to activate the "Search Server Web Parts and Templates" feature on the Site Collection Features page.

Solution:
Open up the SharePoint 2013 Management Shell as Administrator and run the following command:

Enable-SPFeature SearchWebParts -url http://central_admin_url

SharePoint Powershell Create a new list with different column types

noreply@blogger.com (Sandeep) — Fri, 17 May 2013 08:38:00 +0000

Scenario:
Murali ( my collegue ) was looking for a quick script to create a list using PS with diff columns types.

Solution:
PS - Love it - Google + little brain - recipe ready

Code:

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell
 
try 
{
 
$TestSiteUrl = "http://extranet.contoso.com" #provide site url in this variable
 
$ListName = "KPIConfigList"   #listName

$ListDescription = "KPI config list" #list description
 
$myTestWeb = Get-SPWeb -identity $TestSiteUrl   #Get web object
 
$listTemplate = [Microsoft.SharePoint.SPListTemplateType]::GenericList  #GenericList template
 
write-host "Adding list" $ListName
 

$myCustomList = $myTestWeb.Lists[$ListName]
 
if($myCustomList -eq $null) 
{
 
  $lstId = $myTestWeb.Lists.Add($ListName,$ListDescription,$listTemplate)
 
  $myCustomList = $myTestWeb.Lists[$ListName]
 
    #Add columns
 
    $spFieldType = [Microsoft.SharePoint.SPFieldType]::Text 

    $myCustomList.Fields.Add("TextField",$spFieldType,$false)

   #Add columns    
    $spFieldType = [Microsoft.SharePoint.SPFieldType]::Number 

    $myCustomList.Fields.Add("Order",$spFieldType,$false)

   #Add columns
    $spFieldType = [Microsoft.SharePoint.SPFieldType]::Boolean 

    $myCustomList.Fields.Add("IsDefault",$spFieldType,$false)

   #Add columns
    $choices = New-Object System.Collections.Specialized.StringCollection 

    $choices.Add("Client") 

    $choices.Add("Unit")

    $spFieldType = [Microsoft.SharePoint.SPFieldType]::Choice 

    $myCustomList.Fields.Add("Type",$spFieldType,$false,$false,$choices) 
     
    #Update
    $myCustomList.Update()
 
 write-host "List created successfully" $ListName
 
}
 
else
{ 
  write-host "List already exists" $ListName 
} 
}
 
catch
{ 
  write-host "Error" $_.exception
 
  $errorlabel = $true
 
}
 
finally
{
 
  if($myTestWeb -ne $null)
 {$myTestWeb.Dispose()}
 
  if($errorlabel -eq $true){exit 1}
 
  else {exit 0}
 
}exit 0

Article:
Other column types
Powershell

SharePoint test user creation

noreply@blogger.com (Sandeep) — Fri, 08 Mar 2013 05:40:00 +0000

Scenario:
We often need local test users, need to be created in Active Directory and also get them added to SharePoint site.

Solution:
Though of sharing what I use :)

Code:

clear

$user = "test.user1"
$userWithDomain = "contoso\"+$user

Import-Module activedirectory
New-ADUser -Name $user -AccountPassword (ConvertTo-SecureString "somepass" -AsPlainText -force) -Enabled $True -PasswordNeverExpires $True -PassThru 


Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

New-SPUser -UserAlias $userWithDomain -Web http://sp2010 -Group "Team Owners"

Powershell Test Data for Record Center

noreply@blogger.com (Sandeep) — Thu, 07 Feb 2013 10:10:00 +0000

Scenario:
Wanted to do a load test on Record Center with my custom solution. I wanted to have 100 record libraries with 100 folder each.

Solution:
Powershell script can do it in few minutes

Code:

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

[Void][System.Diagnostics.Stopwatch] $sw;
# New Stopwatch object
$sw = New-Object System.Diagnostics.StopWatch;
# Stop any watches that might be running
$sw.Stop();                                         
$sw.Start();

# Initialization
$webUrl = 'http://recordcenter'
$libCount = 1;
$folderCount = 1;
$libraryName = "Record Library" + $libCount
$frontSlash = "/"
$web = Get-SPWeb $webUrl;
$listTemplate = $web.ListTemplates | Where-Object {$_.Name -eq "Record Library"}
#Create folders 
(1..100)|%{
      $libraryName = "Contract Library" + $libCount                         
      write-host "Creating Record library: " $libraryName                                      
      $web.Lists.Add($libraryName,"Record Library",$listTemplate);
       $libCount  = $libCount + 1;
       [string]$howlong0 = $sw.Elapsed.ToString();  # How long
       Write-Host "Library Ready (Time ): " $howlong0 -F Green;
        $spDocumentLibrary = $web.Lists.TryGetList($libraryName)
                    (1..1000)|%{
                    write-host "Adding Folder in library: " $libraryName
                    $folderName = "Folder" + $folderCount
                 $spFolder = $spDocumentLibrary.AddItem("",[Microsoft.SharePoint.SPFileSystemObjectType]::Folder,$folderName) 
                 $spFolder.Update()
                    $folderCount = $folderCount+1
                   [string]$howlong0 = $sw.Elapsed.ToString();  # How long
                    Write-Host "Folder Ready (Time ): " $howlong0 -F Green;
                    }
}

$web.Dispose()
$sw.Stop();    # Stop the timer
[string]$howlong = $sw.Elapsed.ToString();   # How long
write-host "Done (Time ): " $howlong -F Green;

SharePoint popup how to

noreply@blogger.com (Sandeep) — Sun, 03 Feb 2013 16:33:00 +0000

Scenario:
I planned to use SharePoint popup in client project.

Solution:
I did a quick POC and here's what you need to do to make it work.

What goes in Parent Window Header ?
Add following JavaScript in the header section :

function OpenMyWebPage(popupTitle, popupUrl) {
        var options = {
            url: popupUrl,
            autoSize: true,
            showClose: true,
            title: popupTitle,
            dialogReturnValueCallback: function (dialogResult) {
                if (dialogResult == SP.UI.DialogResult.OK) {
                    window.document.location.reload(true);
                }
            }
        };
        SP.UI.ModalDialog.showModalDialog(options);
    }

How to launch the Popup

Edit

What goes in Popup Window - Save button at the end ( to refresh the parent window )

Context.Response.Write("<script type='text/javascript'>window.frameElement.commitPopup();</script>");
           Context.Response.Flush();
           Context.Response.End();

What goes in Popup Window - Cancel button

Nothing is needed here

Hidding Ribbon - Add at the end , in case you dont want to display ribbon

Power-shell to check-in files

noreply@blogger.com (Sandeep) — Sat, 26 Jan 2013 20:14:00 +0000

Scenario:
During bulk migration, lot of files left checked out because of lack of metadata. We wanted to check-in all these files. Also we want to restrict the script to only "Record Libraries" in record center.

Solution:
Power-shell

Code:

Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

$rand = new-object System.Random

function CheckInDocument([string]$url)
{

$spWeb = Get-SPWeb $url
$SPBaseTypeDocumentLibrary = [Microsoft.SharePoint.SPBaseType]::DocumentLibrary
$lists = $spWeb.GetListsOfType($SPBaseTypeDocumentLibrary);

foreach ($list in $lists)
{
    if ($list.Hidden -eq $False -and $list.BaseTemplate.ToString() -eq "1302")
    {
        Write-Host Checking in documents from Library : $list.Title
        $getFolder = $spWeb.GetFolder($list.Title)
        $files = $list.CheckedOutFiles

        write-host "Total Checked Out Files : " $files.Count

        $list.CheckedOutFiles | Where { $_.CheckOutStatus -ne "None" } |
        ForEach {
            $_.TakeOverCheckOut();
            #$docItem = $list.GetItemById($_.ListItemId);
            #$docItem["Field To Update"] = "Some value";
            $docItem.SystemUpdate();                    
            $docItem.File.CheckIn("Checked In By Administrator");
            Write-Host "$($docItem.File.Name) Checked In" -ForeGroundColor Green

            }
    }
}

$spWeb.Dispose()


}

CheckInDocument http://sp2010

Article:

Refresh GAC using Powershell

noreply@blogger.com (Sandeep) — Sat, 26 Jan 2013 18:35:00 +0000

Scenario:
Refreshing GAC is always a painful thing.
Do IISReset / remove old stuff / put new one. Can we automate it ?

Solution:
Certainly.. mighty power-shell can do it easily

If you are running on new machine - you might need to relax executing policy

Set-ExecutionPolicy Unrestricted

Code:

iisreset /stop

Set-Alias Gacutil "C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\bin\gacutil.exe"

Gacutil /uf EntLibContrib.Data.OdpNet
Gacutil /i "MS ENT dlls\EntLibContrib.Data.OdpNet.dll"

Gacutil /uf Microsoft.Practices.EnterpriseLibrary.Caching
Gacutil /i "MS ENT dlls\Microsoft.Practices.EnterpriseLibrary.Caching.dll"

Gacutil /uf Microsoft.Practices.EnterpriseLibrary.Common
Gacutil /i "MS ENT dlls\Microsoft.Practices.EnterpriseLibrary.Common.dll"

Gacutil /uf Microsoft.Practices.EnterpriseLibrary.Data
Gacutil /i "MS ENT dlls\Microsoft.Practices.EnterpriseLibrary.Data.dll"

Gacutil /uf Microsoft.Practices.EnterpriseLibrary.Logging
Gacutil /i "MS ENT dlls\Microsoft.Practices.EnterpriseLibrary.Logging.dll"

Gacutil /uf Microsoft.Practices.ServiceLocation
Gacutil /i "MS ENT dlls\Microsoft.Practices.ServiceLocation.dll"

Gacutil /uf Microsoft.Practices.Unity.Configuration
Gacutil /i "MS ENT dlls\Microsoft.Practices.Unity.Configuration.dll"

Gacutil /uf Microsoft.Practices.Unity
Gacutil /i "MS ENT dlls\Microsoft.Practices.Unity.dll" 

Gacutil /uf Microsoft.Practices.Unity.Interception.Configuration
Gacutil /i "MS ENT dlls\Microsoft.Practices.Unity.Interception.Configuration.dll"

Gacutil /uf Microsoft.Practices.Unity.Interception
Gacutil /i "MS ENT dlls\Microsoft.Practices.Unity.Interception.dll" 

Gacutil /uf Telerik.Web.Design
Gacutil /i "Telerik.Web.Design.dll"

Gacutil /uf Telerik.Web.UI
Gacutil /i "Telerik\Telerik.Web.UI.dll" 

Gacutil /uf Telerik.Reporting
Gacutil /i "Telerik\Telerik.Reporting.dll"

Gacutil /uf Telerik.Web.UI.Skins
Gacutil /i "Telerik\Telerik.Web.UI.Skins.dll"

iisreset /start

Event receiver with Elevated Privileged

noreply@blogger.com (Sandeep) — Tue, 15 Jan 2013 06:32:00 +0000

Scenario:
Client wanted to run the event receiver code with elevated access.

Solution:
Using Elevated Privileged is one option but better options was using System User Token
Code:

/// 
        /// An item is being added.
        /// 
        public override void ItemAdding(SPItemEventProperties properties)
        {
            SPSite site = properties.Web.Site;
            SPUserToken sysToken = site.SystemAccount.UserToken;
            site.Dispose();

            using (var systemSite = new SPSite(properties.SiteId, sysToken))
            {
                using (SPWeb sysWeb = systemSite.OpenWeb(properties.Web.ID))
                {
                       // Code goes here 
                }
            }

Powershell to hide fields from edit form

noreply@blogger.com (Sandeep) — Fri, 14 Dec 2012 07:48:00 +0000

Scenario:
We build a small solution for our client.
Solution had a custom UI for all CRUD operations and client want to block everyone from editing the list using Edit Form.

Solution:
While there can be many ways, considering site is running perfectly in PROD, writing a quick power shell will be enough.

Code:

cls
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

$webUrl = "http://sp2010/siteX"
$web = Get-SPWeb $webUrl
$list = $web.Lists.TryGetList("Tasks")

$fieldDisplayNames = "Status","Priority"
$showFields = $false 

$fieldDisplayNames |foreach {
 
$spfield = $list.Fields[$_]
$spfield.ShowInEditForm = $showFields
$spfield.Update()

}

Article:

SharePoint programatically apply claims

noreply@blogger.com (Sandeep) — Fri, 21 Sep 2012 15:43:00 +0000

Scenario:
Claim based authentication is way to go if you want to have dynamic roles for user based on certain attribute of an item/document. But question is how to apply a claim to the item :)

Solution:
Sample code
Code:

using System;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration.Claims;

namespace SKN
{
    class Program
    {
        static void Main(string[] args)
        {
            int i = 0;
            using (SPSite site = new SPSite("http://intranet/Sites/LoadTest"))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPList list = web.Lists.TryGetList("Shared Documents");
                    SPView view = list.Views["Missing Claims"];
                    SPQuery query = new SPQuery(view);
                   
                    foreach (SPListItem item in list.GetItems(query))
                    {
                        i = item.ID;
ApplyClaims(web, item, true, "0000" + item.ID.ToString(), true,"Myclient");
                    }
                }
            }

            Console.Write(i);
            Console.ReadKey();
        }

        /// 
        /// Applies claims to the item.
        /// 
public static void ApplyClaims(SPWeb web, SPListItem item,string claimValue , string client)
        {
            item.BreakRoleInheritance(false);

            SPClaimProviderManager claimMgr = SPClaimProviderManager.Local;
            if (claimMgr != null)
            {
               SPClaim claim = new                               SPClaim(Microsoft.IdentityModel.Claims.ClaimTypes.Role,
               claimValue,
Microsoft.IdentityModel.Claims.ClaimValueTypes.String,
SPOriginalIssuers.Format(SPOriginalIssuerType.TrustedProvider, client));

                string userName = claimMgr.EncodeClaim(claim);

                // SPUser spUser = web.EnsureUser(userName);
                SPUserInfo info = new SPUserInfo
                {
                    LoginName = userName,
                    Name = claimValue 
                };

                SPRoleAssignment roleAssignmentClaim = new SPRoleAssignment(info.LoginName, info.Email, info.Name, info.Notes);
                roleAssignmentClaim.RoleDefinitionBindings.Add(web.RoleDefinitions["Read"]);
                item.RoleAssignments.Add(roleAssignmentClaim);
            }
        }

        /// 
        /// Adds the role assignment.
        /// 
        /// The item./// The role assignment.public static void AddRoleAssignment(SPListItem item, SPRoleAssignment roleAssignment)
        {
            bool isNotFound = true;
            foreach (SPRoleAssignment roleAssign in item.RoleAssignments)
            {
                if (roleAssign.Equals(roleAssignment))
                {
                    isNotFound = false;
                    break;
                }
            }

            if (isNotFound)
            {
                item.RoleAssignments.Add(roleAssignment);
            }

            item.SystemUpdate();
        }
    }
}

SharePoint Powershell Test Data script

noreply@blogger.com (Sandeep) — Fri, 14 Sep 2012 07:29:00 +0000

Scenario:
Working on a project and we need to test the software limit of SharePoint 2010.
MS Documentation is not clear about things/ community blogs have different experience.
So without taking chance, here a small script to create test items

Solution:
Powershell script

Code:

cls
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell

$webUrl = Read-Host 'Please specify site url'
$web = Get-SPWeb $webUrl;
$list = $web.Lists.TryGetList("Announcements");
(1..50000)|%{
$item = $list.Items.Add();
$item["Title"]="Test";
$item.Update();
# Optional 
# $item.BreakRoleInheritance($True);
$item.ID
}
$web.Dispose()

Cannot start the conversion job because it does not contain any files.

noreply@blogger.com (Sandeep) — Wed, 05 Sep 2012 05:40:00 +0000

Scenario:
While working with a small POC. I encountered a weird error.
Cannot start the conversion job because it does not contain any files.

Solution:
Error was coming when I was trying to convert all files of a document library from word to pdf.

I googled the error - but no luck , so thought of posting once I found the fix.

I read error and as per the message there are no files in the library.
I validated and there were files in there. So what could be it :)

Permission.
I checked the account running the Word Automation Service and gave "Contribute" access the account. That was it.

Quickly identifying claim based site

noreply@blogger.com (Sandeep) — Sun, 26 Aug 2012 11:39:00 +0000

Scenario:
I love user group as you get question from every angle. I got a very simple question from one of the user. How do I know my site is already configured for claims ?

Solution:
If you login to your site and click on My Settings from Welcome menu , you will see clean Account name , with no weird characters :)

If claims is enabled you will see something like this. Notice those weird characters as prefix to account name.

Article:
In case you want to switch from Classic > Claims based or vice-versa, you can use my old article Enable Claim Based Authentication for existing web application

Powershell exporting user profile information

noreply@blogger.com (Sandeep) — Thu, 23 Aug 2012 14:26:00 +0000

Scenario:
I was asked by my client to export User Profile data into Excel.

Solution:
Answer was Powershell. I googled and found a good script to start with, I just added few more things and tested it. Here's the script

Code:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$siteUrl = "http://sp2010"
$outputFile = "C:\UserProfiles.csv"

$serviceContext = Get-SPServiceContext -Site $siteUrl
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($serviceContext);
$profiles = $profileManager.GetEnumerator()

Write-Host "Exporting profiles" 

$collection = @()
foreach ($profile in $profiles) {
 
  $profileData = "" | select "AccountName","FirstName", "LastName","PreferredName","WorkPhone"
   $profileData.AccountName = $profile["AccountName"].Value
   $profileData.FirstName = $profile["FirstName"].Value
   $profileData.LastName = $profile["LastName"].Value
   $profileData.PreferredName = $profile["PreferredName"].Value
   $profileData.WorkPhone = $profile["WorkPhone"].Value
   $collection += $profileData
}

$collection | Export-Csv $outputFile -NoTypeInformation

Article:
User Profile export

ASP.Net Dynamic controls missing after postback

noreply@blogger.com (Sandeep) — Tue, 14 Aug 2012 14:17:00 +0000

Scenario:
One of the fresher on my team had trouble with dynamic controls. Controls were added during a button click and were missing from UI as soon as another button is clicked on the page ( basically any other post back happens )

Solution:
Actually its by design, once page post back happens , data is saved in viewstate for dynamic controls also but dynamic controls will not be repainted. You will have to recreate in Page_Init or Page_Load.Here's a small sample which works.

Code:

using System;
using System.Web.UI.WebControls;

namespace SKN.TestDynamicControl{   

public partial class _Default : System.Web.UI.Page    
{        public int controlCount
        {
            get
            {
                if (null != ViewState["controlcount"])
                {
                    return (int)ViewState["controlcount"];
                }
                else
                {
                    return 0;
                }
            }
            set
            {
                if (null != ViewState["controlcount"])
                {
                    ViewState["controlcount"] = value;
                }
                else
                {                    ViewState.Add("controlcount", value);
                }
            }
        }        
        protected void Page_Load(object sender, EventArgs e)
        {
            for (int i = 0; i < controlcount; i++)
            {
                TextBox txt = new TextBox();
                txt.ID = "txt" + i;
                txt.Text = "Text" + i;
                pnlPlace.Controls.Add(txt);
            }
        }
        
        protected void Button1_Click(object sender, EventArgs e)
        {
            controlcount = 5;
            for (int i = 0; i < controlcount; i++)
            {
                TextBox txt = new TextBox();
                txt.ID = "txt" + i;
                txt.Text = "Text" + i;
                pnlPlace.Controls.Add(txt);
            }
        }
        protected void btnAdd_Click(object sender, EventArgs e)       {            
            string values = string.Empty;
            foreach (var item in pnlPlace.Controls)
            {
               if (item is TextBox)
               {
                    values += "," + (item as TextBox).Text;
                }
            }
            Response.Write(values);
        }
    }
}

SharePoint sub site branding fix

noreply@blogger.com (Sandeep) — Mon, 02 Jul 2012 09:46:00 +0000

Scenario:
Wanted to blog this long back - but :)
At times, SharePoint is very weird. Here's a situation. Client have customer master page , he applied to Root Site and also check the option to apply it to all the sub-sites. All good so far.
No what if client create a new sub-site in future.

Solution:
Created a new feature to bridge the gap and also creates a new feature to ensure that this feature get activated on all the newly created sub-sites.

Steps / Code:
1. Create a new feature ( Branding_Sync / Scope = Web )
2. Add a feature receiver with following code on activation

public override void FeatureActivated(SPFeatureReceiverProperties properties)
        {
            SPWeb web = properties.Feature.Parent as SPWeb;

            if (!web.IsRootWeb)
            {
                Hashtable hash = web.AllProperties;
                web.MasterUrl = web.ParentWeb.MasterUrl;
                hash["__InheritsMasterUrl"] = "True";
                web.CustomMasterUrl = web.ParentWeb.CustomMasterUrl;
                web.SiteLogoUrl = web.ParentWeb.SiteLogoUrl;
                hash["__InheritsCustomMasterUrl"] = "True";
                web.Update();
            }
        }

3. Create a new feature ( Feature2 / Scope = Web Application )
4. Add a new "Empty Element" manifest and paste following lines
5. Replace the "FeatureGUID" with the guid of Feature1 above

lt;?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="STS#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="STS#1" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="STS#2" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="WIKI#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="BLOG#0" />

  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="MPS#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="MPS#1" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="MPS#2" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="MPS#3" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="MPS#4" />

  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="SRCHCENTERLITE#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="SRCHCENTERLITE#1" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="BDR#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="OFFILE#0" />
  <FeatureSiteTemplateAssociation Id="FeatureGUID" TemplateName="SPSREPORTCENTER#0" />
</Elements>

SharePoint Logs controlling file size

noreply@blogger.com (Sandeep) — Fri, 15 Jun 2012 08:15:00 +0000

Scenario: While we are waiting for new version of SharePoint, I still find developers/admin's missing out some great features of SharePoint 2010. Here's one, I got 2 new VM pre-configured and they run out of space every second day.

Reason : SharePoint logs

Solution: In SP2010 , new feature was introduced to control logging size "Restrict log disk space usage"

Article: Configure diagnostic logging (SharePoint Server 2010)

JavaScript and Date Time formatting

noreply@blogger.com (Sandeep) — Fri, 20 Apr 2012 13:38:00 +0000

Scenario: Working with SP client object model , I was getting formatted date string. Not very good for display purpose.
Solution: I asked our in house JavaScript expert sanjay and got a kick start , here's a little bit modified version of that outputting UTC date time.
Code:

//function for the getting the formatted date and time 
// current output April 20, 2012 7:04 PM
function formattedUTCDateTime(d) {

    // code for the year
    var m_names = new Array("January", "February", "March",
    "April", "May", "June", "July", "August", "September",
    "October", "November", "December");

//    var d = new Date();
    var curr_date = d.getUTCDate();
    var sup = "";
    if (curr_date == 1 || curr_date == 21 || curr_date == 31) {
        sup = "st";
    }
    else if (curr_date == 2 || curr_date == 22) {
        sup = "nd";
    }
    else if (curr_date == 3 || curr_date == 23) {
        sup = "rd";
    }
    else {
        sup = "th";
    }

    var curr_month = d.getUTCMonth();
    var curr_year = d.getUTCFullYear();

    //code for the time    
    var hours = d.getUTCHours()
    var minutes = d.getUTCMinutes()

    var suffix = "AM";
    if (hours >= 12) {
        suffix = "PM";
        hours = hours - 12;
    }
    if (hours == 0) {
        hours = 12;
    }

    if (minutes < 10)
        minutes = "0" + minutes;

    var datetimevalue = (m_names[curr_month] + " " + curr_date + ", " + curr_year + "  " + hours + ":" + minutes + " " + suffix);
    return datetimevalue;

}

SharePoint Resource file issues

noreply@blogger.com (Sandeep) — Fri, 06 Apr 2012 08:27:00 +0000

Scenario:
Working on some of the recent projects I faced some weird Resource file based issues. Actually these errors shows up during Feature activation. So doing a quick post on workarounds that worked for me.Leave comments if you found a more appropriate answer

Error type (1):
Failed to read resource file "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Template\Features\myProject_SiteFeature\Resources\Resources.en-US.resx" from feature id "GUID".

Failed to open the file 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Template\Features\myProject_SiteFeature\Resources\Resources.en-US.resx'.

What I did: After googling / investigating my logs with Error co-relation ID , I realized that these can be skipped. Real cause of this error is something else and will recommend to start analyzing the logs from oldest to newest. Doing so I was able to find the real cause of the issue.

Error type (2):
Failed to find resource file "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Resources\myProjectResources.en-US.resx" from feature id "GUID".

What I did: In my project I was using "myProjectResources.resx" file but it was looking for "myProjectResources.en-US.resx", which is weird. To fix the issue, I create a copy of existing "myProjectResources.resx" file and redeployed. It worked for me.

SharePoint Powershell List Items

noreply@blogger.com (Sandeep) — Thu, 01 Mar 2012 10:56:00 +0000

Scenario: SharePoint automation scripts related to list items.
Code:

#Load SharePoint Snap In
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

function xApproveAll-SPItems
{  
 param ($Url, $ListName) 

$web = Get-SPWeb $Url 
$list = $web.Lists.TryGetList($ListName)

$folders = $list.Folders
foreach ($folder in $folders)
{
     $folder["_ModerationStatus"] = 0
     $folder.Update()
}  

$items = $list.Items
foreach ($item in $items)
{
     Write-Host "Approving : " + $intIndex 
     $item["_ModerationStatus"] = 0
     $item.Update()
}  

 $web.Dispose()
 Write-Host "Approved all the documents successfully" -foregroundcolor Green  
}

function xDeleteAll-SPItems
{  
 param ($Url, $ListName) 

$web = Get-SPWeb $Url
$list = $web.Lists.TryGetList($ListName)
$itemCount = $list.ItemCount
for($intIndex = $itemCount; $intIndex -gt 0; $intIndex--) 
{ 
        Write-Host "Deleting : " + $intIndex 
        $list.Items[$intIndex-1].Delete();
}

 $web.Dispose()

}

$url=Read-Host "Enter site url"
$listName=Read-Host "Enter list library name"

xApproveAll-SPItems $url $listName
xDeleteAll-SPItems $url $listName

Powershell and SharePoint Permissions

noreply@blogger.com (Sandeep) — Tue, 28 Feb 2012 21:18:00 +0000

Scenario: SharePoint provide options to have security at different level, here some related functions which you can use.
Code:

#Load SharePoint Snap In
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

function Create-SPGroupInWeb
{
 param ($Url, $GroupName, $PermissionLevel, $Description)
 $web = Get-SPWeb -Identity $Url
 if ($web.SiteGroups[$GroupName] -ne $null)
 {
  Write-Host "Group $GroupName already exists!" -foregroundcolor Red
 }
 else
 {
  $web.SiteGroups.Add($GroupName, $web.Site.Owner, $web.Site.Owner, $Description)
  $group = $web.SiteGroups[$GroupName]
  $roleAssignment = new-object Microsoft.SharePoint.SPRoleAssignment($group)
  $roleDefinition = $web.Site.RootWeb.RoleDefinitions[$PermissionLevel]
  $roleAssignment.RoleDefinitionBindings.Add($roleDefinition)
  $web.RoleAssignments.Add($roleAssignment)
  $web.Update()
  Write-Host "Group $GroupName created successfully" -foregroundcolor Green
 }

 $web.Dispose()
}

function Remove-SPPermisssionFromListGroup
{
 param ($Url, $ListName, $GroupName, $PermissionLevel)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
  if ($list.HasUniqueRoleAssignments -eq $False)
  {
   $list.BreakRoleInheritance($True)
  }
  else
  {
   if ($web.SiteGroups[$GroupName] -ne $null)
   {
    $group = $web.SiteGroups[$GroupName]
    $roleAssign = $list.RoleAssignments.GetAssignmentByPrincipal($group);
    $roleDefinition = $web.RoleDefinitions[$PermissionLevel];
    $roleAssign.RoleDefinitionBindings.Remove($roleDefinition);
    $roleAssign.Update();
    $list.Update();
    Write-Host "Successfully removed $PermissionLevel permission from $GroupName group in $ListName list." -foregroundcolor Green
   }
   else
   {
    Write-Host "Group $GroupName does not exist." -foregroundcolor Red
   }
  }
 }
 else
 {
  Write-Host "List $ListName does not exist!" -foregroundcolor Red
 }

 $web.Dispose()
}

function Add-SPPermissionToListGroup
{
 param ($Url, $ListName, $GroupName, $PermissionLevel)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
  if ($list.HasUniqueRoleAssignments -eq $False)
  {
   $list.BreakRoleInheritance($True)
  }
  else
  {
   if ($web.SiteGroups[$GroupName] -ne $null)
   {
    $group = $web.SiteGroups[$GroupName]
    $roleAssignment = new-object Microsoft.SharePoint.SPRoleAssignment($group)
    $roleDefinition = $web.RoleDefinitions[$PermissionLevel];
    $roleAssignment.RoleDefinitionBindings.Add($roleDefinition);
    $list.RoleAssignments.Add($roleAssignment)
    $list.Update();
    Write-Host "Successfully added $PermissionLevel permission to $GroupName group in $ListName list. " -foregroundcolor Green
   }
   else
   {
    Write-Host "Group $GroupName does not exist." -foregroundcolor Red
   }
  }
 }

 $web.Dispose()
}

function Remove-SPPermisssionFromListItemGroupSpecific
{
 param ($Url, $ListName, $GroupName, $PermissionLevel)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
  foreach ($item in $list.Items) 
  {
   if ($item.HasUniqueRoleAssignments -eq $False)
   {
    $item.BreakRoleInheritance($True)
   }
   else
   {
    if ($web.SiteGroups[$GroupName] -ne $null)
    {
     $group = $web.SiteGroups[$GroupName]
     $roleAssign = $item.RoleAssignments.GetAssignmentByPrincipal($group);
     $roleDefinition = $web.RoleDefinitions[$PermissionLevel];
     $roleAssign.RoleDefinitionBindings.Remove($roleDefinition);
     $roleAssign.Update();
     $item.SystemUpdate();                    
     Write-Host "Successfully removed $PermissionLevel permission from $GroupName group in $ListName list." -foregroundcolor Green
    }
    else
    {
     Write-Host "Group $GroupName does not exist." -foregroundcolor Red
    }
   }
  }
 }
 else
 {
  Write-Host "List $ListName does not exist!" -foregroundcolor Red
 }

 $web.Dispose()
}

function Remove-SPPermisssionFromListItemGroupAll
{
 param ($Url, $ListName, $GroupName)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
  foreach ($item in $list.Items) 
  {
   if ($item.HasUniqueRoleAssignments -eq $False)
   {
    $item.BreakRoleInheritance($True)
   }
   else
   {
    if ($web.SiteGroups[$GroupName] -ne $null)
    {
     $group = $web.SiteGroups[$GroupName]
                    $item.RoleAssignments.Remove($group)
     $item.SystemUpdate();                    
     Write-Host "Successfully removed $PermissionLevel permission from $GroupName group in $ListName list." -foregroundcolor Green
    }
    else
    {
     Write-Host "Group $GroupName does not exist." -foregroundcolor Red
    }
   }
  }
 }
 else
 {
  Write-Host "List $ListName does not exist!" -foregroundcolor Red
 }

 $web.Dispose()
}

function Add-SPPermissionToListItemGroup
{
 param ($Url, $ListName, $GroupName, $PermissionLevel)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
  foreach ($item in $list.Items) 
  {
   if ($item.HasUniqueRoleAssignments -eq $False)
   {
    $item.BreakRoleInheritance($True)
   }
   else
   {
    if ($web.SiteGroups[$GroupName] -ne $null)
    {
     $group = $web.SiteGroups[$GroupName]
     $roleAssignment = new-object Microsoft.SharePoint.SPRoleAssignment($group)
     $roleDefinition = $web.RoleDefinitions[$PermissionLevel];
     $roleAssignment.RoleDefinitionBindings.Add($roleDefinition);
     $item.RoleAssignments.Add($roleAssignment)
     $item.SystemUpdate();
     Write-Host "Successfully added $PermissionLevel permission to $GroupName group in $ListName list. " -foregroundcolor Green
    }
    else
    {
     Write-Host "Group $GroupName does not exist." -foregroundcolor Red
    }
   }
  }
 }

 $web.Dispose()
}

function Add-SPPermissionToListItemGroupConditional
{
 param ($Url, $ListName, $Caml, $GroupName, $PermissionLevel)
 $web = Get-SPWeb -Identity $Url
 $list = $web.Lists.TryGetList($ListName)
 if ($list -ne $null)
 {
        $spQuery = New-Object Microsoft.SharePoint.SPQuery        
        $spQuery.Query = $Caml
        $spQuery.RowLimit = 10000
        $listItems = $list.GetItems($spQuery)        
        $listItems.Count
  foreach ($item in $listItems) 
  {
   if ($item.HasUniqueRoleAssignments -eq $False)
   {
    $item.BreakRoleInheritance($True)
   }
   else
   {
    if ($web.SiteGroups[$GroupName] -ne $null)
    {
     $group = $web.SiteGroups[$GroupName]
     $roleAssignment = new-object Microsoft.SharePoint.SPRoleAssignment($group)
     $roleDefinition = $web.RoleDefinitions[$PermissionLevel];
     $roleAssignment.RoleDefinitionBindings.Add($roleDefinition);
     $item.RoleAssignments.Add($roleAssignment)
     $item.SystemUpdate();
     Write-Host "Successfully added $PermissionLevel permission to $GroupName group in $ListName list. " -foregroundcolor Green
    }
    else
    {
     Write-Host "Group $GroupName does not exist." -foregroundcolor Red
    }
   }
  }
 }

 $web.Dispose()
}

$Url=Read-Host "Enter site url"

Remove-SPPermisssionFromListItemGroupSpecific $Url "Shared Documents" "Team Visitors" "Read"
Remove-SPPermisssionFromListItemGroupAll $Url "Shared Documents" "Team Visitors"
Add-SPPermissionToListItemGroup $Url "Shared Documents" "Team Visitors" "Contribute"
Add-SPPermissionToListItemGroupConditional $Url "Shared Documents" "<Where><Eq><FieldRef Name='Create' /><Value Type='Boolean'>1</Value></Eq></Where>" "Team Visitors" "Contribute"

Configure ReportViewer in SP2010

noreply@blogger.com (Sandeep) — Thu, 09 Feb 2012 17:10:00 +0000

Scenario:
While I already wrote an article before on errors configuring ReportViewer in SharePoint. I get the question on steps, how to configure it without getting errors :)

Solution:
Yes additional configurations need to make it work. Web.config of the web application need to be update with following steps below.

Navigate the c:\inetpub\wwwroot\VirtualDirectories\[portno]
Make a backup copy of web.config
Open web.config in some text editor , may be notepad
Look for following tag , ensure enableSessionState="true"
<pages asynctimeout="7" enablesessionstate="true" enableviewstate="true" enableviewstatemac="true" pageparserfiltertype="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" validaterequest="false">
Look for <httpmodules> tag and add below statement as last child node ( if not there already )
<add name="Session" type="System.Web.SessionState.SessionStateModule">
Look for this tag below and update version to 10.0.0.0
<add name="ReportViewerWebControl" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Look for <appsettings> and comment the entry with name=ReportViewerMessages

Styles not working in custom forms

noreply@blogger.com (Sandeep) — Wed, 18 Jan 2012 19:21:00 +0000

Scenario:
I am sure this worked in MOSS 2007. Applying OOTB styles gives perfect look and feel for custom forms. But when I applied OOTB styles in SP2010 Visual Web part , I didn't get the right styles.

Solution:
After few comparison I realized SharePoint loads different style sheet files on different pages. So for a custom form to get the same styles as OOTB forms, there was a missing stylesheet.
Add the following statement in your Visual Webpart to fix it.

Code:

<link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/Themable/forms.css" />

SharePoint Error activating feature

noreply@blogger.com (Sandeep) — Wed, 18 Jan 2012 06:40:00 +0000

Scenario:
Got an error while activating feature.
Object reference not set to an instance.

Also break point was not hitting the Feature Receiver code while debugging.

Solution:
Few things I tried before I found the real cause.

1. Commented the code and tried, still same error

2. Removed the Element manifest and tried, still same error

3. Checked the feature dependency. This was the culprit. Remove feature dependency resolved the issue.