Chrono Deployment script

Hi,

Before deployment of Chrono, below is the required configuration in the site

1/ Check if Chrono config list exists, if not, create it with columns ChronoFieldColumnName and ChronoIncrementValue

2/ Check if target list exists, if not, report error and stop execution

3/ Add the chrono field in target list

4/ populate Chrono config list with details from the target list i.e. add Target list GUID under Title Column, text ‘Chrono’ under ChronoFieldColumnName

5/ Update New form if list, edit form if document library

6/ if doc lib, set sets settings to enforce display of edit form after doc creation

if list make the field mandatory

7/ Add the content editor web part to the list->newform.aspx,editform.aspx, document library->editform.aspx

8/Assign  the txt link to the content editor link

// SetChronoField.bat

@ECHO OFF

PowerShell -NoProfile -ExecutionPolicy Bypass -Command "& 'C:\DeploymentScript\SetChronoFieldScript.ps1'"

PAUSE

// SetChronoFieldInputs.xml

<?xml version="1.0" encoding="utf-8"?> 

<Inputs> 

  <ConnectSPConfigOnline SiteURL="siteurl" UserName=”username" Password="password"></ConnectSPConfigOnline> 

  <ConnectSPOnline SiteURL=" siteurl " UserName=" username " Password="password "></ConnectSPOnline>   

  <ConfigList Title="MC2ChronoConfigList" URL="MC2ChronoConfigList" Template="GenericList" ChronoFieldColumnName="ChronoFieldColumnName"/>

<ConfigListFields>

   <ConfigListField Title="ChronoFieldColumnName" InternalName="ChronoFieldColumnName" Group="ListGroup" Type="Text"/>     

   <ConfigListField Title="ChronoIncrementValue" InternalName="ChronoIncrementValue" Group="ListGroup" Type="Number"/>     

</ConfigListFields> 

<Lists>

   <List Title="QoD RC Align Feedback CIO" URL="Lists/QoD%20RC%20Align%20Feedback%20CIO" Template="GenericList" ContentType="Item" ListFieldTitle="Chrono" ListFieldInternalName="Chrono" ListFieldGroup="ListGroup" ListFieldType="Number"/>    

<List Title="QoD RC Align Feedback CIO" URL="Lists/QoD%20RC%20Align%20Feedback%20CIO" Template="DocumentLibrary" ContentType="Item" ListFieldTitle="Chrono" ListFieldInternalName="Chrono" ListFieldGroup="ListGroup" ListFieldType="Number"/>    

</Lists>   

<AddWebParts>

 <AddWebPart Title="ChronoFieldWebPart" RelativePageUrl="/sites/programmequalitedelivery/client/Lists/QoD%20RC%20Align%20Feedback%20CIO/NewForm.aspx" WebPartPath="C:\JB\DeploymentScript\ChronoDeploymentScript\ChronoFieldWebPart.webpart" ContentLink="/sites/programmequalitedelivery/Style%20Library/js/PreSaveAction.txt"/>

 <AddWebPart Title="ChronoFieldWebPart" RelativePageUrl="/sites/programmequalitedelivery/client/Lists/QoD%20RC%20Align%20Feedback%20CIO/EditForm.aspx" WebPartPath="C:\JB\DeploymentScript\ChronoDeploymentScript\ChronoFieldWebPart.webpart" ContentLink="/sites/programmequalitedelivery/Style%20Library/js/PreSaveAction.txt"/> 

 </AddWebParts>

</Inputs>

// SetChronoFieldScript.ps1

############################################################## Logging #########################################

  

$date= Get-Date -format MMddyyyyHHmmss 

start-transcript -path .\Log_$date.doc  

################################################### Get input parameters from XML ###############################  

$outItems = New-Object System.Collections.Generic.List[System.Object]

# Get content from XML file 

[xml]$xmlData=Get-Content ".\SetChronoFieldInputs.xml" 

# ConnectSPOnline node 

[System.Xml.XmlElement]$connectSPOnline = $xmlData.Inputs.ConnectSPOnline 

$siteURL=$connectSPOnline.SiteURL 

$userName=$connectSPOnline.UserName 

$password=$connectSPOnline.Password 

# ConnectSPConfigOnline node 

[System.Xml.XmlElement]$connectSPConfigOnline = $xmlData.Inputs.ConnectSPConfigOnline 

$siteConfigURL=$connectSPConfigOnline.SiteURL 

$userNameConfig=$connectSPConfigOnline.UserName 

$passwordConfig=$connectSPConfigOnline.Password 

#Get Config list details

[System.Xml.XmlElement]$configList = $xmlData.Inputs.ConfigList 

$configListTitle=$ConfigList.Title

$configListUrl=$ConfigList.URL

$configListTemplate=$ConfigList.Template

$configListChronoFieldColumnName=$ConfigList.ChronoFieldColumnName

# Target Lists node 

[System.Xml.XmlElement]$lists = $xmlData.Inputs.Lists

# Target List Fields node 

[System.Xml.XmlElement]$listfields = $xmlData.Inputs.ListFields

# Target Config List Fields node 

[System.Xml.XmlElement]$Configlistfields = $xmlData.Inputs.ConfigListFields

# Web Parts node 

[System.Xml.XmlElement]$webparts = $xmlData.Inputs.AddWebParts

########################################################## Get Credentials ######################################

function GetCredentials() 

{  

    try

                {

                write-host -ForegroundColor Green "Get Credentials and connect to SP Online site: " $siteURL 

    # Convert password to secure string   

    $secureStringPwd = ConvertTo-SecureString -AsPlainText $Password -Force 

    # Get the credentials 

    $credentials = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $userName,$secureStringPwd  

    # Connect to SP online site 

    Connect-PnPOnline –Url $siteURL –Credentials $credentials                   

                }

                catch{

                write-host $_.Exception.Message;

                 }

               

}

function GetConfigCredentials()

{

    try

                {

   write-host -ForegroundColor Green "Get Credentials and connect to SP Online site for COnfig: " $siteConfigURL 

    # Convert password to secure string   

    $secureConfigStringPwd = ConvertTo-SecureString -AsPlainText $passwordConfig -Force 

    # Get the credentials 

    $credentialsConfig = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $userNameConfig,$secureConfigStringPwd  

    # Connect to SP online site 

    Connect-PnPOnline –Url $siteConfigURL –Credentials $credentialsConfig 

   }

                catch{

                write-host $_.Exception.Message;

                 }  

}

#######################################################  Create Configuration List#############################

function CreateConfigList() 

{ 

                try

                {

                                write-host -ForegroundColor Green "Creating Config List"   

                                $getConfigList=Get-PnPList -Identity $configListUrl

        # Check if list exists 

        if($getConfigList) 

        { 

           write-host -ForegroundColor Magenta $listURL " - Config List already exists"                                                                                                                                   

                                }

        else 

        { 

           # Create new list           

                                   write-host -ForegroundColor Magenta "Creating Config list: " $configListUrl          

                                   New-PnPList -Title $configListTitle -Url $configListUrl -Template $configListTemplate       

                                   

        } 

                }  

                catch

                {

                write-host $_.Exception.Message;

                }

     

}

#################################################################Create Configuration List Fields#####################################

function CreateConfigListFields() 

{ 

    try

                {

                                write-host -ForegroundColor Green "Creating Config List Fields" 

                                # Loop through List Fields XML node 

                                foreach($Configlistfield in $Configlistfields.ConfigListField)

                                {

                   

                                                # Get List Field node parameters                                              

                                                $ConfiglistfieldTitle=$Configlistfield.Title

                                                $Configlistfieldinternalname=$Configlistfield.InternalName

                                                $Configlistfieldgroup=$Configlistfield.Group      

                                                $Configlistfieldtype=$Configlistfield.Type

                                               

                                                $getConfigListFields=Get-PnPField -List $configListUrl

                                                foreach($field in $getConfigListFields)

                                                {

                                                if($field.InternalName -eq $Configlistfieldinternalname)

                                                {

                                                                $tag=$tag+1;

                                                }

                                                }

                                                if($tag)

                                                {

                                                                write-host -ForegroundColor Magenta $ConfiglistfieldTitle "-List Field Already exists"

                                                }

                                                else

                                                {

                                                               

                                                                Add-PnPField -List $configListTitle -DisplayName $ConfiglistfieldTitle -InternalName $Configlistfieldinternalname -Type $Configlistfieldtype -Group $Configlistfieldgroup -AddToDefaultView

                                                }                             

                               

                               

                                }

                }

                catch

                {

                write-host $_.Exception.Message;

                }

   

}

function HideConfiglist()

{

                try

                {

                                [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client")

                                [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.Runtime")

                                write-host -ForegroundColor Green "Get Credentials and connect to SP Online Root site: " $siteConfigURL 

                                # Convert password to secure string   

                                $secureStringConfigPwd = ConvertTo-SecureString -AsPlainText $passwordConfig -Force

                                #Setup Credentials to connect

                                $credentialsConfig = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userNameConfig,$secureStringConfigPwd)

                                #Set up the context

                                $context = New-Object Microsoft.SharePoint.Client.ClientContext($siteConfigURL)

                                $context.Credentials = $credentialsConfig

                                #Get the List

                                $list = $context.Web.Lists.GetByTitle($configListTitle)

                                $list.Hidden = $true

                                $list.Update()

                                $context.ExecuteQuery()

                                Write-Host "List Hidden Successfully!"

                }

                catch

                {

                write-host $_.Exception.Message;

                }

}

#################################################################################################################

#################################################################Create Target List#####################################  

function CreateTargetLists() 

{

                try

                { 

                                write-host -ForegroundColor Green "Creating Target Lists"  

                 

                                # Loop through List XML node 

                                foreach($list in $lists.List) 

                                { 

                                                # Get List node parameters 

                                                $listTitle=$list.Title 

                                                $listURL=$list.URL 

                                                $listTemplate=$list.Template 

                                                $listItemTemplate=$list.ContentType

                                                $listFieldTitle=$list.ListFieldTitle

                                                $listFieldInternalName=$list.ListFieldInternalName

                                                $listFieldGroup=$list.ListFieldGroup

                                               

                                                # Get the list object 

                                                $getList=Get-PnPList -Identity $listURL

                                                $getListFields=Get-PnPField -List $listTitle                                            

                                               

                                                # Check if list exists 

                                                if($getList) 

                                                { 

                                                   write-host -ForegroundColor Magenta $listURL " - List already exists"                                                                                      

                                                   $listGUID=Get-PnPList -Identity $listURL                                               

                                                   

                                                   $outItems.Add($listGUID.Id.ToString()+";"+$listFieldTitle)                                                            

                                                   $outItems.ToArray()                                     

                                                   if($listTemplate -eq "DocumentLibrary")

                                                   {

                                                                                write-host $listTitle "is a document library"                                                         

                                                                                $doclb=Set-PnPList -Identity $listURL -EnableContentTypes $true

                                                   }

                                                } 

                                                else 

                                                { 

                                                   # Create new list 

                                                   write-host -ForegroundColor Magenta "Target list is not available: " $listURL

                                                   exit                       

                                                }

                                                foreach($field in $getListFields)

                                                {                                             

                                                if($field.InternalName -eq $listFieldInternalName)

                                                {

                                                                $tag=$tag+1;

                                                }                                             

                                                }

                                                if($tag)

                                                {

                                                                write-host -ForegroundColor Magenta $listFieldTitle "-List Field Already exists"

                                                }

                                                else

                                                {

                                                                $fielditem=Add-PnPField -List $listTitle -DisplayName $listFieldTitle -InternalName $listFieldInternalName -Type Number -Group $listfieldgroup -AddToDefaultView -Required                                         

                                                }

                                               

                                }

                }             

                catch

                {

                write-host $_.Exception.Message;

                }

}

function AddListGUIDsToConfigLIst() 

{

                try

                {

                                $listItems = Get-PnPListItem -List $configListUrl -Fields "Title"

                                $listItemsCount=$listItems.Count                           

                                if($listItemsCount -eq 0)

                                {                             

                                foreach($outItem in $outItems)

                                {

                                $semicolonpos=$outItem.IndexOf(";")  

                                $listGUIDvalue=$outItem.Substring(0, $semicolonpos)

                                $chronoFieldValue=$outItem.Substring($semicolonpos+1)                          

                                $newItem = Add-PnPListItem -List $configListTitle                            

                                $itmfield=Set-PnPListItem -List $configListTitle -Identity $newItem -Values @{"Title" = "{"+$listGUIDvalue+"}"; $configListChronoFieldColumnName = $chronoFieldValue}                                          

                                }

                                }

                                else

                                {                             

                                foreach($listItem in $listItems)

                                {

                                                               

                                                                Write-Host "------------------------------------" 

                                                                foreach($outItem in $outItems)

                                                                {

                                                                                $semicolonpos=$outItem.IndexOf(";")  

                                                                                $listGUIDvalue=$outItem.Substring(0, $semicolonpos)

                                                                                $chronoFieldValue=$outItem.Substring($semicolonpos+1)

                                                                               

                                                                                if($listItemTitle="{"+$listGUIDvalue+"}")

                                                                                {

                                                                                                write-host -ForegroundColor Magenta $listItemTitle "Already Exists"

                                                                                }

                                                                                else

                                                                                {

                                                                                                $newItem = Add-PnPListItem -List $configListTitle                                                                                            

                                                                                                $itmfield=Set-PnPListItem -List $configListTitle -Identity $newItem -Values @{"Title" = "{"+$listGUIDvalue+"}"; $configListChronoFieldColumnName = $chronoFieldValue}                                    

                                                                                }

                                                                }

                                }

                                }

                }

                catch

                {

                write-host $_.Exception.Message;

                }

}

#################################################################################################################

#################################################################Add the Web Parts #####################################

function AddWebPart()

{

                try

                {

                                write-host -ForegroundColor Green "Adding Web Parts"                 

                               

                                # Loop through Web Parts XML node 

                                foreach($webpart in $webparts.AddWebPart) 

                                {

                                                $webPartRelativePageUrl=$webpart.RelativePageUrl

                                                $webPartPath=$webpart.WebPartPath

                                                $webPartTitle=$webpart.Title

                                                $webPartContentLink=$webpart.ContentLink

                                                $getwebpart=Get-PnPWebPart -ServerRelativePageUrl $webPartRelativePageUrl -Identity $webPartTitle                                                   

                                                if($getwebpart)

                                                {

                                                write-host -ForegroundColor Magenta $webPartTitle "-Web Part Already exists"

                                                $webpart = Get-PnPWebPart -ServerRelativePageUrl $webPartRelativePageUrl -Identity $webPartTitle                   

                                                $webpartId=$webpart.Id                            

                                                Set-PnPWebPartProperty -ServerRelativePageUrl $webPartRelativePageUrl -Identity $webpartId -Key ContentLink -Value $webPartContentLink                          

                                                write-host -ForegroundColor Magenta $webPartTitle "-Web Part ContentLink has been updated"

                                                }

                                                else

                                                {

                                                Add-PnPWebPartToWebPartPage -ServerRelativePageUrl $webPartRelativePageUrl -Path $webPartPath -ZoneId "Header" -ZoneIndex 1