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 "ADFT0020: 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("#") ) { $exc = ([System.Data.DataException]::new()) if ($_.type -eq "" -or $null -eq $_.type) { Write-Error -Message "ADFT0021: Config file, row $i : Value in column 'Type' is empty." -Exception $exc } if ($_.type -notin $ADF_FOLDERS) { Write-Error -Message "ADFT0022: Config file, row $i : Type ($($_.type)) is not supported." -Exception $exc } if ($_.name -eq "" -or $null -eq $_.name) { Write-Error -Message "ADFT0023: Config file, row $i : Value in column 'Name' is empty." -Exception $exc } if ($_.path -eq "" -or $null -eq $_.path) { Write-Error -Message "ADFT0024: Config file, row $i : Value in column 'Path' is empty." -Exception $exc } 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 -Message "ADFT0025: Config file, row $i has too many columns." -Exception $exc } } $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" } |