Incoming Email in SharePoint Online

We do have many email enabled document libraries, and we are moving to Office 365 and one of the features that’s missing in SharePoint online is NO email enabled document library. How to get those working once we migrate? There are few workarounds for that. Site Mailbox Site mailbox is available in the ‘Add an… Read More »

PowerShell Scripts SharePoint Online

So now we are moving to Office 365 what will happen to all my PowerShell scripts? The answer varies, SharePoint PnP is coming along but not all commandlets are available. So to get the things going we need to use CSOM in PowerShell, yes right CSOM in PowerShell and it’s not straight conversion there are… Read More »

Get all Metadata Columns

Get all Metadata Columns using PowerShell, this will come handy when you need to know the column details. Add-PsSnapin Microsoft.SharePoint.PowerShell function GetMapping($site, $MMSField, $Field, $ContentTypes) { $taxonomySession = Get-SPTaxonomySession -Site $site $termStore = $taxonomySession.TermStores[“Managed Metadata CTH”] $MMSGroup = $termStore.Groups[“Global Taxonomy”] $termset = $MMSGroup.TermSets[$MMSField.TermSetId] Write-Host “Site Column Name : “$Field.Title Write-Host “MMS Column Name : “$MMSField.Title… Read More »

Get All Site Collections with Titles

Simple and easy way to get all site collections with Title.    Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue    function GenerateAllSitecollectionsInWebapplication ($url) {     write-host “Sitecollection List Extraction started….” -foregroundcolor red     try       {          $Site=Get-SPSite $url                   $spWebApp = $Site.WebApplication          foreach($SC in $spWebApp.Sites)          {            write-host $SC.Url  – $SC.RootWeb.Title               }                              }    catch       {           write-host “Unable to Extract Sitecollection List…”… Read More »

Add users to SharePoint using PowerShell

Add-PSSnapin “Microsoft.Sharepoint.PowerShell” $web = Get-SPWeb “https://Marketing” $userObject = $web.EnsureUser(“ABC\a.b”) $group = $web.SiteGroups[“Site Members”] $group.AddUser($userObject)

Download Attachments using PowerShell – SharePoint 2010/2013

[void][System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) #For MOSS 2007 compatibility Function global:Get-SPWeb($url) { $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb() } return $web } #Site URL and List Name variables $WebURL = “https://SharePoint” $LibraryName = “REPORT” #This can be list or document library, if list has multiple attachements it will download all – Note: This PS will create a… Read More »

SharePoint and Information Rights Management (IRM)

I do get lot questions from my SharePoint friends and colleagues regarding IRM’s in SharePoint. The questions are: 1. What is IRM 2. Why do someone need that 3. Where should we apply it. Actually I do not need to answer point 1, as you can Google/Bing it to get the definition but point 2… Read More »

SharePoint Mobile Application – Thoughts

I ask myself every time I use my mobile (Android or IOS, I know windows phone has this default SharePoint app but not UX friendly) to open SharePoint site and feel why I should have mobile master and device channel settings to have good UX to navigate the site. How an app that just works… Read More »

PowerShell Script to Copy/Replace items from one list to another list

Ok guys, I did work on this script for couple of hours and came up with working solution, basically this script will copy/replace items from one SharePoint List to another SharePoint List. Tip: Save the Source list as templace without Content and create desination list with source template and disable any workflows that are associated… Read More »