Add Attachment Field in SharePoint 2013 List Form

Requirement: Add attachment column to a custom new/edit forms 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 it is time-consuming. Using the Central Administration export method also kills my time. Solution: We can copy and paste…

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 2013 – Store, Retrieve Custom Configurations

As its name suggests, the Property bag feature provides a convenient way to store and retrieve custom configurations, instead of having to store them in 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 )…

Read more

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

Doing IISReset on Server Farm with Multiple SharePoint servers is a painful process. If you ever need to restart IIS on all servers in the SharePoint farm, Here is a nifty solution to do IISRESET on all SharePoint Servers using PowerShell: PowerShell Script to Restart IIS on All SharePoint Servers: Make sure,…

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 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 unique…

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, 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, got the error message:  “The local…

Read more

PowerShell “Exception of type ‘System.OutOfMemoryException'”

In middle of a script execution, 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 the…

Read more