.

Tuesday, August 30, 2016

Rollback SharePoint WSP deployed as a Farm sollution

Download XML file used as a config file for this script.

Param([Parameter(Mandatory=$True)]
       [string]$Environment
     )

$snapinName = "Microsoft.SharePoint.PowerShell"
if ((Get-PSSnapin | Where-Object {$_.Name -eq $snapinName }) -eq $NULL) {
  write-host "SharePoint SnapIn not loaded. Loading..."
  Add-PSSnapin $snapinName -ErrorAction SilentlyContinue
  }
#####################################################################

$Envpath=(Get-Location -PSProvider FileSystem).ProviderPath
write-host "Envpath" $Envpath
Write-Host 'Select Current Environment'
Write-Host 'DEV'
Write-Host 'INT'
Write-Host 'QA'
Write-Host 'STAGE'
Write-Host 'PROD'
$Env= $Environment

Write-Host  'Current environment selected' + $Env

if($Env -eq 'DEV')
{
$EnvName='Dev'
}
elseif($Env -eq 'INT')
{
$EnvName='DevInt'
}
elseif($Env -eq 'QA')
{
$EnvName='QA'
}
elseif($Env -eq 'STAGE')
{
$EnvName='Stage'
}
elseif($Env -eq 'PROD')
{
$EnvName='Prod'
}



$Envpath=(Get-Location -PSProvider FileSystem).ProviderPath
write-host "Envpath" $Envpath

#get the Config.xml file from te deployment package
$configpath = $Envpath + "\config.xml"
[xml] $configXml = Get-Content $configpath -ErrorAction SilentlyContinue

#####################################################################

#method to read cofig values from config.xml file -start

#####################################################################
function Get-ConfigValue
{
 Param(
  [string] $key
 )
 Process
 {
  $xpath = "Configuration/$EnvName/param[@key='" + $key + "']" + "/text()"
  $configXml.SelectSingleNode($xpath).Value
 }
}

$SiteCollectionURL=Get-ConfigValue "SiteCollectionUrl"
Write-Host "SiteCollection url:" $SiteCollectionURL

 
$solutionName = "Declaration_Email.wsp"
 
$solution = Get-SPSolution $solutionName
 
Write-Host -ForegroundColor Green "Removing $solutionName"
Write-Host ""
 
if( $solution.Deployed -eq $true) {
 
    if ( $solution.ContainsWebApplicationResource ) {
        Uninstall-SPSolution -Identity $solutionName -Confirm:$false -Webapplication  $SiteCollectionURL
    }
    else {
        Uninstall-SPSolution -Identity $solutionName -Confirm:$false
    }
    $counter = 1
    $maximum = 50
    $sleeptime = 2
    while( $solution.JobExists -and ( $counter -lt $maximum ) ) {
        Write-Host -ForegroundColor yellow "Retracting $solutionName. Please wait..."
        sleep $sleeptime
        $counter++
    }
}
 
Write-Host ""
Write-Host -ForegroundColor Green "$solutionName is retracted."
Write-Host ""
 
Remove-SPSolution -Identity $solutionName -Force -Confirm:$false
 
Write-Host -ForegroundColor Green "$solutionName removed."

Deploy Sharepoint WSP using powershell script using custom config file

Download XML file (config file) used for this powershell script

Param([Parameter(Mandatory=$True)]
       [string]$Environment
     )
$snapinName = "Microsoft.SharePoint.PowerShell"
if ((Get-PSSnapin | Where-Object {$_.Name -eq $snapinName }) -eq $NULL) {
  write-host "SharePoint SnapIn not loaded. Loading..."
  Add-PSSnapin $snapinName -ErrorAction SilentlyContinue
  }
#####################################################################



$Envpath=(Get-Location -PSProvider FileSystem).ProviderPath
write-host "Envpath" $Envpath
#Select the Environment to setup and deploy GRR 
Write-Host 'Select Current Environment'
Write-Host 'DEV'
Write-Host 'INT'
Write-Host 'QA'
Write-Host 'STAGE'
Write-Host 'PROD'
$Env= $Environment

Write-Host  'Current environment selected' + $Env

if($Env -eq 'DEV')
{
$EnvName='Dev'
}
elseif($Env -eq 'INT')
{
$EnvName='DevInt'
}
elseif($Env -eq 'QA')
{
$EnvName='QA'
}
elseif($Env -eq 'STAGE')
{
$EnvName='Stage'
}
elseif($Env -eq 'PROD')
{
$EnvName='Prod'
}



$Envpath=(Get-Location -PSProvider FileSystem).ProviderPath
write-host "Envpath" $Envpath

#get the WSP file path
$solutionName = "Declaration_Email.wsp"
$WSPFilepath = $Envpath + "\Declaration_Email.wsp"

#get the Config.xml file from te deployment package
$configpath = $Envpath + "\config.xml"
[xml] $configXml = Get-Content $configpath -ErrorAction SilentlyContinue

#####################################################################

#method to read cofig values from config.xml file -start

#####################################################################
function Get-ConfigValue
{
 Param(
  [string] $key
 )
 Process
 {
  $xpath = "Configuration/$EnvName/param[@key='" + $key + "']" + "/text()"
  $configXml.SelectSingleNode($xpath).Value
 }
}


 Write-Host "Applying changes to DEV config file"
 $SiteCollectionURL=Get-ConfigValue "SiteCollectionUrl"
  Write-Host "SiteCollection url:" $SiteCollectionURL
  Write-Host "Adding solution.." -foregroundcolor Yellow
 # LogInfoMessage "Adding solution in Dev started" 
 
  Write-Host "Install solution.." -foregroundcolor Yellow
  
    $solution = Add-SPSolution $WSPFilepath
  
 #LogInfoMessage "Solution added" 
 
  Write-Host "Solution added.." -foregroundcolor Yellow
 
if ( $solution.ContainsWebApplicationResource ) {
    Write-Host -ForegroundColor Green "Deploying $solutionName to $url"
    Install-SPSolution -Identity $solutionName -Webapplication $SiteCollectionURL -FullTrustBinDeployment -GACDeployment -Force
 
}
else {
    Write-Host -ForegroundColor Green "Deploying $solutionName"
    Install-SPSolution -Identity $solutionName -GacDeployment -Force
}
 
$solution = Get-SPSolution $solutionName
 
if ($solution.Deployed -eq $false ) {
    $counter = 1
    $maximum = 50
    $sleeptime = 2
    while( ($solution.JobExists -eq $true ) -and ( $counter -lt $maximum  ) ) {
        write-host -ForegroundColor yellow "Please wait..."
        sleep $sleeptime
        $counter++
    }
}
 
Write-Host ""
Write-Host -ForegroundColor Green "$solutionName is deployed"

Tuesday, June 14, 2016

Get REST data from SharePoint List more than 50 items

   $.ajax({
                  type: 'GET',
                  url: url +"_api/web/lists/getbytitle('ReportingList')/Items?$skiptoken=Paged=TRUE&$top=1000&$select= CountryCodeInMap,CountryColourInMap",
                  headers: { "Accept": "application/json;odata=verbose" },
                  cache: false,
                  success: function (data) {
                      var colordata = '{';
                      for (i = 0; i < data.d.results.length; i++) {
                          if (data.d.results[i].CountryCodeInMap != null) {
                              colordata = colordata + '"' + data.d.results[i].CountryCodeInMap + '":' + '"' + data.d.results[i].CountryColourInMap + '"';
                              colordata = colordata + ",";
                          }
                      }
                      var data = colordata.substring(0, colordata.length - 1) + '}';
                      renderMap();
                      var jsondata = $.parseJSON(data);
                      jQuery('#vmap').vectorMap('set', 'colors', jsondata);
                  },
                  error: function (status) {
                      renderMap();
                      DisplayErrorMessage("Error loading world map.");
                  }
              });
          });

Sunday, May 22, 2016

How to genrate Google Client ID and client secret

1) click to url : https://console.developers.google.com

2)

Tuesday, May 3, 2016

How to configure SharePoint 2013 search topology using PowerShell script

Download XML File used for this powershell as a input file.

function Start-SearchServices {
[CmdletBinding()]
 param 
 (  
  [Parameter(Mandatory=$true, Position=0)]
  [ValidateNotNullOrEmpty()]
  [string]$SettingsFile
 )

 cls
    Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

 [xml]$settings = Get-Content $SettingsFile
    $config = $settings.config

 #Get the service and crawl Creds for use at the end of the scripts
 $servicecred = Get-Credential -UserName $config.ServiceAccountUser -Message "Search Service Account Password"
 $crawlcred = Get-Credential -UserName $config.CrawlUser -Message "Crawl Account Password"
 

 Write-Host -ForegroundColor Yellow "Checking if Search Application Pool exists" 
    $SPAppPool = Get-SPServiceApplicationPool -Identity $config.SearchAppPoolName -ErrorAction SilentlyContinue

    if (!$SPAppPool) 
    { 
        Write-Host -ForegroundColor Green "Creating Search Application Pool" 
        $spAppPool = New-SPServiceApplicationPool -Name $config.SearchAppPoolName -Account $config.SearchAppPoolAccountName 
    }

 Write-Host "Setting search service properties..."
    while ($true) {
     Get-SPEnterpriseSearchService | Set-SPEnterpriseSearchService `
      -ServiceAccount $servicecred.Username `
      -ServicePassword $servicecred.Password `
      -ContactEmail $svcConfig.ContactEmail `
      -ErrorAction SilentlyContinue -ErrorVariable err
     if ($err) {
            if ($err[0].Exception.Message -like "*update conflict*") { Write-Warning "An update conflict occured"; Start-Sleep 2; continue; }
      throw $err
     }
        break
 }
 
 

    # Start Services search service instance 
    Write-host -ForegroundColor Yellow "Start Search Service instances...." $config.AdminServer
    Start-SPEnterpriseSearchServiceInstance $config.AdminServer -ErrorAction SilentlyContinue 
    Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance $config.AdminServer -ErrorAction SilentlyContinue


    Write-Host -ForegroundColor Yellow "Checking if Search Service Application exists" 
    $ServiceApplication = Get-SPEnterpriseSearchServiceApplication -Identity $config.ServiceAppName -ErrorAction SilentlyContinue

    if (!$ServiceApplication) 
    { 
        Write-Host -ForegroundColor Green "Creating Search Service Application" 
        $ServiceApplication = New-SPEnterpriseSearchServiceApplication -Partitioned -Name $config.ServiceAppName -ApplicationPool $spAppPool.Name -DatabaseServer $config.DatabaseServer -DatabaseName $config.DatabaseName 
    }


    Write-Host -ForegroundColor Yellow "Checking if Search Service Application Proxy exists" 
    $Proxy = Get-SPEnterpriseSearchServiceApplicationProxy -Identity $config.SearchServiceProxyName -ErrorAction SilentlyContinue

    if (!$Proxy) 
    { 
        Write-Host -ForegroundColor Green "Creating Search Service Application Proxy" 
        New-SPEnterpriseSearchServiceApplicationProxy -Partitioned -Name $config.SearchServiceProxyName -SearchApplication $ServiceApplication 
    }

   

    $OldTopologyId = $ServiceApplication.ActiveTopology.TopologyId 
    Write-Host -ForegroundColor Green "Active Topology ID: $OldTopologyId"


    # Clone the default Topology (which is empty) and create a new one and then activate it 
    Write-Host -ForegroundColor Yellow "Configuring Search Component Topology...." 
    $clone = $ServiceApplication.ActiveTopology.Clone() 
    $SSI = Get-SPEnterpriseSearchServiceInstance $config.AdminServer 

    if ($SSI.Status -ne "Online")
    {
        $SSI | Start-SPServiceInstance
    }

    # Build out Admin Component
    $admin = $ServiceApplication | Get-SPEnterpriseSearchAdministrationComponent
    $admin | Set-SPEnterpriseSearchAdministrationComponent -SearchServiceInstance $SSI
    $admin = ($ServiceApplication | Get-SPEnterpriseSearchAdministrationComponent)

    while (-not $admin.Initialized)
    {
        Start-Sleep 10
        $admin = ($ServiceApplication | Get-SPEnterpriseSearchAdministrationComponent)
    }

    #
    $adminSearchInstance = Get-SPEnterpriseSearchServiceInstance $config.AdminServer
    $adminComponent = New-SPEnterpriseSearchAdminComponent -SearchTopology $clone -SearchServiceInstance $adminSearchInstance 


    Write-Host -ForegroundColor Cyan "  Create a crawl component"
    $config.CrawlServers.Server | ForEach-Object {
        Write-Host -ForegroundColor Green "  Assigning Crawl Server " $_.Name
        $crawlInstance = Get-SPEnterpriseSearchServiceInstance $_.Name
  
  #Online?
  if ($crawlInstance.Status -ne "Online")
  {
   $crawlInstance | Start-SPServiceInstance | Out-Null
  }
  while ($crawlInstance.Status -ne "Online")
  {
   Start-Sleep 10
   $crawlInstance = Get-SPEnterpriseSearchServiceInstance $_.Name
  }
   
        $crawlComponent = New-SPEnterpriseSearchCrawlComponent -SearchTopology $clone -SearchServiceInstance $crawlInstance | Out-Null
    }


    Write-Host -ForegroundColor Yellow "Create a query processing component"
    $config.QueryServers.Server | ForEach-Object {
        Write-Host -ForegroundColor Cyan "  Assigning Query Server " $_.Name
        $queryInstance = Get-SPEnterpriseSearchServiceInstance $_.Name
  #Online?
  if ($queryInstance.Status -ne "Online")
  {
   $queryInstance | Start-SPServiceInstance | Out-Null
  }
  while ($queryInstance.Status -ne "Online")
  {
   Start-Sleep 10
   $queryInstance = Get-SPEnterpriseSearchServiceInstance $_.Name
  }
 
        $queryComponent = New-SPEnterpriseSearchQueryProcessingComponent -SearchTopology $clone -SearchServiceInstance $queryInstance | Out-Null
    }

  
    Write-Host -ForegroundColor Cyan "  Create an index component. We will use RootDirectory parameter to set the index location."
    #Do you need to create the index directories?
    #Remove-Item -Recurse -Force -LiteralPath $config.IndexLocation -ErrorAction SilentlyContinue 
    #mkdir -Path $config.IndexLocation -Force

    $indexInstance = Get-SPEnterpriseSearchServiceInstance $config.IndexServer
 #Online?
 if ($indexInstance.Status -ne "Online")
 {
  $indexInstance | Start-SPServiceInstance | Out-Null
 }
 while ($indexInstance.Status -ne "Online")
 {
  Start-Sleep 10
  $indexInstance = Get-SPEnterpriseSearchServiceInstance $config.IndexServer
 }
    $indexComponent = New-SPEnterpriseSearchIndexComponent -SearchTopology $clone -SearchServiceInstance $indexInstance -RootDirectory $config.IndexLocation | Out-Null

    Write-Host -ForegroundColor Cyan "  Create an analytics component"
    $analyticsInstance = Get-SPEnterpriseSearchServiceInstance $config.AnalyticsServer
 #Online?
 if ($analyticsInstance.Status -ne "Online")
 {
  $analyticsInstance | Start-SPServiceInstance | Out-Null
 }
 while ($analyticsInstance.Status -ne "Online")
 {
  Start-Sleep 10
  $analyticsInstance = Get-SPEnterpriseSearchServiceInstance $config.AnalyticsServer
 }

    $analyticsComponent = New-SPEnterpriseSearchAnalyticsProcessingComponent -SearchTopology $clone -SearchServiceInstance $analyticsInstance | Out-Null

    Write-Host -ForegroundColor Cyan "  Create a content processing component"
    $contentProcessingInstance = Get-SPEnterpriseSearchServiceInstance $config.ContentProcessingServer
 #Online?
 if ($contentProcessingInstance.Status -ne "Online")
 {
  $contentProcessingInstance | Start-SPServiceInstance | Out-Null
 }
 while ($contentProcessingInstance.Status -ne "Online")
 {
  Start-Sleep 10
  $contentProcessingInstance = Get-SPEnterpriseSearchServiceInstance $config.ContentProcessingServer
 }
    $contentProcessingComponent = New-SPEnterpriseSearchContentProcessingComponent -SearchTopology $clone -SearchServiceInstance $contentProcessingInstance | Out-Null

    #Test the Clone before we activate it.
    if ($clone.ComponentCount -ne 0)
    {
        Write-Host -ForegroundColor Yellow "Activating new topology ..."
        $clone.Activate()
     Write-Host -ForegroundColor Green "New topology activated"
        #Set Default Crawl Account
     Write-Host -ForegroundColor Yellow "Setting default content access account"
        $ServiceApplication | Set-SPEnterpriseSearchServiceApplication -DefaultContentAccessAccountName $crawlcred.UserName -DefaultContentAccessAccountPassword $crawlcred.Password

        #Provide the location of the global Search Center
     Write-Host -ForegroundColor Yellow "Setting default global search center"
        $ServiceApplication = Get-SPEnterpriseSearchServiceApplication
        $ServiceApplication.SearchCenterUrl = $config.SearchCenterUrl
        $ServiceApplication.Update()

        Write-host -ForegroundColor Green "Your search service application $serviceAppName is now ready"

        Write-Host
        Write-Host
     #Optionally remove the old topology here
        $title = "Delete old Topology?"
        $message = "Do you want to delete the old topology?"

        $yes = New-Object System.Management.Automation.Host.ChoiceDescription "&Yes", `
            "Deletes the old topology."

        $no = New-Object System.Management.Automation.Host.ChoiceDescription "&No", `
            "Retains the old topology in an inactive state."

        $options = [System.Management.Automation.Host.ChoiceDescription[]]($yes, $no)

        $result = $host.ui.PromptForChoice($title, $message, $options, 0) 

        if ($result -eq 0)
        {
            Remove-SPEnterpriseSearchTopology -Identity $OldTopologyId -SearchApplication $ServiceApplication
        }
    }
    else
    {
        Write-Host -ForegroundColor Red "Error with Topology, Component Count is 0"
    }

    
 
}

Start-SearchServices -SettingsFile .\searchconfigdht.xml

Sunday, April 3, 2016

Read the sharepoint 2013 list data using REST and render into Table

var urllink="https://stagetest.com";
var username="";

var listItemInfoAdmin1 ="";
var listItemInfoAdmin2 ="";
var listItemInfoCOS ="";

$(document).ready(function () {
   username = $("#peoplepickerID").text();
   //alert(username);
   AdminSupportStaff1();
   AdminSupportStaff2();
   ChiefOfSupportStaff();
   

    });

function AdminSupportStaff1() {
    $.ajax({
        url: urllink + "/sites/DL/LD/_api/web/lists/getbytitle('People')/items?$filter=AdminSupportStaff eq '" + username + "'",        
        type: "GET",
        headers: { "Accept": "application/json;odata=verbose" },
        cache: false,
        success: function (data) {

               $.each(data.d.results, function (key, value) {
                               
                               listItemInfoAdmin1 +="<tr><td>"+value.First_x0020_Name+" "+value.Last_x0020_Name+"</td><td>Admin</td></tr>";
                               
        
        });  
         $('#tableSupport').append(listItemInfoAdmin1);     
        //$("#countmein").html(listItemInfo);  
  
        },
        error: function (data) {
            //myApp.hidePleaseWait();
                              //            DisplayErrorMessage(errorMsg);
                                             alert("Error");
        }

    });
}


function AdminSupportStaff2() {
    $.ajax({
        url: urllink + "/sites/DL/LD/_api/web/lists/getbytitle('People')/items?$filter=AdminSuppoprtStaff2 eq '" + username + "'",          
        type: "GET",
        headers: { "Accept": "application/json;odata=verbose" },
        cache: false,
        success: function (data) {

               $.each(data.d.results, function (key, value) {
                               
                               listItemInfoAdmin2 +="<tr><td>"+value.First_x0020_Name+" "+value.Last_x0020_Name+"</td><td>Admin</td></tr>";
                               
        
        });  
         $('#tableSupport').append(listItemInfoAdmin2);     
        //$("#countmein").html(listItemInfo);  
  
        },
        error: function (data) {
            //myApp.hidePleaseWait();
                              //            DisplayErrorMessage(errorMsg);
                                             alert("Error");
        }

    });
}

function ChiefOfSupportStaff() {
    $.ajax({
        url: urllink + "/sites/DL/LD/_api/web/lists/getbytitle('People')/items?$filter=ChiefOfSupportStaff eq '" + username + "'",          
        type: "GET",
        headers: { "Accept": "application/json;odata=verbose" },
        cache: false,
        success: function (data) {

               $.each(data.d.results, function (key, value) {
                               
                               listItemInfoCOS +="<tr><td>"+value.First_x0020_Name+" "+value.Last_x0020_Name+"</td><td>Chief of staff</td></tr>";
                               
        
        });  
         $('#tableSupport').append(listItemInfoCOS);     
        //$("#countmein").html(listItemInfo);  
  
        },
        error: function (data) {
            //myApp.hidePleaseWait();
                              //            DisplayErrorMessage(errorMsg);
                                             alert("Error");
        }

    });
}

Monday, March 21, 2016

How to use XSLT for SharePoint listview

1) Create list with column "First Name" and "Last Name"
2) Create XSLT file with below XSLT tags and upload this to pages library.

<xsl:stylesheet version="1.0"

              xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

              xmlns:msxsl="urn:schemas-microsoft-com:xslt"

              exclude-result-prefixes="msxsl" xmlns:ddwrt2="urn:frontpage:internal">



  <xsl:output method='html' indent='yes'/>



  <xsl:template match='dsQueryResponse'>
<style>

.LD{
    border-collapse: collapse;
    width: 100%;
}
.LD table, .LD td, .LD th {    
    border: 1px solid #ddd;
    text-align: left;
    width: 25%;

}


.LS th, .LS td {
    padding: 10px;
}

.LS{
    border-collapse: collapse;
    width: 100%;
}
.LS table, .LS td, .LS th {    
    border: 1px solid #ddd;
    text-align: left;
    width: 25%;

}


.LS th, .LS td {
    padding: 15px;
}

</style>

    <table class="LD"  >    

     <xsl:apply-templates select='Rows/Row'/>

    </table>

  </xsl:template>



  <xsl:template match='Row'>


<tr style="background-color:#e9e9e9;">

        <td style="border-width: 0px;">

            <b style="font-size:25px;padding-right:10px"><xsl:value-of select="@First_x0020_Name"></xsl:value-of> </b>
             <b style="font-size:25px"><xsl:value-of select="@Last_x0020_Name"></xsl:value-of> </b>

        </td>
 
 </tr >



 
  </xsl:template>

</xsl:stylesheet>

3) Insert a List view webpart for people list, change the properties of XSLT url with the correct url.

4) Save and check the page.