check file in FTP

stefano_marson — Tue, 10 Jan 2023 14:03:14 GMT

Hello everybody,

in QlikSense, I would need to test the possible presence of a .csv file, within an FTP site, before uploading it.
I was thinking of using the filesize() function as I have done in the past with QlikView.
But it doesn't work: the variable vFileExists always returns 0 even if the file exists.

This what I wrote:

LET vFileExists = not isNull(filesize('ftp://sense:Yu7..P4nW6L4@ftpecomm.dmospa.local/daElaborare/SENSE2023.csv'));

Maybe I'm doing the syntax wrong?

Thanks in advance

stefano

Re: check file in FTP

marcus_sommer — Tue, 10 Jan 2023 15:21:03 GMT

FTP doesn't support the usual file-functions. You will need specialized ftp-functions maybe you could evaluate the return of ftp mdir or as an alternatively you transfers the files in beforehand to a local drive with mget or similar functions. Here a starting point: ftp mdir | Microsoft Learn

topic check file in FTP in App Development

check file in FTP

Re: check file in FTP