private/Read-CsvConfigFile.ps1
|
function Read-CsvConfigFile { [CmdletBinding()] param ( [Parameter(Mandatory)] [string] $Path ) Write-Debug "BEGIN: Read-CsvConfigFile(path=$path)" $configFileName = $Path Write-Debug "Testing config file..." Test-Path -Path $configFileName -PathType Leaf | Out-Null $configtxt = Get-Content $configFileName | Out-String # Validation Write-Verbose "Validating config file structure..." $proc_header = "type","name","path","value","empty" $csv = ConvertFrom-Csv $configtxt -Header $proc_header if ($csv[0].type + $csv[0].name + $csv[0].path + $csv[0].value + $csv[0].empty + ";" -ne "typenamepathvalue;") { Write-Error -Message "ASWT0020: The header of config file is wrong. The header must have only 4 columns named: type, name, path, value." -Category "InvalidData" } if ($csv.Count -eq 1) { Write-Warning "Config file is empty." } $i = 0 $csv | ForEach-Object { if ($i -gt 0 -and !$_.type.StartsWith("#") ) { if ($_.type -eq "" -or $null -eq $_.type) { Write-Error -Exception ([System.Data.DataException]::new("ASWT0021: Config file, row $i : Value in column 'Type' is empty.")) } if ($_.type -notin $SYNAPSE_FOLDERS) { Write-Error -Exception ([System.Data.DataException]::new("ASWT0022: Config file, row $i : Type ($($_.type)) is not supported.")) } if ($_.name -eq "" -or $null -eq $_.name) { Write-Error -Exception ([System.Data.DataException]::new("ASWT0023: Config file, row $i : Value in column 'Name' is empty.")) } if ($_.path -eq "" -or $null -eq $_.path) { Write-Error -Exception ([System.Data.DataException]::new("ASWT0024: Config file, row $i : Value in column 'Path' is empty.")) } if ($_.value -eq "" -or $null -eq $_.value) { if (!$_.path.StartsWith('-')) { Write-Warning -Message "Config file, row $i : Value in column 'Value' is empty." } } if ($null -ne $_.empty) { Write-Error -Exception ([System.Data.DataException]::new("ASWT0025: Config file, row $i has too many columns.")) } } $i++ } Write-Host "Validation of config file completed." # Final reading $csv = ConvertFrom-Csv $configtxt # Expanding string (replace Environment Variables with values) $csv | ForEach-Object { $_.value = $ExecutionContext.InvokeCommand.ExpandString($_.value); } return $csv Write-Debug "END: Read-CsvConfigFile" } |