topic Re: How can i obtain the time of a file in a ftp server in QlikView

How can i obtain the time of a file in a ftp server

Fri, 11 Feb 2011 16:11:38 GMT

Hi,

I Need to take a csv file from an FTP to integrate on my qlikview model, the problem is that the file is generated every 2 hours with a different name and I need to identify which is the most up to date and take that to my load ... filetime () function returns me null, someone knows if there is another option to get this information?

Thank you very much in advance!
Gabriela

How can i obtain the time of a file in a ftp server

Wed, 25 Apr 2012 03:07:06 GMT

Hi Gabriela,

I'm facing with the same problem. Can you share with me the solution if you have solved it? Notice this thread is pretty long ago:)

Xue Bin

Re: How can i obtain the time of a file in a ftp server

Thu, 10 Jul 2014 15:11:10 GMT

Hi all,

Have you been able to solve this issue?

If yes, could you share the solution?

Thanks in advance!

Tom

Re: How can i obtain the time of a file in a ftp server

ChiragPradhan — Thu, 10 Jul 2014 16:11:43 GMT

Hi Gabriela,

Have you tried using the full file path in the Filetime function rather than just the file name?

Regards

Re: How can i obtain the time of a file in a ftp server

Thu, 10 Jul 2014 17:39:36 GMT

Hi Pradhan,

can you please post an example on how that should look?

Re: How can i obtain the time of a file in a ftp server

ChiragPradhan — Fri, 11 Jul 2014 12:15:56 GMT

Hi Tom,

Here is the complete solution. Create a sub with the below code.

/************************************************************/

SUB GetLatestFile(Folder,Mask,OutputVariable)

FOR EACH FoundFile in FileList(Folder & Mask)

FileList:

LOAD

SubField('$(FoundFile)','\',-1) AS FileName, FileTime('$(FoundFile)') AS DateTimeStamp

AutoGenerate 1;

NEXT FoundFile

IF NoOfRows('FileList') > 0 THEN

Variable:

LOAD

MAX(DateTimeStamp) , FileName AS $(OutputVariable)

RESIDENT FileList

GROUP BY FileName

ORDER BY DateTimeStamp;

LET $(OutputVariable) = Peek('$(OutputVariable)');

DROP TABLES FileList,Variable;

ENDIF;

ENDSUB;

/***********************************************************/

And call this in your app

CALL GetLatestFile('$(vFilePath)','*.csv','vMyLastestFile');

Hope it helps. If this is what you were looking for, please mark this thread as answered. Thank you.

Re: How can i obtain the time of a file in a ftp server

ChiragPradhan — Fri, 11 Jul 2014 12:31:07 GMT

Gabriela Fonseca Please look at the solution I provided above and mark the question answered if it helps.