Add Attachment Field in SharePoint 2013 List Form

Requirement: Add attachment column to a custom new/edit form in SharePoint 2013. Solution: Create new custom list forms for New and Edit in SharePoint designer 2013. Add this code to the custom list form in the location where you want the attachment field to appear. Result: Here is the SharePoint custom edit…

Read more

Export-Import All Lists and Libraries from One Site to Another using PowerShell

The requirement is to copy and paste all SharePoint lists and libraries from one site to another. While “Save List as a Template” is one approach, it doesn’t work for larger lists and is time-consuming. Using the Central Administration export method also kills my time. Solution: We can copy and paste SharePoint…

Read more

Save Site as Template Option Missing in SharePoint 2013?

Perhaps the easiest way to create a standard site template is to create a site,  Add-remove content, list and libraries, and save it as a template. But SharePoint 2013 does not support the “Save Site as Template” option on Publishing sites. If a site with “SharePoint Server Publishing” is activated, this option…

Read more

Property Bags in SharePoint – Store, Retrieve Custom Configurations

As its name suggests, the Property bag feature provides a convenient way to store and retrieve custom configurations instead of storing them in the web.config files. Property bags in SharePoint store configuration data in the Hash-Table (Key-Value) format. We can store and retrieve properties at the following levels: Farm (SPFarm ) Web…

Read more

Restart IIS (IISRESET) on All Servers in the SharePoint Farm using PowerShell

Doing IISReset on a Server Farm with Multiple SharePoint servers is a painful process. If you are experiencing problems with IIS on your SharePoint servers, you may need to restart it. This blog post will show you how to restart IIS on all servers in a SharePoint farm. PowerShell Script to Restart…

Read more

Set Max Degree of Parallelism for SharePoint 2013 in SQL Server 2012

What is max degree of parallelism in SQL Server? SQL Server configuration option ‘max degree of parallelism’ limits the number of processors used for the execution of a query with a parallel plan. By default, it’s set to ‘0’ to allow all processors available. SharePoint 2013 requires that the “max degree of…

Read more

SharePoint Site Collection vs Subsite – Determine Which One to Create

SharePoint newbies often get confused with this question: When to create a Site collection and when to use Subsites? What are the advantages of having a Ste collection rather subsite? Well, the choice of Site collection or subsite can be determined based on these factors: Security/Permission Management – Every Site collection uses…

Read more

Database is in compatibility range and upgrade is recommended – Solution

Problem: After a service pack upgrade in SharePoint 2013, database status under  Central Admin >> Upgrade & Migration >> Review database status – turned into “Database is in compatibility range, and upgrade is recommended.” Solution: In most cases, this message simply means that you have installed the latest patch/service pack, and running SharePoint…

Read more

Solution for “The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered” PowerShell Error in SharePoint 2013

We have a new SharePoint administrator who joined our team. We granted him access to all SharePoint servers, added him to the Farm Admin group, Web application policy.  However, when he tried launching SharePoint Management Shell or try adding the SharePoint PowerShell snap-in from PowerShell ISE, he got the error message:  “The…

Read more

PowerShell “Exception of type ‘System.OutOfMemoryException'”

In the middle of script execution, I got the below error: The following exception was thrown when trying to enumerate the collection: “Exception of type ‘System.OutOfMemoryException’ was thrown.”. At d:\Scripts\VersionRpt.ps1:19 char:16 +         foreach <<<<  ($FileVersion in $File.Versions)     + CategoryInfo          : NotSpecified: (:) [], ExtendedTypeSystemException     + FullyQualifiedErrorId : ExceptionInGetEnumerator Solution: Increase…

Read more