My SharePoint Technical Experience

Get Folder size quickly using PowerShell

noreply@blogger.com (Ulhas Morbale) — Thu, 15 Jul 2021 15:47:00 +0000

Use the below PowerShell to Get Folder size quickly,

Install-Module -Name GetSTFolderSize

Get-StFolderSize -Path "C:\FolderPath\ABC" -RoboOnly -RoboThreadCount 128

Populate people picker field with logged in user in SharePoint using JS

noreply@blogger.com (Ulhas Morbale) — Mon, 30 Jul 2018 12:48:00 +0000

Please use below code to populate people picker in SharePoint online,

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript">
ExecuteOrDelayUntilScriptLoaded(function () {
setTimeout(function () {
SetUserFieldValue('AuthorName'); }, 1000);
}, 'clientpeoplepicker.js');

//Set PeoplePicker Value
function SetUserFieldValue(fieldName) {
try{
var userAccountName = _spPageContextInfo.userLoginName;
//PeoplePicker Object
var peoplePicker = $("div[title='" + fieldName + "']");
//PeoplePicker ID
var peoplePickerTopId = peoplePicker.attr('id');
//People PickerEditor
var peoplePickerEditor = $("input[title='" + fieldName + "']");
//Set Value to Editor
peoplePickerEditor.val(userAccountName);
//Get Client PeoplePicker Dict
var peoplePickerObject = SPClientPeoplePicker.SPClientPeoplePickerDict[peoplePickerTopId];
//Unresolve User From Editor
peoplePickerObject.AddUnresolvedUserFromEditor(true);
}catch(e) {

}
}//End Set PeoplePicker Value
</script>

Ref: https://jasonscript.wordpress.com/2013/08/07/javascript-and-working-with-the-sharepoint-2013-people-picker/

Select and Delete text vertically in bigger text OR flat file

noreply@blogger.com (Ulhas Morbale) — Tue, 06 Feb 2018 08:05:00 +0000

If you want to Select and Delete text vertically in bigger text OR any flat file use below command to do it.

Example below:
A BCEDF
CDEFTS
CEDDPR
TEXT Sample
My Data

Keep the cursor at first line character which you want to delete and press keys CTRL+ALT+SHIFT and select the contents using mouse and press delete button.

This trick also can be used to delete characters in middle of text as below,

Hope this helps!

How Internet Bots Works?

noreply@blogger.com (Ulhas Morbale) — Wed, 28 Jun 2017 16:12:00 +0000

What is bot?
An internet robot or simply a bot is a software application that runs automated scripts on the web.

How it works?
Typically bots perform tasks that are simple and structurally repetitive at a much higher rate than what is possible for human being. So one single bot can handle queries(in whatever format like voice, chat OR Email) of hundreds of customers at the same time.

Companies don't want their bots to sound too mechanical or business-like so we need to do a lot of cultural adaption in bots.

Machine Learning and Artificial Intellingence (AI) form the underlying base of bots. For businesses to start their bots programme, they should collect a lot of customer related data. This fragmented data is used to populate the knowledge bank servers.

Bots which understand behavior pattern will be able to pick "odd" transaction requests like humans do.

Most of the Social Media platforms are using bots for most common activities.

Below is the pictorial explanation about it.

The instance has exceeded the outbound http request quota for a 1.00:00:00 time period. The 5000 request limit was reached in

noreply@blogger.com (Ulhas Morbale) — Wed, 15 Feb 2017 10:32:00 +0000

This happens when you have so many REST calls from O365 SharePoint designer workflow, below is the KB article for details.

https://support.microsoft.com/en-us/help/3076399/sharepoint-2013-workflow-throttling-and-performance-in-sharepoint-online-and-project-online

EnableVersioning at site collection level

noreply@blogger.com (Ulhas Morbale) — Sun, 29 Jan 2017 16:30:00 +0000

We can use the bele PowerShell script to enable versioning at site collection level,

Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue

$web = get-spweb "site coll url"

$lists = $web.lists

foreach ($list in $lists)

{

if($list.EnableVersioning -eq $false)

{

write-host $list.title " is a not using versions"

$list.Enableversioning = $true

$List.MajorVersionLimit = 5

$list.update()

}

else

{

Write-host $list.title " is set for up to " $list.MajorVersionLimit "previous versions"

}

Deploy dll to GAC in SharePoint

noreply@blogger.com (Ulhas Morbale) — Mon, 12 Dec 2016 16:08:00 +0000

Deploy dll to GAC in SharePoint

E:\GACUtil -latest>gacutil.exe /i "E:\GACUtil -latest\MyNamespace.Contact.Sample.dll" /f

SPEasyForms

noreply@blogger.com (Ulhas Morbale) — Mon, 12 Dec 2016 16:06:00 +0000

This one is best alternative for InfoPath forms,

https://speasyforms.codeplex.com/

SharePoint 2013 - Send Email With Attachment

noreply@blogger.com (Ulhas Morbale) — Mon, 12 Dec 2016 16:05:00 +0000

https://spworkflowactions.codeplex.com/

Show modified by author and date in all pages in O365 SharePoint site

noreply@blogger.com (Ulhas Morbale) — Mon, 12 Dec 2016 16:03:00 +0000

Show modified by author and date in all pages in O365 SharePoint site using below script,

$(document).ready(function() {
GetEditorAndDate();
}); // end document-ready

function GetEditorAndDate()
{
var relativePageURL = _spPageContextInfo.serverRequestPath;
var siteURL = _spPageContextInfo.webAbsoluteUrl;
var profileUrl = "https://myorg.sharepoint.com/sites/devsite/";

var query = siteURL + "/_api/web/getfilebyserverrelativeurl('/"+ relativePageURL +"')?$select=TimeLastModified,ModifiedBy/Title,ModifiedBy/LoginName&$expand=ModifiedBy";

var call = $.ajax({
url: query,
type: "GET",
dataType: "json",
headers: {
Accept: "application/json;odata=verbose"
}
});
call.done( (function (data, textStatus, err){
rawModifedBy = data.d.ModifiedBy.Title
prettiedModifiedBy = rawModifedBy.split(', ')[1]+' '+ rawModifedBy.split(', ')[0]

rawModifiedId=data.d.ModifiedBy.LoginName; //<d:LoginName>i:0#.w|klasj\kpereyra</d:LoginName>
var modifiedId= rawModifiedId.replace('i:0#.w|', '') 

var rawModifedDate = new Date(data.d.TimeLastModified);

console.log("Page modified data"+data.d);
var mm = rawModifedDate.getMonth()+1;
var modifedDate= rawModifedDate.toLocaleDateString()+" "+rawModifedDate.toLocaleTimeString();

var aboveFooter = '<div id="freshIndicator" style="width: 500px;margin-left: auto;margin-right: auto;">This page was last modified by ' + prettiedModifiedBy +' on '+ modifedDate +'</div>'
$(".footer").append(aboveFooter); 
}));

call.fail(function (err,textStatus,errorThrown){
console.log(err);
});
}

Hope this helps someone!

How to delete duplicates from SharePoint list using JSOM

noreply@blogger.com (Ulhas Morbale) — Thu, 17 Nov 2016 11:16:00 +0000

How to delete duplicates from SharePoint list using JSOM, Credit: Thulasi Pasam Reference: https://community.nintex.com/thread/8516

Note:

Make sure the reference file paths
Make sure the column to test duplicate on CAML query
Update your SharePoint list name

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/tr/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=5, IE=8, IE=9, IE=10" >

</head>
<body>
<div Id="myDiv" style= "width: 75%;">
<table id="tblHeading" width = "100%" align = "left">
<tr style ="width:100%;">
<td><input type= "button" onclick="Delete()" align = "Center" alt="Delete Duplicates" value="Delete"></td>
</tr>
</table>

</body>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script src="https://sharepoint.jtafla.com/sites/ROI/Scripts/spjs-utility.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/0.7.2/jquery.SPServices-0.7.2.min.js" ></script>

<script>
var ListA = new Array();
var ListB = new Array();
var strList= 'Your List Name';

$(document).ready (function() {
GetAllListA();

});

function GetAllListA(){
var vblMembers ='';
var strQuery= "<Query> <OrderBy> <FieldRef Name='User_Email_Address' Ascending='TRUE' /> </OrderBy> </Query>";

$().SPServices({
operation: "GetListItems",
async: false,
listName: strList,
CAMLQuery: strQuery,
completefunc: function (xData, Status) {
if(Status == 'success')
{
$(xData.responseXML).SPFilterNode("z:row").each(function(){

ListA.push($(this).attr("ows_User_Email_Address"));
});
}
}
});

}

function GetAllListB(){
var vblMembers ='';
var strQuery= "<Query> <OrderBy> <FieldRef Name='User_Email_Address' Ascending='TRUE' /> </OrderBy> </Query>";
ListB = [];
$().SPServices({
operation: "GetListItems",
async: false,
listName: strList,
CAMLQuery: strQuery,
completefunc: function (xData, Status) {
if(Status == 'success')
{
$(xData.responseXML).SPFilterNode("z:row").each(function(){

ListB.push($(this).attr("ows_User_Email_Address"));
});
}
}
});

}

function Delete(){
GetAllListA();
GetAllListB();

for (var i=0; i<ListA.length; i++) {
var count = 0;

for (var j=0; j<ListB.length; j++)
{
if(ListA[i] == ListB[j])
{
count = count+1;
if (count > 1)
{
DeleteDuplicate(ListA[i]);
GetAllListB();
count = 0;
break;
}
}
}
if (count > 1)
{
count = 0;
break;
}

}
alert('All duplicates are removed!');
}

function DeleteDuplicate(tempName){
var delId = GetIdByName(tempName);
alert(delId != "undefined")
{
$().SPServices({
operation:"UpdateListItems",
async: false,
batchCmd: "Delete",
listName: strList,
ID: delId,
completefunc:function(xData, Status)
{
//alert("Item Deleted");
}
});
}
}

function GetIdByName(tempName){
var vblMembers ='';
var strQuery = "<Query><Where><Eq><FieldRef Name='User_Email_Address'/><Value Type='text'>"+tempName+"</Value></Eq></Where></Query>";
var tempid = new Array();
$().SPServices({
operation: "GetListItems",
async: false,
listName: strList,
CAMLQuery: strQuery,
completefunc: function (xData, Status) {
if(Status == 'success')
{
$(xData.responseXML).SPFilterNode("z:row").each(function(){

tempid.push($(this).attr("ows_ID"));
});
}
}
});
return tempid[0];
}
</script>
</html>

Show confirmation message on click of save in OOB list forms in SharePoint

noreply@blogger.com (Ulhas Morbale) — Fri, 28 Oct 2016 18:01:00 +0000

Show confirmation message on click of save in OOB list forms in SharePoint, add the below script in each OOB list form page.

<script type="text/javascript" language="javascript" src="/sites/dev/Style%20Library/Scripts/jquery-3.1.0.min.js"></script>
<script type="text/javascript">
function PreSaveAction()
{
if($('[id*="Update"]').is(':checked')){
return (confirm("This item has value of Update as “Yes”. Are you sure you want to save this item?"));
}
else{
return true;
}
}
</script>

Bind a html string with Enhanced rich text box which has heavy formatting in O365 using Angular JS

noreply@blogger.com (Ulhas Morbale) — Wed, 19 Oct 2016 09:32:00 +0000

Bind a html string with Enhanced rich text box which has heavy formatting in O365 using Angular JS , below solution did the trick.

You have to use $sce.trustAsHtml(), to use it directly into the DOM, you could do it like this, JS/controller part:

Ref: http://stackoverflow.com/questions/21503588/angularjs-bind-html-string-with-custom-style

$scope.trustAsHtml = function(string) {
    return $sce.trustAsHtml(string);
};


And in DOM/HTML part
<div data-ng-bind-html="trustAsHtml(htmlString)"></div>

URL field in list returns 2 values in SharePoint

noreply@blogger.com (Ulhas Morbale) — Wed, 22 Jun 2016 06:30:00 +0000

I got confused when URL field in list SharePoint list returns 2 values, we need use methods to get respective values as mentioned in below URL,

http://sharepoint.stackexchange.com/questions/158079/how-to-retrieve-list-hyperlink-field-values

GetListItem and UpdateListItem using SPServices in MOSS 2007

noreply@blogger.com (Ulhas Morbale) — Tue, 07 Jun 2016 07:34:00 +0000

GetListItem and UpdateListItem using SPServices in MOSS 2007

$(document).ready(function() {
var itemToUpdate = GetListItem();
UpdateListItem(itemToUpdate);
});

function GetListItem(){

var today = new Date();
var dayOfWeek = today.getDay();
var itemID = 0;
var out = "";

var titleField = "<FieldRef Name='Title' />";
var descriptionField = "<FieldRef Name='Description' />";

var viewFields = "<ViewFields>" + titleField + descriptionField + "</ViewFields>";
var myQuery = "<Query>" +
"<OrderBy>" +
"<FieldRef Name='ItemOrder' Ascending='True'/>" +
"</OrderBy>" +
"</Query>";

$().SPServices({
operation: "GetListItems",
async: false,
listName: "MyList",
CAMLQuery: myQuery,
CAMLViewFields: viewFields,
completefunc: function (xData, Status) {
var activeItemAvailable = false;
$(xData.responseXML).SPFilterNode("z:row").each(function() {
strTitle = $(this).attr("ows_Title");
strDescription = $(this).attr("ows_Description");
itemID = $(this).attr("ows_ID");
});

$("#divID").html(out);
}
});
return itemID;
}

function UpdateListItem(itemToBeUpdated)
{
var today = new Date();
var lastTuesdayDate = today.GetLastTuesdayOfWeek().toISOString();
$().SPServices({
operation:"UpdateListItems",
async: false,
listName: "MyList",
ID: itemToBeUpdated,
valuepairs:[["IsActive", true], ["DateMadeActive", lastTuesdayDate]],
completefunc:function(xData, Status)
{
}
});
}

Date.prototype.GetLastTuesdayOfWeek = function() {
return (new Date(this.setDate(this.getDate() - this.getDay() + 2)));
}

Delete a particular web part from all the sites ans sub sites

noreply@blogger.com (Ulhas Morbale) — Thu, 31 Mar 2016 10:52:00 +0000

Please us below PowerShell script to delete a particular web part from all the sites ans sub sites,

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

#$CSVFile = Import-CSV -Path "E:\Ulhas\Subsites.csv"
$filepath = "E:\Ulhas\Subsites.csv"

Import-CSV $filepath -Header SiteUrl | Foreach-Object{

$SPweb = Get-SPWeb $_.SiteUrl #"https://www.contoso.com/it/pmo/"

$webpartmanager = $SPweb.GetLimitedWebPartManager(($SPweb.Url + "default.aspx"), [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)

$webpartsarray = @()

For($i=0;$i -lt $webpartmanager.WebParts.Count;$i++)
{
if($webpartmanager.WebParts[$i].title -eq "ScriptToRemoveBlankSpace") #Check for particular web part
{
$webpartsarray = $webpartsarray + $webpartmanager.WebParts[$i].ID
}
}

$var=$webpartsarray.length
write-host $var

for($j=0; $j -lt $var; $j++)
{
$webpartmanager.DeleteWebPart($webpartmanager.WebParts[$webpartsarray[$j]])

# call CloseWebPart method to close the web part
}

$SPweb.Update();
$SPweb.Dispose();
}

Permission audit report for site and all sub sites using PowerShell

noreply@blogger.com (Ulhas Morbale) — Thu, 17 Mar 2016 11:58:00 +0000

Use below script to get Permission audit report for site and all sub sites using PowerShell,

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$URL="https://intranet.contoso.com/sales/mysite/"

$site = Get-SPSite $URL

#Write the Header to "Tab Separated Text File"

"Site Name`t URL `t Group Name `t User Account `t User Name `t E-Mail" | out-file "E:\Ulhas\UsersandGroupsRpt.txt"

#Iterate through all Webs

foreach ($web in $site.AllWebs)

{

#Write the Header to "Tab Separated Text File"

"$($web.title) `t $($web.URL) `t `t `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append

#Get all Groups and Iterate through

foreach ($group in $Web.groups)

{

"`t `t $($Group.Name) `t `t `t " | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append

#Iterate through Each User in the group

foreach ($user in $group.users)

{

#Exclude Built-in User Accounts

if(($User.LoginName.ToLower() -ne "nt authority\authenticated users") -and ($User.LoginName.ToLower() -ne "sharepoint\system") -and ($User.LoginName.ToLower() -ne "nt authority\local service"))

{

"`t `t `t $($user.LoginName) `t $($user.name) `t $($user.Email)" | out-file "E:\Ulhas\UsersandGroupsRpt.txt" -append

}

}

}

}
$site.dispose();

write-host "Report Generated at E:\Ulhas\UsersandGroupsRpt.txt"

Color coding the list status column in SharePoint 2013

noreply@blogger.com (Ulhas Morbale) — Thu, 17 Mar 2016 08:45:00 +0000

Below formula can be used to color code the list status column in SharePoint 2013,

="<DIV style='font-weight:bold; font-size:42px; color:"&CHOOSE(RIGHT(LEFT(Priority,2),1),"red","orange","green")&";'>•</DIV>"

Credit goes to Junaid Khan here: https://junaidsk.wordpress.com/2014/02/25/color-coding-in-sharepoint-lists-using-calculated-columns/

Application error when access /_admin/owners.aspx, Error=User cannot be found. reolved using PowerShell

noreply@blogger.com (Ulhas Morbale) — Fri, 04 Mar 2016 07:56:00 +0000

While trying to set site collection admin and secondary admin from central admin in SharePoint I got below error in ULS log,

Application error when access /_admin/owners.aspx, Error=User cannot be found. at Microsoft.SharePoint.SPUserCollection.GetByID(Int32 id) at Microsoft.SharePoint.Administration.SPSiteAdministration.get_SecondaryContactLoginName()

User below PowerShell

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
Set-SPSite –Identity https://contoso.com/sites/it/ –SecondaryOwnerAlias domain\umorbale

https://technet.microsoft.com/en-in/library/ff631156.aspx?f=255&MSPPError=-2147217396

https://pholpar.wordpress.com/2011/05/13/user-cannot-be-found-error-solved-using-a-sql-query/

Redirecting the SharePoint site to another site

noreply@blogger.com (Ulhas Morbale) — Tue, 02 Feb 2016 09:29:00 +0000

Add script editor web part and paste below script in edit snippet, replace google.com with destination site URL.

 <script type="text/javascript">

$(document).ready(function(){
window.location.href = "https://www.google.com/";
});
</script>

Hide top navigation and quick launch in SharePoint 2013

noreply@blogger.com (Ulhas Morbale) — Fri, 29 Jan 2016 05:18:00 +0000

Hide top navigation and quick launch in SharePoint 2013,

<style type="text/css">

.main-topbar,
#siteIcon,
.search-area,
#s4-titlerow,
#sideNavBox{display:none !important;}
#contentBox {
margin-left: 0;
}
div#s4-ribbonrow {
height: auto !important;
margin: 0;
}
#ActionDiv a {
background: #f1f1f1 none repeat scroll 0 0;
border: 1px solid #ccc;
display: inline-block;
margin-bottom: 5px;
margin-right: 4px;
padding: 3px 8px !important;
text-align: center;
}
#ActionDiv {
text-align: left;
}
</style>

Hope this helps!!!

Article page showing HTML tags in SharePoint 2013

noreply@blogger.com (Ulhas Morbale) — Fri, 29 Jan 2016 04:57:00 +0000

Article page showing HTML tags, use below PowerShell to fix as mentioned here :

http://labs.steveottenad.com/publishing-columns-show-escaped-html-in-sharepoint-2010/

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$web = Get-SPWeb "https://contoso.com/sites/mysite/it/"
$list = $web.GetPublishingPages();

foreach ($page in $list.Items)
{
if ($page.Title -eq "Testing123")
{
[Microsoft.SharePoint.Publishing.Fields.HtmlField]$field = [Microsoft.SharePoint.Publishing.Fields.HtmlField]$list.Fields[“Page Content”]
$field.RichText = $true
$field.RichTextMode = [Microsoft.SharePoint.SPRichTextMode]::FullHtml
$field.Update()
break;
}
}
$list.Update()
$web.dispose()

Hope this helps!!!

How to move list paging in top right corner in SharePoint 2013

noreply@blogger.com (Ulhas Morbale) — Fri, 29 Jan 2016 04:54:00 +0000

Add script editor web part and paste the below code to move list paging in top right corner in SharePoint 2013,

<script type="text/javascript">

$(document).ready( function()
{
var header = $("table.ms-listviewtable");
var table = $("#bottomPagingCellWPQ3");

if(header && table)
{
table.insertBefore(header);
$("#bottomPagingCellWPQ3").css('text-align', 'right');
}
else
{
alert('jQuery did not found Elements.');
}
});
</script>
<style type="text/css">
td#bottomPagingCellWPQ3{float:right}
</style>

Hope this helps!!!

Apply page layout for a particular page in SharePoint 2013 using PowerShell

noreply@blogger.com (Ulhas Morbale) — Wed, 13 Jan 2016 15:04:00 +0000

In this article we will see how to apply page layout for a particular page in SharePoint 2013 using PowerShell,

$spWeb = Get-SPWeb("https://server.com/sites/MyWeb")
$spFile = $spWeb.GetFile("https://server.com/sites/Pages/MyPage.aspx")
$spFile.CheckOut("Online",$null)
$spFile.Properties["PublishingPageLayout"] = "/sites/_catalogs/masterpage/PageLayout.aspx"
$spFile.Update()
$spFile.CheckIn("Update page layout via PowerShell",[Microsoft.SharePoint.SPCheckinType]::MajorCheckIn)
$spWeb.Dispose()

Hope this helps!

Why Microsoft has not given first and Last options in SharePoint paging???

noreply@blogger.com (Ulhas Morbale) — Wed, 16 Dec 2015 06:46:00 +0000

This is just a question I had in my mind that: Why Microsoft has not given first and Last options in SharePoint List/Document Library or any other paging for that matter?