Ricardo Gutierrez

In this article, I will show you How to create New Group, TermSet, Term. Add term to TemSet and in turn to the Group. Now, write the following code:

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Text;  
using System.Threading.Tasks;  
using Microsoft.SharePoint;  
using Microsoft.SharePoint.Taxonomy;  
namespace TestTermStore  
{  
class Program  
{  
static void Main(string[] args)  
{  
    using (SPSite site = new SPSite("http://sharepoint"))  
    {  
        //instantiate a new session to a site  
        TaxonomySession sesssion = new TaxonomySession(site);  

        //Get the term store  
        TermStore NauticalStore = sesssion.TermStores["Managed Metadata Service"];  

        //Create a new term group  
        Group Working = NauticalStore.CreateGroup("Working Sailing");  

        //Create a new term set  
        TermSet termSetClasses = Working.CreateTermSet("Class Types");  

        //Add terms  
        Term term1 = termSetClasses.CreateTerm("A", 1033);  
        Term term2 = termSetClasses.CreateTerm("B", 1033);  
        Term term3 = termSetClasses.CreateTerm("C", 1033);  
        Term term4 = termSetClasses.CreateTerm("D", 1033);  
        Term term5 = termSetClasses.CreateTerm("E", 1033);  
        Term term6 = termSetClasses.CreateTerm("F", 1033);  
        Term term7 = termSetClasses.CreateTerm("G", 1033);  

        //Commit changes to the store  
        NauticalStore.CommitAll();  

        //Delte a term  
        term1.Delete();  

        //set descriptions and labels  
        term2.SetDescription("Learning", 1033);  
        term2.CreateLabel("B", 1033, false);  

        NauticalStore.CommitAll();  

        Console.WriteLine("Group Added");  
        Console.ReadLine();  
    }  
}  
}  
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Taxonomy;

namespace TestTermStore

{

class Program

{

static void Main(string[] args)

{

using (SPSite site = new SPSite("http://sharepoint"))

{

//instantiate a new session to a site

TaxonomySession sesssion = new TaxonomySession(site);

//Get the term store

TermStore NauticalStore = sesssion.TermStores["Managed Metadata Service"];

//Create a new term group

Group Working = NauticalStore.CreateGroup("Working Sailing");

//Create a new term set

TermSet termSetClasses = Working.CreateTermSet("Class Types");

//Add terms

Term term1 = termSetClasses.CreateTerm("A", 1033);

Term term2 = termSetClasses.CreateTerm("B", 1033);

Term term3 = termSetClasses.CreateTerm("C", 1033);

Term term4 = termSetClasses.CreateTerm("D", 1033);

Term term5 = termSetClasses.CreateTerm("E", 1033);

Term term6 = termSetClasses.CreateTerm("F", 1033);

Term term7 = termSetClasses.CreateTerm("G", 1033);

//Commit changes to the store

NauticalStore.CommitAll();

//Delte a term

term1.Delete();

//set descriptions and labels

term2.SetDescription("Learning", 1033);

term2.CreateLabel("B", 1033, false);

NauticalStore.CommitAll();

Console.WriteLine("Group Added");

Console.ReadLine();

}

Best SharePoint 2013 Hosting Recommendation HostForLIFE.eu HostForLIFE.eu offer the Best, Cheap and Recommended SharePoint 2013 hosting start from €9.99/month. They can load your site against anticipated traffic and recommend the best option for you. HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Their service is…

SharePoint 2013 Hosting News – Learn How to Get An Year From Column In SharePoint 2013

October 1, 2015

In this article i will be able to make a case for how to get a year only from the date time column using calculation field in SharePoint 2013 list. First Open your SharePoint list. Here I have a Year from DOB column. Click create Column from the top ribbon. The following popup will appear. Enter column name (Year) and select calculated column. Now, you should create Column. Paste the following code to Formula field. =CONCATENATE(YEAR(DOB)) Here, I have an…

SharePoint 2013 Hosting News – Learn How to Search in App Web using REST API in SharePoint

September 23, 2015

In this post, let me explain you about search in App Web using REST API in SharePoint. You can use Search REST service : <Site URL>/_api/search/query?querytext=”<SearchTerm>”. To Process the returned JSON result. Add required Search Service Permission to App.Manifest. Add ‘Search’ in Scope and set permission to ‘QueryAsUserIgnoreAppPrincipal’. Now, write the following code on Default.aspx

<%-- The following 4 lines are ASP.NET directives needed when using SharePoint components --%>  

<%@ Page Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" MasterPageFile="~masterurl/default.master" Language="C#" %>  

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>  
<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>  
<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>  

<%-- The markup and script in the following Content element will be placed in the <head> of the page --%>  
<asp:Content ContentPlaceHolderID="PlaceHolderAdditionalPageHead" runat="server">  
    <script type="text/javascript" src="../Scripts/jquery-1.9.1.min.js"></script>  
    <script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script>  
    <script type="text/javascript" src="/_layouts/15/sp.js"></script>  
    <meta name="WebPartPageExpansion" content="full" />  

    <!-- Add your CSS styles to the following file -->  
    <link rel="Stylesheet" type="text/css" href="../Content/App.css" />  

    <!-- Add your JavaScript to the following file -->  
    <script type="text/javascript" src="../Scripts/App.js"></script>  
</asp:Content>  

<%-- The markup in the following Content element will be placed in the TitleArea of the page --%>  
    <asp:Content ContentPlaceHolderID="PlaceHolderPageTitleInTitleArea" runat="server">  
        Page Title  
    </asp:Content>  

    <%-- The markup and script in the following Content element will be placed in the <body> of the page --%>  
        <asp:Content ContentPlaceHolderID="PlaceHolderMain" runat="server">  

            <div>  
                <p id="message">  
                    <!-- The following content will be replaced with the user name when you run the app - see App.js -->  
                    initializing...  
                </p>  
            </div>  

            <!-- App Web Search-->  
            <div id="searchDiv">  
                <b>Search For</b>  
                <input type="text" id="txtSearchTerm" />  
                <input type="button" id="btnSearch" value="Search" onclick="searchAppWeb()" />  
            </div>  
            <div id="SearchResultsDiv"></div>  
            <!--Search Ends-->  

        </asp:Content>

<%-- The following 4 lines are ASP.NET directives needed when using SharePoint components --%>

<%@ Page Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" MasterPageFile="~masterurl/default.master" Language="C#" %>

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%-- The markup and script in the following Content element will be placed in the <head> of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderAdditionalPageHead" runat="server">

</asp:Content>

<%-- The markup in the following Content element will be placed in the TitleArea of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderPageTitleInTitleArea" runat="server">

Page Title

</asp:Content>

<%-- The markup and script in the following Content element will be placed in the <body> of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderMain" runat="server">

<div>

initializing...

</p>

</div>

<b>Search For</b>

</div>

</asp:Content>

App.js

'use strict';  
var context = SP.ClientContext.get_current();  
var user = context.get_web().get_currentUser();  
// This code runs when the DOM is ready and creates a context object which is needed to use the SharePoint object model    
$(document).ready(function() {  
getUserName();  
});  
// This function prepares, loads, and then executes a SharePoint query to get the current users information    
function getUserName() {  
context.load(user);  
context.executeQueryAsync(onGetUserNameSuccess, onGetUserNameFail);  
}  

// This function is executed if the above call is successful    
// It replaces the contents of the 'message' element with the user name    
function onGetUserNameSuccess() {  
$('#message').text('Hello ' + user.get_title());  
}  

// This function is executed if the above call fails    
function onGetUserNameFail(sender, args) {  
alert('Failed to get user name. Error:' + args.get_message());  
}  

//Search Implemenatation in App Web using Search REST API    
//Do not forget to provide Search Permission in AppManifest file     
var html;  

function searchAppWeb() {  

//Get the Search Term from textbox    
var searchTerm = $("#txtSearchTerm").val();  

//REST API query URL    
var queryUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/search/query?querytext='" + searchTerm + "'";;  

//Empty the string    
html = "";  

//Make the ajax call    
$.ajax({  
url: queryUrl,  
method: "GET",  
headers: {  
    "Accept": "application/json; odata=verbose"  
},  
success: onSearchSuccess,  
error: onSearchError  
});  
}  

function onSearchSuccess(data) {  
// JSON object contains two elements which have search results    
//1. PrimaryQueryResult    
//2. SecondaryQueryResults (When documents are grouped on Host Web)    

//Get PrimaryQueryResult and Render it in HTML Table format    
html = "<table>";  

var primaryQueryResult = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results;  

if (primaryQueryResult != null && primaryQueryResult != undefined) {  
for (var iPrimaryResultCounter = 0; iPrimaryResultCounter < primaryQueryResult.length; iPrimaryResultCounter++) {  
    html += "<tr><td>";  
    html += primaryQueryResult[iPrimaryResultCounter].Cells.results[3].Value;  
    html += "</td><td><a href=\""  
    html += primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value;  
    html += "\">" + primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value + "</a></td><tr>";  
}  
}  

//Get SecondaryQueryResults and continue rendering it in HTML Table format    
var secondaryResult = data.d.query.SecondaryQueryResults;  
if (data.d.query.SecondaryQueryResults != null && data.d.query.SecondaryQueryResults != undefined) {  
for (var iSecondaryResultCounter = 0; iSecondaryResultCounter < data.d.query.SecondaryQueryResults.results.length; iSecondaryResultCounter++) {  
    var resultBlock = data.d.query.SecondaryQueryResults.results[iSecondaryResultCounter].RelevantResults.Table.Rows.results;  
    for (var iResults = 0; iResults < resultBlock.length; iResults++) {  
        html += "<tr><td>";  
        html += resultBlock[iResults].Cells.results[3].Value;  
        html += "</td><td><a href=\""  
        html += resultBlock[iResults].Cells.results[6].Value;  
        html += "\">" + resultBlock[iResults].Cells.results[6].Value + "</a></td><tr>";  
    }  
}  
}  
html += "</table>";  
$("#SearchResultsDiv").append(html);  
} 
function onSearchError(err) {  
alert(JSON.stringify(err));  
}

'use strict';

var context = SP.ClientContext.get_current();

var user = context.get_web().get_currentUser();

// This code runs when the DOM is ready and creates a context object which is needed to use the SharePoint object model

$(document).ready(function() {

getUserName();

});

// This function prepares, loads, and then executes a SharePoint query to get the current users information

function getUserName() {

context.load(user);

context.executeQueryAsync(onGetUserNameSuccess, onGetUserNameFail);

}

// This function is executed if the above call is successful

// It replaces the contents of the 'message' element with the user name

function onGetUserNameSuccess() {

$('#message').text('Hello ' + user.get_title());

}

// This function is executed if the above call fails

function onGetUserNameFail(sender, args) {

alert('Failed to get user name. Error:' + args.get_message());

}

//Search Implemenatation in App Web using Search REST API

//Do not forget to provide Search Permission in AppManifest file

var html;

function searchAppWeb() {

//Get the Search Term from textbox

var searchTerm = $("#txtSearchTerm").val();

//REST API query URL

var queryUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/search/query?querytext='" + searchTerm + "'";;

//Empty the string

html = "";

//Make the ajax call

$.ajax({

url: queryUrl,

method: "GET",

headers: {

"Accept": "application/json; odata=verbose"

success: onSearchSuccess,

error: onSearchError

});

}

function onSearchSuccess(data) {

// JSON object contains two elements which have search results

//1. PrimaryQueryResult

//2. SecondaryQueryResults (When documents are grouped on Host Web)

//Get PrimaryQueryResult and Render it in HTML Table format

html = "<table>";

var primaryQueryResult = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results;

if (primaryQueryResult != null && primaryQueryResult != undefined) {

for (var iPrimaryResultCounter = 0; iPrimaryResultCounter < primaryQueryResult.length; iPrimaryResultCounter++) {

html += "<tr><td>";

html += primaryQueryResult[iPrimaryResultCounter].Cells.results[3].Value;

html += "</td><td><a href=\""

html += primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value;

html += "\">" + primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value + "</a></td><tr>";

}

//Get SecondaryQueryResults and continue rendering it in HTML Table format

var secondaryResult = data.d.query.SecondaryQueryResults;

if (data.d.query.SecondaryQueryResults != null && data.d.query.SecondaryQueryResults != undefined) {

for (var iSecondaryResultCounter = 0; iSecondaryResultCounter < data.d.query.SecondaryQueryResults.results.length; iSecondaryResultCounter++) {

var resultBlock = data.d.query.SecondaryQueryResults.results[iSecondaryResultCounter].RelevantResults.Table.Rows.results;

for (var iResults = 0; iResults < resultBlock.length; iResults++) {

html += "<tr><td>";

html += resultBlock[iResults].Cells.results[3].Value;

html += "</td><td><a href=\""

html += resultBlock[iResults].Cells.results[6].Value;

html += "\">" + resultBlock[iResults].Cells.results[6].Value + "</a></td><tr>";

}

html += "</table>";

$("#SearchResultsDiv").append(html);

}

function onSearchError(err) {

alert(JSON.stringify(err));

}

Best SharePoint 2013 Hosting Recommendation HostForLIFE.eu HostForLIFE.eu offer the Best, Cheap and Recommended SharePoint 2013 hosting start from €9.99/month. They can load…

SharePoint Hosting News: Script to Stop SharePoint Timer Service in All Servers

September 23, 2015

In this post, I will tell you about Script to Stop SharePoint Timer Service in all Servers. As a single unified logical entity, a SharePoint farm requires a mechanism to run tasks necessary to provide its services. These tasks include updating components of the farm such as servers and services, and updating data and configuration in farm databases. To run these tasks, SharePoint provides its own scheduled tasks management service, manifested as Timer Service instances installed on every SharePoint server…

SharePoint 2013 Hosting News – How to Develope a List in SharePoint 2013 Online Using REST API?

September 17, 2015

Today, let me show you How to Develope a List in SharePoint 2013 Online Using REST API. First, open new project and then replace the contents of Default.aspx with the following:

<%-- The markup and script in the following Content element will be placed in the <head>of the page --%> 
<asp:content contentplaceholderid="PlaceHolderAdditionalPageHead" runat="server"> 
    <script type="text/javascript" src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.9.1.min.js"></script> 
    <script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script> 
    <script type="text/javascript" src="/_layouts/15/sp.js"></script> 
    <!-- Add your CSS styles to the following file --> 
    <link rel="Stylesheet" type="text/css" href="../Content/App.css" /> 
    <!-- Add your JavaScript to the following file --> 
    <script type="text/javascript" src="../Scripts/App.js"></script> 
</asp:content> 
<%-- The markup in the following Content element will be placed in the TitleArea of the page --%> 
<asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server">Page Title</asp:content> 
<%-- The markup and script in the following Content element will be placed in the <body>of the page --%> 
<asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server">

<%-- The markup and script in the following Content element will be placed in the <head>of the page --%>

<asp:content contentplaceholderid="PlaceHolderAdditionalPageHead" runat="server">

</asp:content>

<%-- The markup in the following Content element will be placed in the TitleArea of the page --%>

<asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server">Page Title</asp:content>

<%-- The markup and script in the following Content element will be placed in the <body>of the page --%>

<asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server">

REST API Examples

</asp:content> 
<%-- The markup and script in the following Content element will be placed in the <body>of the page --%> 
<asp:content contentplaceholderid="PlaceHolderMain" runat="server"> 
    <div> 
        <p> 
            <b>Create List</b> 
            <br /> 
            <input type="text" value="List Name Here" id="createlistname" /> 
            <button id="createlistbutton">Create List</button> 
        </p> 
    </div> 
</asp:content>

</asp:content>

<%-- The markup and script in the following Content element will be placed in the <body>of the page --%>

<asp:content contentplaceholderid="PlaceHolderMain" runat="server">

<div>

<p>

<b>Create List</b>

<br />

<button id="createlistbutton">Create List</button>

</p>

</div>

</asp:content>

App.js Replace the contents of App.js with the following:

use strict '; 
var hostweburl; 
var appweburl; 
// Load the required SharePoint libraries. 
$(document).ready(function() { 
//Get the URI decoded URLs. 
hostweburl = decodeURIComponent( 
    getQueryStringParameter("SPHostUrl")); 
appweburl = decodeURIComponent( 
    getQueryStringParameter("SPAppWebUrl")); 
//Assign events to buttons 
$("#createlistbutton").click(function(event) { 
    createList(); 
    event.preventDefault(); 
}); 
// Resources are in URLs in the form: 
// web_url/_layouts/15/resource 
var scriptbase = hostweburl + "/_layouts/15/"; 
// Load the js file and continue to load the page with information about the list top level folders. 
// SP.RequestExecutor.js to make cross-domain requests 
$.getScript(scriptbase + "SP.RequestExecutor.js"); 
}); 
// Utilities 
// Retrieve a query string value. 
// For production purposes you may want to use a library to handle the query string. 
function getQueryStringParameter(paramToRetrieve) { 
var params = document.URL.split("?")[1].split("&"); 
for (var i = 0; i < params.length; i = i + 1) { 
    var singleParam = params[i].split("="); 
    if (singleParam[0] == paramToRetrieve) return singleParam[1]; 
} 
} 
// Create a new custom list 
function createList() { 
var listName = document.getElementById("createlistname").value; 
var executor; 
// Initialize the RequestExecutor with the app web URL. 
// Content Type Header is used to tell server what format data in the body contains. 
executor = new SP.RequestExecutor(appweburl); 
executor.executeAsync({ 
    url: appweburl + "/_api/SP.AppContextSite(@target)/web/Lists?@target='" + hostweburl + "'", 
    method: "POST", 
    body: "{ '__metadata': { 'type': 'SP.List' }, 'BaseTemplate': 100,'Description': '" + listName + "', 'Title':'" + listName + "'}", 
    headers: { 
        "content-type": "application/json; odata=verbose" 
    }, 
    success: createListSuccessHandler, 
    error: createListErrorHandler  
});  
}  
// Success Handler  
function createListSuccessHandler(data) {  
alert("List Created successfully")  
}  
// Error Handler  
function createListErrorHandler(data, errorCode, errorMessage) {  
alert("Could not create a new list: " + errorMessage);  
}

use strict ';

var hostweburl;

var appweburl;

// Load the required SharePoint libraries.

$(document).ready(function() {

//Get the URI decoded URLs.

hostweburl = decodeURIComponent(

getQueryStringParameter("SPHostUrl"));

appweburl = decodeURIComponent(

getQueryStringParameter("SPAppWebUrl"));

//Assign events to buttons

$("#createlistbutton").click(function(event) {

createList();

event.preventDefault();

});

// Resources are in URLs in the form:

// web_url/_layouts/15/resource

var scriptbase = hostweburl + "/_layouts/15/";

// Load the js file and continue to load the page with information about the list top level folders.

// SP.RequestExecutor.js to make cross-domain requests

$.getScript(scriptbase + "SP.RequestExecutor.js");

});

// Utilities

// Retrieve a query string value.

// For production purposes you may want to use a library to handle the query string.

function getQueryStringParameter(paramToRetrieve) {

var params = document.URL.split("?")[1].split("&");

for (var i = 0; i < params.length; i = i + 1) {

var singleParam = params[i].split("=");

if (singleParam[0] == paramToRetrieve) return singleParam[1];

}

// Create a new custom list

function createList() {

var listName = document.getElementById("createlistname").value;

var executor;

// Initialize the RequestExecutor with the app web URL.

// Content Type Header is used to tell server what format data in the body contains.

executor = new SP.RequestExecutor(appweburl);

executor.executeAsync({

url: appweburl + "/_api/SP.AppContextSite(@target)/web/Lists?@target='" + hostweburl + "'",

method: "POST",

body: "{ '__metadata': { 'type': 'SP.List' }, 'BaseTemplate': 100,'Description': '" + listName + "', 'Title':'" + listName + "'}",

headers: {

"content-type": "application/json; odata=verbose"

success: createListSuccessHandler,

error: createListErrorHandler

});

}

// Success Handler

function createListSuccessHandler(data) {

alert("List Created successfully")

}

// Error Handler

function createListErrorHandler(data, errorCode, errorMessage) {

alert("Could not create a new list: " + errorMessage);

}

SharePoint 2013 Hosting News – How to Clear SharePoint Config Cache Files with PowerShell ?

August 19, 2015

Other Related Posts

Today, We will learn about Clear SharePoint Config Cache files with powershell scripts. Now write the following code:

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm  
$LogFile = ".\ClearSPConfigCachePatch-$LogTime.rtf"  

# Add SharePoint PowerShell Snapin  

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {  
Add-PSSnapin Microsoft.SharePoint.Powershell  
}  
$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent  
Set-Location $scriptBase  

#Deleting any .rtf files in the scriptbase location  
$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf  
if($FindRTFFile)  
{  
foreach($file in $FindRTFFile)  
{  
remove-item $file  
}  
}  

start-transcript $logfile  

Write-host "##############Following steps will be involved################" -fore green  
write-host "Step 1 - Stop the timerservice" -fore cyan  
write-host "Step 2 - Take the backup of config cache file" -fore cyan  
write-host "Step 3 - Delete the XML files" -fore cyan  
write-host "Step 4 - Reset the cache.ini file" -fore cyan  
write-host "Step 5 - Start the SP timerservice" -fore cyan  
Write-host "##############Above steps will be involved##################" -fore green  

$global:timerServiceName = "SharePoint 2010 Timer"  
$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"  

# Get the local farm instance  
[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()  
Function StopSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
Write-Host ""  
foreach($server in $farm.Servers)  
{  
foreach($instance in $server.ServiceInstances)  
  {  
       # If the server has the timer service then stop the service  
         if($instance.TypeName -eq $timerServiceInstanceName)  
         {  
           [string]$serverName = $server.Name  

           Write-Host "Stop " $timerServiceName " service on server: " $serverName -fore yellow  
              
            $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"  
           $serviceInternalName = $service.Name  
           sc.exe \\$serverName stop $serviceInternalName > $null  

             # Wait until this service has actually stopped  
write-host "Waiting for '$timerServiceName' service on server: " $serverName " to be stopped" -fore yellow  
             do  
  {  
       Start-Sleep 1  
        Write-Host -foregroundcolor DarkGray -NoNewLine "."  
       $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"  
  }  
 while ($service.State -ne "Stopped")  
write-host " '$timerServiceName' service on server: " $serverName " stopped successfully" -fore green              
            break;  
         }  
  }  
}  

Write-Host ""  
}  


Function BackupSPConfigFiles([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
write-host ""  
write-host "Backup SP config cache files" -fore yellow  

foreach($server in $farm.servers)  
{  
foreach($instance in $server.ServiceInstances)  
{  
if($instance.TypeName -eq $timerServiceInstanceName)  
{  
$ServerName = $server.name  
$FolderName  = $servername + "SPConfigCacheBackup"  
write-host "Creating a folder to hold the backup files" -fore magenta  
write-host "Checking whether the folder aleady exist"  
if(Test-path $scriptbase\$FolderName)  
{  
write-host "Folder already exists and the script is deleting it......"  
remove-item $scriptbase\$FolderName -recurse -confirm:$false   
write-host "Existing folder deleted" -fore green  
}  
else  
{  
write-host "Folder does not exist"  
}  
New-Item $scriptbase\$FolderName -type directory  
write-host "New folder created to hold the backup files" -fore magenta  
write-host "Backup of SP config files for the server " $serverName " started ...... " -fore yellow  
$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config"  
Copy-Item $path -Destination $scriptbase\$FolderName -recurse  
write-host "SP config cache files backed up for the server " $serverName " Sucessfully..." -fore green  
}  
}  
}  
write-host "SP config caches files are backed up" -fore green  
write-host ""  
}  


Function DeletingXMLFiles([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
Write-host ""  
write-host "Deleting SP config cache XML files from each server in the farm" -fore yellow  
$path = ""  
foreach($server in $farm.servers)  
{  
foreach($instance in $server.ServiceInstances)  
{  
if($instance.TypeName -eq $timerServiceInstanceName)  
{  
$serverName = $server.Name  
write-host "Deleting SP config cache files from the server " $servername -fore magenta  
$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\*.xml"  
remove-item -path $path -force  
write-host "SP config cache files deleted on the server " $servername -fore magenta  
break  
}  
}  
}  
write-host "SP config cache XML files from each server in the farm is deleted successfully......" -fore green  
write-host ""  
}  


Function ResetTimerCache([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
write-host ""  
write-host "Reseting the value of timer cache to 1" -fore yellow  
$path = ""  
foreach($server in $farm.servers)  
{  
foreach($instance in $server.ServiceInstances)  
{  
if($instance.TypeName -eq $timerServiceInstanceName)  
{  
$serverName = $server.Name  
write-host "Reseting the value of timer cache file in server " $serverName -fore magenta  
$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\cache.ini"  
Set-Content -path $path -Value "1"  
write-host "Value of timer cache file in server " $serverName " is resetted to 1" -fore magenta  
break  
}  
}  
}  
write-host "The value of timer cache is resetted to 1 in all the SP servers in the farm" -fore green  
write-host ""  
}  


Function StartSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm)  
{  
Write-Host ""  
foreach($server in $farm.Servers)  
{  
foreach($instance in $server.ServiceInstances)  
  {  
       # If the server has the timer service then stop the service  
         if($instance.TypeName -eq $timerServiceInstanceName)  
         {  
           [string]$serverName = $server.Name  

           Write-Host "Start " $timerServiceName " service on server: " $serverName -fore yellow  
              
            $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"  
           $serviceInternalName = $service.Name  
           sc.exe \\$serverName start $serviceInternalName > $null  

             # Wait until this service starts running  
write-host "Waiting for " $timerServiceName " service on server: " $serverName " to be started" -fore yellow  
             do  
  {  
       Start-Sleep 1  
        Write-Host -foregroundcolor DarkGray -NoNewLine "."  
       $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"  
  }  
 while ($service.State -ne "Running")  
write-host $timerServiceName " service on server: " $serverName " started successfully" -fore green              
            break;  
         }  
  }  
}  

Write-Host ""  
}  


#############Calling functions################  
StopSPTimerServicesInFarm $farm  
BackupSPConfigFiles $farm  
DeletingXMLFiles $farm  
ResetTimerCache $farm  
StartSPTimerServicesInFarm $farm  
##########################################  

write-host "SCRIPT COMPLETED" -fore cyan  
stop-transcript

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm

$LogFile = ".\ClearSPConfigCachePatch-$LogTime.rtf"

# Add SharePoint PowerShell Snapin

if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) {

Add-PSSnapin Microsoft.SharePoint.Powershell

}

$scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent

Set-Location $scriptBase

#Deleting any .rtf files in the scriptbase location

$FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf

if($FindRTFFile)

{

foreach($file in $FindRTFFile)

{

remove-item $file

}

start-transcript $logfile

Write-host "##############Following steps will be involved################" -fore green

write-host "Step 1 - Stop the timerservice" -fore cyan

write-host "Step 2 - Take the backup of config cache file" -fore cyan

write-host "Step 3 - Delete the XML files" -fore cyan

write-host "Step 4 - Reset the cache.ini file" -fore cyan

write-host "Step 5 - Start the SP timerservice" -fore cyan

Write-host "##############Above steps will be involved##################" -fore green

$global:timerServiceName = "SharePoint 2010 Timer"

$global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer"

# Get the local farm instance

[Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local()

Function StopSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

Write-Host ""

foreach($server in $farm.Servers)

{

foreach($instance in $server.ServiceInstances)

{

# If the server has the timer service then stop the service

if($instance.TypeName -eq $timerServiceInstanceName)

{

[string]$serverName = $server.Name

Write-Host "Stop " $timerServiceName " service on server: " $serverName -fore yellow

$service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"

$serviceInternalName = $service.Name

sc.exe \\$serverName stop $serviceInternalName > $null

# Wait until this service has actually stopped

write-host "Waiting for '$timerServiceName' service on server: " $serverName " to be stopped" -fore yellow

{

Start-Sleep 1

Write-Host -foregroundcolor DarkGray -NoNewLine "."

$service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"

}

while ($service.State -ne "Stopped")

write-host " '$timerServiceName' service on server: " $serverName " stopped successfully" -fore green

break;

}

Write-Host ""

}

Function BackupSPConfigFiles([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

write-host ""

write-host "Backup SP config cache files" -fore yellow

foreach($server in $farm.servers)

{

foreach($instance in $server.ServiceInstances)

{

if($instance.TypeName -eq $timerServiceInstanceName)

{

$ServerName = $server.name

$FolderName = $servername + "SPConfigCacheBackup"

write-host "Creating a folder to hold the backup files" -fore magenta

write-host "Checking whether the folder aleady exist"

if(Test-path $scriptbase\$FolderName)

{

write-host "Folder already exists and the script is deleting it......"

remove-item $scriptbase\$FolderName -recurse -confirm:$false

write-host "Existing folder deleted" -fore green

}

else

{

write-host "Folder does not exist"

}

New-Item $scriptbase\$FolderName -type directory

write-host "New folder created to hold the backup files" -fore magenta

write-host "Backup of SP config files for the server " $serverName " started ...... " -fore yellow

$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config"

Copy-Item $path -Destination $scriptbase\$FolderName -recurse

write-host "SP config cache files backed up for the server " $serverName " Sucessfully..." -fore green

}

write-host "SP config caches files are backed up" -fore green

write-host ""

}

Function DeletingXMLFiles([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

Write-host ""

write-host "Deleting SP config cache XML files from each server in the farm" -fore yellow

$path = ""

foreach($server in $farm.servers)

{

foreach($instance in $server.ServiceInstances)

{

if($instance.TypeName -eq $timerServiceInstanceName)

{

$serverName = $server.Name

write-host "Deleting SP config cache files from the server " $servername -fore magenta

$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\*.xml"

remove-item -path $path -force

write-host "SP config cache files deleted on the server " $servername -fore magenta

break

}

write-host "SP config cache XML files from each server in the farm is deleted successfully......" -fore green

write-host ""

}

Function ResetTimerCache([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

write-host ""

write-host "Reseting the value of timer cache to 1" -fore yellow

$path = ""

foreach($server in $farm.servers)

{

foreach($instance in $server.ServiceInstances)

{

if($instance.TypeName -eq $timerServiceInstanceName)

{

$serverName = $server.Name

write-host "Reseting the value of timer cache file in server " $serverName -fore magenta

$path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\cache.ini"

Set-Content -path $path -Value "1"

write-host "Value of timer cache file in server " $serverName " is resetted to 1" -fore magenta

break

}

write-host "The value of timer cache is resetted to 1 in all the SP servers in the farm" -fore green

write-host ""

}

Function StartSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm)

{

Write-Host ""

foreach($server in $farm.Servers)

{

foreach($instance in $server.ServiceInstances)

{

# If the server has the timer service then stop the service

if($instance.TypeName -eq $timerServiceInstanceName)

{

[string]$serverName = $server.Name

Write-Host "Start " $timerServiceName " service on server: " $serverName -fore yellow

$service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"

$serviceInternalName = $service.Name

sc.exe \\$serverName start $serviceInternalName > $null

# Wait until this service starts running

write-host "Waiting for " $timerServiceName " service on server: " $serverName " to be started" -fore yellow

{

Start-Sleep 1

Write-Host -foregroundcolor DarkGray -NoNewLine "."

$service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'"

}

while ($service.State -ne "Running")

write-host $timerServiceName " service on server: " $serverName " started successfully" -fore green

break;

}

Write-Host ""

}

#############Calling functions################

StopSPTimerServicesInFarm $farm

BackupSPConfigFiles $farm

DeletingXMLFiles $farm

ResetTimerCache $farm

StartSPTimerServicesInFarm $farm

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

write-host "SCRIPT COMPLETED" -fore cyan

stop-transcript

SharePoint 2013 Hosting News – How to Update SharePoint List Metadata Column?

August 12, 2015