SharePoint Diary

How to convert Word documents to PDF by a SharePoint workflow using HarePoint Workflow Extensions?

July 30, 2015 Product Review, SharePoint

Introduction One of the main purposes of SharePoint is collaboration: a group of people can conveniently work with shared documents, making teamwork especially efficient. Usually, text documents are created and edited using Microsoft Word, but when the work is complete, it is convenient to convert the resulting document to PDF. This gives two advantages: No further changes to a document are possible, so it can be safely shared The PDF document can be easily viewed on any device A Word document can be saved manually as a PDF file right from Microsoft Word’s Save As … menu, but if we talk about tens or even hundreds of documents per week, it would obviously be preferable to have this conversion running automatically. Another thing is that if we browse the short list of workflow actions in SharePoint Designer, we won't find anything related to document conversion. This is where HarePoint Workflow Extensions can help. Scenario In this article, we will follow this scenario:

How to convert Word documents to PDF by a SharePoint workflow using HarePoint Workflow Extensions?

Reviewed by Salaudeen Rajack on July 30, 2015 Rating: 5

Product Review: Virto SharePoint Calendar Web Part

July 28, 2015 Product Review, SharePoint

Introduction: Virto SharePoint Calendar Web Part enables users to view all of their events from multiple data sources such as SharePoint Lists, Exchange Calendar, Google Calendar, SalesForce Calendar, SQL Tables or XML and have different views for your easy navigation and reference in one single calendar/or Microsoft Exchange calendars and even from SalesForce Calendars. Virto SharePoint Calendar replaces the existing SharePoint calendar view's functionality by allowing users to specify the list or view, color code the displayed items by category of events such as internal or external, view day, week, month, year, and Gantt view. Roll up Multiple calendars from different data sources into one Single calendar The main added value of the SharePoint Calendar web part is the opportunity to have all the events from different data sources displayed in a single SharePoint calendar view, sparing the necessity to switch between multiple views. You can also combine

Product Review: Virto SharePoint Calendar Web Part

Reviewed by Salaudeen Rajack on July 28, 2015 Rating: 5

SharePoint People Search Results gives "Domain\Account" Instead of User Display Name

July 28, 2015 Search, SharePoint, User Profile

Problem: SharePoint 2010 people search gives "Domain\AccountID" instead of Display name of the user! Solution: SharePoint uses "Preferred Name" property which is mapped with "Display Name" property from AD in People search results. Here, I found the root cause of the problem as: User profile not in sync! Steps to resolve: Make sure in AD, display name field is set properly Go to SharePoint central Administration >> Do a full profile import. Once you run full profile import, You should see the display name field updated in user profiles. Run SharePoint search incremental crawl once for the search results to get updated.

SharePoint People Search Results gives "Domain\Account" Instead of User Display Name $SharePoint People Search Results gives "Domain\Account" Instead of User Display Name$ Reviewed by Salaudeen Rajack on July 28, 2015 Rating: 5

Find All Lists which Exceeds List View Lookup Threashold in SharePoint

July 28, 2015 Admin Reports, CSV, PowerShell, SharePoint

Requirement: Resource throttling feature in SharePoint controls resource usage on SharePoint Farm for optimum usage. My requirement was to find all lists which are exceeding configured list view lookup threashold limit in SharePoint. PowerShell script to find All Lists which are Exceeding List View Lookup Threashold: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Get the Web Application $WebApp = Get-SPWebApplication "http://portal.crescent.com" #Array to Hold Result - PSObjects $ListResults = @() #Get the Throttling Limit of the Web App $Threshold = $WebApp.MaxQueryLookupFields foreach($Site in $WebApp.Sites) { foreach($Web in $Site.AllWebs) { Write-host "Scanning site:"$Web.URL foreach($List in $Web.Lists) { #Get Number of Lookup Fields $LookupFields = $List.Fields | Where { $_.TypeDisplayName -eq "Lookup" -and $_.Hidden -eq $false}

Find All Lists which Exceeds List View Lookup Threashold in SharePoint

Reviewed by Salaudeen Rajack on July 28, 2015 Rating: 5

Mount-Dismount (Attach-Detach) Content Databases in SharePoint using PowerShell

July 27, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database

There are occasions when you may need to attach or detach a content database to SharePoint web applications. E.g. during migrations you want to restore a content database from another farm and would like to access the sites in the content database from a new web application.You can attach or detach SharePoint 2016 content databases by using Central Administration or PowerShell. As stsadm is deprecated in SharePoint 2013, We should use below PowerShell cmdlets to to attach-detach content databases in SharePoint: Mount-SPContentDatabase The Mount-SPContentDatabase cmdlet attaches an existing content database to the specified Web application in the SharePoint farm. If the database being mounted requires an upgrade, this cmdlet upgrades the database automatically. We use this cmdlet when: During Migrations when you want to attach (or associate) the content database with new build (or new platform). E.g. Database attach upgrade Move a content database from one database serve

Mount-Dismount (Attach-Detach) Content Databases in SharePoint using PowerShell

Reviewed by Salaudeen Rajack on July 27, 2015 Rating: 5

How to Get All Lists in SharePoint Site using PowerShell?

July 26, 2015 List, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Get all lists in SharePoint site using PowerShell: To get all SharePoint lists by using PowerShell, use this script: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #Configuration Variables for Web URL $WebURL ="https://sharepoint.company.com/" #Get the site $Web = Get-SPWeb $WebURL #Get all sharepoint lists by using powershell $ListCollection = $Web.Lists #sharepoint powershell loop through all lists Foreach($list in $ListCollection) { #get list details Write-host $List.Title - $list.ItemCount - $List.Author.Name } One-Line Script to get all Lists in SharePoint using PowerShell: (Get-SPweb "https://sharepoint.company.com/").Lists | ForEach-Object { Write-Host $_.Title} SharePoint PowerShell to get all lists in site collection: PowerShell to get all lists in site collection Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #Configuration Variables for Site Collection URL $SiteURL ="http

How to Get All Lists in SharePoint Site using PowerShell?

Reviewed by Salaudeen Rajack on July 26, 2015 Rating: 5

How to Show Status Message in SharePoint 2013?

July 26, 2015 Client Side Object Model (CSOM), Javascript, JSOM, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: After the launch of new SharePoint intranet portal, we wanted to display a status message in each page. Solution: Here is the script to display status message using SharePoint Javascript client side object model. <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(AddStatusMessage, "sp.js"); function AddStatusMessage() { var statusID = SP.UI.Status.addStatus("Welcome","Welcome to New Crescent Portal. Feel free to contact <a href='mailto:support@crescent.com'>Helpdesk </a> if you have any queries"); SP.UI.Status.setStatusPriColor(statusID, 'green'); } </script> and the result of SharePoint 2013 status message: This script can be used in Master pages or in Script editor web parts.

How to Show Status Message in SharePoint 2013?

Reviewed by Salaudeen Rajack on July 26, 2015 Rating: 5

Change Subsite Logo to Link Root Site in SharePoint 2013 / 2016 using jQuery

July 24, 2015 Branding, jQuery, SharePoint, SharePoint 2013, SharePoint 2016, Subsite

Requirement: Change Subsite logo to link root site in SharePoint 2013 / SharePoint 2016 Solution: By default, Subsite logo links points to its homepage. We can change site logo link in SharePoint 2013 using jQuery to point to root site. Change SharePoint 2013 logo link to root site: Add a script editor or modify your master page to include this code <script src="http://code.jquery.com/jquery-3.1.0.min.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $("#DeltaSiteLogo a").attr("href","http://intranet.crescent.com/"); }); </script> Here is my another post with different approach: Change SharePoint 2013/2010 Site Logo Link to Root Site URL

Change Subsite Logo to Link Root Site in SharePoint 2013 / 2016 using jQuery

Reviewed by Salaudeen Rajack on July 24, 2015 Rating: 5

SharePoint Online: Update List Items using PowerShell

July 23, 2015 Client Side Object Model (CSOM), List, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to Edit List Item PowerShell CSOM Script to update List Items in SharePoint Online: Here is the example for SharePoint Online PowerShell to update list item. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/" $ListName="Projects" $UserName="admin@crescent.com" $Password ="Password goes here" #Setup Credentials to connect $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,(ConvertTo-SecureString $Password -AsPlainText -Force)) #Set up the context $Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteUrl) $Con

SharePoint Online: Update List Items using PowerShell

Reviewed by Salaudeen Rajack on July 23, 2015 Rating: 5

Apply Theme in SharePoint 2013 using PowerShell

July 17, 2015 Branding, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Themes are the quick and easiest way to apply branding to SharePoint sites. In SharePoint 2013 Themes got changed and redesigned as "Composed Look" feature. As it sounds "Composed" look, it simply defines theming by combining design elements: Master page - AKA site layout, Color theme, Font schemes and background images. Read more: Composed Looks Feature in SharePoint Apply composed look programmatically in SharePoint 2013 If you want to uniformly apply the composed look which comprises of Master Page, Image file, Font schema to all sites, you can utilize PowerShell. Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Variables for processing $WebURL="http://portal.crescent.com/" $ColorPaletteURL="/_catalogs/theme/15/Palette015.spcolor" $FontSchemeURL="/_catalogs/theme/15/fontscheme005.spfont" $BackgroundImgURL="/_catalogs/theme/15/Tulips.jpg" #Get the Web $web = Get-SPWeb $WebURL #Apply th

Apply Theme in SharePoint 2013 using PowerShell

Reviewed by Salaudeen Rajack on July 17, 2015 Rating: 5

Configuring Visio Graphics Service Application in SharePoint 2013 using PowerShell

July 17, 2015 PowerShell, Service Application, SharePoint 2013, SharePoint 2016

Visio diagrams are wonderful way to express ideas, simplify complex topologies, illustrate the process flow, etc. With Visio Services in SharePoint 2013, you can publish Visio diagrams in SharePoint so that they can be Shared and viewed online without installing Visio application in client computers. Configuring Visio Services in SharePoint 2013 Provisioning Visio services is straight-forward. Head on to SharePoint 2013 Central Administration site, Application Management >> Service Applications >> Manage Service Applications >> Click on "New" and choose "Visio Graphics Services" Visio Graphics services available only in SharePoint 2010/2013 Enterprise Edition! Make sure "SharePoint Server Enterprise Site features" is activated both at site collection level and site level. Fill the form with Service application name, choose Service application pool and other details. Click on "OK" to complete creation of visio service ap

Configuring Visio Graphics Service Application in SharePoint 2013 using PowerShell

Reviewed by Salaudeen Rajack on July 17, 2015 Rating: 5

Configure Audit Settings for SharePoint 2013 Sites using PowerShell

July 16, 2015 Audit, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Audit log feature in SharePoint helps us to analyze how SharePoint contents are being used by users or to track documents and users in accordance to compliance requirements. SharePoint 2013 audit log configuration is explained in my another post: Configuring Audit Logs Feature in SharePoint 2013 . Lets see how to enable auditing feature in SharePoint 2013 using PowerShell. PowerShell to set SharePoint 2013 Audit Log Settings To set SharePoint 2013 site collection audit settings using PowerShell, use this script: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue $SiteCollURL="http://intranet.crescent.com" #Get the site collection $Site = Get-SPSite $SiteCollURL #Define Audit Events $AuditLogEvents = "Delete", "Update" $Site.Audit.AuditFlags = $AuditLogEvents $Site.Audit.Update() #Set Trimming Options $Site.TrimAuditLog = $true $Site.AuditLogTrimmingRetention = 10 Configure Audit log Settings for All Sites in SharePoi

Configure Audit Settings for SharePoint 2013 Sites using PowerShell

Reviewed by Salaudeen Rajack on July 16, 2015 Rating: 5

Disable Alerts on SharePoint 2013 List using PowerShell

July 15, 2015 Alerts, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Temporarily disable Alert Emails on a SharePoint list. Solution: SharePoint Alert objects have "Status" property which can be turned ON or OFF. As there is no UI to disable or enable alerts in SharePoint directly from the browser, we can do it programmatically with PowerShell. Here is my PowerShell script to disable alerts on SharePoint 2010/2013 list or library. Important : This script disables ONLY existing alerts in a specific list or library! It doesn't (of course, can't!) disable any new alerts you create on the particular list! You may have to temporarily turn-off alerts on web application level by changing the flag "AlertsEnabled" to "false" as in How to Disable Alerts in SharePoint PowerShell script to Disable alerts on SharePoint list Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue #Function to Disable All Active Alerts on a Given List Function Disable-ListAlerts($WebURL, $ListName) {

Disable Alerts on SharePoint 2013 List using PowerShell

Reviewed by Salaudeen Rajack on July 15, 2015 Rating: 5

Restore Deleted Items from Recycle Bin in SharePoint Using PowerShell

July 10, 2015 PowerShell, Recycle Bin, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to restore deleted items from SharePoint recycle bin? To restore deleted items, Click on "Recycle Bin" link on the Quick Launch. Locate the object that you want to restore by Selecting the check box next to the object and then click Restore Selection. SharePoint 2010 - Restore from recycle bin using PowerShell Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration variables $SiteURL="http://portal.crescent.com/sites/ops/" $ItemName="Classifieds.xlsx" #Can be a List Name, File Name or ID of an Item #Get Objects $site = Get-SPSite $SiteURL $RecycleBin = $site.RecycleBin #Get the Item from Recycle bin $Item = $RecycleBin | Where{$_.Title -eq $ItemName} if($Item -ne $null) { $Item.Restore() Write-Host "Item Restored from Recycle Bin!" -f DarkGreen } else { Write-Host "No Item Found with the given name!" -ForegroundColor RED } This script restores given items from recycle bin. Tips:

Restore Deleted Items from Recycle Bin in SharePoint Using PowerShell

Reviewed by Salaudeen Rajack on July 10, 2015 Rating: 5

Delete SharePoint User Profile using PowerShell

July 03, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, User Profile

Generally SharePoint user profiles will get deleted when any of the below incident happens: User account is deleted in Active Directory Account is disabled User Profile Service Application Connection is changed or recreated Account is recreated in AD or moved out of an OU which is not part of SharePoint User Profile sync connection At times, You may have to delete SharePoint user profiles manually. PowerShell to Delete a User Profile in SharePoint: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Variables $SiteURL = "http://mypage.crescent.com" $AccountName="Crescent\Sherif" #Get Objects $ServiceContext = Get-SPServiceContext -site $SiteURL $UserProfileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($ServiceContext) #Get the User Profile $UserProfile = $UserProfileManager.GetUserProfile($AccountName) #remove user profile $UserProfileManager.RemoveUserProfile($AccountName); De

Delete SharePoint User Profile using PowerShell

Reviewed by Salaudeen Rajack on July 03, 2015 Rating: 5

Move Site Collection to Another Content Database using PowerShell

July 02, 2015 Content Database, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Site Collection

Requirement: Found a SharePoint Site collection growing in size over a period of time and wanted to move the SharePoint 2013 site collection to another content database. Solution: Use the PowerShell Cmdlet Move-SPSite to move site collection from one content database to another. Here is how: First, Identify the target content database to move your site collection. You can create new content database with New-SPContentDatabase cmdlet. Next, Run Move-SPSite cmdlet with site collection URL and database name parameters. Syntax: Move-SPSite <Site-Collection-URL> –DestinationDatabase "<Database-Name>" Example: Move-SPSite "http://intranet.crescent.com/sites/ops" –DestinationDatabase "SP13_Intranet_Content08" Here is our script in action: Tips: To find the current database of the site collection, use: Get-SPSite "Site-collection-url" | Select ContentDatabase Tags: move sharepoint site collection to new content database, s

Move Site Collection to Another Content Database using PowerShell

Reviewed by Salaudeen Rajack on July 02, 2015 Rating: 5

How to Use JSLink with List View Web Part in SharePoint 2013?

July 02, 2015 Client Side Rendering (CSR), SharePoint, SharePoint 2013

What is JsLink in SharePoint 2013: JSLink is a new method of combining JavaScript, CSS and HTML elements together to customize the look and feel of SharePoint Fields, List Items, List views, List forms and web parts. How to use JSLink in SharePoint 2013? Here is the SharePoint 2013-jslink example. Lets customize the look and feel of static "% Complete" to bar chart with the help of JSLink. At high-level, here are the steps: Create a JavaScript override file Upload the JavaScript file to the "Master Page Gallery >> Display Templates", Set the content type and properties of the file. Set the JS Link property of the List view web part to point to the JavaScript file we've uploaded. Step 1: Create your custom JS file to render SharePoint list field As the first step, We'll have to create a new js file which customizes the rendering of our field. Here is what I've created "TaskListDT.js". (function () { var overrideCtx = {}; ov

How to Use JSLink with List View Web Part in SharePoint 2013?

Reviewed by Salaudeen Rajack on July 02, 2015 Rating: 5

Upload Files to SharePoint Library Remotely using Client Object Model (CSOM) and PowerShell

July 01, 2015 Client Side Object Model (CSOM), PowerShell, SharePoint, SharePoint Online

Requirement: Upload files to SharePoint document library remotely. PowerShell Script to Upload a File to SharePoint Library using Client Object Model: We can upload files to SharePoint Online or SharePoint on-premises document libraries remotely using PowerShell and client side object model (CSOM). #Load SharePoint CSOM Assemblies [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client") | Out-Null [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.Runtime") | Out-Null ##Variables for Processing $SiteUrl = "http://mgmt.crescent.com/" $LibraryName="Proposal Documents" $SourceFile ="D:\Reports\MonthlyRpt.csv" #Setup Credentials to connect $Credentials = [System.Net.CredentialCache]::DefaultCredentials #Current User Credentials #connect using user account/password #$Credentials = New-Object System.Net.NetworkCredential($UserName, (ConvertTo-SecureString $Password -AsPlainText -For

Upload Files to SharePoint Library Remotely using Client Object Model (CSOM) and PowerShell

Reviewed by Salaudeen Rajack on July 01, 2015 Rating: 5