problem with mixing output columns using export-csv

by willbs at 2013-02-22 13:49:09

i am running powershell 3
i am running a test and the results go to a csv file

the output of my first test has 3 columns

"nTest Number tTest Title `tTest Results" | out-file -filepath C:\TestReport.csv -append
then i fill in the columns with the test results

then i run the second test, the output of the second test is this code whis has 2 columns

Get-Process | Select-Object name, fileversion | export-csv -path C:\TestReport.csv -notype -append -force

i get this error

export-csv : Cannot process argument because the value of argument "name" is not valid. Change the value of the "name" argument and run the operation again.
At C:\Users\xxxxx\Documents\PowerShell\PS_Check_Process_Version.ps1:4 char:49
+ Get-Process | Select-Object name, fileversion | export-csv -path C:\TestReport.c …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:slight_smile: [Export-Csv], PSArgumentException
+ FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.ExportCsvCommand

if i switch the test order then the 3 columns are placed in the first column

which ever test is run first always appears correctly, it’s the second test that looks like crap or i get an error

is there a way to clear or reset things so i can append mixed outputs to the same csv file?

thanks in advance
by mjolinor at 2013-02-22 21:48:26
Powershell won’t let you do that, for good reason. Having rows with different numbers of fields and disparate data in the same file essentially renders it "broken" as a .csv file.