PowerShell Export-CSV to Multiple Paths

Question

I'm trying to export the contents of folders in a directory to a CSV. The issue I'm running into is that I can't figure out how to get the export to 2 different paths.

Simply adding another Export-Csv just adds a empty Csv to the 2nd path.

Get-ChildItem -Path *root_path* -Filter *.zip -Recurse | 
Select-Object BaseName, CreationTime |

Export-Csv -Path "*path1*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv"

Export-Csv -Path *path2*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv

Answer 1

It's because econd export is not part of the pipeline. You could store the results first and then export them.

$dat = Get-ChildItem -Path *root_path* -Filter *.zip -Recurse | Select-Object BaseName, CreationTime 
'*path1*','*path2*' | foreach {Export-Csv -InputObject $dat -Path "$_$((Get-Date).ToString('yyyy-MM-dd HHmmss')).csv"}

Answer 2

You could try Tee-Object.

One-liner:

Get-ChildItem -Path *root_path* -Filter *.zip -Recurse | Select-Object BaseName, CreationTime |ConvertTo-Csv -NoTypeInformation | Tee-Object -FilePath "*path1*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv" -Append | Out-File "*path2*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv"

See Example 3 of the Tee-Object docu.

Answer 3

What you are saying is that you want to export the same thing to two different files?

$data = Get-ChildItem -Path *root_path* -Filter *.zip -Recurse 
 
$data | Select-Object BaseName, CreationTime | Export-Csv -Path "*path1*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv"
$data | Select-Object BaseName, CreationTime | Export-Csv -Path "*path2*_$((Get-Date).ToString(' yyyy-MM-dd HHmmss')).csv"