Would it be possible to include the error you received as well as the script?
Here is some simple script from Qlik Sense connecting to an Excel spreadsheet on an FTP server.
[ftp://ftp2.census.gov/acs2002/Ranking%20Tables/Average%20Travel%20Time%20to%20Work/County/Table_Average Travel Time to Work_County.xls]
(biff, embedded labels, header is 2 lines, table is R04_050$);
As you mentioned, this is using legacy scripting and it works fine.
Could it be you need to authenticate to your particular FTP source or that you have a firewall rule blocking access?
Hope this helps.
Yes, I have to authenticate to that particular FTP source. This works well with QlikView as follows:
(biff, embedded labels, table is [ZIP code$]);
Does Sense treat this differently?
You can do the same thing in Qlik Sense using a Web file connection, without the need to activate legacy mode.
In Qlik Sense 2.0:
1. Select Add data from the Menu (next to the Navigation button)
2. Select the Connect my data tab
3. Click Web file in the list of data source types
4. Enter the ftp address in URL, give it a Name and click the > button to continue
Now you should get into the Select data dialog to select fields, and then load.
As an alternative, if you use an old script, just create a Web file data connection in the Data load editor:
1. Select Create new connection, then Web file
2. Enter the ftp address in URL, give it a Name , for example FTP
3. Click Create
Now you have a Web file connection called FTP (your_user_name)
4. In the Load statement From part replace the FTP URL with [lib://FTP (your_user_name)]
FROM [lib://FTP (your_user_name)];
If you connect to an FTP file you may need to use special characters, for example : or @, in the user name and password part of the URL. In this case you need to replace special characters with a percent character and the ASCII hexadecimal code of the character. For example, you should replace : with '%3a', and @ with '%40'