European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint List Column Updated As An Owner User Field Type

Oct 22nd

Posted by Peter in European SharePoint 2013 Hosting

Hi guys, let’s discuss an amazing way for a SharePoint List Column to be updated as an Owner Column User Field Type via PowerShell scripting. It’s used after a quick export all the Excel sheet based records onto a SharePoint List with different type of field types.

But what if the Title column has values which have to be converted to the User field property?

Note

The discussed approach is only applicable on an SP On-Prem site collection!

Prerequisites

Windows PowerShell ISE should be installed on the system.

Install the SharePoint Client DLLs after downloading them in some respective paths and mention them in the PS code as shown below.

Valid login details need to be hard coded in the last UserName, Password section in order to run the script without giving the login details at the run time and achieve a seamless program running.

PowerShell script

#reference the SharePoint Client DLLs  
Add - Type - Path ".\Microsoft.SharePoint.Client.dll" | Out - Null  
Add - Type - Path ".\Microsoft.SharePoint.Client.Runtime.dll" | Out - Null  
#Add - Type - Path "C:\Users\123594\Documents\Veera Kaveri\BoxUpdate\BoxUpdate\Microsoft.SharePoint.Client.dll" | Out - Null  
#Add - Type - Path "C:\Users\123594\Documents\Veera Kaveri\BoxUpdate\BoxUpdate\Microsoft.SharePoint.Client.Runtime.dll" | Out - Null  
  
function Get - SPOSites {  
    Param(  
        [Microsoft.SharePoint.Client.ClientContext] $Context,  
        [Microsoft.SharePoint.Client.Web] $RootWeb)  
    #Create array variable to store data  
    # $siteitems = $null  
    #$siteitems = @()  
    $RunDateTime = Get - Date - Format G  
    #get all webs under root web  
    $Webs = $RootWeb.Webs  
    $Context.Load($Webs)  
    $Context.ExecuteQuery()  
    #loop through the webs  
    ForEach($sWeb in $Webs) {  
            Write - Host $sWeb.url  
            #Create array variable to store data  
            $siteitems = $null  
            $siteUrl = $sWeb.Url;  
            #if($siteUrl - Match 'http://test.sample.com/sites/EU2/teams/e-Business') {  
                #if($siteUrl - match 'http://test.sample.com/sites/EU3/tvoe') {  
                    if ($siteUrl - match 'http://eu.test.sample.com/sites/AdvEU3/Megamigration') {  
                        #get all lists in web  
                        $AllLists = $sWeb.Lists  
                        $Context.Load($AllLists)  
                        $Context.ExecuteQuery()  
                        #loop through all lists in web  
                        ForEach($list in $AllLists) {  
                            Write - Host List: $list.Title  
                            #get list title  
                            $listTitle = $list.Title;  
                            If($listTitle - eq '3rdpartytosample_test') {  
                                $itemPosition = $null  
                                $Count = 0;  
                                Do {  
                                    $camlQuery = New - Object Microsoft.SharePoint.Client.CamlQuery  
                                    $camlQuery.ViewXml = '<View Scope="RecursiveAll"><RowLimit Paged="TRUE">1000</RowLimit></View>'  
                                    $camlQuery.ListItemCollectionPosition = $itemPosition;  
                                    $AllItems = $list.GetItems($camlQuery)  
                                    $Context.Load($AllItems)  
                                    $Context.ExecuteQuery()  
                                    $itemPosition = $AllItems.ListItemCollectionPosition;  
                                    Write - Host itemPosition: $itemPosition  
                                    If($AllItems.Count - gt 0) {  
                                        ForEach($item in $AllItems) {  
                                            #use internal name  
                                            $userEmail = $item["Title"]  
                                            if ($userEmail - match 'sample.com') {  
                                                $userEmail = $userEmail.Replace('ap.sample.com', 'sample.com')  
                                                $userEmail = $userEmail.Replace('am.sample.com', 'sample.com')  
                                                $userEmail = $userEmail.Replace('eu.sample.com', 'sample.com')  
                                                $userEmail = $userEmail.Replace('jp.sample.com', 'sample.com')  
                                                $User = $Context.Web.EnsureUser($userEmail);  
                                                $Context.Load($user);  
                                                $item["Owner"] = $User;  
                                                $item.Update();  
                                                $Context.ExecuteQuery()  
                                            }  
                                        }  
                                        #end loop  
                                        for all items in list  
                                    }  
                                    #check  
                                    if item count is > 0  
                                }  
                                While($itemPosition - ne $null)  
                            }  
                            #check  
                            if it is a 'do not inventory'  
                            list  
                        }  
                        #end loop  
                        for all lists in site  
                    }  
                    Get - SPOSites - RootWeb $sWeb - Context $Context #recursive call  
                }  
                #end loop  
                for all sites in site collection  
            }  
            #Set parameter values  
            $SiteURL = "http://eu.test.sample.com/sites/AdvEU3/Megamigration"  
            #$LibraryName = "Documents"  
            $UserName = "###########"  
            $PassWord = "############"  
            $securePassword = ConvertTo - SecureString $PassWord - AsPlainText - Force  
            $spoCred = New - Object System.Net.NetworkCredential($UserName, $securePassword)  
            #Setup the context  
            $ctx = New - Object Microsoft.SharePoint.Client.ClientContext($SiteURL)  
            $ctx.Credentials = $spoCred  
            $Web = $ctx.Web  
            $ctx.Load($Web)  
            $ctx.ExecuteQuery()  
            Get - SPOSites - RootWeb $Web - Context $ctx

#reference the SharePoint Client DLLs

Add - Type - Path ".\Microsoft.SharePoint.Client.dll" | Out - Null

Add - Type - Path ".\Microsoft.SharePoint.Client.Runtime.dll" | Out - Null

#Add - Type - Path "C:\Users\123594\Documents\Veera Kaveri\BoxUpdate\BoxUpdate\Microsoft.SharePoint.Client.dll" | Out - Null

#Add - Type - Path "C:\Users\123594\Documents\Veera Kaveri\BoxUpdate\BoxUpdate\Microsoft.SharePoint.Client.Runtime.dll" | Out - Null

function Get - SPOSites {

Param(

[Microsoft.SharePoint.Client.ClientContext] $Context,

[Microsoft.SharePoint.Client.Web] $RootWeb)

#Create array variable to store data

# $siteitems = $null

#$siteitems = @()

$RunDateTime = Get - Date - Format G

#get all webs under root web

$Webs = $RootWeb.Webs

$Context.Load($Webs)

$Context.ExecuteQuery()

#loop through the webs

ForEach($sWeb in $Webs) {

Write - Host $sWeb.url

#Create array variable to store data

$siteitems = $null

$siteUrl = $sWeb.Url;

#if($siteUrl - Match 'http://test.sample.com/sites/EU2/teams/e-Business') {

#if($siteUrl - match 'http://test.sample.com/sites/EU3/tvoe') {

if ($siteUrl - match 'http://eu.test.sample.com/sites/AdvEU3/Megamigration') {

#get all lists in web

$AllLists = $sWeb.Lists

$Context.Load($AllLists)

$Context.ExecuteQuery()

#loop through all lists in web

ForEach($list in $AllLists) {

Write - Host List: $list.Title

#get list title

$listTitle = $list.Title;

If($listTitle - eq '3rdpartytosample_test') {

$itemPosition = $null

$Count = 0;

Do {

$camlQuery = New - Object Microsoft.SharePoint.Client.CamlQuery

$camlQuery.ViewXml = '<View Scope="RecursiveAll"><RowLimit Paged="TRUE">1000</RowLimit></View>'

$camlQuery.ListItemCollectionPosition = $itemPosition;

$AllItems = $list.GetItems($camlQuery)

$Context.Load($AllItems)

$Context.ExecuteQuery()

$itemPosition = $AllItems.ListItemCollectionPosition;

Write - Host itemPosition: $itemPosition

If($AllItems.Count - gt 0) {

ForEach($item in $AllItems) {

#use internal name

$userEmail = $item["Title"]

if ($userEmail - match 'sample.com') {

$userEmail = $userEmail.Replace('ap.sample.com', 'sample.com')

$userEmail = $userEmail.Replace('am.sample.com', 'sample.com')

$userEmail = $userEmail.Replace('eu.sample.com', 'sample.com')

$userEmail = $userEmail.Replace('jp.sample.com', 'sample.com')

$User = $Context.Web.EnsureUser($userEmail);

$Context.Load($user);

$item["Owner"] = $User;

$item.Update();

$Context.ExecuteQuery()

}

#end loop

for all items in list

}

#check

if item count is > 0

}

While($itemPosition - ne $null)

}

#check

if it is a 'do not inventory'

list

}

#end loop

for all lists in site

}

Get - SPOSites - RootWeb $sWeb - Context $Context #recursive call

}

#end loop

for all sites in site collection

}

#Set parameter values

$SiteURL = "http://eu.test.sample.com/sites/AdvEU3/Megamigration"

#$LibraryName = "Documents"

$UserName = "###########"

$PassWord = "############"

$securePassword = ConvertTo - SecureString $PassWord - AsPlainText - Force

$spoCred = New - Object System.Net.NetworkCredential($UserName, $securePassword)

#Setup the context

$ctx = New - Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$ctx.Credentials = $spoCred

$Web = $ctx.Web

$ctx.Load($Web)

$ctx.ExecuteQuery()

Get - SPOSites - RootWeb $Web - Context $ctx

Enter your respective details wherever highlighted or required in the above PowerShell script.

Benefit

Once the above process is finished we can re-use that User field property converted Ttile column to use in many kind of List views.

We can also use the same List column for Filtering, Sorting options on all the custom List views wherever required.

Conclusion

Finally, we got an important way to run PowerShell script to make a given SharePoint List column to be updated as an Owner Column User Field Type via PowerShell scripting

SharePoint 2013 Hosting – HostForLIFE.eu :: Deleting Node Module Packages From SPFx Solution

Oct 13th

Posted by Peter in European SharePoint 2013 Hosting

It is difficult to move an SPFx solution from one folder to another or delete an SPFx solution in the Windows File Explorer. Whenever you try to delete an SPFx solution, it takes forever to calculate the space. It is due to the Node Modules folder which contains more number of files.

Well, we all know that npm install <package-name> is used to install a specific module into the SPFx solution. Similarly, npm uninstall <package-name> command is used to remove a specific package from the SPFx solution. It is impossible to uninstall each individual package in the node modules folder separately. Let us see how to remove all the node modules with the help of a single command.

I have been searching for a tool which will help me to remove all the node modules at once. In recent times, I came across this new deletion module called rimraf which was very useful.

Rimraf is a deep deletion module for Node.js. It is an executable that is used to clean the installed node packages in a node based project. Open the Node js command prompt and run the below command for installation of rimraf.

npm install rimraf -g

1	npm install rimraf -g

Once installed successfully, it will give the below message.

After installation, navigate to your project folder and execute the below command

rimraf node_modules

1	rimraf node_modules

Once this command is executed, you can see that the Node Modules folder has been deleted from your solution root folder. Now it is easy for you to archive your solution or remove it, after deleting the node modules.

SharePoint 2013 Hosting – HostForLIFE.eu : React Vertical Timeline In SPFX

Oct 2nd

Posted by Peter in European SharePoint 2013 Hosting

Vertical Timeline is a graphical representation of a period of time, on which important events are marked. In this article we will learn how to implement vertical timeline in our SPFX webpart component.

Steps

Open a command prompt and create a directory for the SPFx solution.

md spfx-ReactTimeline

Navigate to the above-created directory.

cd spfx-ReactTimeline

Run the Yeoman SharePoint Generator to create the solution.

yo @microsoft/sharepoint

Solution Name

Hit Enter for the default name (spfx-ReactTimeline in this case) or type in any other name for your solution.

Selected choice – Hit Enter

Target for the component

Here, we can select the target environment where we are planning to deploy the client web part; i.e., SharePoint Online or SharePoint OnPremise (SharePoint 2016 onwards).

Selected choice – SharePoint Online only (latest).

Place of files

We may choose to use the same folder or create a subfolder for our solution.

Selected choice – same folder.

Deployment option

Selecting Y will allow the app to be deployed instantly to all sites and be accessible everywhere.

Selected choice – N (install on each site explicitly).

Permissions to access web APIs

Choose if the components in the solution require permission to access web APIs that are unique and not shared with other components in the tenant.

Selected choice – N (solution contains unique permissions)

Type of client-side component to create

We can choose to create a client-side web part or an extension. Choose the web part option.

Selected choice – WebPart

Web part name

Hit Enter to select the default name or type in any other name.

Selected choice – ReactTimeline

Web part description

Hit Enter to select the default description or type in any other value.

Framework to use

Select any JavaScript framework to develop the component. Available choices are – No JavaScript Framework, React, and Knockout.

Selected choice – React

The Yeoman generator will perform a scaffolding process to generate the solution. The scaffolding process will take a significant amount of time.

Once the scaffolding process is completed, lock down the version of project dependencies by running the below command:

npm shrinkwrap

In the command prompt, type the below command to open the solution in the code editor of your choice.

npm i react-vertical-timeline-component
npm i csstype
npm install @material-ui/icons

VerticalTimeline Props

animate={ Boolean }	Enable or disable animations on elements (default: true).
className={ String }	Add extra class name to root div element.
layout={ String }	Choose if you want ‘1-column’ or ‘2-columns’ (default: ‘2-columns’).

VerticalTimelineElement Props

className={ String }	Add extra class name to root div element.
contentArrowStyle={ Object }	Add extra style to content arrow div element.
contentStyle={ Object }	Add extra style to content div element.
date={ String }	Date of the element.
dateClassName={ String }	Add extra class name to the element’s date.
icon={ String }	Icon of the element.
iconClassName={ String }	Add extra class name to the element’s icon.
iconOnClick={ Function }	onClick handler of the element’s icon.
onTimelineElementClick={ Function }	onClick handler of the vertical timeline element’s div.
iconStyle={ Object }	Style of the element’s icon.
position={ String }	Position of the element (left or right).
style={ Object }	Add extra style to root div element.
textClassName={ String }	Add extra class name to the text container.

in ReactTimeline.tsx,

import * as React from 'react';  
import { IReactTimelineProps } from './IReactTimelineProps';  
import { VerticalTimeline, VerticalTimelineElement }  from 'react-vertical-timeline-component';  
import 'react-vertical-timeline-component/style.min.css';  
import SchoolIcon from '@material-ui/icons/School';  
import WorkIcon from '@material-ui/icons/Work';  
import StarIcon from '@material-ui/icons/Star';  
import LoyaltyIcon from '@material-ui/icons/Loyalty';  
  
import './mystyle.css';  
import * as CSS from 'csstype';   
var divStyle: CSS.Properties<string | number> = {     
  background: 'rgb(227, 227, 227)'      
  };  
export default class ReactTimeline extends React.Component<IReactTimelineProps, {}> {  
  public render(): React.ReactElement<IReactTimelineProps> {  
    return (  
      <div style={divStyle}>  
       <VerticalTimeline>  
  <VerticalTimelineElement  
    className="vertical-timeline-element--work"  
    contentStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}  
    contentArrowStyle={{ borderRight: '7px solid  rgb(33, 150, 243)' }}  
    date="2019 - 2020"  
    iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}  
    icon={<LoyaltyIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Most Valuable Proffesional</h3>  
    <h4 className="vertical-timeline-element-subtitle">MVP</h4>  
    <p>  
  1St time awarded as a C#Corner MVP  
    </p>  
  </VerticalTimelineElement>  
   
  <VerticalTimelineElement  
    className="vertical-timeline-element--work"  
    date="2019 - Till Date"  
    iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}  
    icon={<WorkIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Software Engineer,Smartek21</h3>  
    <h4 className="vertical-timeline-element-subtitle">SharePoint Developer</h4>  
    <p>  
    SharePoint Online ,Onpremise,M365 Development  
    </p>  
  </VerticalTimelineElement>  
  <VerticalTimelineElement  
    className="vertical-timeline-element--work"  
    date="2016 - 2019"  
    iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}  
    icon={<WorkIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Junior Software Engineer,Zylog Systems</h3>  
    <h4 className="vertical-timeline-element-subtitle">SharePoint Developer</h4>  
    <p>  
      SharePoint Online ,Onpremise,M365 Development  
    </p>  
  </VerticalTimelineElement>  
  <VerticalTimelineElement  
    className="vertical-timeline-element--education"  
    date="2012 - 2014"  
    iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}  
    icon={<SchoolIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Master of Engineering</h3>  
    <h4 className="vertical-timeline-element-subtitle">M.E.</h4>  
    <p>  
      Computer and Communication  
    </p>  
  </VerticalTimelineElement>  
  <VerticalTimelineElement  
    className="vertical-timeline-element--education"  
    date="2009 - 2012"  
    iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}  
    icon={<SchoolIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Bachelor of Engineering</h3>  
    <h4 className="vertical-timeline-element-subtitle">B.E.</h4>  
    <p>  
      Computer Science and Engineering  
    </p>  
  </VerticalTimelineElement>  
  <VerticalTimelineElement  
    className="vertical-timeline-element--education"  
    date="2007 - 2009"  
    iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}  
    icon={<SchoolIcon />}  
  >  
    <h3 className="vertical-timeline-element-title">Diploma in Computer Engineering</h3>  
    <h4 className="vertical-timeline-element-subtitle">Diploma Degree</h4>  
    <p>  
      Computer Technology  
    </p>  
  </VerticalTimelineElement>  
  <VerticalTimelineElement  
    iconStyle={{ background: 'rgb(16, 204, 82)', color: '#fff' }}  
    icon={<StarIcon />}  
  />  
</VerticalTimeline>  
      </div>  
    );  
  }  
}

100

101

102

103

import * as React from 'react';

import { IReactTimelineProps } from './IReactTimelineProps';

import { VerticalTimeline, VerticalTimelineElement } from 'react-vertical-timeline-component';

import 'react-vertical-timeline-component/style.min.css';

import SchoolIcon from '@material-ui/icons/School';

import WorkIcon from '@material-ui/icons/Work';

import StarIcon from '@material-ui/icons/Star';

import LoyaltyIcon from '@material-ui/icons/Loyalty';

import './mystyle.css';

import * as CSS from 'csstype';

var divStyle: CSS.Properties<string | number> = {

background: 'rgb(227, 227, 227)'

};

export default class ReactTimeline extends React.Component<IReactTimelineProps, {}> {

public render(): React.ReactElement<IReactTimelineProps> {

return (

<VerticalTimelineElement

className="vertical-timeline-element--work"

contentStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}

contentArrowStyle={{ borderRight: '7px solid rgb(33, 150, 243)' }}

date="2019 - 2020"

iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}

icon={<LoyaltyIcon />}

<h3 className="vertical-timeline-element-title">Most Valuable Proffesional</h3>

<p>

1St time awarded as a C#Corner MVP

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

className="vertical-timeline-element--work"

date="2019 - Till Date"

iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}

icon={<WorkIcon />}

<h3 className="vertical-timeline-element-title">Software Engineer,Smartek21</h3>

<h4 className="vertical-timeline-element-subtitle">SharePoint Developer</h4>

<p>

SharePoint Online ,Onpremise,M365 Development

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

className="vertical-timeline-element--work"

date="2016 - 2019"

iconStyle={{ background: 'rgb(33, 150, 243)', color: '#fff' }}

icon={<WorkIcon />}

<h3 className="vertical-timeline-element-title">Junior Software Engineer,Zylog Systems</h3>

<h4 className="vertical-timeline-element-subtitle">SharePoint Developer</h4>

<p>

SharePoint Online ,Onpremise,M365 Development

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

className="vertical-timeline-element--education"

date="2012 - 2014"

iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}

icon={<SchoolIcon />}

<h3 className="vertical-timeline-element-title">Master of Engineering</h3>

<p>

Computer and Communication

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

className="vertical-timeline-element--education"

date="2009 - 2012"

iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}

icon={<SchoolIcon />}

<h3 className="vertical-timeline-element-title">Bachelor of Engineering</h3>

<p>

Computer Science and Engineering

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

className="vertical-timeline-element--education"

date="2007 - 2009"

iconStyle={{ background: 'rgb(233, 30, 99)', color: '#fff' }}

icon={<SchoolIcon />}

<h3 className="vertical-timeline-element-title">Diploma in Computer Engineering</h3>

<h4 className="vertical-timeline-element-subtitle">Diploma Degree</h4>

<p>

Computer Technology

</p>

</VerticalTimelineElement>

<VerticalTimelineElement

iconStyle={{ background: 'rgb(16, 204, 82)', color: '#fff' }}

icon={<StarIcon />}

</VerticalTimeline>

</div>

);

}

in mystyle.css,

.vertical-timeline::before {  
    content: "";  
    position: absolute;  
    top: 0px;  
    left: 18px;  
    height: 100%;  
    width: 4px;  
    background:black!important;  
}

.vertical-timeline::before {

content: "";

position: absolute;

top: 0px;

left: 18px;

height: 100%;

width: 4px;

background:black!important;

}

Output:

SharePoint 2013 Hosting – HostForLIFE.eu :: Easy Debugging With Developer Dashboard In SharePoint

Sep 24th

Posted by Peter in European SharePoint 2013 Hosting

As we know writing code for SharePoint sites is not difficult whether we are writing server side or client-side code for customizing features. The main point where everyone gets struck is troubleshooting or handling errors related to code. Also, error logging for SharePoint sites is done to both ULS and Windows Event Logs and finding or reading logs sometimes is really a mess. As, reading ULS (SharePoint Unified Logging Service) is not easy for everyone to get through. So, a new feature was introduced in SharePoint 2010 named Developer Dashboard.

What is developer dashboard?

Developer Dashboard is introduced as a new feature in SharePoint 2010. It’s a user interface which reflects useful diagnostic information. Developer dashboards are helpful to not only developers in debugging but also to administrators in handling issues related to farm.

Developer Dashboard gives the information about performance of controls used of a SharePoint page. Also, it tells about execution time taken by each control, log correlation ID, critical events, database queries with their handling time, service calls, SPRequests allocation whether used nominal or not and webparts event offsets (time taken in loading and rendering of webparts). This is a very helpful performance tuning feature. By default, this feature is disabled. We may enable it by:

Powershell script
STSADM command
using code

Enable developer dashboard SharePoint 2016/2013 using PowerShell script

We may easily enable or disable developer dashboard in SharePoint using PowerShell script as below,

Enable Developer Dashboard SharePoint

$var = Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;  
$var.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On  
$var.Update()

$var = Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;

$var.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On

$var.Update()

Enable on Demand

$var.DisplayLevel = ‘OnDemand’;

1	$var.DisplayLevel = ‘OnDemand’;

Display level for Developer dashboard can also be set as ‘OnDemand’.

Disable Developer Dashboard SharePoint

$var = Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;  
$var.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::Off  
$var.Update()

$var = Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;

$var.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::Off

$var.Update()

Just and On/Off and it can be enabled or disabled.

Enable developer dashboard SharePoint 2010 STSADM

Below is the STSADM command to enable or disable developer dashboard in SharePoint.

Enable Developer Dashboard SharePoint

stsadm -o setproperty -pn developer-dashboard -pv on

Disable Developer Dashboard

stsadm -o setproperty -pn developer-dashboard -pv off

Enable on Demand (Recommended approach will be OnDemand)

stsadm -o setproperty -pn developer-dashboard -pv OnDemand

Enable developer dashboard SharePoint using Server Object Model

By using SharePoint server object model, we may do the enable or disable developer dashboard in SharePoint as below,

using Microsoft.SharePoint;  
using Microsoft.SharePoint.Administration;  
SPDeveloperDashboardSettings settings = SPWebService.ContentService.DeveloperDashboardSettings;  
settings.DisplayLevel = SPDeveloperDashboardLevel.On;  
settings.TraceEnabled = true;  
settings.Update();

using Microsoft.SharePoint;

using Microsoft.SharePoint.Administration;

SPDeveloperDashboardSettings settings = SPWebService.ContentService.DeveloperDashboardSettings;

settings.DisplayLevel = SPDeveloperDashboardLevel.On;

settings.TraceEnabled = true;

settings.Update();

Developer Dashboard on custom master page in SharePoint

To use Developer Dashboard on custom master pages, keep the Developer Dashboard Launcher and page rendering control on the custom master page.

For the developer dashboard launcher,

<Sharepoint:DeveloperDashboardLauncher ID="DeveloperDashboardLauncher" NavigateUrl="javascript:ToggleDeveloperDashboard()" runat="server" ImageUrl="/_layouts/images/fgimg.png" Text="<%$Resources:wss,multipages_launchdevdashalt_text%>" OffsetX=0 OffsetY=222 Height=16 Width=16 />

1	<Sharepoint:DeveloperDashboardLauncher ID="DeveloperDashboardLauncher" NavigateUrl="javascript:ToggleDeveloperDashboard()" runat="server" ImageUrl="/_layouts/images/fgimg.png" Text="<%$Resources:wss,multipages_launchdevdashalt_text%>" OffsetX=0 OffsetY=222 Height=16 Width=16 />

Page Rendering Control

<SharePoint:DeveloperDashboard runat="server" />

1	<SharePoint:DeveloperDashboard runat="server" />

Where on the page it will reflect and render the output.

Viewing Logs with Developer Dashboard

Using the below steps, we can view the ULS logs in developer dashboard.

Log to your site
From the right side of the ribbon, click on developer dashboard. Developer dashboard will pop up in new window.
Browse the link to troubleshoot. It will start logging the session requests.
Select the request you want to investigate and click on related ULS log entries.

Recommendation

Most important, it gets enabled to the whole farm and is not particular to any site collection. So, it’s recommended to use in test environments. Then turn it off in production environments.

SharePoint 2013 Hosting – HostForLIFE.eu :: Filtered/Connected Web Parts In Modern SharePoint Pages

Sep 17th

Posted by Peter in European SharePoint 2013 Hosting

For SharePoint power users, the Filtered/Connected Web parts is a very popular feature. While this feature has been in use in Classic SharePoint sites for a long time, it has been a more recent introduction to Modern SharePoint Pages. While the features in Modern SharePoint Pages may not be the same as in Classic SharePoint, I like the fact that the current web parts cover the most relevant functionalities used in Classic SharePoint sites.

Following are the filtered/connected web parts that are available in Modern SharePoint Pages as of today. Further in this article, I will explain how to use each one of them.

List Properties Web part: Displays properties of selected List Item
File Viewer Web part: Displays file content of selected document in Library
Embed Web part: Displays any type of content including Images and Videos
Filter Web part based on another list or library

List Properties Web Part

This web part is useful when users have a list with too many columns and you cannot display the relevant columns in a view without horizontal scrolling. List Properties web part allows users to configure the columns they want to display in a web part when a particular item is selected in List View web part. Here’s how to configure it,

Add a “List Web part” (select a List from the site) and “List Properties Web part” on the page
On the “List Properties Web part”, click “Connect”, it will open the properties pane of the web part
In the properties pane, click on the ellipsis (…), and click “Connect to source”
If you have more than one “List Web part” on the page, then select appropriate web part/list and choose the columns you want to display in the “List Properties Web part”
You can also select if properties should be editable or read-only in the web part
Save the page and test the webpart by selecting any item from “List Web part”

File Viewer Web Part

This web part allows users see the content of a selected file without a need to open each file in browser/desktop app. Here’s how to configure it,

Add a “Document Library Web part” (select a Document Library from the site) and “File Viewer Web part” on the page
On the “File Viewer Web part”, click “Edit”, it will open the properties pane of the web part
In the properties pane, click on the ellipsis (…), and click “Connect to source”
If you have more than one “Document Library Web part” on the page, then select appropriate web part/document library
Save the page and test the webpart by selecting any document from “Document Library Web part”

File Viewer Web part supports various file types apart from Office Documents like Images, Text and PDF.

Embed Web Part

This web part allows users to display dynamic content using links or embed code that can use variables. Below are a couple examples on how to configure it for Images; similar logic can be applied for other content too like YouTube Videos.

Create a List, add a Hyperlink Column to it that will contain the Image URL
Add a “List Web part” (select the List with Image URL’s) and “Embed Web part” on the page
On the “Embed Web part”, click “Edit”, it will open the properties pane of the web part
In the properties pane, click on the ellipsis (…), and click “Connect to source”, then select appropriate web part/list
Under “Web site address or embed code”, add the embed code. In this example, the embed code is,

<iframe width=”693″ height=”390″ src=”[$Image URL]” frameborder=”0″ ></iframe> where [$Image URL] is the variable that represents the column name for the Image URLs.

Save the page and test the web part by selecting any item from “List Web part”. Respective Image will be displayed in Embed Web part

Filter Web Part based on another list or library

This is the same feature as Connected Web parts in Classic SharePoint Sites. In Modern Experience, we enable the “Dynamic Filtering” on the secondary web part and provide the details on the filter. Here is how to do this,

In order to have the dynamic filtering capabilities between two lists, there should be some kind of parent-child relationship that will allow the filters to work
Add a “List” or “Document Library” web part to the page that will act as the parent control
Add another “List” or “Document Library” web part to the page. This will be the child control.
On the second web part, click “Edit”
In the properties pane, enable the “Dynamic Filtering” toggle and provide the column to filter on
Select the Parent List and the column to filter by
Click on “Apply”
Save the page and test the web part by selecting any item/document from parent “List Web part”. Items in the second “List Web part” will be filtered accordingly.

These are some very useful web parts that makes the user experience and content rendering very friendly for end users. If you have not explored these web part features yet, then I encourage you to try them out now in Modern SharePoint Pages.

SharePoint Hosting – Upload Nested Folder Structure And Files On A SP Online Library

Aug 31st

Posted by Peter in European SharePoint 2013 Hosting

Hi guys, let’s explore some amazing ways to completely migrate a nested folder structure with lots of different files which is from your local path to a SP online library using PnP PowerShell.

Here is the script to run on Windows ISE Powershell:

#Function to Copy Multiple Files with Folder structure to SharePoint Online Document Library
Function Migrate - PnPFolderToSPO() {
param(
[Parameter(Mandatory = $true)][string] $SiteURL,
[Parameter(Mandatory = $true)][string] $SourceFolderPath,
[Parameter(Mandatory = $true)][string] $LibraryName,
[Parameter(Mandatory = $true)][string] $LogFile)
Try {
Add - content $Logfile - value "`n---------------------- File Upload Script Started: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-------------------"
#Connect to PnP Online
Connect - PnPOnline - Url $SiteURL - UseWebLogin
#Get the Target Folder to Upload
$Web = Get - PnPWeb
$List = Get - PnPList $LibraryName - Includes RootFolder
$TargetFolder = $List.RootFolder
$TargetFolderSiteRelativeURL = $TargetFolder.ServerRelativeURL.Replace($Web.ServerRelativeUrl, "")
#Get All Items from the Source
$Source = Get - ChildItem - Path $SourceFolderPath - Recurse
$SourceItems = $Source | Select FullName, PSIsContainer, @ {
Label = 'TargetItemURL';
Expression = {
$_.FullName.Replace($SourceFolderPath, $TargetFolderSiteRelativeURL).Replace("\"," / ")}}
Add - content $Logfile - value "Number of Items Found in the Source: $($SourceItems.Count)"
#Upload Source Items from Fileshare to Target SharePoint Online document library $Counter = 1 $SourceItems | ForEach - Object {
#Calculate Target Folder URL
$TargetFolderURL = (Split - Path $_.TargetItemURL - Parent).Replace("\"," / ")
$ItemName = Split - Path $_.FullName - leaf #Replace Invalid Characters $ItemName = [RegEx]::Replace($ItemName, "[{0}]" - f([RegEx]::Escape([String]
'\"*:<>?/\|')), '_') #Display Progress bar $Status = "uploading '" + $ItemName + "' to " + $TargetFolderURL + " ($($Counter) of $($SourceItems.Count))"
Write - Progress - Activity "Uploading ..." - Status $Status - PercentComplete(($Counter / $SourceItems.Count) * 100) If($_.PSIsContainer) {
#Ensure Folder
$Folder = Resolve - PnPFolder - SiteRelativePath($TargetFolderURL + "/" + $ItemName)
Write - host "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL"
Add - content $Logfile - value "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL"
}
Else {
#Upload File
$File = Add - PnPFile - Path $_.FullName - Folder $TargetFolderURL
Write - host "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL"
Add - content $Logfile - value "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL"
}
$Counter++
}
}
Catch {
Write - host - f Red "Error:"
$_.Exception.Message
Add - content $Logfile - value "Error:$($_.Exception.Message)"
}
Finally {
Add - content $Logfile - value "---------------------- File upload Script Completed: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-----------------"
}
}
#Call the Function to Upload a Folder to SharePoint Online
Migrate - PnPFolderToSPO - SiteURL "https://samplesharenet.sharepoint.com/sites/classictest" - SourceFolderPath "C:\Users\Bharat\Documents\Bharat\General Works for Internal Requirements" - LibraryName "PnPCopytoLib" - LogFile "C:\Users\Bharat\PnPTest\Migration-LOG.log"

#Function to Copy Multiple Files with Folder structure to SharePoint Online Document Library

Function Migrate - PnPFolderToSPO() {

param(

[Parameter(Mandatory = $true)][string] $SiteURL,

[Parameter(Mandatory = $true)][string] $SourceFolderPath,

[Parameter(Mandatory = $true)][string] $LibraryName,

[Parameter(Mandatory = $true)][string] $LogFile)

Try {

Add - content $Logfile - value "`n---------------------- File Upload Script Started: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-------------------"

#Connect to PnP Online

Connect - PnPOnline - Url $SiteURL - UseWebLogin

#Get the Target Folder to Upload

$Web = Get - PnPWeb

$List = Get - PnPList $LibraryName - Includes RootFolder

$TargetFolder = $List.RootFolder

$TargetFolderSiteRelativeURL = $TargetFolder.ServerRelativeURL.Replace($Web.ServerRelativeUrl, "")

#Get All Items from the Source

$Source = Get - ChildItem - Path $SourceFolderPath - Recurse

$SourceItems = $Source | Select FullName, PSIsContainer, @ {

Label = 'TargetItemURL';

Expression = {

$_.FullName.Replace($SourceFolderPath, $TargetFolderSiteRelativeURL).Replace("\"," / ")}}

Add - content $Logfile - value "Number of Items Found in the Source: $($SourceItems.Count)"

#Upload Source Items from Fileshare to Target SharePoint Online document library $Counter = 1 $SourceItems | ForEach - Object {

#Calculate Target Folder URL

$TargetFolderURL = (Split - Path $_.TargetItemURL - Parent).Replace("\"," / ")

$ItemName = Split - Path $_.FullName - leaf #Replace Invalid Characters $ItemName = [RegEx]::Replace($ItemName, "[{0}]" - f([RegEx]::Escape([String]

'\"*:<>?/\|')), '_') #Display Progress bar $Status = "uploading '" + $ItemName + "' to " + $TargetFolderURL + " ($($Counter) of $($SourceItems.Count))"

Write - Progress - Activity "Uploading ..." - Status $Status - PercentComplete(($Counter / $SourceItems.Count) * 100) If($_.PSIsContainer) {

#Ensure Folder

$Folder = Resolve - PnPFolder - SiteRelativePath($TargetFolderURL + "/" + $ItemName)

Write - host "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL"

Add - content $Logfile - value "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL"

}

Else {

#Upload File

$File = Add - PnPFile - Path $_.FullName - Folder $TargetFolderURL

Write - host "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL"

Add - content $Logfile - value "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL"

}

$Counter++

}

Catch {

Write - host - f Red "Error:"

$_.Exception.Message

Add - content $Logfile - value "Error:$($_.Exception.Message)"

}

Finally {

Add - content $Logfile - value "---------------------- File upload Script Completed: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-----------------"

}

#Call the Function to Upload a Folder to SharePoint Online

Migrate - PnPFolderToSPO - SiteURL "https://samplesharenet.sharepoint.com/sites/classictest" - SourceFolderPath "C:\Users\Bharat\Documents\Bharat\General Works for Internal Requirements" - LibraryName "PnPCopytoLib" - LogFile "C:\Users\Bharat\PnPTest\Migration-LOG.log"

Just enter your own respective details which are highlighted in the above script.

When it starts running, enter your Site Admin/Global Admin Tenant details to start the processing.

You can see the Uploading in Progress on your Windows Powershell ISE Interface. Just wait until it gets finished!

This script copies the contents of a folder to the SharePoint Online document library. It overwrites any existing file in the target SharePoint Online library. It creates a folder if it doesn’t exist on the target site already. We can also use this script to migrate files and folders from network file share to SharePoint Online document library!

Creative Idea

You can have the above script triggered through a Flow/Azure Flow[Logic Apps] to have an automated Copying and include Removal in the Source to establish an Automated Archival Process for your Business needs.

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint List Column Updated As An Owner User Field Type

SharePoint 2013 Hosting – HostForLIFE.eu :: Deleting Node Module Packages From SPFx Solution

SharePoint 2013 Hosting – HostForLIFE.eu : React Vertical Timeline In SPFX

Steps

SharePoint 2013 Hosting – HostForLIFE.eu :: Easy Debugging With Developer Dashboard In SharePoint

What is developer dashboard?

Enable developer dashboard SharePoint 2016/2013 using PowerShell script

Enable developer dashboard SharePoint 2010 STSADM

Enable developer dashboard SharePoint using Server Object Model

Developer Dashboard on custom master page in SharePoint

Viewing Logs with Developer Dashboard

SharePoint 2013 Hosting – HostForLIFE.eu :: Filtered/Connected Web Parts In Modern SharePoint Pages

List Properties Web Part

File Viewer Web Part

Embed Web Part

Filter Web Part based on another list or library

SharePoint Hosting – Upload Nested Folder Structure And Files On A SP Online Library

BLOGROLL

Featured On

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint List Column Updated As An Owner User Field Type

SharePoint 2013 Hosting – HostForLIFE.eu :: Deleting Node Module Packages From SPFx Solution

SharePoint 2013 Hosting – HostForLIFE.eu : React Vertical Timeline In SPFX

Steps

SharePoint 2013 Hosting – HostForLIFE.eu :: Easy Debugging With Developer Dashboard In SharePoint

What is developer dashboard?

Enable developer dashboard SharePoint 2016/2013 using PowerShell script

Enable developer dashboard SharePoint 2010 STSADM

Enable developer dashboard SharePoint using Server Object Model

Developer Dashboard on custom master page in SharePoint

Viewing Logs with Developer Dashboard

SharePoint 2013 Hosting – HostForLIFE.eu :: Filtered/Connected Web Parts In Modern SharePoint Pages

List Properties Web Part

File Viewer Web Part

Embed Web Part

Filter Web Part based on another list or library

SharePoint Hosting – Upload Nested Folder Structure And Files On A SP Online Library

BLOGROLL

Featured On

Tags