Files:
Deploy.bat
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 Powershell.exe -Command Set-ExecutionPolicy "Bypass" 2 Powershell.exe -Command "& {%~dp0InstallMain_listcolumn.ps1}" 3 Pause
InstallMain.ps1
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 #******************************************************************** 2 # Create Site List Instance 3 # 4 #******************************************************************** 5 6 7 # Log the Power shell window text 8 $0 = $MyInvocation.MyCommand.Definition # Get complete file path of file 9 $dp0 = [System.IO.Path]::GetDirectoryName($0) # Get current Directory file path 10 $bits = Get-Item $dp0 | Split-Path -Parent # Get current Drive (eg: D:\) 11 12 ## check to ensure Microsoft.SharePoint.PowerShell is loaded if not using the SharePoint Management Shell 13 $snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'} 14 if ($snapin -eq $null) 15 { 16 Write-Host "Loading SharePoint Powershell Snapin..." 17 Add-PSSnapin "Microsoft.SharePoint.Powershell" 18 Write-Host "SharePoint Powershell Snapin Loaded" 19 } 20 21 22 #Step0 : Assign values for Variable 23 $scriptFolderPath = $dp0 24 $path = "$scriptFolderPath\" 25 #$configurationFilePath = "$path\CreateListInstance.xml" 26 $configFile = "$path\UpdateListColumn.xml" 27 28 #Step1 : Create Site Collection Application 29 #$command = "& '$scriptFolderPath\CreateListInstance.ps1' -InputFile '$configurationFilePath'" 30 $command = "& '$scriptFolderPath\UpdateListColumn.ps1' -InputFile '$configFile'" 31 32 Invoke-Expression $command
UpdateListColumn.ps1
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 function ChangeListColumn([xml]$solutionsConfig) 2 { 3 ForEach($Web in $solutionsConfig.SiteCollection.Webs.Web) 4 { 5 $webpath=$solutionsConfig.SiteCollection.url+$Web.url 6 Write-Host -foregroundcolor white $webpath 7 $targetWeb=Get-SPWeb $webpath 8 9 $list=$Web.List 10 11 $targetlist=$targetWeb.Lists[$list.name] 12 13 Write-Host -foregroundcolor white $list.name 14 15 $targetfield=$list.property 16 $targetvalue=$list.value 17 18 Write-Host -foregroundcolor white $targetlist.Fields[$targetfield].DefaultValue 19 $field=$targetlist.Fields[$targetfield] 20 $field.DefaultValue=$targetvalue 21 22 Write-Host -foregroundcolor white $targetlist.Fields[$targetfield].DefaultValue 23 $field.update() 24 $targetlist.Update() 25 $targetWeb.Update() 26 write-host -foregroundcolor white '===========================' 27 write-host -foregroundcolor white '' 28 } 29 } 30 31 if([string]::IsNullOrEmpty($configFile)){return} 32 [xml]$solutionsConfig=Get-Content $configFile 33 if($solutionsConfig -eq $null){return} 34 35 Write-Host -foregroundcolor white "Begin update ListColumn." 36 Write-Host "" 37 ChangeListColumn $solutionsConfig 38 Write-Host -foregroundcolor white "End update ListColumn."
Attention:
$field.update()不能少,否则不会修改数据库.同时要结合list使用,否则此method不能调用
UpdateListColumn.xml
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 <?xml version="1.0" encoding="utf-8"?> 2 <SiteCollection url="http://xde7109sp033:9999"> 3 <Webs> 4 <Web name="English" url="/en-us"> 5 <List name="Pages" property="Display Priority" value="Medium"/> 6 </Web> 7 <Web name="News" url="/en-us/News"> 8 <List name="Pages" property="Display Priority" value="Medium"/> 9 </Web> 10 <Web name="Company" url="/en-us/company"> 11 <List name="Pages" property="Display Priority" value="Medium"/> 12 </Web> 13 <Web name="Company" url="/en-us/Misc"> 14 <List name="Pages" property="Display Priority" value="Medium"/> 15 </Web> 16 </Webs> 17 </SiteCollection>