US and Worldwide: +1 (866) 660-7555
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Get file name from "Get a file with FTP"

  1. #1
    Join Date
    Jul 2009
    Posts
    15

    Default Get file name from "Get a file with FTP"

    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.

  2. #2

    Default

    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
    Samatar

  3. #3
    Join Date
    Jul 2009
    Posts
    15

    Default

    Quote Originally Posted by shassan2 View Post
    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

  4. #4

    Default

    "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
    Samatar

  5. #5
    Join Date
    Jul 2009
    Posts
    15

    Default

    Quote Originally Posted by shassan2 View Post
    "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

  6. #6
    Join Date
    Jan 2011
    Posts
    4

    Default

    Hi guys,

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

    Please help.

    Thanks.

    Rgds/Dejoong

    Quote Originally Posted by shassan2 View Post
    "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

  7. #7
    Join Date
    Jan 2011
    Posts
    4

    Default

    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

    Quote Originally Posted by dejoong View Post
    Hi guys,

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

    Please help.

    Thanks.

    Rgds/Dejoong

  8. #8
    Join Date
    Nov 2008
    Posts
    143

    Default

    Try the "Get files from Result" step.

  9. #9
    Join Date
    Jan 2011
    Posts
    4

    Default

    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

    Quote Originally Posted by renatopb View Post
    Try the "Get files from Result" step.

  10. #10
    Join Date
    Nov 2008
    Posts
    143

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •