Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Problems attaching Excel File to email

  1. #1

    Default Problems attaching Excel File to email

    I've got a transformation that writes data to an excel file, and I wish to then email that file to someone. From what I understand (and read in this forum), the Excel Output step in a transformation is supposed to pass the filename along to the next step in a job. I can't get this to work. The email is sent with no attachment. No errors in the log. I've attached the simple job and transformation.
    Attached Files Attached Files

  2. #2

    Default

    Works fine in 3.0 RC2.
    But not in 2.5.3 (and of course probably in 2.5.x)

    We had pb when cheking "add time" in Excel output filename.

    I posted a bug : http://jira.pentaho.org/browse/PDI-462

    Rgds

    Samatar

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

    Default

    And a solution for 2.5.x but which doesn't work anymore in 3.0

    I removed you're excel creation for the moment

    Regards,
    Sven

    Edit: Example does not work in v3.0RC2 but will work in v3.0GA
    Attached Files Attached Files
    Last edited by sboden; 11-13-2007 at 06:04 PM.

  4. #4

    Default

    Thanks Sven,

    I got your approach working. Used a get filenames step & set files in result after the excel file output, then just delete the excel files after sending the email.

  5. #5
    Join Date
    Apr 2016
    Posts
    3

    Default

    Hi,

    I am new to Pentaho. Can anyone help me on this. I am creating one excel in the transformation and when i am trying to attach it in the mail,it is not attaching... Mail coming without the attachment.
    Attached Files Attached Files
    Last edited by rithu.simon; 04-17-2016 at 06:38 AM. Reason: Changing all the ftp details

  6. #6
    Join Date
    Apr 2016
    Posts
    3

    Default

    Hi all...i got the solution.

    In the excel file generation step...there is a checkbox"Add filenames to result" that you need to check(tick it) ... when you are trying to attach the excel to the mail always make sure this check box is always checked.Name:  soln.jpg
Views: 525
Size:  9.0 KB

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.