SharePoint Diary

How to Upload File to SharePoint Library using PowerShell?

July 31, 2012 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

We had a PowerShell script code to generate Large Lists reports in D:\Reports, and now want to periodically upload them to a document library "Reports" in my Admin site. So, scheduled a PowerShell script to do so. Here is my PowerShell code to upload the report to a document library. …

Delete or Restore SharePoint Recycle Bin Items based on Deleted Date using PowerShell

July 30, 2012 PowerShell, Recycle Bin, SharePoint

Requirement is to Restore all the Items deleted before last week from Recycle bin, which were already deleted from End-User Recycle bin (1st Stage Recycle bin). Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebApp=get-spwebapplication "http://sharePoint.cre…

Display Lists from Other Site Collection/Web Application Using JQuery

July 29, 2012 jQuery, SharePoint, Tips and Tricks

Another frequent requirement is to display Lists/Libraries from Root site to Sub-site or Sub-site to Root site, and in some cases from Cross Site collection. While this can be fulfilled by Web Services, Custom Web Parts, etc, here is the simple JQuery method to display SharePoint list from anoth…

Maintenance Page for SharePoint - Quick way to Implement

July 26, 2012 Administration, Best Practices, IIS, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Here is the quick way to implement Maintenance page in SharePoint, during scheduled down times/upgrade/service pack patching: Create a new app_offline.htm file in IIS Root folder of your SharePoint site. Place some descriptive text/images to the file, Make sure the file size is at least 512 byt…

How to Create - Update - Delete SharePoint Views Programmatically?

July 23, 2012 C#, List View, Object Model, SharePoint, SharePoint Development

Often in development we may have to deal with SharePoint Views programmatically. Here I'm sharing the code snippets from my recent project to handle views programmatically. Creating a New View Programmatically: using (SPSite site = new SPSite("http://crescent.sharepoint.com"…

SharePoint 2010 Custom Error Page Redirect in Event Receivers

July 21, 2012 Event Receivers, SharePoint, SharePoint 2010

In my last post Allow only Certain File Types to be Uploaded in SharePoint Document Library using Event Receiver I developed an Event receiver to prevent files other than PDF from being uploaded to a document library. So when user tries to upload a file other than PDF they'll get an Error m…

Restrict File Types in SharePoint Document Library Upload using Event Receiver

July 19, 2012 Event Receivers, SharePoint, SharePoint 2007, SharePoint 2010

Requirement: In a Project collaboration SharePoint site, had a requirement to Allow users to upload only PDF files to a Document library and prevent all other files from being uploaded. Solution: Our requirement is basically to prevent files being uploaded other than PDF, isn't it? So le…

SharePoint 2013 Preview Officially Launched!

July 18, 2012 SharePoint, SharePoint 2013

SharePoint 2013 preview officially launched with great features. Here are some useful URL's to get started: SharePoint 2013 Home: http://technet.microsoft.com/en-us/sharepoint/fp142366 Download SharePoint 2013 Preview: http://technet.microsoft.com/en-us/evalcenter/hh973397 SharePoint 2013…

Customize Top Navigation Programmatically in SharePoint 2010

July 12, 2012 C#, Navigation, Object Model, SharePoint, SharePoint 2007, SharePoint 2010

Requirement: Had to customize the Top navigation with bunch of provided internal/external links as part of a branding project. Solution: Designed a feature to programmatically add links to top navigation bar. when activated, feature will add bunch of links to the top navigation bar. Customi…

SharePoint List Column Limits

July 08, 2012 Reference, SharePoint, SharePoint 2007, SharePoint 2010

There are limits in number of columns we can create in a SharePoint list. You may Get "Column Limit Exceeded" when You add a new column to a SharePoint List. This is because of the column limitations. For SharePoint 2003/2007: With Windows SharePoint Services, you can create the fol…

How to Create SharePoint List or Library Programmatically?

July 07, 2012 C#, Object Model, PowerShell, SharePoint

At times, We may have to create List or Document Libraries programmatically. These code snippets will help to get it done. Using .Net Object Model (C#) using (SPSite site = new SPSite("http://sharepoint")) { using (SPWeb web = site.OpenWeb()) …

Activate-Deactivate Features Programmatically in SharePoint

July 06, 2012 C#, Object Model, SharePoint, Solutions and Features

At times, We may have to activate/deactivate features programmatically. Here is the code snippet: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; namespace ActivateFeature { class …

Set Sorting, Filter, Group By in SharePoint Views Programmatically

July 04, 2012 C#, CAML, List View, Object Model, PowerShell, SharePoint

SharePoint List views uses CAML internally to Filter, Sort list items. In a Recent project, we had to programmatically set the Filter and Sort order of default views. How to Get the CAML? Simple! use U2U CAML Query builder, one of my favorite SharePoint tool. C# code to set the View Filter…

How to Create Custom Application Page in SharePoint 2010 to get List Owners?

July 02, 2012 Administration, SharePoint, SharePoint 2010, SharePoint Development, Visual Studio

In my environment, This is one of a Frequently asked question: How do I find who has created a List or Library? oops, I don't find any direct way from SharePoint interface to know who has created a List or Library. Lets develop a Application page, host it under Layouts folder and let the …

Run a Console Application and Mail Output Report with PowerShell

July 01, 2012 Admin Reports, PowerShell, SharePoint

We had a console application GetStorageReport which runs and generates detailed storage reports based on some SharePoint APIs. Got the requirement to run the tool periodically and mail the output report of the application. Scheduled a PowerShell script to execute the application and mail the rep…

Set ListViewWebPart Toolbar Type Programmatically

July 01, 2012 List, Object Model, SharePoint

While adding a ListViewWebPart to web part page programmatically, had to set the List View's tool bar to "Summary View". After trying for hours found this code: //Method to Set the Tool bar type public static void SetToolbarType(SPView spView, String toolBarType) …

How to Change Site Collection URL in SharePoint?

July 01, 2012 Administration, Managed Path, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to change SharePoint site URL? At times, we get requests to change the Site collection URLs. While its relatively straightforward and easy by going to Site Actions >> Site Settings >> Title, description, and icon under Look and Feel to change the sub-site's URL, changing th…

Disclaimer