Set the refinable property to true for Managed Metadata Property in Search Service Application and do full crawl using PowerShell

Hi Again,

I came up with a requirement where I want to show the custom managed metadata property in the search refinement web part in the search results page.

By default the refinable property of any managed property is non set as false/not active. In order to show a property in the search refinement web part , it has to be active/true.

Below is the PowerShell script I wrote to update the custom managed metadata refinable property and then I did the full crawl.

	#Checking the Refiners refinable property for Managed Properties
	Write-Host "Checking for refinable property for managed property" -ForegroundColor Yellow
	$searchServiceApp=Get-SPEnterpriseSearchServiceApplication
	$isFullCrawlRequired=$false;
	#Custom Audience Managed Property
	Write-Host "Checking refinable property for CustomAudience" -ForegroundColor Yellow
	$audience= Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication $searchServiceApp | ? {$_.Name -eq "owstaxidCustomAudience"}
	#Metadata Managed Property is always starts with owstaxid*
	if($audience.Refinable -eq $false){
	$audience.Refinable =$true
	$audience.Update()
	$isFullCrawlRequired=$true
	}
	if($isFullCrawlRequired -eq $false )
	{
	$customContentsources=Get-SPEnterpriseSearchCrawlContentSource -SearchApplication $searchServiceApp | ? {$_.Name -eq 'YourContentSourceName'}
	if($customContentsources -ne $null)
	{
	Write-Host "Full crawl has started..." -ForegroundColor Yellow
	$customContentsources.StartFullCrawl()
	do {Start-Sleep -s 1} while ($customContentsources.CrawlStatus -ne "Idle")
	Write-Host "Full crawl is completed successfully..." -ForegroundColor Green
	}
	}

view raw gistfile1.ps1 hosted with ❤ by GitHub

Hope this is helpful.
Cheers,
Isha Jain  

SharePoint 2013 Exception from HRESULT : 0x80131904

Hi All,

I am recently involved in big migration project from SharePoint 2010 to SharePoint 2013. During this journey I come across a very weird exception - Exception from HRESULT : 0x80131904.

One of the site collections in the migrated web application is giving me this issue for all the users except site collection administrator. When any user other than site collection administrator tries to either change master page or page layouts under look and feel section in the site settings page. The user is getting the below error.

I have checked the permissions for the below lists and it all inherits from parent.

• Master Page Gallery
• Device Channel

Then I thought is it something related to windows to claims conversion , as I am getting the below error when I ran Test-SPContentDatabase.

"The web application is configured with claims authentication mode however the content database you are trying to attach is intended to be used against a windows classic authentication mode."

then I ran the below script to convert users from Windows to Claims to my content database, but still no luck.

Windows to Claims Conversion:

	$webApp = Get-SPWebApplication "My web application url here"
	$webApp | Get-SPContentDatabase | ft Name # get the content database number
	$arguments = New-Object Microsoft.SharePoint.Administration.SPWebApplication+SPMigrateUserParameters
	$arguments.AddDatabaseToMigrate($webApp.ContentDatabases[0])
	$webApp.MigrateUsersToClaims("farm admin account", $false, $arguments)

view raw WindowsToClaims hosted with ❤ by GitHub

I have also tried deleting the master page gallery and importing from other working site collection but still the same error message.

ULS logs also giving me very weird errors like below:

Invalid column name 'tp_IsCurrent' - from the SQL executed for AllUserData table of the content database. When I read more about this column in the database I found the below description.

tp_IsCurrent: When a file is checked out, tp_IsCurrent is set to false on that file’s record, and a new line is created for the checked-out version of the file (wherein tp_IsCurrent becomes true).

I have almost lost my patience as I have spent more than a week to troubleshoot this issue. Then I found a light in the tunnel. I tried moving one of the items "BlankWebPartPage.aspx" from the master page gallery to a blanknew document library and have found that it also copies the below fields and content type in the document library when I copied the file.

Content Type: Page Layout

When I click on any of the above lookup fields, I got access denied for all the users except site collection administrators. Then I realised , it is something to do with the access with the above lookup fields.

Then I found, the nice blog explaining about the cache Profiles
http://sureshpydi.blogspot.com.au/2013/10/cache-profiles-in-sharepoint.html

and I found my solution to the problem, it is the Cache Profile list has unique permissions. I then just deleted the unique permissions from my cache profile list and everything started working :).


Hope this could save some of your time.

Cheers,
Isha Jain

 

How to call and pass parameter from one PowerShell script file to another?

I came across a scenario where I have to call another PowerShell script file and pass the current PowerShell script file input parameter to this second file.

PowerShell as the name says is very powerful and I was able to achieve my requirement with a simple expression called as "Invoke-Expression" in PowerShell.

Just to explain you how I have achieved my above requirement, I have created two demo PowerShell files called First.ps1 and Second.ps1. I am gonna show you how I have called First.ps1 and invoke the Second.ps1and pass the First.ps1 input parameter to the Second.ps1 with "Invoke-Expression".

	clear-Host
	$snapin = Get-PSSnapin | Where-Object { $_.Name -eq "Microsoft.SharePoint.Powershell" }
	if ($snapin -eq $null) {
	Write-Host "Loading SharePoint Powershell Snapin..."
	Add-PSSnapin "Microsoft.SharePoint.Powershell"
	}
	Write-Host "First!!"
	$name = $(Read-Host -Prompt "Enter your Name:")
	$PSScriptRoot = Split-Path -Parent -Path $MyInvocation.MyCommand.Definition
	Invoke-Expression "$PSScriptRoot\Second.ps1 $name"

view raw First.ps1 hosted with ❤ by GitHub

	param
	(
	[string]$name
	)
	if($name)
	{
	Write-Host "Welcome $name from second file"
	}
	else
	{
	Write-Host "Nothing!!"
	}

view raw Second.ps1 hosted with ❤ by GitHub

Hope this is helpful.
Cheers!!
Isha Jain

Upgrade Search Settings and result sources using PowerShell in SharePoint 2013

I came up with a requirement where I want the user to search the results only from the site collection level. In SharePoint 2010, we all know there are search scopes which help us to narrow down our search based on content sources, web address and metadata. However; there is no search scopes in SharePoint 2013. There is a new concept similar to Search Scope called as Search Result Sources.

This Result sources can be created at "Application Level", "Site Collection Level" and "Site Level".

You could find more information on Result Sources in SharePoint 2013 @ http://technet.microsoft.com/en-us/library/dn186229(v=office.15).aspx

I decided to script out the following
1. Creation of Enterprise Search Centre site
2. Update the search settings to point to this new search centre instead of default OSSSearchResults page.
3. Create a site collection level result source
4. Update the search results webpart properties to query only at above created site collection result source.

1. Create Enterprise Search Centre via PowerShell

	$Url = $(Read-Host -Prompt "Enter site url:")
	if(-not(Get-PSSnapin | Where-Object {$_.Name -eq "Microsoft.SharePoint.PowerShell"})) {
	Add-PSSnapin Microsoft.SharePoint.PowerShell;
	}
	$site = Get-SPSite $Url
	Write-Host "Settings up search centre setup for your site" -ForegroundColor Yellow
	$webs=$site.AllWebs | ? {$_.Url -like "*search*"}
	$webs | % { Write-Host "Deleting old search centre" -ForegroundColor Yellow ; $_.Delete() }
	Enable-SPFeature -Identity "BaseSite" -Url $site.Url
	$searchSiteUrl= $site.Url+"/searchcentre"
	New-SPWeb $searchSiteUrl -Name Search -Template SRCHCEN#0 -UseParentTopNav
	Write-Host "Search centre is setup for your site successfully" -ForegroundColor Green

view raw gistfile1.ps1 hosted with ❤ by GitHub

Note: you need to activate the "BaseSite" Collection hidden feature before creating the search centre.
2. Settings the results page for your above search centre

	Write-Host "Settings results page for search centre for your site" -ForegroundColor Yellow
	$SEARCH_SETTINGS_PROPERTY_NAME = "SRCH_SB_SET_WEB"
	$settingsObj = @{}
	$settingsObj.Inherit = $false
	$settingsObj.ResultsPageAddress = "/searchcentre/pages/results.apsx"
	$settingsObj.ShowNavigation = $false
	$settingsObjAsJSON = ConvertTo-Json $settingsObj -Compress
	if (!$web.AllProperties.ContainsKey($SEARCH_SETTINGS_PROPERTY_NAME))
	{
	Write-Host "- adding new entry " -ForegroundColor Yellow -NoNewline
	$web.AllowUnsafeUpdates = $true
	$web.AddProperty($SEARCH_SETTINGS_PROPERTY_NAME, $settingsObjAsJSON)
	$web.Update()
	}
	else
	{
	Write-Host "- updating entry " -ForegroundColor Yellow -NoNewline
	$web.AllowUnsafeUpdates = $true
	$web.SetProperty($SEARCH_SETTINGS_PROPERTY_NAME, $settingsObjAsJSON);
	$web.Update()
	}
	Write-Host "Results page for search centre for your site is set succesfully" -ForegroundColor Green

view raw gistfile1.ps1 hosted with ❤ by GitHub

3. Create a Site Collection level result source

	rite-Host "setting up the site collection level result souce for the site" -ForegroundColor yellow
	$resultSourceName="MyResultSource"
	$resultSourceDescription ="site collection result source"
	$query="{searchTerms?} Path:{SiteCollection.Url}"
	$ssa = Get-SPEnterpriseSearchServiceApplication "Search Service Application"
	$fedman = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($ssa)
	$searchOwner = Get-SPEnterpriseSearchOwner -SPWeb $web -Level SPSite
	$resultSource = $fedman.GetSourceByName($resultSourceName, $searchOwner)
	#Check To See if it exists
	if(!$resultSource){
	$resultSource = $fedman.CreateSource($searchOwner)
	}
	$resultSource.Name =$resultSourceName
	$resultSource.ProviderId = $fedman.ListProviders()['Local SharePoint Provider'].Id
	$resultSource.Description = $resultSourceDescription
	$resultSource.CreateQueryTransform($query)
	$resultSource.Commit()
	Write-Host "Settings the Site Collection scope for the search results in the Search Results webpart" -ForegroundColor yellow

view raw gistfile1.ps1 hosted with ❤ by GitHub

4. Update the search results webpart to use this above result source for query.

	$resultSourceID=$resultSource.ID
	$resultSourceLevel="SPSite"
	$webURL =$web.Url + "/searchcentre"
	$web=Get-SPWeb $webURL
	$pageUrl="$webURL/Pages/results.aspx?k=test"
	$page=$web.lists["Pages"].Items | ? {$_.Name -eq "results.aspx"}
	$page.File.CheckOut();
	$webpartmanager=$web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
	$webpart = $webpartmanager.WebParts | ? { $_.Title -eq 'Search Results' }
	$dataProvider = ConvertFrom-Json $webpart.DataProviderJSON
	$dataProvider.SourceID=$resultSourceID
	$dataProvider.SourceLevel=$resultSourceLevel
	$dataProvider.SourceName=$resultSourceName
	$webpart.DataProviderJSON = ConvertTo-Json $dataProvider -Compress
	$webpartmanager.SaveChanges($webpart)
	$page.File.CheckIn("Changed the Result Source")
	$page.File.Publish("Changed the Result Source")
	Write-Host "Site Collection scope for the search results in the Search Results webpart is set to 'MyResultSource' successfully" -ForegroundColor green

view raw gistfile1.ps1 hosted with ❤ by GitHub

Hope you like my approach.
enjoy!!
Isha Jain

Runtime error when creating SharePoint 2013 Pulishing site

Today, I received a very strange error when creating a sub publishing site in SharePoint 2013. I received the below error runtime error with the famous yellow screen.

I am surprised to see this error and I have full control to the site and uls logs says access denied to one of the mobile channel list. I wondered what is mobile channel list is, then after much searching I have found that there is a new feature introduced in SharePoint 2013 called device channels.

With Device channel in SharePoint 2013, you can render a single publishing site in multiple ways by using different designs that target different devices like Mobile, i-Pad etc.

In order to resolve this error, you need to grant at least read only access to all the users to this device channel list or break the unique permissions to this list. Device channel list is hidden and can be accessible via site settings -> Device Channels

Thus to solve the above error while creating the sub publishing site, at least provide read only permission to sub site owners at device channel list.

Hope this must have saved lot of your time.

Cheers,
Isha Jain



 

Add Custom Web Parts to a page and Connect them using PowerShell

These days I am working heavily on SharePoint CSOM and BCS (Business Connectivity Services). I have created a sandbox package with multiple custom business data and html form data web parts.

The reason why I am writing this blog is to share with you some of the cool stuffs I did with PowerShell in the project.

I have written many automation scripts to create web part page, add web parts to this page and then connect to them on a single click using PowerShell.

First thing first…

1.       Create a web part page using PowerShell:

	Function CreateWebPartPage
	{
	param($title,$name,$pageLayout)
	Write-Host "***************Creating Web part page: "$title -ForegroundColor Yellow
	if([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($web)){
	$pubWeb =[Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web)
	$name+=".aspx";
	$layout = $pubWeb.GetAvailablePageLayouts() | Where { $_.Name -eq $pageLayout}
	$newPage = $pubWeb.AddPublishingPage($name, $layout);
	$newPage.Title=$title;
	$newPage.Update()
	Write-Host "***************Page is created successfully" -ForegroundColor Yellow
	}
	Else{
	Write-Host "***************Not a publishing web" -ForegroundColor Yellow
	}}
	$Url = $(Read-Host -Prompt "Enter site url:")
	$web = Get-SPWeb $Url
	CreateWebPartPage "Test Page" "Test" "BlankWebPartPage.aspx"
	$web.Dispose();

view raw CreateWebPartPage hosted with ❤ by GitHub

2.       Add web part to this page:

	$Url = $(Read-Host -Prompt "Enter site url:")
	$web = Get-SPWeb $Url
	$web.AllowUnsafeUpdates=$true
	function Add-WebPartToPage($pageUrl, $webpartzone,$index,$fileName)
	{
	$webPartGallery = $web.Lists["Web Part Gallery"]
	Write-Host "Searching webpart $fileName in web part gallery" -ForegroundColor Yellow
	if($webPartGallery -eq $null)
	{
	Write-Host("Unable to retrieve Webpartgallery");
	}
	$webpart = $null;
	$webpart=$webPartGallery.Items | ? { $_.Title -eq $fileName}
	if($webpart -eq $null) {
	Write-Host("Unable to retrieve webpart: $fileName") -ForegroundColor Red
	}
	else {
	Write-Host("----------Adding Webpart--------")-ForegroundColor Yellow
	$webpartmanager=$web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
	$errorMsg = "";
	$xmlReader = New-Object System.Xml.XmlTextReader($webpart.File.OpenBinaryStream());
	$webpart = $webpartmanager.ImportWebPart($xmlReader,[ref]"Error")
	$webpartmanager.AddWebPart($webpart, $webpartzone, $index);
	Write-Host("Webpart is added successfully") -ForegroundColor Green ;
	}
	}
	$SiteURL =$Url
	#---------------Test Page----------------------------
	$PageName="Test.aspx"
	$page=$web.lists["Pages"].Items | ? {$_.Name -eq $PageName}
	$page.File.CheckOut();
	Add-WebPartToPage "$SiteURL/Pages/$PageName" "Header" 0 "My Custom WebPart"
	$page.File.CheckIn("Added Web part to a page");
	$page.File.Approve("Added Web part to a page");

view raw AddWebparttoAPage hosted with ❤ by GitHub

3.       Connect web parts in a page: In this script I have shown how we can connect

a.       Query String filter Web Part with Business Data List Web Part

b.      Query String filter Web Part with Business Data Item Web Part

c.       Business data List Web Part with Business Data Item Builder Web Part

 

	function Connect-QueryStringFilterWP-To-BCSListWP($pageUrl,$fileName,$providerWP,$consumerArrayValue,$providerArrayValue,$consumerConnectionId)
	{
	$webPartGallery = $web.Lists["Web Part Gallery"]
	$webpartmanager=$web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
	Write-Host "Searching Consumer webpart $fileName in web part gallery" -ForegroundColor Yellow
	if($webPartGallery -eq $null)
	{
	Write-Host("Unable to retrieve Webpartgallery");
	}
	$webPartConsumer = $webpartmanager.WebParts | Where {$_.Title -eq $fileName}
	Write-Host "Searching Consumer webpart $providerWP in web part gallery" -ForegroundColor Yellow
	$webPartProvider = $webpartmanager.WebParts | Where {$_.Title -eq $providerWP}
	$conWP = $webpartmanager.GetConsumerConnectionPoints($webPartConsumer)
	$provWP = $webpartmanager.GetProviderConnectionPoints($webPartProvider)
	$conWP=$conWP[$consumerConnectionId]
	$provWP=$provWP["ITransformableFilterValues"]
	$trans = New-Object Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToParametersTransformer
	$consumerArray=@($consumerArrayValue)
	$providerArray=@($providerArrayValue)
	$trans.ProviderFieldNames=$providerArray
	$trans.ConsumerFieldNames=$consumerArray
	$newCon = $webpartmanager.SPConnectWebParts($webPartProvider,$provWP,$webPartConsumer,$conWP,$trans)
	$webpartmanager.SPWebPartConnections.Add($newCon);
	$webpartmanager.Dispose()
	Write-Host "Webparts are connected successfully" -ForegroundColor Green
	}
	function Connect-QueryStringFilterWP-To-BCSListItemWP($pageUrl,$fileName,$providerWP,$consumerConnectionId)
	{
	$webPartGallery = $web.Lists["Web Part Gallery"]
	$webpartmanager=$web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
	Write-Host "Searching Consumer webpart $fileName in web part gallery" -ForegroundColor Yellow
	if($webPartGallery -eq $null)
	{
	Write-Host("Unable to retrieve Webpartgallery");
	}
	$webPartConsumer = $webpartmanager.WebParts | Where {$_.Title -eq $fileName}
	Write-Host "Searching Consumer webpart $providerWP in web part gallery" -ForegroundColor Yellow
	$webPartProvider = $webpartmanager.WebParts | Where {$_.Title -eq $providerWP}
	$conWP = $webpartmanager.GetConsumerConnectionPoints($webPartConsumer)
	$provWP = $webpartmanager.GetProviderConnectionPoints($webPartProvider)
	$conWP=$conWP[$consumerConnectionId]
	$provWP=$provWP["ITransformableFilterValues"]
	$trans = New-Object Microsoft.SharePoint.Portal.WebControls.TransformableFilterValuesToEntityInstanceTransformer
	$newCon = $webpartmanager.SPConnectWebParts($webPartProvider,$provWP,$webPartConsumer,$conWP,$trans)
	$webpartmanager.SPWebPartConnections.Add($newCon);
	$webpartmanager.Dispose()
	Write-Host "Webparts are connected successfully" -ForegroundColor Green
	}
	function Connect-BCSWebParts($pageUrl,$fileName,$providerWP){
	$webPartGallery = $web.Lists["Web Part Gallery"]
	$webpartmanager=$web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
	Write-Host "Searching Consumer webpart $fileName in web part gallery" -ForegroundColor Yellow
	if($webPartGallery -eq $null)
	{
	Write-Host("Unable to retrieve Webpartgallery");
	}
	$webPartConsumer = $webpartmanager.WebParts | Where {$_.Title -eq $fileName}
	Write-Host "Searching Consumer webpart $providerWP in web part gallery" -ForegroundColor Yellow
	$webPartProvider = $webpartmanager.WebParts | Where {$_.Title -eq $providerWP}
	$conWP = $webpartmanager.GetConsumerConnectionPoints($webPartConsumer)[0]
	$provWP = $webpartmanager.GetProviderConnectionPoints($webPartProvider)[0]
	$newCon = $webpartmanager.SPConnectWebParts($webPartProvider,$provWP,$webPartConsumer,$conWP)
	$webpartmanager.SPWebPartConnections.Add($newCon);
	$webpartmanager.Dispose()
	Write-Host "Webparts are connected successfully" -ForegroundColor Green
	}
	function setupPageConnections ($pageName) {
	Write-Host "Connecting webparts for page: $pageName" -ForegroundColor Yellow
	$page=$web.lists[$LibName].Items | ? {$_.Name -eq $PageName}
	$page.File.CheckOut();
	setupWebPartsConnections $pageName
	$page.File.CheckIn("Webparts are connected");
	$page.File.Approve("Webparts are connected");
	}
	function setupWebPartsConnections ($pageName) {
	Connect-BCSWebParts "$SiteURL/$LibName/$PageName" "{Custom Webpart Title}" "Business Data Item Builder" #{Custom Webpart Title} with title of custom web part
	Connect-QueryStringFilterWP-To-BCSListWP "$SiteURL/$LibName/$PageName" "My Custom WebPart" "{Query String Filter WebPart tilte}" "{Custom Webpart filter Name}" "QueryString" "BDWP Query Values"
	Connect-QueryStringFilterWP-To-BCSListItemWP "$SiteURL/$LibName/$PageName" "{Custom Webpart Title}" "{Query String Filter WebPart tilte}" "BDWP Item"
	}
	$Url = $(Read-Host -Prompt "Enter site url:")
	$web = Get-SPWeb $Url
	$web.AllowUnsafeUpdates=$true
	$LibName = "Pages";
	$SiteURL =$Url
	setupPageConnections "Test.aspx"
	$web.Update();
	$web.AllowUnsafeUpdates=$false
	$web.Dispose()

view raw Connect WebParts hosted with ❤ by GitHub

Have Fun!

Isha Jain

Paste content into SharePoint with no formatting

Hello Again,

These days I am working heavily into SharePoint Ribbon customization. If you have not read my previous blog on this, I would recommend you to read Previous Ribbon Blog before reading this one.

SharePoint 2010 brings the new evolution in user interface and have brought common functionalities into same page by introducing the Ribbon concept.

In SharePoint user is allowed to copy content from various sources like email, office applications like word, excel  and paste into SharePoint.

By default there are two ways to paste content into SharePoint from ribbon.


1. Paste (paste content with styles and formatting)
2. Paste palintext (paste content without styles but keeps the formatting)


However; pasting the content even as Plain text from word and other sources into SharePoint  introduces breaks and other markup issues in Html.

Paste  (format:break line and color:Blue)
Add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue | out-null
Write-Host "Hello All"

Paste Plaintext (only format:break line)
Add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue | out-null
Write-Host "Hello All"

I wanted to achive something shown below.

Paste with no formatting (no format no color)
Add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue | out-null Write-Host "Hello All"



I have created a sandbox solution and added element.xml as shown below.

	<?xml version="1.0" encoding="UTF-8"?>
	<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
	<CustomAction Location="CommandUI.Ribbon" Id="AddNewPaste">
	-<CommandUIExtension><CommandUIDefinitions>
	<!--Add Paste with no formatting to the Paste Group -->
	<CommandUIDefinition Location="Ribbon.EditingTools.CPEditTab.Clipboard.Paste.Menu.Paste.Controls._children">
	<Button Id="Ribbon.Inset.CustomGroup.Paste"
	Alt="Paste as plain text with no formatting"
	ToolTipTitle="Paste as plain text with no formatting"
	ToolTipDescription="Paste the contents of clipboard as plain text with no formatting."
	Sequence="30" LabelText="Paste with no formatting"
	Image16by16="_layouts/images/Paste.gif"
	Image32by32="_layouts/images/PasteHH.png"
	TemplateAlias="o1" Command="Ribbon.Paste"/>
	</CommandUIDefinition></CommandUIDefinitions>
	<CommandUIHandlers>
	<CommandUIHandler Command="Ribbon.Paste" CommandAction="javascript:pasteAsPlainTextWithNoFormatting();"/>
	</CommandUIHandlers>
	</CommandUIExtension>
	</CustomAction>
	</Elements>

view raw gistfile1.xml hosted with ❤ by GitHub

On click of this flyout anchor menu I have called a javascript function as defined in commandaction attribute in the command handler.

	function pasteAsPlainTextWithNoFormatting() {
	var cursorLocation = RTE.Cursor.get_range();
	var copiedData = window.self.clipboardData.getData('Text'); //Copy content from clipboard
	var copiedDataSpan = document.createElement('span');
	copiedDataSpan.setAttribute('id', 'copiedData');
	copiedDataSpan.innerText = copiedData; //add clipboard content to new span element
	cursorLocation.deleteContent();
	cursorLocation.insertBefore(copiedDataSpan); //add the content with the span element at the cursor location
	var rawContent = $ribbon('#copiedData').html(); //find that span
	var cleanContent = rawContent.replace(/<[^>]*>/gi, ''); //remove all the formatting
	$ribbon('#copiedData').html(cleanContent);//add the content back
	RTE.RteUtility.removeNodeAndKeepChildNodes(copiedDataSpan);//remove the span by keeping the data
	RTE.Cursor.update(); //update the cursor position
	}

view raw gistfile1.js hosted with ❤ by GitHub

Hope you find this useful.
Cheers,
Isha Jain