FTP with VFS

[dorellan]

Dear,
i´m using the vfs to read in sftp site a lot of files and it's ok. But, i try to do the same with ftp and the ktr do nothing.
The problem: I'm using "Get File Names" steps for this. If i have a sftp path (for example in File/Directory colum i put "sftp://MyUser:MyPw@MyIPHost/CompletePath/" and Wildcard i put .*) and execute it, the transformation give me a namelist file. Thats is great.

If i do the same but with ftp, in kettle appear this error
"2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : org.apache.commons.vfs.FileSystemException: Could not list the contents of "ftp://ftpuserw1234@IP_HOST/dir1/input" because it is not a folder.2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at org.apache.commons.vfs.provider.AbstractFileObject.getChildren(AbstractFileObject.java:527)
2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at org.pentaho.di.core.fileinput.FileInputList.createFileList(FileInputList.java:231)
2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at org.pentaho.di.trans.steps.getfilenames.GetFileNamesMeta.getFileList(GetFileNamesMeta.java:557)
2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at org.pentaho.di.trans.steps.getfilenames.GetFileNames.init(GetFileNames.java:302)
2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:48)
2012/06/26 17:02:25 - FileInputList - ERROR (version 3.1.0-RC1, build 771 from 2009/02/23 17:26:10) : at java.lang.Thread.run(Unknown Source)


"

If i use ftp://ftpuserw1234@IPHOST/dir1/input/Myfile.ext in the File/Directory Column (in step), the ktr is correct and give me a filename. But, i need to list all files in this ftp site before get a local server.

if does not understand this... oops, i'll will lost for ever.
I don't know more do it. If somebody can help, i'll be in debt with you.

[gutlez]

Step 1. Update your PDI.

3.1.0-RC1 is very old. At the *VERY* Least, upgrade to 3.1.0-stable.
Better would be 4.3.0.

[dorellan]

Well, is in productive envelopement... I can´t change it.
But, if i need to change it to 4.2 version (i use it for otrher customer) can i do this steps?

[dorellan]

Somebody can giveme any idea? ... I'll be in debt 4 all my life.

[MattCasters]

Of-course, FTP should work without a single problem.
For SFTP you might have to tweak things a bit... http://wiki.pentaho.com/display/COM/...ing+Kettle+VFS

[dorellan]

Hi Matt
in ths moment i'm working with this.. i can solve this in my PC. Now i can get the list file from ftp site (win envelopement). But, when i execute this ktr in my productive envelopement, when map try to write the list file ftp to a output local file, the console is stopped (please see picture)
consola.jpg

i don't understando why can happend this... only know that in my PC working ready

May be server configuration?? how can i know if is server local problem or ftp server problem?


Pls.... i need help...

Thank

(abouth sftp i have no problem)

[MattCasters]

Sorry buddy, I can't even read the text in that image.
But yes, the problem is most likely due to network security, a firewall somewhere, an incorrect password, that sort of thing.

[dorellan]

i trust the ftp o net rules...
Well, thanks for help... was important to know that is no my wrong...

Regards to everybody