For column order you can
refer this post as well
function SetColumnOrder([Microsoft.SharePoint.SPContentType]$contentType)
{
#Write-Host
$contentType.name
[Microsoft.SharePoint.SPFieldLinkCollection]$flinks = $contentType.FieldLinks;
#array object
$fieldsArray = New-Object 'System.Collections.Generic.List[string]';
#Read all the InternalNames of the
FieldLinks into a list
foreach($fieldLink in $flinks){
$fieldsArray.Add($contentType.Fields[$fieldLink.ID].InternalName);
}
$fieldchkboxInternalName =$contentType.Fields["SAC
DOC"].InternalName
# Write-Host $fieldchkboxInternalName
$fieldDDLInternalName =$contentType.Fields["ddlTest"].InternalName
if($fieldsArray.Contains($fieldchkboxInternalName)){
$indexChkbox = $fieldsArray.IndexOf($fieldchkboxInternalName)
#Write-Host "checkbox index:"
$indexChkbox
$indexDDL = $fieldsArray.IndexOf($fieldDDLInternalName)
#Write-Host "ddlindex:" $indexDDL
#Write-Host "fieldsArraycount"
$fieldsArray.Count
if($indexChkbox -ne $indexDDL )
{
$fieldsArray.RemoveAt($indexDDL)
if($indexChkbox -le $fieldsArray.Count -1){
$fieldsArray.Insert($indexChkbox,$fieldDDLInternalName)
Write-Host "SAC ddl
index:" $fieldsArray.IndexOf($fieldDDLInternalName)
$msg = ("{0},{1}" -f "SAC ddl
index order :", $fieldsArray.IndexOf($fieldDDLInternalName))
$msg | out-file -FilePath $logfile -append
}
#else{
# $fieldsArray.Add($fieldDDLInternalName);
#}
}
#Add the array to the reorder
$flinks.Reorder($fieldsArray.ToArray());
#Update the ContentYpe
$contentType.Update($true)
}
}
$URL = "http://spdev5:8002/sites/library"
$site = New-Object Microsoft.SharePoint.SPSite($URL)
$web = $site.openweb("")
#logging
$timestamp = get-date -format "yyyyMMdd_hhmmtt"
$filenameStart = "SAC_AddField2ContentTypes"
$logfile = ("{0}{1}.csv" -f $filenamestart, $timestamp)
$header = "S.No,Message"
$header | out-file -FilePath $logfile
$fieldName = "ddlTest"
$field = $web.Fields[$fieldName]
#$ct =
$web.ContentTypes[$contentTypeName]
Write-Host "Fieldname:" $field
$index=40
$ContentTypes = $web.ContentTypes
try{
foreach ($ContentType in $ContentTypes)
{
$contentTypeGroup = $ContentType.Group
$contentTypeName = $ContentType.Name
if ( $contentTypeGroup -like '*DMID*')
{
#if($ContentType.Fields["SAC
DOC"] -ne $null)
#{
#
write-host $ContentType.Name #$MyField.Id
#$MyField=$ContentType.Fields["SAC
DOC"]
#$ContentType.FieldLinks[$MyField.Id].Required=$true
# }
#if($ContentType.Name
-eq "Laboratory Normal
Ranges")
if($ContentType.Name -eq "CI" -or $ContentType.Name -eq "Lab" )
{
if($ContentType.Fields["ddlTest"] -eq $null)
{
$link = new-object Microsoft.SharePoint.SPFieldLink $field
$ContentType.FieldLinks.Add($link)
$ContentType.Update($true)
write-host "'SAC Doc'
dropdownlist added to: " $ContentType.Name
$msg = ("{0},{1}" -f "'SAC Doc'
dropdownlist added to:", $ContentType.Name)
$msg | out-file -FilePath $logfile -append
SetColumnOrder $ContentType
#break;
}
else
{
write-host "'SAC Doc' dropdownlist already
added to: " $ContentType.Name -BackgroundColor Red
$msg = ("{0},{1}" -f "'SAC Doc'
dropdownlist already added to:", $ContentType.Name)
$msg | out-file -FilePath $logfile -append
}
}
}
}
}
catch [System.Management.Automation.ExtendedTypeSystemException]
{
Write-Host $_.Exception.ToString()
$msg = ( "{0},{1}" -f "Error
occurred while reading list..:", $_)
$msg | out-file -FilePath $logfile -append
}
$web.Dispose()
$site.Dispose()
Hi Surya,
ReplyDeleteThanks for sharing info.
Re-Order the sharepoint site content type columns using powershell script:
http://sharepointquicksolutions.blogspot.in/2014/12/reoreder-sp-content-types-columns.html
Regards,
Sasi Kumar Reddy
http://sharepointquicksolutions.blogspot.in/