Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

okolyug16
Contributor II

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

Tags (2)
4 Replies
tomasz_tru
Valued Contributor

Re: QlikSense Enterprise - Loading files from FTP site

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

rohitk1609
Valued Contributor II

Re: QlikSense Enterprise - Loading files from FTP site

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


okolyug16
Contributor II

Re: QlikSense Enterprise - Loading files from FTP site

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

okolyug16
Contributor II

Re: QlikSense Enterprise - Loading files from FTP site

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

Community Browser