Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Use email attachment as input

  1. #1
    Join Date
    Feb 2011
    Posts
    1

    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
    Posts
    810

    Default

    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.

    Cheers

    Slawo

  3. #3
    Join Date
    Feb 2014
    Posts
    22

    Default

    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
    Posts
    382

    Default

    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.