• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2424
  • Last Modified:

ROBOCOPY TO SEARCH IN SUBFOLDERS

Hi,
I have a code that copies only .xls files from one location to another without actually copying the folders. I need this to be modified so that The source looks for all the subfolders under it for .xls files and not only look just the root folder.
eg: if I have C:/Source/AllFiles/excel1.xls and C:Source/excel2.xls then if I give C:/Source as my source then it must copy both excel1 and excel 2 files and not just excel1.

Please assist.
Thanks
0
zubairvp123
Asked:
zubairvp123
  • 9
  • 6
1 Solution
 
sirbountyCommented:
Use /s parameter...

robocopy c:\source d:\destination *.xls /s
0
 
zubairvp123Author Commented:
/s parameters include subfolders but do not search in subfolders. I dont want any folders copied but only files in the subfolders.
0
 
sirbountyCommented:
Oops - sorry about that.

Try this from a command prompt:

cd source
for /r %a in (*.xls) do robocopy %~dpsa c:\destination *.xls

should accomplish what you want...if you want it in a batch file,
repeat the above two lines, but double up on the % signs...
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
zubairvp123Author Commented:
Oh My God!!! This looks for all the files in my C drive. I guess my question is not clear.
If I have a directory C:/Source/Source1/Source2/*.xls
then In my batch file if I specify my source as C:/Source then it must look for C/Source and further down till it gets a .xls file. It shouldnt look in my entire C: but The source+ subfolders.
I'm sure you know the answer...it's just the way I put the question. Sorry about that.
0
 
sirbountyCommented:
No, I understood.
That's why it's necessary to use the
 cd source
command first.

This starts you out in the source folder.  It'll then scan through each subfolder and copy *.xls to your destination folder.
Obviously if you have the same file name in seperate folders, the results will be different...
0
 
zubairvp123Author Commented:
Thanks, can I ask...
what does %~dpsa  do?
0
 
sirbountyCommented:
the for loop is looking in all subfolders for the specification you asked for, *.xls
This loop returns the full path and file name...all we need is the folder name, since that's what robocopy's gonna want.
So, I used that 'filter' to strip off the file name.  It takes c:\source\file.xls and only returns the (d)rive and (p)ath and shows it in its (s)hort format (LongFo~1 instead of Long Folder Name - so we don't have to contend with spaces).
0
 
zubairvp123Author Commented:
Wow!!! You are a genious!!! Thanks a bunch! Looks like it's working now. Let me do a few days of test on it so that I know whether it's tracking the modified and new files.
For now all the points to you.
0
 
sirbountyCommented:
Happy to have helped. :^)
0
 
zubairvp123Author Commented:
Sirbounty,
I'd tested with files in my C:/ but my actual operations are to be performed on files on the network (Shared LAN).
When I put the path Z:/ it by default takes files on my desktop.

I thought that robocopy could copy files from the lan aswell.
Please correct me if I'm wrong.
0
 
sirbountyCommented:
Sure it will...that could be considered it's primary purpose.

Show me what you're running...
0
 
zubairvp123Author Commented:
@echo off
set source1=I:\DTF\00 DTF Daily Report Drop Box\Daily Activity Report
set source2=C:\Source
set dest=C:\dest1
set n=7
cd "%source1%"
for /r %%a in (*DDR*.xls) do robocopy %%~dpsa %dest% *DDR*.xls /copy:DAT /MAXAGE:%n% /M /log+log.txt

cd "%source2%"
for /r %%a in (*DDR*.xls) do robocopy %%~dpsa %dest% *DDR*.xls /copy:DAT /MAXAGE:%n% /M >>log.txt

Sirbounty, It takes the files from source2 but not source1.
Also it would be great if you could show me how to have log.txt files that get generated showing which all files were successfully copied and which files were skipped.
0
 
zubairvp123Author Commented:
I just realized that /log+log.txt
 is invalid. Even if I delete it no files are picked up from this source1.
0
 
zubairvp123Author Commented:
Someone...please help! It must be a small tweek required somewhere which I'm not aware of....
Please....
0
 
zubairvp123Author Commented:
Any updates? Please...
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 9
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now