Get file name from "Get a file with FTP"

[komodo]

Dear all,
I would like to get name of files from "Get a file with FTP"? and pass them to "Text file input".
How could i do that?

Thank you so much.

[shassan2]

Hi,

"Get a file with FTP" job entry will download files in a local folder.
If you need "just" to get files name, you can use VFS (get filesname step support VFS) :

http://commons.apache.org/vfs/filesystems.html#FTP

Samatar

[komodo]

Hi,

"Get a file with FTP" job entry will download files in a local folder.
If you need "just" to get files name, you can use VFS (get filesname step support VFS) :

http://commons.apache.org/vfs/filesystems.html#FTP

Samatar

Dear Samatar,
Thank you for yr answer, but i would like to get filenames directly from "Get a file with FTP", and pass these filenames as result to "Text file input".

Thanks

[shassan2]

"Get files with FTP" job entry will send downloaded filenames to next job entry (a transformation for example).
You can use "Get rows from result" step to read from rows from previous result.

START --> Get files with FTP --> Transformation

in Transformation : Get rows from result --> TExt file input


Samatar

[komodo]

"Get files with FTP" job entry will send downloaded filenames to next job entry (a transformation for example).
You can use "Get rows from result" step to read from rows from previous result.

START --> Get files with FTP --> Transformation

in Transformation : Get rows from result --> TExt file input


Samatar

I got it.
Thank you so much, Samatar

[dejoong]

Hi guys,

i opened spoon, from Utility i couldn't find "Get files with FTP".
anything missed??

Please help.

Thanks.

Rgds/Dejoong

"Get files with FTP" job entry will send downloaded filenames to next job entry (a transformation for example).
You can use "Get rows from result" step to read from rows from previous result.

START --> Get files with FTP --> Transformation

in Transformation : Get rows from result --> TExt file input


Samatar

[dejoong]

Hi Guys,

ignore my prev question, i;ve already gotten it.
but i confused about how to transfer file from FTP into transformation inside a job.

Anyone can help me out?

Thanks.

Rgds/Dejoong

Hi guys,

i opened spoon, from Utility i couldn't find "Get files with FTP".
anything missed??

Please help.

Thanks.

Rgds/Dejoong

[renatopb]

Try the "Get files from Result" step.

[dejoong]

thx fro the answer rena..,
i got a new prob here.., when i run the job, it showed error while get file from FTP.

2011/01/25 14:03:37 - Get a file with FTP - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : Error getting files from FTP : Control channel unexpectedly closed ('FZS blabla... ' read so far)
2011/01/25 14:03:37 - Get a file with FTP - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : Error quiting FTP connection: The FTP client has not yet connected to the server. The requested action cannot be performed until after a connection has been established.

i've got conv about this here -> http://forums.pentaho.com/showthread...es-through-FTP but seems no solving method yet so far.
anyone can help??

Thanks.

Rgds/Dejoong

Try the "Get files from Result" step.

[renatopb]

Those seem to be different errors (yours and the one from the other thread).

I remember running into this "channel unexpectedly closed" issue back in 3.2. However, I didn't have to fix it, someone else was working on it.
They ended up moving the ftp step out of kettle, using wget. Not neat, but it fit.