Import XML File Data into SharePoint List using PowerShell

Requirement: PowerShell to Import XML to SharePoint List We have a utility from a third-party system that generates project data in XML format. We had to import those data to a list in the PMO site. In other words: We’ve to import from XML file to SharePoint list. Here is a sample…

Read more

How to Add New List Item in SharePoint using PowerShell?

My PowerShell scripts to add list item in SharePoint: Add SharePoint list items using PowerShell The syntax to add new list item in SharePoint using PowerShell, goes like this Add list item in SharePoint with PowerShell Lets add new task to the task list using PowerShell:  Result: Here is my another article…

Read more

Exclude a Column from SharePoint Search Crawl

Requirement:  Exclude a column from SharePoint search. By default, the SharePoint search engine craws and indexes all documents and their associated metadata properties from lists and libraries. In our case, We keep few fields for configuration in a custom SharePoint application and don’t want those fields to appear in SharePoint Search results….

Read more

Find Who has Created / Modified a SharePoint View

Ever wondered how to find the user who has created or modified a particular SharePoint view? and when it was created/modified? Well, There is no SharePoint UI to get these information! But using SharePoint object model, we can retrieve these data programmatically from SPFile object’s properties. Here is how I retrieved “Created…

Read more

Get All SharePoint Site Collection Owners (Primary/Secondary Site Collection Administrators)

Requirement is to find out owners of each SharePoint site collection in the environment.We needed this data to get approvals on critical changes and to inform site owners prior to maintenance windows. Simple! Use STSADM command: On SharePoint 2007 and above, STSADM command can be used to get primary owner details of…

Read more

Format SharePoint Number Column without Commas

Problem: SharePoint Number columns shows, (comma) in View/Display Forms. There are specific numeric columns, User wanted to display without commas. There is no direct way to remove comma/avoid thousand separators in SharePoint Number fields, But the below tricks help to get SharePoint 2007/2010/2013 number column values without commas. Solutions: Here are some…

Read more

Add-Remove-Get Event Receivers in SharePoint with PowerShell

We usually use C# console application or feature activation code to register event receivers with the target list or library in SharePoint. At times, we may have to handle event receiver associations explicitly. Of course, there are some great tools (E.g. SharePoint Event Receiver Manager) to manage event receivers. However, in a…

Read more

SharePoint 2013 “Get Started with your site” Web Part – FAQs

“Getting Started” tiles are new addition to SharePoint 2013 team sites. These tiles intend to provide shortcuts to common actions, such as sharing your site, applying a theme. In SharePoint 2013, They replaces the “Getting Started” links from its previous version: SharePoint 2010. Disable Getting Started Web Part: From the home page…

Read more