Ascotel Contacts to Avaya System Diary

Script.ps1

# For more information visit: https://www.marcogriep.de/posts/telefonbuch-von-ascotel-zu-avaya-telefonanlage-migrieren/
$InputFile = "Input.csv"
$OutputFile = "Export.csv"

class Entry {
    [string]$Name
    [string]$Number
    [string]$SpeedDialCode
}
$entries = @()


$reader = [System.IO.StreamReader]::new($InputFile, [System.Text.Encoding]::UTF8)

$lineCount = 0;
while($reader.Peek() -ge 0) {
    $ln = $reader.ReadLine();

    $lineCount += 1;

    if ($lineCount -lt 10) {
        continue;
    }

    if ($ln.StartsWith('//')) {
        continue;
    }

    if ($ln -like "*;*") {

        $splitted = $ln.Split(';')

        $obj = [Entry]::new()
        $obj.SpeedDialCode = "None" # Überschreiben

        $number = $splitted[1]
        $skipNumberCheck = $false;
        if ($number.StartsWith('00')) {
            $skipNumberCheck = $true;
        }
        elseif ($number.StartsWith('0')) {
            if (-not $skipNumberCheck) {
                $number = "0" + $number;
            }
        }
        else {
            if (-not $skipNumberCheck) {
                $number = "00" + $number;
            }
        }

        $obj.Number = $number

        $name = $splitted[2];

        $sanitizedName = $name.Replace(',', '')

        if ([String]::IsNullOrEmpty($sanitizedName)) {
            continue;
        }
        $obj.Name = $sanitizedName.Trim()

        $entries += $obj;
    }

    continue;
}

Write-Host "Alles ausgelesen".

$entries | Export-Csv -Path $OutputFile -Force -Encoding utf8 -Delimiter ',' -UseQuotes Never

For more Information visit: Avaya contact import