topic Re: csv filetime in QlikView

csv filetime

Wed, 21 Nov 2012 20:54:08 GMT

Hi Folks, I need to know CSV file modification time. I tried with filetime('C:\Documents and Settings\Documenst\Test.csv') and works well.

But I pointed the filename with web file and I got the null value.

let vExcelTime = filetime('http://myteamsusa/sites/New Folder/RMS_File.csv') and this returns null value.

Please help me, how can i get the modification time of the csv file on the web files.

Thanks,

Siri

Re: csv filetime

Wed, 21 Nov 2012 22:43:17 GMT

try like this

load date(filetime()) as vExcelTime

FROM

http://myteamsusa/sites/New Folder/RMS_File.csv;

Re: csv filetime

Mon, 26 Nov 2012 14:58:53 GMT

Hi, Thanks for your reply.

I tried that option and I got the null value.

I am not sure why Filetime gave null when you provide the filenamas FTP or webfile.

Please help me on this.

Re: csv filetime

jonathandienst — Mon, 26 Nov 2012 15:09:45 GMT

I do not believe that the HTTP or FTP protocols support the filetime call.

Regards

Jonathan

Re: csv filetime

Mon, 26 Nov 2012 15:27:35 GMT

Hi Jonathan, Thanks for reply.

Is there any other way to find the csv file modification time ?

Thanks,

Siri

Re: csv filetime

jonathandienst — Wed, 28 Nov 2012 13:46:24 GMT

Siri

I've never tried to do ths from QV, but if you could send the appopriate LS command to the FTP site, you may be able to get the directory listing into a temporory text file. Exactly how would depend on what FTP client you use, but assuming you have one (or can find one) that will allow batch commands, you could execute this in a command shell bat file and then load the resulting text file to get the file date.

But a better way would be to see if the person generating the file can embed the date stamp in the file name and then attempt to load the appropriate date stamped file name. Or include a field in the file with the file create time.

Regards

Jonathan