Rakesh Patel

Thursday, September 27, 2018

Promoted Links -> Script to show tile in rows and column

Promoted Links in SharePoint always show in a single row, following script help to break it into columns and rows also added style that will modify height and width.

// Copy Paste follow script into "Script Editor" above your Promoted Link web-part.

/*  Tile and border size. Delta between ms-tileview-tile-root and size of the promoted link tiles is the space between tiles  */
.ms-tileview-tile-root {
     width: 105px! important;
     height: 105px !important;
}

/*  size of the promoted link tiles */
.ms-tileview-tile-content, .ms-tileview-tile-detailsBox {
     width: 100px !important;
     height: 100px !important;
}

/*  size of the image within the promoted link tile */
.ms-tileview-tile-content > a > img {
     width: 100% !important;
     height: 100% !important;
}

/* Changes the Promoted Link Title when you hover over it*/
.ms-tileview-tile-detailsListMedium {
     font-weight: bold;
     height: 100px;
     padding: 4px 7px 7px;
     font-size: 12px;
     line-height: 14px;
}

/* Changes the Promoted Link Description when you hover over it*/
.ms-tileview-tile-descriptionMedium {
     font-weight: normal;
     padding-top: 10px;
     font-size: 11px;
     /*  If you want to change the font size, change above */
}

/*  Remove this if you only what to show the images and not the text */
/*  Adjust the text in the Collapsed Promoted Link */
.ms-tileview-tile-titleTextMediumCollapsed {
     font-weight: normal;
     background-color: rgba(0, 0, 0, 0.6);
     width: 100px;
     height: 40px;
     position: absolute;
     top: -20px;
     left: 0px;
     text-align: center;
     vertical-align: middle;
     font-size: 11px;
     /*  If you want to change the font size, change above */
     line-height: 20px;
     word-wrap: break-word;
}

</style>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
   
// Update this value to the number of links you want to show per row
var numberOfLinksPerRow = 4;
   
// local variables
var pre = "
<tr><td><div class='ms-promlink-body' id='promlink_row_";
var post = "'>
</div>
</td></tr>
";
var numberOfLinksInCurrentRow = numberOfLinksPerRow;
var currentRow = 1
// find the number of promoted links we're displaying
var numberOfPromotedLinks = $('.ms-promlink-body > .ms-tileview-tile-root').length;
  // if we have more links then we want in a row, let's continue
  if (numberOfPromotedLinks > numberOfLinksPerRow) {
    // we don't need the header anymore, no cycling through links
    $('.ms-promlink-root > .ms-promlink-header').empty();
    // let's iterate through all the links after the maximum displayed link
    for (i = numberOfLinksPerRow + 1; i <= numberOfPromotedLinks; i++) {
      // if we're reached the maximum number of links to show per row, add a new row
      // this happens the first time, with the values set initially
      if (numberOfLinksInCurrentRow == numberOfLinksPerRow) {
        // i just want the 2nd row to
        currentRow++;
        // create a new row of links
        $('.ms-promlink-root > table > tbody:last').append(pre + currentRow + post);
        // reset the number of links for the current row
        numberOfLinksInCurrentRow = 0    }    
// move the Nth (numberOfLinksPerRow + 1) div to the current table row    
$('#promlink_row_' + currentRow).append($('.ms-promlink-body > .ms-tileview-tile-root:eq(' + (numberOfLinksPerRow) + ')'));    
// increment the number of links in the current row
    numberOfLinksInCurrentRow++;  }
}
$(".ms-tileview-tile-detailsListMedium").attr('style', 'text-align: center');
});
</script>

Monday, August 13, 2018

CSOM Example

You have to reference following two dll file in your project.

Microsoft.SharePoint.Client.dll
Microsoft.SharePoint.Client.Runtime.dll

You can find this file at "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell"

example.

using System;
using System.Windows.Forms;
using Microsoft.SharePoint.Client;
using System.Security;

namespace CAML_CSOMDemo
{
public partial class Form1 : System.Windows.Forms.Form
{
public Form1()
{
InitializeComponent();
}

private void bntExecute_Click(object sender, EventArgs e)
{
using (ClientContext ctx = new ClientContext("https://contoso.sharepoint.com/"))
{
string uname = "myemail@contoso.com";
SecureString upwd = new System.Net.NetworkCredential("", "P@ssw0rd").SecurePassword;
ctx.Credentials = new SharePointOnlineCredentials(uname,upwd);

Web myWeb = ctx.Web;
List productsList = myWeb.Lists.GetByTitle("CSOM_TestList");

ctx.Load(myWeb);
ctx.ExecuteQuery();

MessageBox.Show(myWeb.Title);

}

}

}// end of class

}// end of namespace

Friday, July 20, 2018

SharePoint '/_layouts/' locations

Some times you want to jump right to a specific system list, page or go to the edit mode in a SharePoint site. I wanted to list all the famous urls I used for the past years and ask you to tell me about any other ones you know to add it here in the list. Other have already contributed a bunch

(Remember for SharePoint 2013, 2016 you might want to add "15", "16" respectively after "/_layouts/" but if you don't SharePoint will take care of that for you) .. Also some of these are turned off on Office 365 SharePoint online.

Site collection level recycle bin:

/_layouts/15/AdminRecycleBin.aspx

Site level recycle bin (Added by Steve Stewart):

/_layouts/RecycleBin.aspx

Recreate default site sp groups (Added by Neal Bongers):

_layouts/15/permsetup.aspx

Load document tab initial (Added by Dominik Gempeler)

?InitialTabId=Ribbon.Document

Delete user from Site collection (on-premises) (Added by SamDavid):

/_layouts/15/people.aspx?MembershipGroupId=0

Display list in grid view. 'True' is case sensitive (Added by Antoine L.):

?ShowInGrid=True

Quick Launch settings page (Added by Ishani M.):

/_layouts/quiklnch.aspx

Navigation Settings page (Added by Abdur Raheem):

/_layouts/15/AreaNavigationSettings.aspx

Sandboxed Solution Gallery:

/_catalogs/solutions/Forms/AllItems.aspx

Workflow history hidden list:

/lists/Workflow History

Filter toolbar for Lists and libraries (Added by Asimaili):

?Filter=1

Site usage page (Added by @Dnyag):

/_layouts/usage.aspx

Site content and structure page (Added by @Dnyag):

/_layouts/sitemanager.aspx

Site settings page (Added by Aowworld):

/_layouts/settings.aspx

View all site content page (Site content) (Added by Aowworld):

/_layouts/viewlsts.aspx

Manage site collection features - CASE SENSITIVE - (Added by Vardhaman):

/_layouts/ManageFeatures.aspx?Scope=Site

Manage site features (Added by Vardhaman):

/_layouts/ManageFeatures.aspx

Get the version of the SharePoint server (Patch level) (Added by: John Liu):

/_vti_pvt/Service.cnf

Web Part Maintenance Page (Added by: Ricky):

?Contents=1

Show Page in Dialog View (Added by:Ricky):

?isdlg=1

Application page for registering SharePoint apps

/_layouts/15/appregnew.aspx

Save Site as a template

/_layouts/savetmpl.aspx

/_layouts/closeConnection.aspx?loginasanotheruser=true

Enable SharePoint designer

/_layouts/SharePointDesignerSettings.aspx

Welcome Page (Default page settings)

/_layouts/AreaWelcomePage.aspx

Change Site Master Page

/_layouts/ChangeSiteMasterPage.aspx

Page Layouts and Site Templates

/_Layouts/AreaTemplateSettings.aspx

Master Pages library

/_catalogs/masterpage/Forms/AllItems.aspx

Quick Deploy List

Quick%20Deploy%20Items/AllItems.aspx

Open Page in Edit Mode

?ToolPaneView=2

Taxonomy Hidden List (MMS)

Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:

_catalogs/users

_catalogs/users/simple.aspx

Force displaying the user profile in the site
collection:

/_layouts/userdisp.aspx?id={UserID}&Force=True

Site hierarchy page (lists of sub sites) - (Added by community contributions)

/_layouts/vsubwebs.aspx

/_layouts/1033/vsubwebs.aspx

Reference Site

Thursday, July 19, 2018

WE CAN’T DO THAT FOR YOU BECAUSE THE FILE IS NO LONGER CHECKED OUT OR HAS BEEN DELETED IN SHAREPOINT DESIGNER

SCENARIO

In SharePoint Designer, When I tried to “Check In” a file inside, I got the below error:

WE CAN’T DO THAT FOR YOU BECAUSE THE FILE IS NO LONGER CHECKED OUT OR HAS BEEN DELETED

I already have tried to

Close Share Point Designer and restart it again,
Close SPD then clear cache from the following folder:
- %USERPROFILE%\AppData\Local\Microsoft\WebsiteCache
- %USERPROFILE%\AppData\Roaming\Microsoft\Web Server Extensions\Cache

Unfortunately, the “We can’t do that for you because the file is no longer checked out or has been deleted” still persists.

CAUSE

This problem might occur in case, the file title contains disallowed characters like “/” as shown below:
The file title contains disallowed characters in SharePoint Designer

The file title contains disallowed characters in SharePoint Designer

SOLUTION

Right-click on the affected file > Select “Edit file in advanced mode“.

Edit file in advanced mode in SharePoint Designer

Right-click again on the affected file > Select “properties“.

Open File Properties In SharePoint Designer

The properties page should be shown.

Remove URL > Change the title to an appropriate name by avoiding using the disallowed characters.

master-page-properties-change-title-SharePoint-designer

The file should be now checked in properly.

Reference of this POST

Tuesday, July 10, 2018

REST API Compare Date Field

add following "toISOString()" that will allow you to check Date is >,<,>=,<=,!=

var today = new Date();
...$filter=StartDate ge + today.toISOString() + and ...

Calculate Day in SharePoint

LastAction = '7 Apr 2018'
Created = '1 Apr 2018'

=DATEVALUE(TEXT(LastAction,"dd/mm/yyyy"))-DATEVALUE(TEXT(Created,"dd/mm/yyyy"))

OUTPUT
6

Tuesday, June 19, 2018

Remove duplicate through JQuery

test1

test2

test1

test2

var seen = {};
$('table tr').each(function() {
var txt = $(this).text();
if (seen[txt])
$(this).remove();
else
seen[txt] = true;
});