Copy multiple files to multiple destination based on text file

Question

I want to copy list of files specified in text file to list of destination by creating directory. I have one Excel file in which there are 2 columns, source and destination, each source has a destination.

Example Source:

\\10.0.0.1\share\abd.nsf
\\20.0.0.1\share\red.nsf

Example Dest:

\\10.0.0.2\share\abd\
\\10.0.0.2\share\red\

Currently I am using below code, but involves n number of lines so it is tedious.

copy-item "\\10.0.0.1\share\abd.nsf" -destination (New-item "\\10.0.0.2\share\abd\" -Type container -force) -force
copy-item "\\20.0.0.1\share\red.nsf" -destination (New-item "\\10.0.0.2\share\red\" -Type container -force) -force

Not quite sure what the question is here. Are you looking for logic that moves all nsf files into their own folders? — Matt
– Matt, Commented Dec 29, 2015 at 2:08
i am looking for a logic to take backup of resigned user nsf files to user_name folder — Vino
– Vino, Commented Dec 29, 2015 at 2:35
i can copy list of files to common destination, but i want to copy it in username folders — Vino
– Vino, Commented Dec 29, 2015 at 2:37
How do you determine which folder to copy to? Can you show an example from your source file? is it just "\\10.0.0.1\share\abd.nsf" — Matt
– Matt, Commented Dec 29, 2015 at 2:37
I didn't get your question; i have multiple sources like have specified in example, want to copy files to specific destination; each source file will have specific destination, — Vino
– Vino, Commented Dec 29, 2015 at 2:59

Matt · Accepted Answer · 2015-12-29 03:14:35Z

1

This is a rather simple one. Make your Excel file a 2 column csv where the columns are labelled Source and Destination. You don't have to use those just know that if yours differ that you need to adjust the properties called in the code.

$path = "c:\path\to\file.csv"
$jobs = Import-CSV $path
$jobs | ForEach-Object{
    # Check if the target folder exists. If not create it.
    If(-not (Test-Path -PathType Container $_.destination)){New-item "$_.destination" -Type Container -Force}

    # If the source file exists copy it to the destination directory. 
    If(Test-Path $_.Source){Copy-Item $_.Source $_.Destination -Force}
}

Creates the destination directory if it does not exist (It is possible the path is still wrong but its better than nothing.). Then copy the file, assuming it also exists, to the destination.

answered Dec 29, 2015 at 3:14

Matt

47k9 gold badges90 silver badges125 bronze badges

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

1 Comment

Vino Over a year ago

Thanks @Matt the script is working fine, and this was main requirement

Chand · Accepted Answer · 2015-12-29 03:06:57Z

1

$source = get-content c:\source.txt
$destination = get-content c:\destination.txt
$Count= $source.Count
$i = 0

For($i -eq 0;$i -Lt $count; $i++){
Try{new-item -itemtype directory $destination[$i]}
Catch {}
Finally{copy-item $source[$i] $destination[$i]}
}

Source and destination in text file should be in same order

answered Dec 29, 2015 at 3:06

Chand

3203 silver badges15 bronze badges

Collectives™ on Stack Overflow

Copy multiple files to multiple destination based on text file

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related