I'm completely stumped with how I would go about loading in all the .CSV files in a given FTP directory base on the date added to that directory... Any ideas?
You can have a ftp batch running, or a qvw in batch calling ftpxx.bat file with EXECUTE command, which will download newer files added in last hour and load them in QV. Just a quick idea.
@echo off > %0.ftp >> %0.ftp echo o mysite.com >> %0.ftp echo username >> %0.ftp echo password >> %0.ftp echo dir >> %0.ftp echo bye ftp -s:%0.ftp > %0.txt
2. Now that you have a list of files in text file, you can read it and loop through them. In the loop you can determine which file you need to download - based on date, file name sequence, etc. For those file, you may call another batch file (say GetMyFile.bat). For this have a look here: http://www.ericphelps.com/batch/samples/ftp.script.txt
Thanks Rakesh - I will look into that way of doing it.
In the last hour I was looking through the QlikView Reference document and came across this subroutine...
sub DoDir (Root)
for each Ext in 'qvw','qvo','qvs','qvt','qvd','csv'
for each File in filelist (Root&'\*.'&Ext)
Load
'$(File)' as Name,
FileSize('$(File)') as Size,
FileTime('$(File)') as FileTime
autogenerate 1;
next File
next Ext
for each Dir in dirlist (Root&'\*')
call DoDir (Dir)
next Dir
end sub
call DoDir ('C:\Temp')
I put a .CSV file into the C:\Temp directory and tested this but I'm not sure how to actually load the file's contents... I think this may be the right way of going about it and I'll add the FTP stuff in later, but first I want to try doing this with some test files in the C:\Temp folder...
