Create a SharePoint Group using PowerShell

January 30, 2015    , , , , , ,
Requirement: Create new SharePoint Group using PowerShell SharePoint groups to simplifies permission management by assigning a set of users to a group and assigning permission level to them through the group. There are default groups gets created based on the site template you choose while creating site collections, Such as Owners, Members and Visitors. PowerShell to Create SharePoint Security Group Here is my script to create new SharePoint group using PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue #Custom Function to Create new SharePoint Group function Create-SPGroup { param ($SiteURL, $GroupName, $PermissionLevel, $GroupDescription) try { #Get the Web $web = Get-SPWeb -Identity $SiteURL if($web -ne $null) { #Check if Group Exists already if ($web.SiteGroups[$GroupName] -ne $null) { write-Host "Group $GroupName exist
Read More
Create a SharePoint Group using PowerShell Create a SharePoint Group using PowerShell Reviewed by Salaudeen Rajack on January 30, 2015 Rating: 5

"There has been a critical error while processing the form." - Error in InfoPath

January 29, 2015    , ,
Problem: SharePoint browser enabled InfoPath form gave this error message: There has been a critical error while processing the form. Click Start Over to load a new copy of the form. If this error persists, contact the support team for the Web site.  Click Close to exit this message.  Error details: Object doesn't support property or method 'addEventListener' Solution: This is due to Browser compatibility settings. Add your Site under compatibility view settings to resolve this issue. Open your Site in Internet Explorer Go to "Tools" Menu >> Click on "Compatibility View Settings" menu item Add your site to the list! That's all. Now the browser enabled InfoPath form should render without any issue.
Read More
"There has been a critical error while processing the form." - Error in InfoPath "There has been a critical error while processing the form." - Error in InfoPath Reviewed by Salaudeen Rajack on January 29, 2015 Rating: 5

How to Connect to SharePoint Online from PowerShell?

January 27, 2015    , , , ,
I know I said it several times, but I'll say it again: I'm a big fan of PowerShell! PowerShell makes repetitive tasks easier and makes our life smarter. It helps to automate complex tasks and reduces the risk of human errors. In this article, I'm exploring how to use PowerShell with SharePoint Online. How to Connect to SharePoint Online using PowerShell? Follow these steps to connect to SharePoint Online via PowerShell. Step 1: Install SharePoint Online PowerShell Module  Make sure You have PowerShell and SharePoint Online PowerShell Module Installed. To download Windows Management Framework 3, which includes PowerShell 3.0: http://www.microsoft.com/en-us/download/details.aspx?id=34595 To Download and Install SharePoint Online PowerShell module: You must download and install SharePoint Online Management Shell to start with. Download PowerShell for SharePoint online at: https://www.microsoft.com/en-us/download/details.aspx?id=35588 Instead of downloading and i
Read More
How to Connect to SharePoint Online from PowerShell? How to Connect to SharePoint Online from PowerShell? Reviewed by Salaudeen Rajack on January 27, 2015 Rating: 5

Delete Button Missing in SharePoint Column? Here is How to Delete

January 25, 2015    , ,
How to delete a Column when Delete Button is missing? Unable to delete list column in SharePoint since there is no delete button in field properties? In some cases, columns added through "Add existing columns" doesn't provide the option to delete! To make them deletable, just revert these two properties: AllowDeletion & Sealed Here is how to delete SharePoint list column programmatically with PowerShell:  #Get the Web $web = Get-SPWeb "http://sharepoint.crescent.com/sites/pmo" #Get the List $list = $web.Lists["Design Documents"] #Get the column $column = $list.Fields["Category"] #Disable Delete $column.AllowDeletion = $true $column.Sealed = $false $column.Update() #To delete a SharePoint list column in PowerShell, use: $column.Delete() $web.Dispose()  We can also make fields to Sealed, So that nobody can change the field settings. SharePoint Manager tool   can be used to set these properties. Just navigate to the site, list
Read More
Delete Button Missing in SharePoint Column? Here is How to Delete Delete Button Missing in SharePoint Column? Here is How to Delete Reviewed by Salaudeen Rajack on January 25, 2015 Rating: 5

Delete a Site Column using PowerShell in SharePoint

January 21, 2015    , , , , , ,
Requirement: Delete site column with PowerShell in SharePoint How to Delete a Site Column in SharePoint? Site columns in SharePoint can be deleted when we don't need them anymore. When you delete a site column, any lists and libraries with the particular site column doesn't get affected. Those site column becomes standard list field. To remove a site column in SharePoint, Navigate to: Site Actions >> Site Settings Click on "Site Columns" under Web Designer Galleries section In Site columns page, Click on the Title of the site column to pick target site column Scroll down and click on "Delete" button. Confirm the prompt. Now, lets remove a site column using PowerShell! Delete a Site Column using PowerShell in SharePoint To delete site column using PowerShell in SharePoint, use this script: Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue #Variables $RootWebURL ="http://intranet.crescent.com" #Internal
Read More
Delete a Site Column using PowerShell in SharePoint Delete a Site Column using PowerShell in SharePoint Reviewed by Salaudeen Rajack on January 21, 2015 Rating: 5

Create Site Column in SharePoint using PowerShell

January 21, 2015    , , , ,
The PowerShell way of adding site column is extremely helpful when you have to add site columns in bulk. Say for e.g. You may have certain site columns created in your DEV environment and would like to have them in Staging or in PROD environment. Will you be creating them one by one with SharePoint UI? No! That would be hectic. Here I'm sharing my PowerShell scripts to create site columns in SharePoint. Add site column to SharePoint with PowerShell Here is a simple example of creating site column in SharePoint 2013 with PowerShell: #Get the Root Web $RootWeb = Get-SPWeb "http://intranet.crescent.com" #Create a text Field site column $RootWeb.Fields.Add("ProjectCode","Text",$false) $SalaryField = $RootWeb.Fields.Add("Crescent-Salary", "Currency", $false) Create site columns using PowerShell - Lets create in Bulk! Now, lets add site columns in bulk. Just enter your column names to the array: $SiteColumnsToAdd and run th
Read More
Create Site Column in SharePoint using PowerShell Create Site Column in SharePoint using PowerShell Reviewed by Salaudeen Rajack on January 21, 2015 Rating: 5

Copy Permissions from One User to Another in SharePoint using PowerShell

January 20, 2015    , , , , , ,
Permission management in SharePoint is always a complex task especially on large environments. Granting permissions in SharePoint becomes cumbersome when you are in a situation to clone an existing user's access rights. Consider this scenario: You have an existing user in a department granted access to various SharePoint web applications, sites, lists, files, etc. and when a new user joins to this department, You-SharePoint Administrator get the requirement of adding new user to all of the places with same access rights as the existing team member! How will you compare access rights of an existing team member and grant access in bulk? He may be granted permission on various levels with different access rights. It would become very time-consuming to find and grant same level of permissions to multiple users on multiple SharePoint objects. Existing user may be grated access as part of: Farm Administrator group and/or as part of web application policies Member of Site collectio
Read More
Copy Permissions from One User to Another in SharePoint using PowerShell Copy Permissions from One User to Another in SharePoint using PowerShell Reviewed by Salaudeen Rajack on January 20, 2015 Rating: 5

SharePoint 2013: PowerShell to Create a Folder in Document Library

January 20, 2015    , , , , ,
How to add folder in SharePoint Document Library using PowerShell: To create folder in document library in SharePoint 2013, use this PowerShell script: $folder = $list.Folders.Add("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, "New") $folder.Update() The above codes doesn't provide much fault tolerance, isn't it? What if the particular library we are looking for doesn't exists? What if the folder we are trying to add already exists on the library? Error! So lets re-write the code in PowerShell with little fault tolerance! How to Create Folders and Sub-Folders in SharePoint List using PowerShell? Here is the PowerShell code snippet for creating Folders and Sub-Folders inside SharePoint List or Library: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Get the Web $web=Get-SPWeb "http://sharepoint.company.com" #Get the List/Library $list=$web.Lists.TryGetList("SalesList") if($list)
Read More
SharePoint 2013: PowerShell to Create a Folder in Document Library SharePoint 2013: PowerShell to Create a Folder in Document Library Reviewed by Salaudeen Rajack on January 20, 2015 Rating: 5

The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items

January 19, 2015    , , ,
Problem: End-user wants to copy paste bunch of rows from Excel to SharePoint using Datasheet view. Datasheet view doesn't allow user to paste the data for Person or Group type column! it gives the error message: The Text entered for the "Person or Group column" isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items. Root cause: This is by design! SharePoint 2010 datasheet view uses Microsoft access run time engine, which doesn't has any interface to connect and resolve user names from active directory (or any other authentication provider). So, it fetches user names from User information list of SharePoint site collection. That being said: If you enter a new user who is not there in UIL, datasheet view can't resolve it! Workaround: In order to fix this problem, prior copy-pasting to datasheet view, we should have them all in user information list! So, Just add all users from people picker column valu
Read More
The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items Reviewed by Salaudeen Rajack on January 19, 2015 Rating: 5

Disable Throttling on SharePoint List using PowerShell

January 16, 2015    , , , ,
Throttling feature helps to avoid performance hits in SharePoint. We set throttling limits for entire web application. Its not possible to set throttling limits on specific SharePoint list or library. But we can disable/enable throttling on SharePoint lists. PowerShell to disable list throttling: Use the below script to disable list throttling in SharePoint 2010 using PowerShell Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variables for Site URL and List Name $WebURL = "http://sales.crescent.com" $ListName = "Proposal Documents" #Get the Site and List objects $web = Get-SPWeb $WebURL $List = $Web.Lists[$ListName] #Disable throttling on the list $list.EnableThrottling = $false $List.Update() Related post: Configure Resource Throttling in SharePoint 2013 using PowerShell
Read More
Disable Throttling on SharePoint List using PowerShell Disable Throttling on SharePoint List using PowerShell Reviewed by Salaudeen Rajack on January 16, 2015 Rating: 5

Run PowerShell Script as Administrator (Elevated Privileges) by Default

January 15, 2015    ,
Its a common SharePoint Administrator's pitfall - Forget to run PowerShell script using "Run as Administrator" option, failing so could lead to many *weird* issues while running PowerShell scripts in SharePoint, such as: "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.". Solution: Solution is pretty simple! just right click the SharePoint 2013 PowerShell Snap-in and choose the option "Run as Administrator". Enable "Run as Administrator" elevated privilege for SharePoint 2013 Management Shell by default: To run PowerShell script as administrator automatically, Create a shortcut to your PowerShell console on your desktop Right-click the "SharePoint 2013 Management Shell" shortcut and click Properties Click "Advanced" button under Shortcut tab Enable "Run as Administrator" and click on "OK" button. Now you can run PowerShell in elevated mode by simply d
Read More
Run PowerShell Script as Administrator (Elevated Privileges) by Default Run PowerShell Script as Administrator (Elevated Privileges) by Default Reviewed by Salaudeen Rajack on January 15, 2015 Rating: 5

Create New Custom List in SharePoint using PowerShell

January 12, 2015    , , , , ,
Requirement: Add custom list to SharePoint using PowerShell. PowerShell to Create New List in SharePoint: To create a new list or library in a SharePoint Online site, you must have the "Manage Lists" permission! The default permission levels Edit, Design, Manage Hierarchy, and Full Control contains this permission. So in order to create lists or libraries, you need to have at least one of these permission level. Here is the PowerShell script to create new list in SharePoint. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Function to create custom list Function Create-List($SiteURL, $ListName) { #Set the Error Action $ErrorActionPreference = "Stop" Try { $Web = Get-SPWeb -Identity $SiteURL $ListTemplate = [Microsoft.SharePoint.SPListTemplateType]::GenericList #Check if List with specific name exists if($Web.Lists.TryGetList($ListName) -eq $null) { $List = $W
Read More
Create New Custom List in SharePoint using PowerShell Create New Custom List in SharePoint using PowerShell Reviewed by Salaudeen Rajack on January 12, 2015 Rating: 5

SharePoint 2013 Patch (Service Pack-CU-Hotfix) Installation Guide - Step by Step

January 10, 2015    , , , , , ,
So you want to maintain your SharePoint environment healthy, secure, stable and up to date by installing latest patches? Well, this article walks through the various steps involved in installing patches for your SharePoint 2013 environment. SharePoint 2013 patching best practices Before proceeding , Lets consider some of the best practices for SharePoint 2013 patching. I would strongly recommend patching your development/test SharePoint farms first before proceeding with the production environment. Make sure Dev/Test environments are thoroughly tested, all custom/third-party components are fully functional. Watch those environments, Identify and address common issues and then schedule the maintenance window for your SharePoint 2013 production farm. Always, Its a good idea to stay one CU behind the current release (or 3 to 6 Moths behind latest patch) for production environments to avoid any potential issues that may be introduced by a new CU. Simply installing the latest upd
Read More
SharePoint 2013 Patch (Service Pack-CU-Hotfix) Installation Guide - Step by Step SharePoint 2013 Patch (Service Pack-CU-Hotfix) Installation Guide - Step by Step Reviewed by Salaudeen Rajack on January 10, 2015 Rating: 5

Sync SharePoint List Data from a CSV File using PowerShell

January 05, 2015    , ,
Requirement: We've a SharePoint list with number of fields to capture organization wide people Expertise. This list has a particular field called "Team" and is to be updated from a CSV file of 100+ rows. Yes, Datasheet view can help, but the problem is: The Team field value to be updated on items matching "AccountName" field of the SharePoint list and CSV file. Solution: Lets write a PowerShell script to select the matching row from the CSV file to SharePoint list and then update it. PowerShell Script to sync SharePoint List data from CSV File: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Read the CSV file $CSVData = Import-CSV -path "C:\Expertdata.csv" #Get the Web $web = Get-SPWeb -identity "http://portal.crescent.com" #Get the Target List $list = $web.Lists["ExpertProfiles"] $TeamsLookupList = $web.Lists["Teams"] #Iterate through each Row in the CSV foreach ($row in $CSVDat
Read More
Sync SharePoint List Data from a CSV File using PowerShell Sync SharePoint List Data from a CSV File using PowerShell Reviewed by Salaudeen Rajack on January 05, 2015 Rating: 5

SharePoint 2013 Specific User Permission Analysis Report using PowerShell

January 05, 2015    , , , , , ,
Analyzing SharePoint permissions for a particular user is often a common task in SharePoint administration. Generally, How do we check what permissions a user has on SharePoint content? By getting into site or list settings page and check permissions for the particular user, isn't it? Well, You may want to analyze the particular user's permissions for your entire SharePoint environment.  How about that? Each and every SharePoint site, list, library, folder and list items may have unique permissions. It can even go more challenging when you have multiple SharePoint farms. Well, PowerShell is the life saver! Here is my permission reporting solution to scan and provide a report to view a user's permission on the SharePoint web application. With this script, you can analyze and track the security effectively! Check what permissions on an account has been granted in all places in SharePoint. This PowerShell script scans below areas to retrieve a specific user's access r
Read More
SharePoint 2013 Specific User Permission Analysis Report using PowerShell SharePoint 2013 Specific User Permission Analysis Report using PowerShell Reviewed by Salaudeen Rajack on January 05, 2015 Rating: 5

SharePoint Online: Activate Feature using PowerShell

January 03, 2015    , , , , ,
Requirement: Activate a feature in SharePoint online site collection using PowerShell. Solution: In SharePoint On-Premises, We use: Enable-SPFeature cmdlet to activate/enable features. In SharePoint online there is no such cmdlet available through PowerShell to activate feature. But we can utilize Client Side Object Model (CSOM) to activate feature in SharePoint online. Lets activate "SharePoint Server Publishing Infrastructure" feature. Here is an example for SharePoint Online PowerShell to activate a site collection feature: Make sure you have SharePoint online Client SDK installed on your client machine to use this code. You can download it from: https://www.microsoft.com/en-us/download/details.aspx?id=42038 SharePoint Online: PowerShell Script to Enable Feature Activating a feature makes the functionality associated with the feature available. It could bring new functionality or new artifacts like lists and libraries, etc. Here is how to activate a site feature
Read More
SharePoint Online: Activate Feature using PowerShell SharePoint Online: Activate Feature using PowerShell Reviewed by Salaudeen Rajack on January 03, 2015 Rating: 5

How to Hide Column Headers in SharePoint List View Web Parts using CSS, jQuery?

January 02, 2015    , , , , ,
I was looking for some ways to hide SharePoint list view column headers today. Here are my findings: You can use CSS to hide column headers Use JavaScript/JQuery to Hide column headers You can edit the page in SharePoint designer and remove column headers Hide Column Headers of All List View using CSS in SharePoint 2010-2013-2016: Insert a CEWP just below your list view web part and place this code in it. <style type="text/css"> tr.ms-viewheadertr { display: none } </style> This will hide all list view web part headers. The headers of your web part should now be hidden. The above code hides headers of every web part in the page. Its helpful when the page contains a web part using with boxed style list views. You can also hide specific web part's header using this CSS: #WebPartWPQxxxx .ms-viewheadertr { display: none } Where xxxx is the web part ID. Use IE Toolbar/Firebug to find it. jQuery to find and Hide specific W
Read More
How to Hide Column Headers in SharePoint List View Web Parts using CSS, jQuery? How to Hide Column Headers in SharePoint List View Web Parts using CSS, jQuery? Reviewed by Salaudeen Rajack on January 02, 2015 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.