UpdateConfigurationRecords.ps1
|
# # UpdateConfigurationRecords.ps1 # param( [string]$CrmConnectionString, [string]$EntityName, [string]$LookupFieldName, [string]$ValueFieldName, [string]$ConfigurationRecordsJson ) $ErrorActionPreference = "Stop" Write-Verbose 'Entering UpdateConfigurationRecords.ps1' #Parameters Write-Verbose "EntityName = $EntityName," Write-Verbose "LookupFieldName = $LookupFieldName" Write-Verbose "ValueFieldName = $ValueFieldName" Write-Verbose "ConfigurationRecordsJson = $ConfigurationRecordsJson" #Script Location $scriptPath = split-path -parent $MyInvocation.MyCommand.Definition Write-Verbose "Script Path: $scriptPath" #Load XrmCIFramework $xrmCIToolkit = $scriptPath + "\Xrm.Framework.CI.PowerShell.Cmdlets.dll" Write-Verbose "Importing CIToolkit: $xrmCIToolkit" Import-Module $xrmCIToolkit Write-Verbose "Imported CIToolkit" #load json string into array $array = ConvertFrom-Json $ConfigurationRecordsJson Write-Host ("Processing ({0}) records" -f $array.Count) #iterate through the configuration items and set secure configuration For ($i=0; $i -lt $array.Count; $i++) { $lookup = $array[$i][0] $value = $array[$i][1] Write-Host ("Processing record with lookup: {0} - value: {1}" -f $lookup, $value) $records = Get-XrmEntities -ConnectionString $CrmConnectionString -EntityName $EntityName -Attribute $LookupFieldName -Value $lookup -ConditionOperator 0 if ($records.Count -eq 1) { $record = $records[0] if ($record.Attributes[$ValueFieldName] -ne $value) { $record.Attributes[$ValueFieldName] = $value Set-XrmEntity -ConnectionString $CrmConnectionString -EntityObject $record Write-Host ("Record Update Completed for Id: {0}" -f $record.Id) } else { Write-Host ("Record Update Skipped for Id: {0}" -f $record.Id) } } elseif ($records.Count -eq 0) { $record = New-XrmEntity -EntityName $EntityName $record.Attributes["$LookupFieldName"] = $lookup $record.Attributes["$ValueFieldName"] = $value $recordId = Add-XrmEntity -ConnectionString $CrmConnectionString -EntityObject $record Write-Host ("Record Create Completed for Id: {0}" -f $recordId) } else { Write-Error ("Multiple matches found for {0}" -f $lookup) } } Write-Host "Configuration Records Update Succeeded" Write-Verbose 'Leaving UpdateConfigurationRecords.ps1' |