Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ingoniclas
Creator II
Creator II

How to load data in Sense via FTP?

According to the help for Qlik Sense it's possible to load data from FTP, provided that the legacy scripting mode is activated: https://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/ScriptRegularState...

I quote:

"In legacy scripting mode, the following path formats are also supported:

  •   absolute

    Example: c:\data\

  • relative to the Qlik Senseapp working directory.

    Example: data\

  • URL address (HTTP or FTP), pointing to a location on the Internet or an intranet.

    Example: http://www.qlik.com

..."

But it didn't work with the script I used succesfully in QlikView. What else has to be done to allow for loading data via FTP (w/o having to use the QVsource API connector)?

1 Solution

Accepted Solutions
Ralf-Narfeldt
Employee
Employee

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

View solution in original post

9 Replies
Not applicable

Hi Ingoniclas,

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.

LOAD Rank,

    County,

    Average,

    [Lower Bound],

    [Upper Bound]

FROM

[ftp://ftp2.census.gov/acs2002/Ranking%20Tables/Average%20Travel%20Time%20to%20Work/County/Table_Aver... 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.

Rod

ingoniclas
Creator II
Creator II
Author

Hi Rod,

Yes, I have to authenticate to that particular FTP source. This works well with QlikView as follows:

Load ZIP,

Town

FROM

[ftp://[Username]:[Password]@[FTP server]/Location.xls]

(biff, embedded labels, table is [ZIP code$]);

Does Sense treat this differently?

Cheers,

Ingo

Ralf-Narfeldt
Employee
Employee

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

ingoniclas
Creator II
Creator II
Author

Dear Ralf,

I got it to work now. Many thanks!

Ingo !

Ralf-Narfeldt
Employee
Employee

Great, please mark this question as answered!

Not applicable

Hello it doesn't work for me , it gives 'source unavailable'

pauldamen
Partner - Creator II
Partner - Creator II

How did you get it to work?

I entered everything as described above and in Qlikview it works fine. But in Sense I get the error "source not found" when entering the FTP URL

Ralf-Narfeldt
Employee
Employee

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'

Connect to data sources ‒ Qlik Sense

suhasinigm
Partner - Contributor III
Partner - Contributor III

Hi  Ralf,

I am trying to connect Qlik sense with FTP,

I followed the above steps ,but not able to achieve.

If I am giving the FTP URL ,getting 30002 Error,please help me out where I am going wrong.

Thanks and Regards

Suhasini G Metri