Download All Files From a SharePoint Library Programmatically using PowerShell

Ever wanted to download all files from a SharePoint Library (Document Library, Picture Library, etc.) to your local drive? While downloading a single file or document is fairly straightforward by clicking “Download a Copy” from the documents tab of the Ribbon or From the ECB Menu of the document  >> Send To…

Read more

How to Run SQL Server Query from PowerShell Script?

For a migration project, there was a requirement to read from SQL Server table data , process the migration and then insert / update the tables back from PowerShell. We got to run SQL Server query from PowerShell. Here is how to query SQL Server using PowerShell: PowerShell to Run SQL Server…

Read more

How to Prevent SharePoint List or Columns from Deletion?

Scenario: We have a configuration list being used by a custom SharePoint application, and we don’t want to let the users delete the configuration list in SharePoint. So how to prevent delete in SharePoint list? The idea is: Set the “AllowDeletion” property of the SharePoint list or Library to false. These properties…

Read more

SharePoint 2010 Rating Feature Configuration – How to Activate? Fix Ratings not Updating Issue

Rating feature was introduced in SharePoint 2010, It helps to rate Lists, Documents, Pages on a SharePoint site. How To Enable SharePoint 2010 Rating Setting? To setup SharePoint 2010 rating configuration, follow these steps: Navigate to your SharePoint site and then Target list or document library where you want Ratings to be…

Read more

SharePoint WSP Solution Deployment Stuck at “Deploying”

Issue: SharePoint WSP Solution got stuck at “Deploying” stage for hours while trying to deploy using STSADM command in SharePoint 2007! Same thing happened in SharePoint 2013 also: Workarounds: Try these workarounds to fix the solution deployment stuck at “deploying” stage. Make sure all your WFE & DB Servers in the Farm…

Read more

IE 10 Browser Compatibility issues with MOSS 2007 and SharePoint 2010

Found so many user interface issues with Internet Explorer 10 while using it in MOSS 2007 and SharePoint 2010 sites. For instance, KPI didn’t load, Grouped items stuck with “Loading..” message, “Save” button didn’t work on SharePoint list forms, etc. Additionally, Experienced many JavaScript errors when tying Datasheet view, Multiple File Upload,…

Read more

Delete All Document Versions in SharePoint Document Library using PowerShell

Requirement: Delete all old document versions in a SharePoint site collection to free up some disk space occupied by document versions. Because simply disabling versioning does not delete old versions which are already created until the next update happens on the document! So, If you want to release the space occupied by…

Read more

How to Hide SharePoint 2010 Ribbon Tab – Group – Button – Menu?

How to hide Ribbon Tab – Group – Button – Menu in SharePoint 2010? But why? Because the requirement is: Users fill the form and not upload any existing documents to the document libraries on a particular site. So wanted to disable the Upload Document button from the SharePoint ribbon. Solution: Override…

Read more

Open with Explorer Error – Alternate Method

When you try to use “Open with Explorer” on SharePoint document library, Received Error “Your client does not support opening this list with Windows Explorer”. You tried all the workarounds on Open with Windows Explorer Error: “Your client does not support opening this list with windows explorer” , but no luck! Well,…

Read more

How to Remotely Execute SharePoint PowerShell Cmdlets?

PowerShell allows us to run cmdlets remotely from client machines. We can run SharePoint 2010 cmdlets on the SharePoint Server, remotely connecting from client machines by following these two steps: Step 1: To execute SharePoint PowerShell remotely, you have to enable PowerShell Remoting on the server first! By default, PowerShell Remoting is…

Read more