1 Reply Latest reply: Jan 11, 2018 9:52 AM by Petter Skjolden RSS

    Multiple files FTP to Qlik Sense

    Rajarshi Guin

      Hi All,

       

      I am using the Qlik Web Connector to access files using FTP. I tried to FTP one file using the FTPGetRawFile option under Qlik FTP/SFTP Connector. Then I created a Web File data connection using the link generated in Web Connector. I could import data from one table in that way.

       

      Now I am trying to access multiple files kept in that same location. So under FTPGetRawFile option this time I am putting the file name as *.csv. All other details I have kept same as previous.


      But this time I am getting the error

      A file or directory in the path name does not exist (550).)


      A URL was generated in the Web Connector along with this error and I tried to create a Web File connection using that URL. I am getting the Invalid Server Error there.


      I also tested by using the same path that I used for accessing multiple files under FTPListFilesAndFolders option in Qlik FTP/SFTP Connector and could see all the files in that folder listed there. So, I am assuming there is no issue with the path.


      Can anyone please let me know what can be the issue here.

       

      Thanks and Regards,

      Rajarshi Guin



        • Re: Multiple files FTP to Qlik Sense
          Petter Skjolden

          The documentation seems to be very specific that you have to use FTPDownload to retrieve multiple files with wildcard. FTPGetRawFile can only retrieve a single file at a time. So if you for some reason need to use FTPGetRawFile instead of FTPDownload you will have to make a loop in your load script to retrieve all the files.

           

          Snippet from the documentation:

          • FTPGetRawFile - Downloads a named file from your FTP server and returns the results directly. You can use the URL generated as a Web File source.
          • FTPDownload - Downloads a named file, or files if you use a wildcard '*', from your FTP server to a local folder. The table returned shows the number of files downloaded.

           

          You can read more here: FTP/SFTP ‒ Qlik Connectors