Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikSense Enterprise - Loading files from FTP site

Hi All,

I'm working on a project where the data source consists of excel sheets from several vendors posted to an FTP site, new documents are added to site monthly. Any ideas on the best approach to load these new sheets into a Qlik application?

*Using Qlik Sense Enterprise Edition

Thanks

4 Replies
tomasz_tru
Specialist
Specialist

It's best to a avoid such a data source. Excel and different parties involved feels like problems.

rohitk1609
Master
Master

Hi,

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)]

LOAD

....

FROM [lib://FTP (your_user_name)];


Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar


Anonymous
Not applicable
Author

Hi Rohit - the web file connection doesn't work, it returns an 'Unknown Error'.

Anonymous
Not applicable
Author

Any suggestions for dealing with such scenarios where the client's core data source is spreadsheets?