SharePoint Diary

Export and Import Subsite in SharePoint 2013 using PowerShell

September 28, 2015 Backup/Restore, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Subsite

Export-Import subsite using PowerShell in SharePoint 2010 how to export SharePoint subsite? export subsite SharePoint 2013 PowerShell, Unlike SharePoint 2013, you'll have to create a subsite first and then import. Export-SPWeb cmdlet used to export a sub site, list or document library. Op…

Get SharePoint Timer Job History using PowerShell

September 27, 2015 CSV, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Timer Job

Requirement: Retrieve and review the SharePoint timer job history for troubleshooting an issue. Solution: SharePoint 2013 Central Administration site provides an interface to get timer job history. Here are the steps to get SharePoint timer job history in SharePoint. Navigate to SharePoint …

Open with Explorer: Network Error - Windows cannot access [email protected]\DavWWWRoot\SiteURL

September 26, 2015 Known Issues, SharePoint

Problem: Open with Explorer button in SharePoint 2010 site gave this error message on a particular document library. Network Error - Windows cannot access [email protected]\DavWWWRoot\SiteURL\Library You do not have permission to access \\[email protected]@SSL\DavWWWRoot\Library-URL. Contact your netw…

Open SharePoint List Items in Edit Mode by Default

September 25, 2015 jQuery, List Forms, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: Open SharePoint Task list items in Edit form directly instead of "Display form". Solution: Go to your SharePoint task list, Click on Site settings gear, Choose "Edit page" Add a script editor and place this code: jQuery to launch list items in Edit mode:…

SPD Error: Microsoft SharePoint designer does not support editing non-SharePoint sites

September 25, 2015 SharePoint, SharePoint Designer

Error: "Microsoft SharePoint designer does not support editing non-SharePoint sites" - while trying to open a SharePoint 2016 site with SharePoint designer 2013, got this error message. Solutions: Simply close all instances of your SharePoint Designer and then reopen it. Check …

SharePoint Online: Get All List Items using PowerShell Script

September 23, 2015 Client Side Object Model (CSOM), List, List Item, PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to Get List Items SharePoint Online: PowerShell to Get All List Items How to get items from a SharePoint Online list using PowerShell? Well, here is an example PowerShell CSOM script to get you all items in the given list or library, including items …

Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013

September 18, 2015 Known Issues, Migration/Upgrade, Permission, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: After migrating from SharePoint 2010 to SharePoint 2013 using database attach method, all users received "access denied" error and they were unable to login. Made sure, both the source and destination SharePoint farms are in same Active Directory domain. Root cause: This is…

How to Create a Service Application Pool in SharePoint using PowerShell?

September 15, 2015 App Pool, PowerShell, Service Application, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Service Application pools runs service application proxy web services inside IIS. Typically all of the service applications can be run with the same application pool. You can create a new service application pool while creating new service applications in SharePoint 2013. Ever wanted to create…

Server Error in '/x' Application - Excel Web App Error - Solution

September 14, 2015 Office Web Apps, SharePoint

Problem: All of a sudden Office Web Apps Excel Web App stopped working and gave this Runtime error message on opening Microsoft Excel files from SharePoint 2013: Server Error in '/x' Application. Solution: This occurs due to the public key which connects to the WOPI application su…

Access Denied Error on Insert Picture/Link/Upload File in SharePoint 2010

September 13, 2015 Known Issues, Permission, SharePoint, SharePoint 2010

Problem: Users getting "Access Denied" error message while trying insert a picture via SharePoint 2010 Rich text editor. Verified that the user has "Full Access" permissions on the specific list, Still gets access denied on accessing layout pages such as: /_layouts/RteUploadD…

SharePoint Online: Import CSV File into SharePoint List using PowerShell

September 09, 2015 Client Side Object Model (CSOM), CSV, List, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Scenario: My requirement is to import data from CSV file to SharePoint online list from a local drive, every day! Create a List in SharePoint Online, matching columns from the CSV file, before running the script! PowerShell Script to import SharePoint List Items from CSV File: Here is the …

Top 50 Use Cases of SharePoint in the Industry

September 09, 2015 SharePoint

Most of the people knows Microsoft SharePoint as a File Share, But apart from File Share, there are number ways SharePoint is being used by organizations. Here is the list of top 50 use cases in my experience: Document Management System File Shares Content Management System Enterprise Search…

How to Add a Link to SharePoint 2013 Suite Bar?

September 07, 2015 jQuery, SharePoint, SharePoint 2013

Requirement : Add a link to SharePoint 2013 suite bar. Solution: Edit SharePoint 2013 Master page to add a new link in Suite Bar Adding link to suite bar in SharePoint 2013 can be achieved by following these simple steps: Open your SharePoint 2013 site in SharePoint designer 2013. Navigate …

Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator

September 05, 2015 Known Issues, SharePoint

Problem: When trying to filter a list with large items, got this error message: "Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator" Root cause: Identified that the part…

Disable Redirect from User Information Page (userdisp.aspx) to MySite Profile Page (Person.aspx)

September 04, 2015 SharePoint, Tips and Tricks, User Profile

If you want to quickly check SharePoint user profile properties, You can get it from user information list or by simply clicking on user name hyperlinks from metadata fields such as: Created by. Usually, user profile page points to: http://sharepointsite.com/_layouts/userdisp.aspx?ID=123 When…

Fix "The site is not valid. The 'Pages' document library is missing" Error

September 03, 2015 Known Issues, SharePoint

Problem: After trying to deactivate and activate the publishing feature in a site, users started receiving this error: "The site is not valid. The 'Pages' document library is missing". It also happened after importing a subsite backup! Additionally, when tried creating a Publis…

Get and Export User Profile Properties using PowerShell in SharePoint 2013

September 03, 2015 CSV, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, User Profile

Its a common requirement in SharePoint to prepare reports from user profile properties. Here is my PowerShell scripts to get user profile properties in SharePoint. Important: Make sure User Profile Service Application is created , up and running before running these scripts! and run as Farm Adm…

Disclaimer