Scenario: SharePoint automation scripts related to list items.
Code:
#Load SharePoint Snap In Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
function xApproveAll-SPItems { param ($Url, $ListName) $web = Get-SPWeb $Url $list = $web.Lists.TryGetList($ListName) $folders = $list.Folders foreach ($folder in $folders) { $folder["_ModerationStatus"] = 0 $folder.Update() } $items = $list.Items foreach ($item in $items) { Write-Host "Approving : " + $intIndex $item["_ModerationStatus"] = 0 $item.Update() } $web.Dispose() Write-Host "Approved all the documents successfully" -foregroundcolor Green } function xDeleteAll-SPItems { param ($Url, $ListName) $web = Get-SPWeb $Url $list = $web.Lists.TryGetList($ListName) $itemCount = $list.ItemCount for($intIndex = $itemCount; $intIndex -gt 0; $intIndex--) { Write-Host "Deleting : " + $intIndex $list.Items[$intIndex-1].Delete(); } $web.Dispose() }
$url=Read-Host "Enter site url" $listName=Read-Host "Enter list library name" xApproveAll-SPItems $url $listName xDeleteAll-SPItems $url $listName
0 comments:
Post a Comment