Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Spoon and FTP

  1. #1

    Default Spoon and FTP

    I have been trying to create an FTP and Unzip Job in Spoon but I cannot figure out how to do this as a chain.

    What I want to do is to ftp a filepattern.zip and then unzip a particular wildcard pattern from the ftp'd zip archives.

    The problem is that the Unzip module needs for you to name a particular file but we do not know the exact name of the file because it was ftp'd from a pattern.

    Is there some way to do this?

    Gerry

  2. #2

    Default

    I can sort of get things working with a shell script in the chain instead of the unzip module. What would really be helpful is if the "Get a file with FTP" would pass along the filenames of the files that it ftp'd. That way I could take them in as args to the shell script and operate on them.

    Gerry

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Not currently, some of the entries have been adapted to pass along filenames. Raise a JIRA request for it.

    What you could is ftp and then use a get filenames step in a transformation to read the files with the same wildcard (if you're starting out from an empty directory every time).

    Regards,
    Sven

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Actually, to my knowledge all the files that are retrieved are put on the Result list.
    As such, you can get a hold of these filenames using the "Get files from result" step.
    Copy these filenames to result, set variables, loop over it.
    It might not be extremely trivial to do so, but it's most certainly possible.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.