Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help.
I've been trying to make a list of files downloaded from FTP server.
I used this code but no result in my table list.
//======================= A N R FILE LIST =============================
Sub DoDir (Root)
for each Ext in 'xlsm'
for each File in filelist (Root&'\*.'&Ext)
Load
'$(File)' as SourceFile,
subfield('$(File)', '\', -1) as [File Name],
FileSize('$(File)') as Size,
FileTime('$(File)') as FileModified
autogenerate 1;
next File
next Ext
for each Dir in dirlist (Root&'\*')
call DoDir (Dir)
next Dir
End sub
call DoDir('$(Var_ANRServer)')
//=========================================================================
Thanks for your help.
It's not possible by FTP because the FTP-Protocoll didn't support any file-functions. You will need to create a loop with full-paths for each file or using of batches- see: For Each File in Filelist - FTP load is not working?
- Marcus