How to automatically move a file to another PC on the network

batch filefile-transferscheduled-tasks

Here is what I am after.

I have 2 PCs connected on a network and one of them prints out an Excel spreadsheet every night to a specific folder. Is it possible to use a batch script to copy that file to the other computer on the network at a certain time?

Best Answer

You can.

Create Batch File (Use UNC paths to copy - I recommend RoboCopy)
Create Scheduled Task to call batch file at certain time

robocopy C:\FolderName\ \\machinename\sharedfolder "filename.ext"

Related Solutions

Batch file: Change names on files with certain extensions in multiple directories based on the directory name and copy into one directory

Ok, here's one. You might want to consider using something more flexible than a batch file; a simple C++ program would have been much easier. Batch does not play nice with the string manipulation necessary to extract the directory name.

@ECHO OFF

SETLOCAL EnableDelayedExpansion

SET _destination=%~1
SHIFT

SET _source=%~1
SHIFT

SET _cmdstring=dir /b /s

:LoopGetExt
    SET _cmdstring=%_cmdstring% "%_source%\*%~1"
    SHIFT
    IF NOT "%~1"=="" GOTO LoopGetExt
::End LoopGetExt

FOR /F "tokens=*" %%i IN ('%_cmdstring%') DO (
        SET _fullpath=%%i
        SET _splitpath=!_fullpath:\=^

!
        SET _filename=%%~ni%%~xi
        FOR /F "tokens=*" %%j IN ("!_splitpath!") DO (
            IF NOT "%%j"=="!_filename!" SET _dirname=%%j
        )

        ECHO "%%i" =^> "%_destination%\!_dirname!_!_filename!"
        COPY "%%i" "%_destination%\!_dirname!_!_filename!"
)

ENDLOCAL

At the moment nothing has been hardcoded: to use it, do this.

copyfiles.bat <destination> <source> <ext> [ext]

e.g.

copyfiles.bat "C:\Dest" "C:\Source" .txt .xml .csv .log

EDIT (as per request in first comment)

::copyfiles.bat <destination> <source> <ext> [ext]
::e.g.
::copyfiles.bat "C:\Dest" "C:\Source" .txt .xml .csv .log

@ECHO OFF

SETLOCAL EnableDelayedExpansion

SET _destination=%~1
SHIFT

SET _source=%~1
SHIFT

SET _cmdstring=dir /b /s

:LoopGetExt
    SET _cmdstring=%_cmdstring% "%_source%\*%~1"
    SHIFT
    IF NOT "%~1"=="" GOTO LoopGetExt
::End LoopGetExt

FOR /F "tokens=*" %%i IN ('%_cmdstring%') DO (
        SET _fullpath=%%i
        SET _splitpath=!_fullpath:\=^

!
        SET _filename=%%~ni
        FOR /F "tokens=1 delims=. " %%j IN ("!_splitpath!") DO (
            IF NOT "%%j"=="!_filename!" SET _dirname=%%j
        )

        ECHO "%%i" =^> "%_destination%\!_dirname!%%~xi"
        COPY "%%i" "%_destination%\!_dirname!%%~xi"
)

ENDLOCAL

Windows – How to copy recent folder/files from a network drive using a batch file

%DATE% will give you the format MM/DD/YYYY instead of the required MM-DD-YYYY

Try this instead to get dashes instead of slashes:

UK/Europe:  /D:%DATE:~3,2%-%DATE:~0,2%-%DATE:~6,4%
USA:        /D:%DATE:~4,2%-%DATE:~7,2%-%DATE:~10,4%

As a side note, if your using Windows 7 have a look at using the 'Robocopy' /MINAGE /MAXAGE command instead, as it is usually far more reliable than xcopy, and provides a lot more options.

Best Answer

Related Solutions

Batch file: Change names on files with certain extensions in multiple directories based on the directory name and copy into one directory

Windows – How to copy recent folder/files from a network drive using a batch file

Related Question