topic Re: FTP-Connection Failed in QlikView

FTP-Connection Failed

elie_issa — Thu, 19 May 2016 14:17:24 GMT

Dear All,

Please advise why when i am trying to connect to the ftp through Qlikview it's giving the below error while the link to the FTP with username and password is working fine outside the Qlikview script.

Re: FTP-Connection Failed

marcus_sommer — Fri, 20 May 2016 07:46:50 GMT

Have you tried to load manually, like:

table:

load * From [ftp://user:password@YourFTPServer.com/YourFolder/YourFile.csv] (txt);

- Marcus

Re: FTP-Connection Failed

elie_issa — Fri, 20 May 2016 09:59:40 GMT

I tried it and get the below error :

Re: FTP-Connection Failed

marcus_sommer — Fri, 20 May 2016 13:33:44 GMT

Are you sure that the used user has really access rights to these file? This meant this user could manually open this file per windows explorer?

- Marcus

Re: FTP-Connection Failed

Thu, 23 Jun 2016 16:06:21 GMT

same error, and yes, I can open the ftp from files explorer, browser and file zilla,
but not in qv

what could it be?

thanks!

Re: FTP-Connection Failed

marcus_sommer — Thu, 23 Jun 2016 18:20:23 GMT

How looked the load-statement? And open the file per explorer and loading per qlikview is with the same user and on the same machine?

- Marcus

Re: FTP-Connection Failed

Thu, 23 Jun 2016 18:54:14 GMT

we were able to generate the load statement manually

something like that
LOAD @1,

@2,

FROM

ftp://user:password@187.157.255.42/Inbox/file.txt

(txt, codepage is 1252, no labels, delimiter is '|', msq);

and it works, but it doesn't connect through dialog box table files with option 'use FTP'

now the issue is to load a file that does not have the txt extension...

Re: FTP-Connection Failed

marcus_sommer — Fri, 24 Jun 2016 06:27:25 GMT

I must admit I have never used this 'use FTP' and written all my statements manually - therefore I have no idea what didn't work with them.

But if it worked manually everything is fine. To still use the convenient of the table-wizard you could copy these file to a local drive, perform the wizard and then replace simply the local-path with the ftp-path.

- Marcus

Re: FTP-Connection Failed

Tue, 28 Jun 2016 20:28:51 GMT

I have tried, from local folder it's working to load file.20160628, but for some reason QV does not see any file in this ftp, so even if I run:

LOAD *

FROM

[ftp://user:pw@ftp.ip/file.20160628 pw@ftp.ip/file.20160628]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

it's not working because QV can't find this file (file.20160628) that not have any extension

the strange thing is that I can see the files from windows file explorer, filezilla, winscp, internet browser, but no from QV neither QSense

Re: FTP-Connection Failed

marcus_sommer — Wed, 29 Jun 2016 07:00:47 GMT

I don't think that the file-format respectively the file-extension is the reason for the failure. AFAIK FTP transferred files completely independent which one - but it could be that there any rules implemented within the firewall and/or the group policies within your network that block certain actions and/or ports.

I would try a test with a copy from the file which you give the extension txt (now your file had the extension 20160628 then the last point within the filename will be identified as extension) and also to find out if some ports are blocked respectively to add the port to the load-statement like:

table:

load * From [ftp://user:password@YourFTPServer.com:21/YourFolder/YourFile.csv] (txt);

See further: File Transfer Protocol - Wikipedia, the free encyclopedia

- Marcus

Re: FTP-Connection Failed

diego_vazquez — Wed, 29 Jun 2016 08:25:11 GMT

Hi,

I use this sentence to load files from the ftp. Hope it helps:

[ftp://user:pass@ip_or_domain/path/file.xlsx]

(ooxml, embedded labels, table is [table_name]);

Re: FTP-Connection Failed

Wed, 29 Jun 2016 16:03:57 GMT

I can't add any extension, I've tried many extension types but each time QV tells me that "cannot open the file"

it's not csv, neither txt ...

and dont think it's the port cause in any other way I can see the files, but I will ask

Re: FTP-Connection Failed

Wed, 29 Jun 2016 16:23:56 GMT

that's why I think its an extension missing problem... or find a syntax that QV can see directly from ftp.. but I've tried all...

Re: FTP-Connection Failed

marcus_sommer — Wed, 29 Jun 2016 19:17:28 GMT

Try to load this file manually without using the wizard:

table:

load * From [ftp://user:password@YourFTPServer.com/YourFolder/YourFile] (txt);

- Marcus

Re: FTP-Connection Failed

Wed, 29 Jun 2016 19:27:42 GMT

already tried many times, not working, it can't find the file

in the pic, right low corner, QV cant see any file in the ftp folder...

so even if I force it manually, it cannot open it...

LOAD @1,

@2,

FROM

[ftp://user:password@111.222.333.444/VENTAS.20160622]

(txt);

tried with many extensions and not working!

Re: FTP-Connection Failed

marcus_sommer — Thu, 30 Jun 2016 05:50:20 GMT

I had had never any problem with accessing files per ftp and therefore I think that something is blocking the access from qlikview to these file per ftp. I think you should check the ports - maybe there people in your company which could assist you in tracing the ftp-call and/or looking in settings/logs from firewall and group policies.

An alternatively could be to copy these files per batch to a local storage which had also further advantages that you could now use filefunctions like filetime() or loading files per wildcard which aren't supported by the ftp-protocol:

Re: For Each File in Filelist - FTP load is not working?

- Marcus