Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to read excel file into Qlikview from FTP server

Hi All,

I have requirement where in the execl file will be placed on the FTP server and i need to load that from FTP server location.

I have tried setting up the connection but every time i got "FTP-Connection failed error"..

Is there anything that needs to be taken care as a prerequisites? Can someone guide me?

Thank you in advance.

7 Replies
Clever_Anjos
Employee
Employee

Please post how this screen is configured

Capturar.PNG

Not applicable
Author

FTP.PNG

Server name along with credentials..

jpenuliar
Partner - Specialist III
Partner - Specialist III

You haven't mention if you can connect to the ftp server apart from Qlikview.

It could be that you need privileges to connect to the ftp server.

Not applicable
Author

Hi Peniliar

I am able to connect to  FTP server with server address and credentials.

but from Qlikview i am getting the above mentioned error.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or a correct username and password. FTP servers hosting business-ciritical information usually do not allow anonymous access.

Clever_Anjos
Employee
Employee

Try conneting to your FTP without Qlik using this How to FTP using Command Prompt - Server Intellect

quwok
Creator III
Creator III

Also note that QlikView FTP does not support the sFTP protocol.