SharePoint Diary

Set Content Editor Web Part (CEWP) Content with PowerShell

June 30, 2013 Content Editor Web Part, PowerShell, SharePoint

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

June 27, 2013 Javascript, jQuery, List Forms, SharePoint, SharePoint 2010, SharePoint 2016, SharePoint Online

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

June 26, 2013 Integration, SharePoint, SharePoint 2007

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

June 25, 2013 CSV, Search, SharePoint, SharePoint 2007

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

June 24, 2013 Document Library, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

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?

June 18, 2013 PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SQL Server

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?

June 17, 2013 Column, List, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

June 17, 2013 Configuration, SharePoint, SharePoint 2010

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"

June 16, 2013 Deployment Guides, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013

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

June 16, 2013 Browser Issues, SharePoint, SharePoint 2007, 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

June 16, 2013 Administration, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Version History

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?

June 13, 2013 Ribbon, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

June 12, 2013 Known Issues, SharePoint, Tips and Tricks

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?

June 09, 2013 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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?

June 05, 2013 C#, PowerShell, Security, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, Tips and Tricks

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

June 01, 2013 Javascript, jQuery, List Forms, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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…

Disclaimer