Export-CSV powershell loop

Question

What is the correct practice on outputting to a CSV file from a loop. My goal is to check the attributes of all files matching a series of extensions that have not been accessed in over a month and output to a csv file for reading later.

it only outputs the information for the first file. and errors the following:

Add-Member : Cannot add a member with the name "FileName" because a member with that name already exists. If you want to overwrite the member a
nyway, use the Force parameter to overwrite it.
At C:\Users\claw\Desktop\checkFileAge.ps1:10 char:25
+             $out2csv | add-member <<<<  -MemberType NoteProperty -Name FileName -Value $i.fullname
    + CategoryInfo          : InvalidOperation: (@{FileName=C:\u...012 9:33:46 AM}:PSObject) [Add-Member], InvalidOperationException
    + FullyQualifiedErrorId : MemberAlreadyExists,Microsoft.PowerShell.Commands.AddMemberCommand

Here is my example:

    $out2csv = New-Object PSObject;

foreach ($i in get-childitem c:\users -recurse -include *.doc, *.xls, *.ppt, *.mdb, *.docx, *.xlsx, *.pptx, *.mdbx, *.jpeg, *.jpg, *.mov, *.avi, *.mp3, *.mp4, *.ogg) 
    {if ($i.lastaccesstime -lt ($(Get-Date).AddMonths(-1))) 
        {
            $out2csv | add-member -MemberType NoteProperty -Name FileName -Value $i.fullname
            $out2csv | add-member -MemberType NoteProperty -Name LastAccess -Value $i.LastAccessTime
        } 
    } $out2csv | Export-Csv "C:\FileAccessInformation.csv" -NoTypeInformation -Force

Keith Hill · Accepted Answer · 2012-09-28 00:03:32Z

2

Try something like this. It is a bit more canonical PowerShell.

$ext = '*.doc', '*.xls',...
Get-ChildItem C:\Users -r -inc $ext | 
    Where {$_.LastAccessTime -lt [DateTime]::Now.AddMonths(-1)} |
    Select FullName, LastAccessTime |
    Export-Csv -NoTypeInformation -Force C:\FileAccessInformation.csv

answered Sep 28, 2012 at 0:03

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JS1986 Over a year ago

is it possible to get the FullName into a variable so that I can then use it with another function?

Keith Hill Over a year ago

You can stick in a Foreach into the pipe after the Where cmdlet e.g. Where ... | Foreach {$fn = $_.FullName; do stuff here with no output; $_} | ... Note that at the end of the foreach, I output the pipeline object so it can be processed further down the pipeline.

Collectives™ on Stack Overflow

Export-CSV powershell loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related