August 2022 – PhoeNIXBird Networks

[CSOM] Copy list items from one SPO list to another

August 19, 2022 Andrei Rachita 0

So, here goes:

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

Function Copy-ListItems()
{
    param
    (
        [Parameter(Mandatory=$true)] [string] $SiteURL,
        [Parameter(Mandatory=$true)] [string] $SourceListName,
        [Parameter(Mandatory=$true)] [string] $TargetListName
    )    
    Try {
        #Setup Credentials to connect
        $Cred = Get-Credential
        $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)
    
        #Setup the context
        $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
        $Ctx.Credentials = $Cred

        #Get the Source List and Target Lists
        $SourceList = $Ctx.Web.Lists.GetByTitle($SourceListName)
        $TargetList = $Ctx.Web.Lists.GetByTitle($TargetListName)
    
        #Get All Items from Source List
        $SourceListItems = $SourceList.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())
        $Ctx.Load($SourceListItems)
        $Ctx.ExecuteQuery()
    
        #Get All fields from Source List &amp; Target List
        $SourceListFields = $SourceList.Fields
        $Ctx.Load($SourceListFields)
        $TargetListFields = $TargetList.Fields
        $Ctx.Load($TargetListFields)        
        $Ctx.ExecuteQuery()

        #Get each column value from source list and add them to target
        ForEach($SourceItem in $SourceListItems)
        {
            $NewItem =New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
            $ListItem = $TargetList.AddItem($NewItem)        
 
            #Map each field from source list to target list
            Foreach($SourceField in $SourceListFields)
            {  
                #Skip Read only, hidden fields, content type and attachments
                If((-Not ($SourceField.ReadOnlyField)) -and (-Not ($SourceField.Hidden)) -and ($SourceField.InternalName -ne  "ContentType") -and ($SourceField.InternalName -ne  "Attachments") )  
                {
                    $TargetField = $TargetListFields | where { $_.Internalname -eq $SourceField.Internalname}
                    if($TargetField -ne $null)
                    {
                        #Copy column value from source to target
                        $ListItem[$TargetField.InternalName] = $SourceItem[$SourceField.InternalName]  
                    }
                }
            }
            $ListItem.update()
            $Ctx.ExecuteQuery()
        }

        write-host  -f Green "Total List Items Copied from '$SourceListName' to '$TargetListName' : $($SourceListItems.count)"
    }
    Catch {
        write-host -f Red "Error Copying List Items!" $_.Exception.Message
    }
}

#Set Parameters
$SiteURL= https://tenant.sharepoint.com/sites/DOCTEST1
$SourceListName="TESTLIST2222"
$TargetListName="Test List"

#Call the function to copy list items
Copy-ListItems -siteURL $SiteURL -SourceListName $SourceListName -TargetListName $TargetListName

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

Function Copy-ListItems()

{

param

(

[Parameter(Mandatory=$true)] [string] $SiteURL,

[Parameter(Mandatory=$true)] [string] $SourceListName,

[Parameter(Mandatory=$true)] [string] $TargetListName

)

Try {

#Setup Credentials to connect

$Cred = Get-Credential

$Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)

#Setup the context

$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$Ctx.Credentials = $Cred

#Get the Source List and Target Lists

$SourceList = $Ctx.Web.Lists.GetByTitle($SourceListName)

$TargetList = $Ctx.Web.Lists.GetByTitle($TargetListName)

#Get All Items from Source List

$SourceListItems = $SourceList.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())

$Ctx.Load($SourceListItems)

$Ctx.ExecuteQuery()

#Get All fields from Source List & Target List

$SourceListFields = $SourceList.Fields

$Ctx.Load($SourceListFields)

$TargetListFields = $TargetList.Fields

$Ctx.Load($TargetListFields)

$Ctx.ExecuteQuery()

#Get each column value from source list and add them to target

ForEach($SourceItem in $SourceListItems)

{

$NewItem =New-Object Microsoft.SharePoint.Client.ListItemCreationInformation

$ListItem = $TargetList.AddItem($NewItem)

#Map each field from source list to target list

Foreach($SourceField in $SourceListFields)

{

#Skip Read only, hidden fields, content type and attachments

If((-Not ($SourceField.ReadOnlyField)) -and (-Not ($SourceField.Hidden)) -and ($SourceField.InternalName -ne "ContentType") -and ($SourceField.InternalName -ne "Attachments") )

{

$TargetField = $TargetListFields | where { $_.Internalname -eq $SourceField.Internalname}

if($TargetField -ne $null)

{

#Copy column value from source to target

$ListItem[$TargetField.InternalName] = $SourceItem[$SourceField.InternalName]

}

$ListItem.update()

$Ctx.ExecuteQuery()

}

write-host -f Green "Total List Items Copied from '$SourceListName' to '$TargetListName' : $($SourceListItems.count)"

}

Catch {

write-host -f Red "Error Copying List Items!" $_.Exception.Message

}

#Set Parameters

$SiteURL= https://tenant.sharepoint.com/sites/DOCTEST1

$SourceListName="TESTLIST2222"

$TargetListName="Test List"

#Call the function to copy list items

Copy-ListItems -siteURL $SiteURL -SourceListName $SourceListName -TargetListName $TargetListName

Enjoy!

[CSOM] Create a specified number of list items using CSOM

August 18, 2022 Andrei Rachita 0

So the idea is to create a large number of list items (definable) using CSOM. So… here goes:

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

#Config Parameters
$SiteURL=https://tenant.sharepoint.com/sites/DOCTEST1
$ListName="Test List"
$ItemsToCreate="2000"

Try {
    $Cred= Get-Credential
    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

   #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
    $Ctx.Credentials = $Credentials
        
    #Get the List
    $List = $Ctx.Web.Lists.GetByTitle($ListName)
    $Ctx.Load($List)
    $Ctx.ExecuteQuery()

    #add an item to list SharePoint Online PowerShell - with Random Data
    For($i=1; $i -le $ItemsToCreate; $i++)
    {
        #create list item in sharepoint online using powershell
        $ListItemInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
        $ListItem = $List.AddItem($ListItemInfo)
        $ListItem["Title"] = $I
        $ListItem.Update()
        $Ctx.ExecuteQuery()

        Write-host "New Item $I Added to the List!" -ForegroundColor Green  
    }
}
Catch {
    write-host -f Red "Error Adding Items to List!" $_.Exception.Message
}

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

#Config Parameters

$SiteURL=https://tenant.sharepoint.com/sites/DOCTEST1

$ListName="Test List"

$ItemsToCreate="2000"

Try {

$Cred= Get-Credential

$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

#Setup the context

$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$Ctx.Credentials = $Credentials

#Get the List

$List = $Ctx.Web.Lists.GetByTitle($ListName)

$Ctx.Load($List)

$Ctx.ExecuteQuery()

#add an item to list SharePoint Online PowerShell - with Random Data

For($i=1; $i -le $ItemsToCreate; $i++)

{

#create list item in sharepoint online using powershell

$ListItemInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation

$ListItem = $List.AddItem($ListItemInfo)

$ListItem["Title"] = $I

$ListItem.Update()

$Ctx.ExecuteQuery()

Write-host "New Item $I Added to the List!" -ForegroundColor Green

}

Catch {

write-host -f Red "Error Adding Items to List!" $_.Exception.Message

}

Enjoy!

[NETWORKING] SSL CERTIFICATE CHECKER

August 11, 2022 Andrei Rachita 0

Tool that checks for the SSL certificate info + SANs for specific hosts. Application’s switches: optional arguments: -H [HOSTS [HOSTS …]], –host [HOSTS [HOSTS […]

[MS Graph/SPO PowerShell] Pre-Provision OneDrive sites

August 3, 2022 Andrei Rachita 0

Since the Get-MSOLUser cmdet is going to be deprecated, (see: https://practical365.com/azure-ad-license-management-extension/), the pre-provisioning script for ODB sites (https://docs.microsoft.com/en-us/onedrive/pre-provision-accounts) will need to be re-written for Microsoft […]