Sharepoint hide an item from edit control block (ECB)

A simpler way to remove any item from the Edit Control Block of SharePoint 2013 site is to add some javascript in master page. This way we can also hide the item(s) from specific lists. To do this, just add the below code in a javascript file and link that js file to your master page. Alternatively you can also make use of Content Editor Web part to embed it in a page.

$(document).ready(function ()

{

    $('.ms-core-menu-list').live('focus', function ()

    {

        var ecbToHide = "Version History";

        var showVersionHistory = $("li[text='" + ecbToHide + "']");

        if window.location.href.toLowerCase().indexOf(encodeURIComponent('/Lists/TechPerspect/')) != -1)

        {

            showVersionHistory.hide();

        }

        else

        {

            showVersionHistory.show();

        }

    });

});

The above snippet will remove the ECB item - "Version History" from the List - "TechPerspect". 

spweb.properties.remove not working (SPPropertyBag)

This might have bugged a lot of developers that spweb property bag doesn't removes the key when you execute following code

if ( spweb.Properties.ContainsKey(key) )
{
    spweb.Properties.Remove(key);
    spweb.Properties.Update();
}

The Correct code for making sure that property is removed from the from the spweb properties bag is : -

if ( spweb.Properties.ContainsKey(key) )
{
    spweb.AllProperties.Remove(key);
    spweb.Properties[key] = null;
    spweb.Properties.Update();
    spweb.Update();
}

Install Timer Jobs through Powershell in SharePoint

If you need to install Timer service through Powershell in SharePoint, you can make use of the below script. This script will install custom timer job in the defined web application. Fir the purpose of testing, this script also has a function to execute the timer job. This is very helpful if you wish to execute your job immediately after installing.

Copy below code and paste it in file with extension - .ps1

#__________________________Install SharePoint Timer Jobs___________________________________

# ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#                             VARIABLE DECLATRATION

# +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#

# Grab the web app URL from User

write-host "Enter the Web Application Url where you want to deploy the Timer service:"

[string]$webAppUrl = Read-Host

# Define here the Timer Job assembly name.

[string]$assemblyName = "TechPerspect.TimerJobs"

# Define here the Job Name

[string]$jobName = "TechPerspect Demo Timer Job"

# Define the class name here. (assembly name + class name of timer job)

$className = "TechPerspect.TimerJobs.DemoTimerJob"

# load the required assemblies

[void][reflection.assembly]::LoadWithPartialName("Microsoft.SharePoint")

[void][reflection.assembly]::LoadwithPartialName("Microsoft.Office.Server")

# Stop further execution of an error occured anywhere in script

$ErrorActionPreference = "Stop"

#

# +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#                                 Functions

# ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#

# This methods restarts SharePoint Timer service (OWSTIMER)

function global:Restart-TimerServices

{

    # Restart timer services

    Write-Host "Restarting SharePoint Timer services"

    Stop-Service "SPTimerV4"

    Start-Service "SPTimerV4"

}

function global:Install-TimerJob

{

    Restart-TimerServices

    # Load job assembly

    [void][reflection.assembly]::LoadwithPartialName($assemblyName)

    # below call is commented however may be used in Powershell v3.0, since          

    # LoadwithPartialName is depreciated after powershell 2.0

    #[System.Reflection.Assembly]::Load("TechPerspect.TimerJobs, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d8668901f3456325")

    $objSPSite = [Microsoft.SharePoint.SPSite]$webAppUrl

    $objWebApplication = $objSPSite.WebApplication

    # search for the Job

    $objTimerJobInstance = $objWebApplication.JobDefinitions | ? { $_.Name -like $jobName }

       # Delete the job instance if already exists

       if ($objTimerJobInstance)

    {

        Write-Host "Job [" $objTimerJobInstance.Name "] already exists. Deleting..."

       $objTimerJobInstance.Delete()

       }

      

       # Initlize new instance of timer job

    # Note that the argument List should be same, which you have defined in your 

    # timer service code for invoking the service.

    # Argument list could contain 1, 2, 3 params depending upon constructor used 

    # in your timer code

    $objTimerJobInstance = new-object $className -ArgumentList $jobName,$objWebApplication

      

       # Create a Daily Schedule

    $sched = new-object Microsoft.SharePoint.SPDailySchedule

    # setting the hour to execute at 0100 AM to 0200 AM

    $sched.BeginHour = 1

    $sched.EndHour = 2

    $objTimerJobInstance.Schedule = $sched

    $objTimerJobInstance.Update()

       # Set the schedule to the timerjob object and save the job schedule

    $objTimerJobInstance.Schedule = $sched

    $objTimerJobInstance.Update()

   

    # Dispose site

    $objSPSite.Dispose()

    Restart-TimerServices

}

#This method will execute the Timer Job.(helpful when testing the timer jobs)

function global:Execute-TimerJob

{

    # Open site

    $objSPSite = [Microsoft.SharePoint.SPSite]$webAppUrl

    $objWebApplication = $objSPSite.WebApplication

    # Content DB to execute job on

    $contentDB = $objWebApplication.ContentDatabases[0]

    # Search for the Job

    $objTimerJobInstance = $objWebApplication.JobDefinitions | ? { $_.Name -like $jobName }

    if ($objTimerJobInstance)

    {

        Write-Host "Executing Timer Job [" $objTimerJobInstance.Name "]..."

        $objTimerJobInstance.Execute($contentDB.Id)

        Write-Host "Job Executed successfully!"

    }

    else

    {

        Write-Host "Job [" $jobName "] not found"

    }

    # Dispose site

    $objSPSite.Dispose()

}

#

# ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#                                        MAIN

# ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#

Install-TimerJob

# If you want to test the timer service, uncomment the below method call

#Write-Host "Executing the Timer Job..."

#Execute-TimerJob

SharePoint 2010 : Custom BCS connector for Search with Security Trimming, Batching, Incremental Crawling

This guide is designed to highlight the solution for enabling security trimming on search results in SharePoint 2010 for external database. It also focuses on large datasets and file system crawling. It provides an overview of the requirement, a solution for the same, and concludes with implementation of the solution suggested. In order to have item level security implemented and search result trimming based on security, we need to have the security descriptor generated for each record and present in the table for each row. BCS is used to pull data and index in SharePoint for implementing search driven applications, we need constant updation of data from the external system. In such systems we need incremental update to work to ensure CRUD operations. If you have documents stored in your External Systems then it is possible using the Business Connectivity Services (BCS) give your end users the ability to access and crawl these artifacts with ease. The Stream Accessor method allows you to pull System.Byte[] data from your External System and make it available from within SharePoint.

http://social.technet.microsoft.com/wiki/contents/articles/22945.sharepoint-2010-custom-bcs-connector-for-search-with-security-trimming-batching-incremental-crawling.aspx

How to programmatically update a content source in SharePoint 2010 enterprise / fast search

Following are the assembly references required to execute the code

using Microsoft.Office.Server.Search.Administration;
using Microsoft.SharePoint.Administration;
using Microsoft.SharePoint.BusinessData.Administration;
using Microsoft.SharePoint.BusinessData.Parser;
using Microsoft.SharePoint.BusinessData.SharedService;
using Microsoft.SharePoint.BusinessData.Infrastructure;
using Microsoft.BusinessData.Infrastructure;
using Microsoft.BusinessData.MetadataModel;
using Microsoft.Office.Server.Search;
using Microsoft.SharePoint.Search.Extended.Administration;
 

Here is the function that take two parameters as first is your central application url and other parameter to define if you want to configure fast search or enterprise search. You can use the code individually also in case you dont want to configure both.

public void UpdateContentSource(string WebAppUrl, bool IsFast)

        {

            try

            {

                string strContentSourceName = "<CustomContentSourceName>";

                string strLogSystemName = "<BDCLogSystemName>";

                //Content Source Update Started

                //execute this code if you are updaameting a fast search content source. else user for enterprise content source

                if (IsFast)

                {

                    foreach (SearchServiceApplication FASTServiceApp in SearchService.Service.SearchApplications)

                    {

                        SearchServiceApplicationType at = FASTServiceApp.SearchApplicationType;

                        if (FASTServiceApp.SearchApplicationType == SearchServiceApplicationType.ExtendedConnector)

                        {

                            Content FastContent = new Content(FASTServiceApp);

                            bool CheckExist = false;

                            ContentSourceCollection FastCSColl = FastContent.ContentSources;

                            foreach (ContentSource cs in FastCSColl)

                            {

                                if (cs.Name.Equals(strContentSourceName))

                                {

                                    CheckExist = true;

                                    Console.WriteLine(strContentSourceName + " FAST Search Content Source already exist");

                                }

                            }

                            BusinessDataContentSource CustomConSource = null;

                            if (CheckExist)

                            {

                                CustomConSource = (BusinessDataContentSource)FastCSColl[strContentSourceName];

                                if (CustomConSource.StartAddresses.Count > 0)

                                {

                                    CustomConSource.StartAddresses.Remove(BusinessDataContentSource.ConstructStartAddress("Default", new Guid("00000000-0000-0000-0000-000000000000"), strLogSystemName, strLogSystemName));

                                }

                                CustomConSource.Delete();

                                FastCSColl.Update();

                                Console.WriteLine(strContentSourceName + " FAST Search Content Source Deleted");

                            }

                            CustomConSource = (BusinessDataContentSource)FastCSColl.Create(typeof(BusinessDataContentSource), strContentSourceName);

                            CustomConSource.StartAddresses.Add(BusinessDataContentSource.ConstructStartAddress("Default", new Guid("00000000-0000-0000-0000-000000000000"), strLogSystemName, strLogSystemName));

                            CustomConSource.CrawlPriority = CrawlPriority.Normal;

                            FastCSColl.Update();

                            Console.WriteLine("External Source FAST Content Source Created");

                        }

                    }

                }

                else

                {

                    using (SPSite site = new SPSite(WebAppUrl))

                    {

                        foreach (SearchServiceApplication objServiceApp in SearchService.Service.SearchApplications)

                        {

                            if (objServiceApp.SearchApplicationType == SearchServiceApplicationType.Regular)

                            {

                                SearchServiceApplicationProxy proxy = (SearchServiceApplicationProxy)SearchServiceApplicationProxy.GetProxy(SPServiceContext.GetContext(site));

                                Guid appId = proxy.GetSearchServiceApplicationInfo().SearchServiceApplicationId;

                                SearchServiceApplication SearchApp = objServiceApp;         //SearchService.Service.SearchApplications.GetValue<SearchServiceApplication>(appId);

                                Content content = new Content(SearchApp);

                                ContentSourceCollection csColl = content.ContentSources;

                                bool CheckExist = false;

                                foreach (ContentSource cs in csColl)

                                {

                                    if (cs.Name.Equals(strContentSourceName))

                                    {

                                        CheckExist = true;

                                        Console.WriteLine(strContentSourceName + " is already exist");

                                    }

                                }

                                BusinessDataContentSource CustomConSource = null;

                                if (CheckExist)

                                {

                                    CustomConSource = (BusinessDataContentSource)csColl[strContentSourceName];

                                    if (CustomConSource.StartAddresses.Count > 0)

                                    {

                                        CustomConSource.StartAddresses.Remove(BusinessDataContentSource.ConstructStartAddress("Default", new Guid("00000000-0000-0000-0000-000000000000"), strLogSystemName, strLogSystemName));

                                    }

                                    CustomConSource.Delete();

                                    csColl.Update();

                                    Console.WriteLine(strContentSourceName + " Deleted");

                                }

                                CustomConSource = (BusinessDataContentSource)csColl.Create(typeof(BusinessDataContentSource), strContentSourceName);

                                CustomConSource.StartAddresses.Add(BusinessDataContentSource.ConstructStartAddress("Default", new Guid("00000000-0000-0000-0000-000000000000"), strLogSystemName, strLogSystemName));

                                CustomConSource.CrawlPriority = CrawlPriority.Normal;

                                csColl.Update();

                                Console.WriteLine("External Source Content Source Created");

                            }

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                Console.WriteLine("Error:" + ex.Message);

            }

            Console.WriteLine("Content Source Update Ended");

        }