Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Use email attachment as input

  1. #1
    Join Date
    Feb 2011

    Default Use email attachment as input

    Is is possible (or is there any plugin, which allows) to use the attachment (in Excel format) as the input of a PDI-transformation. Every time the transformation (or job) is started, the mail box should be polled. If new mail is available, the attachment should be retrieved and used as an Excel input.

  2. #2
    Join Date
    Sep 2009


    Hi there,

    I think most people do that by having a job that uses the "Get Mails" job entry, and follow it up by a transformation that uses an Excel input step.



  3. #3
    Join Date
    Feb 2014


    I realize this is a very old thread but it is exactly what I am looking to do and searching and searching is just coming up here. Does anyone know of an example of this? I fail to see how in the 5.1.0 Email Messages Input step I can get at the attachment and turn it into something the Excel step can receive.

  4. #4
    Join Date
    Nov 2013


    Yes we do exactly that.

    Use a 'get emails from ..." job step saving the attachments to a specific folder (we use a 'today's folder but that's for convenience), then check if the desired file is there (we require a specific name, but you can also look whatever is there and check the date/time). Start a transformation that reads the desired file(s).

Tags for this Thread

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.