FTP Connection is not working in Qlik Sense 3.2

tesc01409 — Thu, 09 Nov 2017 09:47:14 GMT

Hey everybody,

i do have the following ftp connection problem which arised through an Update to Qlik Sense 3.2.

For more than a year this syntax worked in Qlik Sense 3.0 like this:

Table1:

LOAD

FILEBASENAME() as Filebasename

FROM

[ftp://Username:password@IP/$(vFile)]

(txt, utf8, embedded labels, delimiter is '|', msq);

$(vFile) is a variable which contains the filename.

Now i updated the server to Version 3.2 and when refreshing data Qlik Says "This statement only works with lib:// paths in this script mode." So i created a Lib which contains the ftp expression (ftp://Username:password@IP/) and the syntax changed to the following:

Table1:

LOAD

FILEBASENAME() as Filebasename

FROM

[lib://FTP/$(vFile)]

(txt, utf8, embedded labels, delimiter is '|', msq);

$(vFile) is still the filename.

Now, Qlik completely ignores any syntax after lib://FTP. I can type in any expression, even ABCDE of whatever. It always gives me list with all files on the ftp server. But i want a specific file which is on the ftp server. Around this expression is a loop, because the file name changes every time and that's why we are using a variable.

Does anybody have an idea for a solution?

Thank you folks

Re: FTP Connection is not working in Qlik Sense 3.2

shraddha_g — Fri, 10 Nov 2017 04:01:50 GMT

Can you share whole script?

How you have defined variable vFile?

Re: FTP Connection is not working in Qlik Sense 3.2

tesc01409 — Fri, 10 Nov 2017 08:44:03 GMT

It finally worked again. One just need to deactivate the standard mode in engine settings, so that qlik doesn't need Lib:// anymore.

Re: FTP Connection is not working in Qlik Sense 3.2

shraddha_g — Fri, 10 Nov 2017 09:27:23 GMT

Great!

topic FTP Connection is not working in Qlik Sense 3.2 in Connectivity & Data Prep

FTP Connection is not working in Qlik Sense 3.2

Re: FTP Connection is not working in Qlik Sense 3.2

Re: FTP Connection is not working in Qlik Sense 3.2

Re: FTP Connection is not working in Qlik Sense 3.2