kwizcom banner advertisement

Find and Replace User ID in SharePoint InfoPath Forms using PowerShell

March 30, 2017    , , , ,
Requirement: Replace User IDs in InfoPath Forms. Little background: A particular user's User account changed in Active directory and in SharePoint we ran Move-SPUser cmdlet to accommodate the user's SAM account name change. However, There are many InfoPath form libraries with bunch of InfoPath forms in it - with old user id. Of course, Move-SPUser has no effect on InfoPath Forms! PowerShell script to search and replace user id in InfoPath XML Forms: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $SiteCollURL="http://intranet.crescent.com" #Old and New User IDs - CASE SENSITIVE! $OldUserID="<pc:AccountId>i:0#.w|Crescent\JohnA</pc:AccountId>" $NewUserID="<pc:AccountId>i:0#.w|Crescent\JonhAbraham</pc:AccountId>" #Get all webs in the site collection $WebsColl = Get-SPSite $SiteCollURL | Get-SPWeb -Limit All #Iterate through each web foreach($web in $WebsColl) {
Find and Replace User ID in SharePoint InfoPath Forms using PowerShell Find and Replace User ID in SharePoint InfoPath Forms using PowerShell Reviewed by Salaudeen Rajack on March 30, 2017 Rating: 5

Get All List and Libraries Inventory of a SharePoint Site Collection using PowerShell

March 30, 2017    , , , ,
Requirement: Get All Lists and Libraries Inventory of a SharePoint Site Collection PowerShell to Get Site Collection Inventory: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Site collection Variable $SiteURL="http://intranet.crescent.com" $ReportOutput="C:\SiteInventory.csv" #Get the site collection $Site = Get-SPSite $SiteURL $ResultData = @() #Ge All Sites of the Site collection Foreach($web in $Site.AllWebs) { Write-host -f Yellow "Processing Site: "$Web.URL #Get all lists - Exclude Hidden System lists $ListCollection = $web.lists | Where-Object { ($_.hidden -eq $false) -and ($_.IsSiteAssetsLibrary -eq $false)} #Iterate through All lists and Libraries ForEach ($List in $ListCollection) { $ResultData+= New-Object PSObject -Property @{ 'Site Title' = $Web.Title 'Site URL' = $Web.URL 'List-Library Name' = $List.Title
Get All List and Libraries Inventory of a SharePoint Site Collection using PowerShell Get All List and Libraries Inventory of a SharePoint Site Collection using PowerShell Reviewed by Salaudeen Rajack on March 30, 2017 Rating: 5

SharePoint Online: PowerShell to Download All Files from a Document Library

March 29, 2017    , , ,
Requirement: PowerShell to download all files from a SharePoint Online document library.   SharePoint Online: Download All Files from a Library using PowerShell CSOM Why PowerShell? Because, Explorer view didn't work! #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" Function Download-FilesFromLibrary() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $LibraryName, [Parameter(Mandatory=$true)] [string] $TargetFolder ) Try { #Setup Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the
SharePoint Online: PowerShell to Download All Files from a Document Library SharePoint Online: PowerShell to Download All Files from a Document Library Reviewed by Salaudeen Rajack on March 29, 2017 Rating: 5

SharePoint Online: Create a Document Library or List with New Experience UI using PowerShell-CSOM

March 21, 2017    , , , ,
The new list and library experience in SharePoint Online improves the user experience by providing many features such as navigation, fast response, mobile UI, easier to use, etc. You can switch between classic & new experiences anytime. Here is the PowerShell-CSOM script to create a document library in SharePoint online with new experience UI. PowerShell Script to create a document library in new experience UI: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" ##Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/Projects" $UserName="salaudeen@crescent.com" $Password ="Password goes here" #Setup Credentials to connect $Credentials = New-Object Microsoft.SharePoint.Cli
SharePoint Online: Create a Document Library or List with New Experience UI using PowerShell-CSOM SharePoint Online: Create a Document Library or List with New Experience UI using PowerShell-CSOM Reviewed by Salaudeen Rajack on March 21, 2017 Rating: 5

SharePoint Online: Get All List Items with Unique Permissions using PowerShell

March 12, 2017    , , ,
Requirement: Get All SharePoint Online List Items with Unique Permissions using PowerShell How to Check if a list Item is using Unique permissions or inheriting permissions from the parent? To get if a SharePoint Online list Item or File in a document library has unique permissions, follow these steps: Navigate to the list/library and then select the list item. From the details pane, Click on "Manage Access" link (in Classic experience, Click on "Advanced" >> "Shared With") and then click on "Advanced" link. This takes you to the Advanced permissions page of the list item, which gives you the information whether the list item has unique permissions or its inheriting permissions from the parent. E.g. You'll get the text " This list item has unique permissions " SharePoint Online: PowerShell to Get All List Items with Unique Permissions: Lets get all list items with unique permissions using PowerShell. #Load Shar
SharePoint Online: Get All List Items with Unique Permissions using PowerShell SharePoint Online: Get All List Items with Unique Permissions using PowerShell Reviewed by Salaudeen Rajack on March 12, 2017 Rating: 5

Fix "Unfortunately, help seems to be broken...There aren't any help collections in the current language for the site you're using." Error in SharePoint 2016

March 08, 2017    ,
Problem: The Help Menu (?) in SharePoint 2016 is not working! On clicking the Help menu, it gets the error message: "Unfortunately, help seems to be broken... There aren't any help collections in the current language for the site you're using." Troubleshooting Steps:  Enable External Web-based Help in Privacy Options of SharePoint 2016 Central Admin. Navigate to : http://central-admin-url/_admin/privacy.aspx , and Set "Yes" to "Display Help from external web Sites as specified by each Help collection?" Check the help collection status and install if needed: Open SharePoint 2016 Management Shell, Run: Get-SPHelpCollection It gave nothing. Guess help collection is not installed. Now, Install help collection by running: Install-SPHelpCollection -All wait for few minutes to get them installed (10 min!). Try close and reopen the SharePoint 2016 sites! Now, SharePoint 2016 help should work.
Fix "Unfortunately, help seems to be broken...There aren't any help collections in the current language for the site you're using." Error in SharePoint 2016 Fix "Unfortunately, help seems to be broken...There aren't any help collections in the current language for the site you're using." Error in SharePoint 2016 Reviewed by Salaudeen Rajack on March 08, 2017 Rating: 5
Powered by Blogger.