Set Content Editor Web Part (CEWP) Content with PowerShell

Scenario: We've a Project site collection with 100's of sub sites created for each project from a custom site template. Home page of each site has a content Editor web part with some content in it, titled "Dashboard Links". Years later, business wanted to change the content in …

Get Query String and Set List Form Field Value using jQuery

Years back, I used JavaScript for the similar requirement in SharePoint 2007: Get the value from URL Query String and populate the value of SharePoint list form field: How to Get the Query String from URL and Set SharePoint List Form field value? Now in SharePoint 2010, lets use jQuery to get …

Building Charts in SharePoint with Google Charts API

Looking for a quick way to build Charts & Graphs from SharePoint list data? Here is the quickest way to create charts on SharePoint with Google Chart API ! Go to: http://usermanagedsolutions.com/SharePoint-User-Toolkit/Pages/Pie-Bar-Chart-Connector.aspx Provide "Edit view " URL i…

Export SharePoint 2007 Search Crawl History using PowerShell

Here is the PowerShell script to export Search crawl history in SharePoint 2007 using PowerShell: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server.Search") …

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 straight forward by Clicking "Download a Copy" from documents Tab of the Ribbon or From the ECB Menu of th…

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 …

How to Prevent SharePoint List or Columns from Deletion?

Scenario: We've a configuration list being used by a custom SharePoint application and we don't want to let the users to delete the configuration list in SharePoint. So how to prevent delete in SharePoint list? The idea is: Set the "AllowDeletion" property of the SharePoint l…

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…

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" …

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, Expe…

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 rel…

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 to fill the form and not upload any existing documents to the document libraries in a particular site. So wanted to disable Upload Document button from SharePoint ribbon. Solution: …

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…

How to Remotely Execute SharePoint 2010 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 th…

How to Hide a List or Library in SharePoint?

How to Hide a SharePoint list or library from browser?  But why? Because, My custom application uses some configurations which should be stored and retrieved from a SharePoint list, but it must not be visible to end-users to avoid any mess. So, we got to hide our configuration list from users. …

Change "Save" or "OK" Button Text on SharePoint List Forms

Wouldn't it be more meaningful to rename SharePoint List NewForm.aspx "Save" or "OK" button text to "Submit" in Request Tracking Lists? Yes! Sure, It's possible to change the "Save" button's text to something else which gives more meaning in t…