Thursday, May 3, 2018

Save site as template in SharePoint Online or Sharepoint Site

To Save the site as a template you can follow this steps.
  1. Open your the site with SharePoint Designer
  2. In the ribbon go to Site Options
  3. Locate the option SaveSiteAsTemplateEnabled and modify the value to true
  4. Since the site template is disabled in the Publishing sites the option Save Site as Template is not available in the Site Settings you will need to navigate to the page directly: Provide all the details and click OK after a couple of minutes you will have the WSP site template generated
Note: If you have apps downloaded from the store they could prevent you to save the site as a template if you are facing this scenario you will need to uninstall the apps first.
Create a site based on the template will require a similar environment this means that you will need to have the same features installed and activated in the site collection where you want to install the template.
In this article you can find more information about how to activate the features. Save Publishing Site as template
If you have custom page layouts applied to your site site you might loose the access to the pages with them applied after creating the site based on the template.
If you face this issue you can follow this article to fix it Fix publishing pages with custom page layouts created from template

Monday, March 19, 2018

Apply Custom CSS to Sharepoint List View Webpart Pages

Apply in the below code to Script Editor web part or Content Editor Webpart in your list view sharepoint pages.

Add Style Tag begin and end in the following code:

 /* ---------- Table Rows ----------*/
    /* Set background for every row */
    .ms-listviewtable > tbody > tr {
        background: white;

    /* Set border for every row */
    .ms-listviewtable > tbody > tr td{
        border-bottom: 1px solid #AFAFAF !important; /* !important needed over override SharePoint inline style */
        border-left: 1px solid #AFAFAF !important;
        border-right: 1px solid #AFAFAF !important;

    /* Set background for every alternating row */
    .ms-listviewtable > tbody > {
        background: #E2E3E5;

    /* ---------- Table Header Row ----------*/
    /* Remove background set in SharePoint's general data table style */
    .ms-listviewtable {
        background: transparent;

    /* Modify background color */ >, /* Input box and attachment icon */ >, /* Text */ >, > th /* Text */ {
        background: #2E4C70;

    /* Modify background color on hover */ >, >, > th  {
        background-color: #273C51;
        border-color: #273C51;

    /* Modify font color */
    .ms-viewheadertr a,
    .ms-viewheadertr div {
        color: white;

    /* Modify font color on hover */
    .ms-viewheadertr a:hover,
    .ms-viewheadertr div:hover {
        color: white;
    } > {


Wednesday, March 7, 2018

Scheduled workflows and the Nintex Site Workflow Scheduler timer job

If Nintex Site workflow is not running or trigger by automatically, you need to follow in the below steps:

The Nintex Workflow Scheduler job should only have one instance listed in the Timer Job Definitions page.  To check, please go to Central AdministrationMonitoring Timer Jobs Review job definitions.  Scroll through until you locate Nintex Workflow Scheduler.  There should be only one instance there.  If there are more, all but one will need to be deleted, ensuring the one that is left is on a web application on a server running the “Microsoft SharePoint Foundation Web Application” service.

To change this, the NWAdmin.exe 
InstallTimerJob and UninstallTimerJob operations can be used to bind the timer job to a Web application running the Microsoft SharePoint Foundation Web Application service.  Doing this will ensure SharePoint executes scheduled workflows on a web front end servers, so any content web application running the web application service will do (only one per farm).

The nwadmin.exe command line tool is used.  Full information here NWAdmin Operations - Nintex Workflow 2010

Please type (do not copy and paste) these commands:
1.      NWAdmin.exe -o UninstallTimerJob -job ScheduledWorkflows
    (Use above line if it is currently installed on Central Admin Web App, if not specify what Web App to remove it from using -url switch)


2.      NWAdmin.exe -o InstallTimerJob -job ScheduledWorkflows -url http://yourwebappurl/

Naturally, you will need to replace http://yourwebappurl/ with the real URL of the relevant web application you choose to install it on.

NOTE: Only scheduled workflows use the Nintex Workflow Scheduler service.  Any regular workflow is run at first by the "w3wp.exe" service and once having been "put to sleep", then after by "owstimer.exe", the SharePoint Timer service.  Moving the Nintex Workflow Scheduler will not interfere with regular workflows at all.  

Install, Uninstall and reinstall can be done during business hours, there is no resets, down-time or any impact to workflows.  The timer job will pickup where it left off after reinstall and run any schedules that were missed during reinstall. 


How do I delete columns that workflows create in a sharepoint list

Here is what you should do:
1. Get SharePoint Manager from Codeplex, if you've not already. It's a freeware with very useful feature for people like us. you can download it.
2. Run SharePoint Manager as Administrator 
3. Under the site -> List -> Fields, change the property of Workflow field Allow Deletion True
4. Open the site in SPD, Edit List coulmns, Show Read Only columns & finally delete.
Sharepoint Manager Screen:

Sharepoint Designer

Thursday, February 22, 2018

Remove-SPODeletedSite - Sharepoint Online site from Recycle bin

1.Connect Sharepoint Online via SPO Service

Connect-SPOService -Url


Go to your Sharepoint Admin center and copy URL

Connect-SPOService -Url

2. Enter Login Credentials.

3.Execute this command and Enter Y

Remove-SPODeletedSite -Identity

Site will be removed immediately from Recycle Bin.

Tuesday, January 23, 2018

All Power shell Backup Commands for SharePoint Site

Backup Site Collection

Backup -SPSite http://spuat/sites/SG -Path C:\Backup\SGSite.bak

Restore Site Collection

Restore-SPSite http://spuat:222/sites/SG  -Path C:\Backup\SGSite.bak -Force