Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Copy from network drive to local computer using batch

Posted on 2016-09-15
Medium Priority
Last Modified: 2016-09-26
Hello experts,

Is there a batch file I can create which can copy all files from \\\Script\sw to C:\CSV\sw
I also need the same batch file to copy from \\\Script\hw to C:\CSV\hw

Is that possible?
Question by:Siddharth S
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 85

Expert Comment

ID: 41799831
@echo off
for %%a in (sw hw) do (
	robocopy.exe "\\\Script\%%a" "C:\CSV\%%a" /e /r:0 /w:0

Open in new window


Author Comment

by:Siddharth S
ID: 41799847
Wow, that was fast and works! Thanks but I have another thing. I have to copy from different locations onto one folder, can I incorporate it all in one.

Say I have to copy from  \\\Script\sw to  C:\CSV\sw and \\\Script\hw to C:\CSV\hw
LVL 85

Assisted Solution

oBdA earned 1000 total points
ID: 41799873
Sorry, can't quite follow you.
The script above will copy two subfolders from a share into the respective subfolders locally.
Your second comment differs from the first only in the source IP address, if I'm not mistaken.
So do you want to collect the hw and sw folders from both servers into their local equivalents?
In other words:
\\\Script\hw  -\
                           >--> C:\CSV\hw
\\\Script\hw -/

\\\Script\sw  -\
                           >--> C:\CSV\sw
\\\Script\sw -/

Open in new window

If so, what's supposed to happen with duplicate file names?
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 57

Accepted Solution

Bill Prew earned 1000 total points
ID: 41799894
Building on what oBdA proposed, and adding support for both multiple source servers, and multiple folders to copy, you could try the below.  The open question about duplicate handling still needs to be answered, but this should give you a starting point.

@echo off

set ServerList=\\ \\
set FolderList=sw hw
set DestFolder=C:\CSV

for %%a in (%ServerList%) do (
  for %%b in (%FolderList%) do (
    robocopy.exe "%%~a\Script\%%~b" "%DestFolder%\%%~b" /e /r:0 /w:0

Open in new window


Author Comment

by:Siddharth S
ID: 41800964
Thanks Bill, duplicate handling wont be a problem. If two files with the same name exists, then I want them to overwrite.
Let me try this and get back to you.
LVL 85

Expert Comment

ID: 41801038
You might want to add the /xo (eXclude Older) switch to the robocopy command then, to make sure only the latest file is copied.

Author Closing Comment

by:Siddharth S
ID: 41817226
Thanks guys, solved it. Great help as usual.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoHotkey is an excellent, free, open source programming/scripting language for Windows. It started out as a keyboard/mouse macros product, but has expanded into a robust language. This article provides an introduction to it, with links to addition…
How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question