how to load files from FTP with généric names like *.csv

[doespirito]

hi every body,

i try to load several files from FTP all with csv extension.

il try to write this script, using generic names as *.csv,  but it dosen't work :

LOAD *

FROM

[MYFTPADRESS/MYFOLDER/*.csv]

//(txt, codepage is 932, no labels, delimiter is ' ', msq, no eof);

but it doesn't work,

Can anyone could help me,

Thank you very much

Arnault

[Peter_Cammaert]

BTW FTP is one of the oldest (if not the oldest remaining) protocols afloat on the net. It really is starting to show its age. You don't have an alternative method of transferring your data files?

[ed_hoecker]

Marcus,

thanks for this information!

Edgar

[doespirito]

thank you for your help.

I've wrote a script for loading my files from ftp with for...next instruction.

It works fine, except that the QlikView FileName() instruction returns insteed of name's file, the entire  name with ftp adresse. So the following script falls in error....

Finally, i think you are right : ftp is an old protocole.

I think i will copy the files on a special  directory and then load them in qlikview.

all thinks i didn't want to do first...

Arnault