3 Replies Latest reply: Nov 10, 2017 4:27 AM by Shraddha Gajare RSS

    FTP Connection is not working in Qlik Sense 3.2

    Robert Teschendorf

      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