SharePoint Diary

Export SharePoint 2007 Search Crawl Log Errors using PowerShell

May 30, 2014 CSV, PowerShell, Search, SharePoint, SharePoint 2007

Requirement: Found so many errors logged in the Search crawl log. Wanted to analyze them. So need them in CSV format. Solution: Lets use this PowerShell Script to export search crawl errors to CSV: #Load SharePoint Assemblies [void][System.Reflection.Assembly]::LoadWithPartialName("Mic…

How to Integrate Google Analytics with SharePoint 2013?

May 28, 2014 Integration, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Google Analytics is a popular free service for website analytics. Why don't we use Google analytics with our SharePoint sites? Here is how to add Google analytics to SharePoint 2013: Step 1: Sign-up & Get Google analytics Tracking code You need to have a Google analytics account to sta…

How to Create Redirect (URL Shortcut) to a Subsite in SharePoint?

May 28, 2014 IIS, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Subsite

Requirement: We've a sub-site located at the URL - http://sharepoint.crescent.com/sites/marketing/regions/us/brandcenter/ and the requirement is to create a shortcut to this subsite. That is the URL shortcut: http://brandcenter.com should redirect to the above subsite. Solution: To red…

Default View Missing - Incremental Search Crawl Stuck - Solution

May 26, 2014 Search, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013

Problem: SharePoint incremental crawl stuck at a particular point of time - without changing the crawling status from: "Crawling Incremental". No progress in search crawl log. No new items included in search crawl. Root cause: Default view files / associations missing in some of the …

Configure Self Service Site Creation in SharePoint 2013

May 24, 2014 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is Self Service Site Creation in SharePoint? To create a new Site collection in SharePoint, Usually SharePoint Administrators use SharePoint Central Administration site or SharePoint Management Shell. Self-Service Site Creation feature enables end users to create site collections within a p…

Upload Master Page to SharePoint using PowerShell

May 23, 2014 Branding, Master Page, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: We've a SharePoint 2013 master page from a third-party consultants and would like copy-apply the master page to SharePoint sites. PowerShell script to upload Master page to SharePoint: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue $WebURL = "…

Storage Analysis Report for SharePoint Document Library

May 22, 2014 Admin Reports, CSV, SharePoint, SharePoint 2007

Requirement: On a very large document library, We needed to analyze all documents stored, in-order-to move documents into individual libraries/folders, as this larger library causing latency issues. Lets use PowerShell script to analyze and generate report on document library storage information…

How to Hide Quick Launch Bar in SharePoint 2013?

May 22, 2014 CSS, Navigation, Quick Launch, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Online

How to hide SharePoint quick launch? Want to remove the quick launch from SharePoint 2013 or SharePoint 2016 sites, perhaps to see the home page in full width? How to hide quick launch in SharePoint 2013? Well, to enable or disable Quick Launch through the SharePoint 2013 user interface, Go to:…

Increase Maximum File Upload Size in SharePoint 2013

May 21, 2014 Central Administration, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

SharePoint 2013's default file upload size is 250 MB! To upload large files you have to change "Maximum Upload Size" setting in SharePoint 2013 Central administration site. How to increase file upload size in SharePoint 2013? Maximum upload size setting is configured per web appl…

Enable Anonymous Access in SharePoint using PowerShell

May 21, 2014 Anonymous Access, Permission, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to Enable Anonymous Access in SharePoint using PowerShell? In continuation with my last post, How to Enable Anonymous Access in SharePoint 2013 , Here are some nifty PowerShell scripts to manage anonymous access in SharePoint: Enabling anonymous access in SharePoint involves three steps:…

How to Enable Anonymous Access in SharePoint 2013?

May 21, 2014 Anonymous Access, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

As the name suggests, Anonymous access allows anonymous users to view pages in SharePoint. Setting up anonymous access in SharePoint sites is a common task for most us, Often we do it to enable anonymous access for SharePoint 2013 for public facing sites. Lets see the steps needed to configure an…

Merge-SPLogFile: Merge SharePoint Log Files from Multiple Servers

May 17, 2014 Debug, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, ULS Log

Problem: In a multi-server SharePoint farm, if you need to trace an issue, you have to log-in and review the ULS logs on each server in the farm. This process could be tedious in multi-server farms since you're not sure on which server the error has occurred. Solution: Use the Merge-SPLog…

Database is up to date, but some sites are not completely upgraded

May 17, 2014 Migration/Upgrade, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database

Problem: Getting database status as "Database is up to date, but some sites are not completely upgraded" from "Review Database Status" page in Central Administration, Root Cause: This simple means: SharePoint Products Configuration wizard is unsuccessful in upgrading the …

Find and Delete Unused Orphan Databases in SharePoint

May 15, 2014 PowerShell, SharePoint, SharePoint Database

Problem: In a SharePoint 2013 pilot environment, Created several Web applications and service application for testing purpose. Some of those web applications are deleted without deleting their databases. After a while, The database server is filled up and we got to cleanup SQL Server by deleting…

Restore-SPSite: The operation that you are attempting to perform cannot be completed successfully

May 15, 2014 Backup/Restore, Known Issues, PowerShell, SharePoint, SharePoint 2013

Problem: While trying to restore a site collection, with "Restore-SPSite" cmdlet in PowerShell, Got this error: Restore-SPSite : The operation that you are attempting to perform cannot be completed successfully. No content databases in the web application were available to store yo…

How to Change Favicon in SharePoint 2013?

May 10, 2014 Branding, SharePoint, SharePoint 2013, SharePoint 2016, SharePoint Foundation

Favicon - short form for "Favourites Icon" adds branding to SharePoint 2013 sites. Its not only used for bookmark Favourites, but also in address bar, browser icon locations too. In case you want to change favicon in SharePoint 2013, here are the options. SharePoint 2013 favicon loca…

No Apps are installed to open this type of link (grvopen) - Fix Sync Issue

May 08, 2014 Known Issues, OneDrive for Business, SharePoint, SharePoint 2013

Sync feature in SharePoint provides two way between SharePoint libraries and your local computer. Getting "No Apps are installed to open this type of link (grvopen)" error message on clicking the "Sync" button in SharePoint 2013? In some cases SharePoint 2013 sync button not w…

Change SharePoint 2013 Site Logo Link to Root Site URL

May 07, 2014 Branding, SharePoint, SharePoint 2010, SharePoint 2013

By default, on clicking the SharePoint 2010 or SharePoint 2013 site logo - It takes us to the root of the current site or sub-site. But you may want to link logo to top level site.Well, to change this behavior you got to change the master page. Important: Since this is a Master page change, You…

Change Quick Launch Width in SharePoint 2013/2010/2007

May 07, 2014 CSS, Quick Launch, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

When using lengthy titles in SharePoint 2013 quick launch bar, we may have to increase the width to fit the contents without wrapping to next line. Here are the nifty collection of CSS styles to change the width of left navigation in SharePoint. SharePoint 2013 left navigation width: <style…

Disclaimer