When extracting the data from the FTP server:
- Open your web browser to check whether the URL is correct and whether you have access to the server (I prefer Firefox for this task).
- Insert the following URL from which you can see a list of folders and files from a local FTP server: ftp://qlik:pwd@localhost (change the URL with your credentials and server name):
- Navigate to the folder with the files you need:
- Right-click on the file and select Copy Link Location:
In my example, I chose ROUTE_BUS.csv:
- Open an existing Qlik Sense application or create a new one.
- Open the Data load editor.
- Click on Create new connection and select Web file.
- The Select web file window will open.
- Insert the URL copied from the web page to set a connection with the file to extract data: ftp://qlik:pwd@localhost/chapter%201/QlikSenseData/ROUTE_BUS.csv.
- Name the connection as QlikSense Cookbook FTP ROUTE_BUS, as shown in the following screenshot: