Скрипт замены баз в файле ibases.v8i c использованием excel

$Ini = Get-Content -Path $FileF | Where-Object { $_ -match 'КаталогПрием=' }
[array]$ContentF=""
$ContentF[0] = $Ini.Split('=')[1]
$ContentF_Change = $ContentF.Replace('%username%','CF\%username%\')

function Parse-IniFile ($file)
{
  $ini = @{}
  switch -regex -file $file
  {
    #Section.
    "^\[(.+)\]$"
    {
      $section = $matches[1].Trim()
      $ini[$section] = @{}
      continue
    }
    #Int.
    "^\s*([^#].+?)\s*=\s*(\d+)\s*$"
    {
      $name,$value = $matches[1..2]
      $ini[$section][$name] = [int]$value
      continue
    }
    #Decimal.
    "^\s*([^#].+?)\s*=\s*(\d+\.\d+)\s*$"
    {
      $name,$value = $matches[1..2]
      $ini[$section][$name] = [decimal]$value
      continue
    }
    #Everything else.
    "^\s*([^#].+?)\s*=\s*(.*)"
    {
      $name,$value = $matches[1..2]
      $ini[$section][$name] = $value.Trim()
    }
  }
  $ini
}

#USAGE:
 
$ini = Parse-IniFile ./ibases.v8i 
 
foreach ( $section in $ini.keys ) {
   
  ...
   $ini.$section.Connect
  ...
 
}

$v8i_path = 'C:\Temp\1CEStart'
$csv_list = "C:\Temp\1CEStart\new_1c_bases.csv"
 
$base_list = Import-Csv -Path $csv_list -Delimiter ';' -Encoding Default
 
ForEach ($v8i_file in Get-ChildItem -Path $v8i_path\*.v8i -File)
{
    $config = Get-Content -Path $v8i_file -Encoding UTF8
    
    ForEach ($base in $base_list)
    {
        $Pattern = "^Connect=Srvr=.+;Ref=`"$($base.СтароеНазваниеБазы)`";$"
        $config = $config -replace $Pattern,"Connect=Srvr=`"$($base.НовыйСервер)`";Ref=`"$($base.НовоеНазваниеБазы)`";"
    }
 
    $config | Set-Content -Path $v8i_file -Encoding UTF8
}

$users_path = 'C:\Users'
$csv_list   = '\\server\share\new_1c_bases.csv'
 
$base_list = Import-Csv -Path $csv_list -Delimiter ';' -Encoding Default
 
ForEach ($v8i_file in Get-ChildItem -Path $users_path -Directory | Get-ChildItem -Path {"$($_.FullName)\AppData\Roaming\1C\1CEStart\*.v8i"} -ErrorAction SilentlyContinue -File)
{
    $save   = $false
    $config = Get-Content -Path $v8i_file -Encoding UTF8
    
    ForEach ($base in $base_list)
    {
        $Pattern = "^Connect=Srvr=.+;Ref=`"$($base.СтароеНазваниеБазы)`";$"
 
        if ($config -match $Pattern)
        {
            $config = $config -replace $Pattern,"Connect=Srvr=`"$($base.НовыйСервер)`";Ref=`"$($base.НовоеНазваниеБазы)`";"
            $save = $true
        }
    }
 
    if ($save)
    {
        Copy-Item -Path $v8i_file -Destination "$($v8i_file.FullName).bak"
        $config | Set-Content -Path $v8i_file -Encoding UTF8
    }
}

 if ($save)
    {
        Copy-Item -Path $v8i_file -Destination "$($v8i_file.FullName).bak"
        $config | Set-Content -Path $v8i_file -Encoding UTF8
        ($v8i_file.FullName) | set-content c:\backup\log.txt
    }

ForEach ($v8i_file in Get-ChildItem -Path $users_path -Directory | Get-ChildItem -Path {"$($_.FullName)\AppData\Roaming\1C\1CEStart\*.v8i"} -ErrorAction SilentlyContinue -File)
{
    Copy-Item -Path $v8i_file.FullName -Destination "c:\backup\$(($v8i_file.FullName -split '\\')[2])_$($v8i_file.Name)"
}