How to FTP get only new file from remote server?

[izy]

I would like to get only new file from remote server to local machine. I already do this:

First file: batch.bat
@echo off
echo ---------------------------------------------------------------------------
echo %date% %time% Begin Transfer

FTP -s:GetFiles.ftp server_name

echo %date% %time% Done FTP Transfer
goto end
:end
echo.
echo.

Second file: GetFiles.ftp
username
password
cd acmr/4398/try/out
mget GL_*.txt
y
quit

I want to get only new file start with GL_*.txt from remote server. Every day is a new file on remote server which I have to get to my local machine.
How to set to get only new file not all files?

[foxidrive]

You will need to:

extract a list of the files using the FTP DIR or ls command and put them in a file on your local machine.

Then parse the list of files in a for /f loop and use if not exist "c:\download\%%a" >>file.txt echo %%a
to create a list of the files that you do not have.

Finally, use that list in another for /f loop to create an FTP script using the FTP get command with each of the files.

[izy]

Could you please add code because I don't know how to do it and where to place new code.

[foxidrive]

Not all FTP servers provide the same format of information.

If you give me a filelist from your FTP server then I may be able to work with that.

Also tell me the path to your saved files.

[foxidrive]

Try this in a different folder - it should create filelist.txt with the files listed.
if the filelist.txt file contains your username etc then change it but don't delete the lines.

test.bat

Code: Select all

@echo off
echo ---------------------------------------------------------------------------
echo %date% %time% Begin Transfer

FTP -s:GetFiles.ftp >filelist.txt

echo %date% %time% Done FTP Transfer
echo.
echo.

Second file: GetFiles.ftp

Code: Select all

open server_name
username
password
cd acmr/4398/try/out
dir
quit

[izy]

Local directory:
c:\FTPFMSBatch\Prenos\

File list(every day is generated a new file on remote server):
GL_20120530002303.txt
GL_20120529002220.txt
GL_20120528002121.txt
GL_20120527002027.txt
...

File is created like: GL_YEAR_MONTH_DAY_RANDOMNUMBER.txt

[foxidrive]

Is that the filelist.txt from the FTP server? No headers or date/times or other information?

[izy]

This are files from remote server directory:

GL_20120530002303.txt 30.05.2012 00:35
GL_20120529002220.txt 29.05.2012 00:35
GL_20120528002121.txt 28.05.2012 00:35
GL_20120527002027.txt 27.05.2012 00:35
... more files

[foxidrive]

I asked for the FTP list.

If your information is incomplete then you will get a batch file that is incomplete, or one that may not work at all.

[izy]

ftp> ls GL_*.txt
200 PORT command successful.
150 Opening ASCII mode data connection for file list.
GL_20120410004124.txt
GL_20120415003731.txt
GL_20120416003743.txt
GL_20120417001643.txt
GL_20120418003937.txt
GL_20120419003252.txt
GL_20120420003813.txt
GL_20120421003900.txt
GL_20120422003415.txt
GL_20120423004133.txt
GL_20120424003948.txt
GL_20120425003830.txt
GL_20120426004115.txt
GL_20120427003859.txt
GL_20120428003925.txt
GL_20120429003936.txt
GL_20120430003125.txt
GL_20120501003743.txt
GL_20120503003843.txt
GL_20120504003532.txt
GL_20120505003737.txt
GL_20120506003416.txt
GL_20120507003454.txt
GL_20120508003950.txt
GL_20120509004822.txt
GL_20120510004310.txt
GL_20120511004913.txt
GL_20120511102949.txt
GL_20120512002546.txt
GL_20120513002200.txt
GL_20120514003637.txt
GL_20120515003024.txt
GL_20120516002223.txt
GL_20120517001839.txt
GL_20120518002519.txt
GL_20120519001927.txt
GL_20120520002019.txt
GL_20120521002229.txt
GL_20120522001718.txt
GL_20120523001519.txt
GL_20120524002051.txt
GL_20120525002655.txt
GL_20120526003858.txt
GL_20120527002027.txt
GL_20120528002121.txt
GL_20120529002220.txt
GL_20120530002303.txt
226 Transfer complete.
ftp: 1081 bytes received in 0,08Seconds 13,86Kbytes/sec.
ftp> quit
221
sre 30.05.2012 12:38:56,74 Done FTP Transfer

[foxidrive]

If you have trouble then stop the four files from being deleted and show us the contents.

Code: Select all

faulty code removed

[izy]

Hi,

I try it but no files get on local machine?

thu 31.05.2012 9:14:23,75 Begin Transfer
ftp> open server
Connected to server
220 Microsoft FTP Service
User (server:(none)):
331 Password required for username.

230 User passwordlogged in.
ftp> cd remote dir

250 CWD command successful.
ftp> get GL_20120410004124.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120410004124.txt(36911 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 36911 bytes received in 0,00Seconds 36911000,00Kbytes/sec.
ftp> get GL_20120416003743.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120416003743.txt(3104 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 3104 bytes received in 0,00Seconds 3104000,00Kbytes/sec.
ftp> get GL_20120417001643.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120417001643.txt(6984 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 6984 bytes received in 0,00Seconds 6984,00Kbytes/sec.
ftp> get GL_20120418003937.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120418003937.txt(118728 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 118728 bytes received in 0,01Seconds 23745,60Kbytes/sec.
ftp> get GL_20120419003252.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120419003252.txt(160632 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 160632 bytes received in 0,01Seconds 16063,20Kbytes/sec.
ftp> get GL_20120420003813.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120420003813.txt(166840 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 166840 bytes received in 0,01Seconds 18537,78Kbytes/sec.
ftp> get GL_20120421003900.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120421003900.txt(152096 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 152096 bytes received in 0,01Seconds 19012,00Kbytes/sec.
ftp> get GL_20120422003415.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120422003415.txt(11640 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 11640 bytes received in 0,00Seconds 11640000,00Kbytes/sec.
ftp> get GL_20120423004133.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120423004133.txt(16296 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 16296 bytes received in 0,00Seconds 16296000,00Kbytes/sec.
ftp> get GL_20120424003948.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120424003948.txt(184688 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 184688 bytes received in 0,01Seconds 18468,80Kbytes/sec.
ftp> get GL_20120425003830.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120425003830.txt(172272 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 172272 bytes received in 0,01Seconds 19141,33Kbytes/sec.
ftp> get GL_20120426004115.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120426004115.txt(232800 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 232800 bytes received in 0,03Seconds 8953,85Kbytes/sec.
ftp> get GL_20120427003859.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120427003859.txt(191672 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 191672 bytes received in 0,01Seconds 17424,73Kbytes/sec.
ftp> get GL_20120428003925.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120428003925.txt(206416 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 206416 bytes received in 0,01Seconds 17201,33Kbytes/sec.
ftp> get GL_20120429003936.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120429003936.txt(19400 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 19400 bytes received in 0,00Seconds 19400,00Kbytes/sec.
ftp> get GL_20120430003125.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120430003125.txt(11640 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 11640 bytes received in 0,00Seconds 11640000,00Kbytes/sec.
ftp> get GL_20120501003743.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120501003743.txt(119504 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 119504 bytes received in 0,00Seconds 29876,00Kbytes/sec.
ftp> get GL_20120503003843.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120503003843.txt(239008 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 239008 bytes received in 0,01Seconds 15933,87Kbytes/sec.
ftp> get GL_20120504003532.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120504003532.txt(145888 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 145888 bytes received in 0,01Seconds 18236,00Kbytes/sec.
ftp> get GL_20120505003737.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120505003737.txt(1944656 bytes)

> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 1944656 bytes received in 0,18Seconds 10626,54Kbytes/sec.
ftp> get GL_20120506003416.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120506003416.txt(30264 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 30264 bytes received in 0,00Seconds 30264,00Kbytes/sec.
ftp> get GL_20120507003454.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120507003454.txt(5432 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 5432 bytes received in 0,00Seconds 5432000,00Kbytes/sec.
ftp> get GL_20120508003950.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120508003950.txt(400416 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 400416 bytes received in 0,03Seconds 13807,45Kbytes/sec.
ftp> get GL_20120509004822.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120509004822.txt(203312 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 203312 bytes received in 0,01Seconds 18482,91Kbytes/sec.
ftp> get GL_20120510004310.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120510004310.txt(197104 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 197104 bytes received in 0,01Seconds 16425,33Kbytes/sec.
ftp> get GL_20120511004913.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120511004913.txt(160632 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 160632 bytes received in 0,01Seconds 20079,00Kbytes/sec.
ftp> get GL_20120511102949.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120511102949.txt(17072 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 17072 bytes received in 0,00Seconds 17072000,00Kbytes/sec.
ftp> get GL_20120512002546.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120512002546.txt(136576 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 136576 bytes received in 0,01Seconds 15175,11Kbytes/sec.
ftp> get GL_20120513002200.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120513002200.txt(20952 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 20952 bytes received in 0,00Seconds 20952,00Kbytes/sec.
ftp> get GL_20120514003637.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120514003637.txt(10088 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 10088 bytes received in 0,00Seconds 10088000,00Kbytes/sec.
ftp> get GL_20120515003024.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120515003024.txt(200208 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 200208 bytes received in 0,05Seconds 3850,15Kbytes/sec.
ftp> get GL_20120516002223.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120516002223.txt(152872 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 152872 bytes received in 0,01Seconds 19109,00Kbytes/sec.
ftp> get GL_20120517001839.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120517001839.txt(171496 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 171496 bytes received in 0,01Seconds 19055,11Kbytes/sec.
ftp> get GL_20120518002519.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120518002519.txt(137352 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 137352 bytes received in 0,01Seconds 22892,00Kbytes/sec.
ftp> get GL_20120519001927.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120519001927.txt(152872 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 152872 bytes received in 0,01Seconds 19109,00Kbytes/sec.
ftp> get GL_20120520002019.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120520002019.txt(20176 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 20176 bytes received in 0,00Seconds 20176000,00Kbytes/sec.
ftp> get GL_20120521002229.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120521002229.txt(5432 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 5432 bytes received in 0,00Seconds 5432000,00Kbytes/sec.
ftp> get GL_20120522001718.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120522001718.txt(190896 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 190896 bytes received in 0,01Seconds 17354,18Kbytes/sec.
ftp> get GL_20120523001519.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120523001519.txt(144336 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 144336 bytes received in 0,01Seconds 20619,43Kbytes/sec.
ftp> get GL_20120524002051.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120524002051.txt(128816 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 128816 bytes received in 0,01Seconds 21469,33Kbytes/sec.
ftp> get GL_20120525002655.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120525002655.txt(11640 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 11640 bytes received in 0,00Seconds 11640000,00Kbytes/sec.
ftp> get GL_20120526003858.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120526003858.txt(24832 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 24832 bytes received in 0,00Seconds 24832000,00Kbytes/sec.
ftp> get GL_20120527002027.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120527002027.txt(12416 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 12416 bytes received in 0,00Seconds 12416000,00Kbytes/sec.
ftp> get GL_20120528002121.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120528002121.txt(4656 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 4656 bytes received in 0,00Seconds 4656000,00Kbytes/sec.
ftp> get GL_20120529002220.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120529002220.txt(81480 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 81480 bytes received in 0,00Seconds 40740,00Kbytes/sec.
ftp> get GL_20120530002303.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120530002303.txt(211848 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 211848 bytes received in 0,01Seconds 16296,00Kbytes/sec.
ftp> get GL_20120531002138.txt
200 PORT command successful.
150 Opening ASCII mode data connection for GL_20120531002138.txt(169944 bytes).
> Replace Existing File with Temp File:ICMP port unreachable
226 Transfer complete.
ftp: 169944 bytes received in 0,01Seconds 18882,67Kbytes/sec.
ftp> quit
221
čet 31.05.2012 9:14:34,39 Done FTP Transfer

[foxidrive]

Google is not much help with that error - I am not sure.

Try changing this portion and adding the 'm' to change get to mget

for /f "delims=" %%a in ('type "filelist2.txt"') do (
>>list2.ftp echo mget %%a
)

Let us know how that goes, and if it is still an issue then also post the contents of list2.ftp

[izy]

I change it to mget and now I receive two files:

filelist.txt
filelist2.txt

Still no files in my local directory: c:\FTPFMSBatch\prenos ?

And also quit before all files?

ftp> cd rmca/TR3-001/2110/OTHERS/out
250 CWD command successful.
ftp> mget GL_20120410004124.txt
200 Type set to A.
mget GL_20120410004124.txt? mget GL_20120416003743.txt
ftp> mget GL_20120417001643.txt
200 Type set to A.
mget GL_20120417001643.txt? mget GL_20120418003937.txt
ftp> mget GL_20120419003252.txt
200 Type set to A.
mget GL_20120419003252.txt? mget GL_20120420003813.txt
ftp> mget GL_20120421003900.txt
200 Type set to A.
mget GL_20120421003900.txt? mget GL_20120422003415.txt
ftp> mget GL_20120423004133.txt
200 Type set to A.
mget GL_20120423004133.txt? mget GL_20120424003948.txt
ftp> mget GL_20120425003830.txt
200 Type set to A.
mget GL_20120425003830.txt? mget GL_20120426004115.txt
ftp> mget GL_20120427003859.txt
200 Type set to A.
mget GL_20120427003859.txt? mget GL_20120428003925.txt
ftp> mget GL_20120429003936.txt
200 Type set to A.
mget GL_20120429003936.txt? mget GL_20120430003125.txt
ftp> mget GL_20120501003743.txt
200 Type set to A.
mget GL_20120501003743.txt? mget GL_20120503003843.txt
ftp> mget GL_20120504003532.txt
200 Type set to A.
mget GL_20120504003532.txt? mget GL_20120505003737.txt
ftp> mget GL_20120506003416.txt
200 Type set to A.
mget GL_20120506003416.txt? mget GL_20120507003454.txt
ftp> mget GL_20120508003950.txt
200 Type set to A.
mget GL_20120508003950.txt? mget GL_20120509004822.txt
ftp> mget GL_20120510004310.txt
200 Type set to A.
mget GL_20120510004310.txt? mget GL_20120511004913.txt
ftp> mget GL_20120511102949.txt
200 Type set to A.
mget GL_20120511102949.txt? mget GL_20120512002546.txt
ftp> mget GL_20120513002200.txt
200 Type set to A.
mget GL_20120513002200.txt? mget GL_20120514003637.txt
ftp> mget GL_20120515003024.txt
200 Type set to A.
mget GL_20120515003024.txt? mget GL_20120516002223.txt
ftp> mget GL_20120517001839.txt
200 Type set to A.
mget GL_20120517001839.txt? mget GL_20120518002519.txt
ftp> mget GL_20120519001927.txt
200 Type set to A.
mget GL_20120519001927.txt? mget GL_20120520002019.txt
ftp> mget GL_20120521002229.txt
200 Type set to A.
mget GL_20120521002229.txt? mget GL_20120522001718.txt
ftp> mget GL_20120523001519.txt
200 Type set to A.
mget GL_20120523001519.txt? mget GL_20120524002051.txt
ftp> mget GL_20120525002655.txt
200 Type set to A.
mget GL_20120525002655.txt? mget GL_20120526003858.txt
ftp> mget GL_20120527002027.txt
200 Type set to A.
mget GL_20120527002027.txt? mget GL_20120528002121.txt
ftp> mget GL_20120529002220.txt
200 Type set to A.
mget GL_20120529002220.txt? mget GL_20120530002303.txt
ftp> mget GL_20120531002138.txt
200 Type set to A.
mget GL_20120531002138.txt? quit

[foxidrive]

I change it to mget and now I receive two files:

Still no files in my local directory: c:\FTPFMSBatch\prenos ?

You will find the files in the folder the batch file was started from.

Add this on the line after @echo off
pushd "c:\FTPFMSBatch\Prenos\"

and on the very last line add this:
popd