Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How do I communicate Zip File Name to a Shell Script Job Step?

  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Default How do I communicate Zip File Name to a Shell Script Job Step?

    Pentaho Version: 4.1.0-stable
    OS: Windows (XP, 2008)

    I am working on an ETL which takes a CSV file, reformats the data into a different set of CSV files, zips the results up into a zip file. then passes that file as a parameter to shell batch file. The shell batch script is a given in this situation.

    The batch file command line looks like:
    >batch_file.bat file zip-file.zip

    I was trying to create a daily zip file using Create a Zip File... step with the 'Include date in filename' option, but I could not find a way to deliver the resulting filename into the shell script step.

    I tried using the "Add Zip File to result" on the Advanced tab, but that does not seem to be what I want.
    Last edited by mds; 09-28-2011 at 11:54 AM.

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    If you convert the zip file name into a variable, you can reference that in the shell script step, e.g.

    batch_file.bat ${ZIP_FILE}

    Cheers,
    Paul

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.