Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ingoniclas
Contributor

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

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: How to load data in Sense via FTP?

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

9 Replies
Not applicable

Re: How to load data in Sense via FTP?

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
Contributor

Re: How to load data in Sense via FTP?

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

Employee
Employee

Re: How to load data in Sense via FTP?

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
Contributor

Re: How to load data in Sense via FTP?

Dear Ralf,

I got it to work now. Many thanks!

Ingo !

Employee
Employee

Re: How to load data in Sense via FTP?

Great, please mark this question as answered!

Not applicable

Re: How to load data in Sense via FTP?

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

pauldamen
Contributor II

Re: How to load data in Sense via FTP?

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

Employee
Employee

Re: How to load data in Sense via FTP?

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
New Contributor III

Re: How to load data in Sense via FTP?

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

Community Browser