243 lines
8.6 KiB
PowerShell
243 lines
8.6 KiB
PowerShell
#Get-Module -Name Microsoft.Online.SharePoint.PowerShell -ListAvailable | Select Name,Version
|
|
#Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Force
|
|
Import-Module Microsoft.Online.SharePoint.PowerShell -Force
|
|
|
|
$Cred = Get-Credential
|
|
Connect-SPOService -Url "https://italsortbuttrio-admin.sharepoint.com"
|
|
|
|
# ************** SUB PROJ ****************
|
|
$webURL = "https://italsortbuttrio.sharepoint.com/sites/Commesse2025"
|
|
|
|
#Setup credentials to connect
|
|
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
#Get Web information and subsites
|
|
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($webURL)
|
|
$Context.Credentials = $Credentials
|
|
$Web = $context.Web
|
|
$Context.Load($web)
|
|
$Context.Load($web.Webs)
|
|
$Context.executeQuery()
|
|
|
|
#Iterate through each subsite in the current web
|
|
foreach ($Subweb in $web.Webs)
|
|
{
|
|
#Get the web object
|
|
#$Subweb
|
|
|
|
$SubwebURL = $Subweb.Url
|
|
$SubwebTitle = $Subweb.Title
|
|
|
|
write-host "Subsite URL: " $Subweb.url
|
|
|
|
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SubwebURL)
|
|
$Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
$LibraryName= "SottoCommesse $SubwebTitle"
|
|
|
|
$Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
$Ctx.Load($Library)
|
|
$Ctx.ExecuteQuery()
|
|
|
|
$viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
$viewFields.Add("DocIcon") > $null
|
|
$viewFields.Add("LinkFilename") > $null
|
|
$viewFields.Add("_ExtendedDescription") > $null
|
|
$viewFields.Add("PAL_Item") > $null
|
|
$viewFields.Add("PAL_ItemCode") > $null
|
|
$viewFields.Add("PAL_ItemDescription") > $null
|
|
$viewFields.Add("PAL_SerialNumber") > $null
|
|
$viewFields.Add("Modified") > $null
|
|
$viewFields.Add("Editor") > $null
|
|
$viewFields.Add("Version") > $null
|
|
$viewFields.Add("PAL_Status") > $null
|
|
|
|
$viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
$viewInfo.Paged = $true
|
|
$viewInfo.SetAsDefaultView = $true
|
|
$viewInfo.ViewFields = $viewFields
|
|
$viewInfo.Title = "$LibraryName View"
|
|
|
|
$newView = $Library.Views.Add($viewInfo)
|
|
|
|
$Ctx.ExecuteQuery()
|
|
|
|
$View = $Library.Views[0]
|
|
$Ctx.Load($View)
|
|
$Ctx.ExecuteQuery()
|
|
|
|
$projNameWithoutDash = $SubwebTitle -replace "-", ""
|
|
|
|
$Ctx.web.RootFolder.WelcomePage = "SottoCommesse%20" + $projNameWithoutDash + "/Forms/SottoCommesse%20" + $projNameWithoutDash + "%20View.aspx"
|
|
$Ctx.web.RootFolder.Update()
|
|
$Ctx.ExecuteQuery()
|
|
}
|
|
|
|
# ************** QUOTATIONS ****************
|
|
# $SiteURL= "https://italsortbuttrio.sharepoint.com/sites/Offerte"
|
|
|
|
# $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
|
|
# $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
# for ($i = 3; $i -le 5; $i++) {
|
|
# $year = "202$i"
|
|
# $LibraryName="Offerte $year"
|
|
|
|
# $Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
# $Ctx.Load($Library)
|
|
# $Ctx.ExecuteQuery()
|
|
|
|
# $viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
# $viewFields.Add("DocIcon") > $null
|
|
# $viewFields.Add("LinkFilename") > $null
|
|
# $viewFields.Add("PAL_Quotation_Reason") > $null
|
|
# $viewFields.Add("PAL_ID_Quotation") > $null
|
|
# $viewFields.Add("PAL_Quotation_Name") > $null
|
|
# $viewFields.Add("PAL_Authors") > $null
|
|
# $viewFields.Add("PAL_Status") > $null
|
|
# # $viewQuery = '<OrderBy><FieldRef Name="LinkFileName" /></OrderBy>
|
|
# # <Where><Contains><FieldRef Name="File_x0020_Series"/><Value Type="Choice">' + $L1Folder + '</Value></Contains></Where>'
|
|
|
|
# $viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
# # $viewInfo.Query = $viewQuery
|
|
# # $viewInfo.RowLimit = 50
|
|
# $viewInfo.Paged = $true
|
|
# $viewInfo.SetAsDefaultView = $true
|
|
# $viewInfo.ViewFields = $viewFields
|
|
# $viewInfo.Title = "$LibraryName View"
|
|
|
|
# $newView = $Library.Views.Add($viewInfo)
|
|
|
|
# $Ctx.ExecuteQuery()
|
|
# }
|
|
|
|
# ************** PURCHASING PO ****************
|
|
# $SiteURL= "https://italsortbuttrio.sharepoint.com/teams/purchasing/OrdinidiAcquisto/"
|
|
|
|
# $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
|
|
# $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
# for ($i = 2; $i -le 5; $i++) {
|
|
# $year = "202$i"
|
|
# $LibraryName="Ordini di Acquisto $year"
|
|
|
|
# $Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
# $Ctx.Load($Library)
|
|
# $Ctx.ExecuteQuery()
|
|
|
|
# $viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
# $viewFields.Add("DocIcon") > $null
|
|
# $viewFields.Add("LinkFilename") > $null
|
|
# $viewFields.Add("PAL_PO_Supplier") > $null
|
|
# $viewFields.Add("PAL_Status") > $null
|
|
|
|
# $viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
|
|
# $viewInfo.Paged = $true
|
|
# $viewInfo.SetAsDefaultView = $true
|
|
# $viewInfo.ViewFields = $viewFields
|
|
# $viewInfo.Title = "$LibraryName View"
|
|
|
|
# $newView = $Library.Views.Add($viewInfo)
|
|
|
|
# $Ctx.ExecuteQuery()
|
|
# }
|
|
|
|
# ************** PURCHASING DDT ****************
|
|
# $SiteURL= "https://italsortbuttrio.sharepoint.com/teams/purchasing/DDTdiAcquisto"
|
|
|
|
# $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
|
|
# $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
# for ($i = 2; $i -le 5; $i++) {
|
|
# $year = "202$i"
|
|
# $LibraryName="DDT di Acquisto $year"
|
|
|
|
# $Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
# $Ctx.Load($Library)
|
|
# $Ctx.ExecuteQuery()
|
|
|
|
# $viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
# $viewFields.Add("DocIcon") > $null
|
|
# $viewFields.Add("LinkFilename") > $null
|
|
# $viewFields.Add("PAL_PO_Supplier") > $null
|
|
# $viewFields.Add("PAL_Status") > $null
|
|
|
|
# $viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
# $viewInfo.Paged = $true
|
|
# $viewInfo.SetAsDefaultView = $true
|
|
# $viewInfo.ViewFields = $viewFields
|
|
# $viewInfo.Title = "$LibraryName View"
|
|
|
|
# $newView = $Library.Views.Add($viewInfo)
|
|
|
|
# $Ctx.ExecuteQuery()
|
|
# }
|
|
|
|
# ************** PURCHASING RDA ****************
|
|
# $SiteURL= "https://italsortbuttrio.sharepoint.com/teams/purchasing/RichiestediAcquisto"
|
|
|
|
# $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
|
|
# $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
# for ($i = 2; $i -le 5; $i++) {
|
|
# $year = "202$i"
|
|
# $LibraryName="Richieste di Acquisto $year"
|
|
|
|
# $Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
# $Ctx.Load($Library)
|
|
# $Ctx.ExecuteQuery()
|
|
|
|
# $viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
# $viewFields.Add("DocIcon") > $null
|
|
# $viewFields.Add("LinkFilename") > $null
|
|
# $viewFields.Add("PAL_PO_Supplier") > $null
|
|
# $viewFields.Add("PAL_Status") > $null
|
|
|
|
# $viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
# $viewInfo.Paged = $true
|
|
# $viewInfo.SetAsDefaultView = $true
|
|
# $viewInfo.ViewFields = $viewFields
|
|
# $viewInfo.Title = "$LibraryName View"
|
|
|
|
# $newView = $Library.Views.Add($viewInfo)
|
|
|
|
# $Ctx.ExecuteQuery()
|
|
# }
|
|
|
|
# ************** NC but NCS****************
|
|
# $SiteURL= "https://italsortbuttrio.sharepoint.com/sites/NonConformità"
|
|
|
|
# $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
|
|
# $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
|
|
|
|
# for ($i = 2; $i -le 5; $i++) {
|
|
# $year = "202$i"
|
|
# $LibraryName="Non Conformità $year"
|
|
|
|
# $Library=$Ctx.web.Lists.GetByTitle($LibraryName)
|
|
# $Ctx.Load($Library)
|
|
# $Ctx.ExecuteQuery()
|
|
|
|
# $viewFields = New-Object System.Collections.Specialized.StringCollection
|
|
# $viewFields.Add("DocIcon") > $null
|
|
# $viewFields.Add("LinkFilename") > $null
|
|
# $viewFields.Add("PAL_NC_Source") > $null
|
|
# $viewFields.Add("PAL_NC_Reference") > $null
|
|
# $viewFields.Add("PAL_NC_Nominative") > $null
|
|
# $viewFields.Add("PAL_NC_DateOfDetection") > $null
|
|
# $viewFields.Add("PAL_NC_Project") > $null
|
|
# $viewFields.Add("PAL_NC_ItemCode") > $null
|
|
# $viewFields.Add("PAL_NC_PortalUrl") > $null
|
|
# $viewFields.Add("PAL_Status") > $null
|
|
|
|
# $viewInfo = New-Object Microsoft.SharePoint.Client.ViewCreationInformation
|
|
# $viewInfo.Paged = $true
|
|
# $viewInfo.SetAsDefaultView = $true
|
|
# $viewInfo.ViewFields = $viewFields
|
|
# $viewInfo.Title = "$LibraryName View"
|
|
|
|
# $newView = $Library.Views.Add($viewInfo)
|
|
|
|
# $Ctx.ExecuteQuery()
|
|
# } |