powershellcsv

Powershell System.Array to CSV file


I am having some difficulty getting an Export-Csv to work. I am creating an array like this...

[pscustomobject] @{
    Servername = $_.Servername
    Name = $_.Servername
    Blk = ""
    Blk2 = ""
    Method = "RDP"
    Port = "3389"
}

The issue I have is when I try to export that to a CSV I get garbage that looks like this...

"9e210fe47d09416682b841769c78b8a3",,,,,

I have read a ton of articles addressing this issue, but I just don't understand how to get the data right.


Solution

  • For testing, I built a CSV file w/ the servernames, and read it in, and the following works in PS4:

    $serverList = import-csv "datafile.csv"
    
    $AllObjects = @()
    
    $serverList | ForEach-Object {
        $AllObjects += [pscustomobject]@{
            Servername = $_.Servername
            Name = $_.Servername
            Blk = ""
            Blk2 = ""
            Method = "RDP"
            Port = "3389"
        }
    }
    
    $AllObjects | Export-Csv -Path "outfile.csv" -NoTypeInformation