PowerShell——修改list columnDefaultValue属性

Files:

Deploy.bat

Powershell.exe -Command Set-ExecutionPolicy "Bypass"
Powershell.exe -Command "& {%~dp0InstallMain_listcolumn.ps1}"
Pause

InstallMain.ps1

#********************************************************************
#    Create Site List Instance
#      
#********************************************************************


# Log the Power shell window text
$0 = $MyInvocation.MyCommand.Definition                 # Get complete file path of file 
$dp0 = [System.IO.Path]::GetDirectoryName($0)           # Get current Directory file path 
$bits = Get-Item $dp0 | Split-Path -Parent              # Get current Drive   (eg:  D:\)

## check to ensure Microsoft.SharePoint.PowerShell is loaded if not using the SharePoint Management Shell 
$snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'} 
if ($snapin -eq $null)  
{    
    Write-Host "Loading SharePoint Powershell Snapin..."    
    Add-PSSnapin "Microsoft.SharePoint.Powershell" 
    Write-Host "SharePoint Powershell Snapin Loaded"   
} 


#Step0 : Assign values for Variable
$scriptFolderPath = $dp0
$path = "$scriptFolderPath\"
#$configurationFilePath = "$path\CreateListInstance.xml"
$configFile = "$path\UpdateListColumn.xml"

#Step1 : Create Site Collection Application
#$command = "& '$scriptFolderPath\CreateListInstance.ps1' -InputFile '$configurationFilePath'"
$command = "& '$scriptFolderPath\UpdateListColumn.ps1' -InputFile '$configFile'"

Invoke-Expression $command

 UpdateListColumn.ps1

function ChangeListColumn([xml]$solutionsConfig)
{
    ForEach($Web in $solutionsConfig.SiteCollection.Webs.Web)
    {
        $webpath=$solutionsConfig.SiteCollection.url+$Web.url
        Write-Host -foregroundcolor white $webpath
        $targetWeb=Get-SPWeb $webpath

        $list=$Web.List

        $targetlist=$targetWeb.Lists[$list.name]
        
        Write-Host -foregroundcolor white $list.name

        $targetfield=$list.property
        $targetvalue=$list.value

        Write-Host -foregroundcolor white $targetlist.Fields[$targetfield].DefaultValue
        $field=$targetlist.Fields[$targetfield]
        $field.DefaultValue=$targetvalue

        Write-Host -foregroundcolor white $targetlist.Fields[$targetfield].DefaultValue
        $field.update()
        $targetlist.Update()
        $targetWeb.Update()
        write-host -foregroundcolor white '==========================='
        write-host -foregroundcolor white ''
    }
}

if([string]::IsNullOrEmpty($configFile)){return}
[xml]$solutionsConfig=Get-Content $configFile
if($solutionsConfig -eq $null){return}

Write-Host -foregroundcolor white "Begin update ListColumn."
Write-Host ""
ChangeListColumn $solutionsConfig
Write-Host -foregroundcolor white "End update ListColumn."

Attention:

$field.update()不能少，否则不会修改数据库.同时要结合list使用，否则此method不能调用

UpdateListColumn.xml

<?xml version="1.0" encoding="utf-8"?>
<SiteCollection url="http://xde7109sp033:9999">
  <Webs>
    <Web name="English" url="/en-us">
      <List name="Pages" property="Display Priority" value="Medium"/>
    </Web>
    <Web name="News" url="/en-us/News">
      <List name="Pages" property="Display Priority" value="Medium"/>
    </Web>
    <Web name="Company" url="/en-us/company">
      <List name="Pages" property="Display Priority" value="Medium"/>
    </Web>
    <Web name="Company" url="/en-us/Misc">
      <List name="Pages" property="Display Priority" value="Medium"/>
    </Web>
  </Webs>
</SiteCollection>