copy file over to new folder

mallarc · 2020-05-12T12:43:26.000Z

Hi,

I got a csv file that has the following information

IMAGE_NAME,Voucher
00067050.pdf,112222
00067052.pdf,33232
00067054.pdf,EXCEPTION
00067056.pdf,224344
00067058.pdf,33344
00067060.pdf,5454
00067062.pdf,EXCEPTION
00067065.pdf,55555
00067068.pdf,45454
00067070.pdf,EXCEPTION
00067074.pdf,54445
00067076.pdf,EXCEPTION
00067080.pdf,77776
00067092.pdf,756767
00067094.pdf,EXCEPTION
00067095.pdf,7567566
00067097.pdf,EXCEPTION

The IMAGE_NAME corresponds to a file that exists in the folder. I want to copy the files to a subfolder (Upload) if the ‘Voucher’ Column has number inside and not the word ‘EXCEPTION’

Neally · 2020-05-12T13:42:57.000Z

Cool, what have you tried? Were are you stuck? We’re happy to help, but why don’t you give it a shot yourself first and then post the code you have tried if you get stuck

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

mallarc · 2020-05-12T14:32:46.000Z

I do apologise!. Thought I had posted. Here is the code that I got so far:

#get files that have a voucher
# Determine script location for PowerShell
$SourceCSV = Split-Path $script:MyInvocation.MyCommand.Path
$FolderToUse = "$SourceCSV\ENDFILES"

 #Here is the PowerShell script for moving the files in required folder:
$text = Import-Csv “$SourceCSV\InputFile.csv” 
 foreach($item in $text ){
#where IMAGE_NAME is the name of the column in the csv file and Voucher the name of #second column in the input csv file
 if($item.IMAGE_NAME – eq $Folder.Name){
 $sourcefile = "$SourceCSV" + $item.Voucher 
  # Copy over the one csv to a location given by the client
 copy-Item -Path $sourcefile -Destination $FolderToUse -Force
 
Write-Host“Folder $item.Voucher moved sucessfully to $target”-ForegroundColor Green
 }

qexle · 2020-05-12T14:34:19.000Z

Hey @alexw , I have a question related to this.

Im trying to loop through each line in a CSV file using foreach loop and if statement, but I have some problems.

Here is one of the things I have tried:

$Csv = Import-Csv path\file.csv | Select-Object IMAGE_NAME, Voucher

foreach ($Line in $Csv) {

if ($_.Voucher -eq 'EXCEPTION') {

Write-Host "Exception"

} else {

Write-Host "No exception"

}
}

<#
Got this result:

No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception
No exception

Then I tried this:
if ($Csv.Voucher -eq 'EXCEPTION')

And got this result:

Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
Exception
#>

Tried this too, but I dont know how to edit it to get the result I want:

$path = "d:\scratch\export.csv"
$csv = Import-Csv -path $path

foreach($line in $csv)
{ 
    $properties = $line | Get-Member -MemberType Properties
    for($i=0; $i -lt $properties.Count;$i++)
    {
        $column = $properties[$i]
        $columnvalue = $line | Select -ExpandProperty $column.Name

        # doSomething $column.Name $columnvalue 
        # doSomething $i $columnvalue 
    }
} 

# https://stackoverflow.com/questions/11885246/how-do-i-loop-through-a-line-from-a-csv-file-in-powershell

Neally · 2020-05-12T14:34:41.000Z

So, what’s not working or where are you stuck with it?

Neally · 2020-05-12T14:39:00.000Z

Why don’t you start your own threat for that so we don’t mix and match?

@qexle

qexle · 2020-05-12T14:43:10.000Z

No problem, I wasnt trying to hijack I just figured if one of us got it working both issues would be solved.

Neally · 2020-05-12T14:50:14.000Z

before troubleshooting, looks like there are a few syntax issues in your script

#get files that have a voucher
# Determine script location for PowerShell
$SourceCSV = Split-Path $script:MyInvocation.MyCommand.Path
$FolderToUse = "$SourceCSV\ENDFILES"

#Here is the PowerShell script for moving the files in required folder:
$text = Import-Csv “$SourceCSV\InputFile.csv” 
foreach ($item in $text ) {
    #where IMAGE_NAME is the name of the column in the csv file and Voucher the name of #second column in the input csv file
    if ($item.'IMAGE_NAME' -eq $Folder.Name) {
        $sourcefile = "$SourceCSV" + $item.Voucher 
        # Copy over the one csv to a location given by the client
        copy-Item -Path $sourcefile -Destination $FolderToUse -Force
 
        Write-Host “Folder $item.Voucher moved sucessfully to $target”-ForegroundColor Green
    }
}

Neally · 2020-05-12T14:52:35.000Z

Why do you select it after importing the CSV
You are mixin FOREACH and FOREACH-OBJECT
See how it has $_ → that’s for foreach $object
But you should be using $line.voucher


$csv = import-csv "test.csv"

foreach($line in $CSV){

    if($line.voucher -eq 'EXCEPTION'){

        write-output 'EXCEPTION'

    }

    else{

        Write-Output 'NO EXCEPTION'

    }

}

@qexle

Neally · 2020-05-12T15:07:20.000Z

mallarc:

The IMAGE_NAME corresponds to a file that exists in the folder. I want to copy the files to a subfolder (Upload) if the ‘Voucher’ Column has number inside and not the word ‘EXCEPTION’

You can do it 2 ways, see if it is NOT ’ EXCEPTION’ OR of it is a number. I’d check if is a number.

clear
$csv = import-csv "test.csv"

foreach($line in $CSV){
    if($line.voucher -match "\d+"){
        $line.voucher
        # code for other stuff, copy and such
    }
}

qexle · 2020-05-12T15:29:03.000Z

Thank you, that solved my problem.

mallarc · 2020-05-12T17:43:33.000Z

Thanks for the help Neally,

My problem is solved. I did a bit of modification to it and the final code is below:

#get files that have a voucher
# Determine script location for PowerShell
$SourceCSV = Split-Path $script:MyInvocation.MyCommand.Path
$FolderToUse = "$SourceCSV\ENDFILES"

#Here is the PowerShell script for moving the files in required folder:
$csv = Import-Csv "$SourceCSV\InputFile.csv" 
foreach ($item in $csv) {
    #where IMAGE_NAME is the name of the column in the csv file and Voucher the name of #second column in the input csv file
    if ( Test-Path "$FolderToUse" ) {
        # Exists then do
      }
      else {
        # Does Not Exist so create folder in archive directory
        New-Item -ItemType Directory -Path "$FolderToUse"
      }
    if ($item.voucher -match "\d+") {
        $FileToCopy=$item.IMAGE_NAME
        $sourcefile = "$SourceCSV\$FileToCopy"
        # Copy over the one csv to a location given by the client
        copy-Item -Path $sourcefile -Destination $FolderToUse -Force
 
        Write-Host "Folder $item.IMAGE_NAME COPIED sucessfully to $FolderToUse"-ForegroundColor Green
    }
}