Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I need to load data from an FTP site. I have a username and password which workes fine on a different FTP app but is not working on Qlikview. Please help.
Try this:
Load *
FROM ftp://User:Password@YourServer.com/abc.csvPassword@YourServer.com/abc.csv (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);
- Marcus
Hi ,
I have done the same but did not work
[ftp://User:ABCD@10.10.10.192/var/XXX/reports/PPP.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);
On the other FTP app where I tried this, I had to put port number too... I hope there is nothing to do with the port.
Yes, it could be a security issue - ports, firewall, group policies ... Try an access to your files per explorer and/or IE, then you knows.
- Marcus
Is there an option in QV where in I can metion the port number as well?
Yes you could: ftp://[user ID:password@]<host name>[:port]/[path name/]
But I think you would rather ask your IT to allow such connections.
- Marcus
Thanks... i will give it a try
HI
Did anyone find the exact syntax to load from ftp in the script?
Regards
Meir
Use the Wizard in the load script - bottom frame "Data From Files" and check the Use FTP box and then press the button of the data type you're looking to load.