Update Document library column value

Add-PSSnapin Microsoft.Sharepoint.Powershell

cls

$siteurl = "http://testsite.com/"

$web = Get-SPWeb $siteurl

$list = $web.Lists["DivisionDocuments"]

$count = 0

$spQuery = New-Object Microsoft.SharePoint.SPQuery

$spQuery.ViewAttributes = "Scope='Recursive'";

$spQuery.RowLimit = 20000

$caml = "<View></View>"

$spQuery.Query = $caml

do

{

    $listItems = $list.GetItems($spQuery)

    $spQuery.ListItemCollectionPosition = $listItems.ListItemCollectionPosition

    foreach($item in $listItems)

    {

        if(($item["MapId"]  -eq $null ))

          {

             write-host "Name" $item["FileRef"]

             write-host "Doesn't have map id "$item["MapId"]

            #if($item["Contract"] -ne "No")

               #{

                 $item["Contract"] = "0"

                 $item.Update()

                 $item.File.Approve("Approved");

                 $count++;   

               #}    

         }

        else

            {    

              Write-Host "HasMapid "$item["MapId"]

              write-host "Name" $item["FileRef"]

              #if($item["Contract"] -ne "1")

               #{

                 $item["Contract"] = "1"

                 $item.Update()

                 $item.File.Approve("Approved");

                 $count++;

               #}

           }

    }

}

while ($spQuery.ListItemCollectionPosition -ne $null)

write-host "Successfully archived " $count " records"