FTP help

[varunjain]

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.

[marcus_sommer]

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

[varunjain]

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.

[marcus_sommer]

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

[varunjain]

Is there an option in QV where in I can metion the port number as well?

[marcus_sommer]

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

[varunjain]

Thanks... i will give it a try

[#8]

HI

Did anyone find the exact syntax to load from ftp in the script?

Regards

Meir

[#9]

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.

[marcus_sommer]

This worked:

t1:

Load * From

ftp://userID:password@YourServer/Path/File/Ext (Typ);

- Marcus