Set Content Editor Web Part (CEWP) Content with PowerShell

Scenario: We have a Project site collection with 100’s of sub sites created for each project from a custom site template. The home page of each site has a content editor web part with some content in it, titled “Dashboard Links”. Years later, The business wanted to change the content in the…

Read more

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…

Read more

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: https://usermanagedsolutions.com/SharePoint-User-Toolkit/Pages/Pie-Bar-Chart-Connector.aspx Provide the “Edit view” URL in the given text box. E.g. I have a List “Q1Summary” in the Finance site collection….

Read more

Export SharePoint 2007 Search Crawl History using PowerShell

Here is the PowerShell script to export Search crawl history in SharePoint 2007 using PowerShell: This gives data such as: CrawlType (2 – Increment, 1- FULL), ContentSourceID ( 4 – Local Crawls, 10 -People search), Status, Start Time, End Time, Success Count, Error Count, Warning Count of last 8 crawls.

Read more

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