HOW TO MAKE FILE LIST USING FTP DIRECTORY?

Thu, 30 Jul 2015 09:08:01 GMT

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.

Re: HOW TO MAKE FILE LIST USING FTP DIRECTORY?

marcus_sommer — Thu, 30 Jul 2015 11:22:55 GMT

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

topic Re: HOW TO MAKE FILE LIST USING FTP DIRECTORY? in QlikView

HOW TO MAKE FILE LIST USING FTP DIRECTORY?

Re: HOW TO MAKE FILE LIST USING FTP DIRECTORY?