Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Pentaho CE 5 Schedules Email Report

  1. #1

    Default Pentaho CE 5 Schedules Email Report

    Hi,

    I saw a video showing a scheduled report being sent by email. This feature is only for EE?

    Emannuel

  2. #2
    Join Date
    Aug 2013
    Posts
    132

    Default

    AFAIK its only in Enterprise version.

  3. #3

    Default

    Just tried it with a fresh 5.0.1 CE install and it worked.
    I was able to schedule one of the sample reports and send the result to an email address.
    Where did you find that video ?

  4. #4

    Default

    I can't find the URL but was a demo of pentaho 5 (probably a oficial one).


    In the demonstration in the same process of schedule a report the user can write a email to receive the report.


    How did you do? Can you give me a step by step instruction?

  5. #5
    Join Date
    Aug 2013
    Posts
    132

    Default

    hi Emanuel,

    I tried the scheduling the email reports and I was successful.

    All you need to do is configure your smtp setttings in in administration concole ,,(Note: in pentaho CE 5, adminstration concole and puc and integrated.)
    later go for scheduler menu, choose any file to be mailed, process add email address, for multiple email add user email address use ';' (semicolon) between 2 email address.
    set time to schedule the report. and the needful will happen.

    Thanks,
    malibu

  6. #6
    Join Date
    Apr 2011
    Posts
    159

    Default

    I wrestled with this, also, until I came across this thread and read that the scheduling is done at the file level.

    That is, if you click the main menu and choose schedules there is not an 'add new' button. This may very well be an EE version, but in CE no such button exists (at least, not that I could find).

    However, if you go to main menu option (a) Browse Files and (b) select a file then you can click the 'Schedule...' in the right menu and create a schedule (it will be associated with your login) and if you have your email server configured/tested then, in theory, it should work.

    In this post there is mention of creating them via the REST api; though I have not found how/where that is done, this may be close to the solution. (That page says it is going to show REST schedule examples, but I didn't actually see any on that page...)

    So, in sum, with my limited knowledge I think the following may be true:
    1. There is NOT a 'create new' schedule option under 'Schedules' (in Community Edition. There happens to be 'an empty space' in the button menus where I am guessing this exists in EE...totally just a guess)

    2. You CAN create user-defined schedules by selecting a particular file in Browse Files and using the 'Schedule...' link on the right

    3. There may be a way in CE to create Public schedules via REST. IDK.

  7. #7
    Join Date
    Apr 2014
    Posts
    2

    Default Pentaho GEmail Notification

    Quote Originally Posted by pfabrici View Post
    Just tried it with a fresh 5.0.1 CE install and it worked.
    I was able to schedule one of the sample reports and send the result to an email address.
    Where did you find that video ?
    How id you do this please. I have this... and its not working

    Name:  PentahoSmtp.jpg
Views: 178
Size:  10.8 KB

    This config works in PDI 5.0.1 but do not work in BI-Server

    Server smtp.gmail.com
    Port: 465
    Use Authentication
    User : mygmailusername
    Pass : mygmailpass
    Secure Con Type : SSL
    Last edited by YonniQ; 04-23-2014 at 06:20 AM.

  8. #8
    Join Date
    Oct 2013
    Posts
    28

    Default

    I am facing problem on report mailing(scheduling) using BI server 5.1.0.0.752 i am scheduled report on mail in previous version 4.5,4.8,5.0 but here on latest stable BI server i cant find out any option of mailing report, if any one do this please share the process .

    Thans in advance

    Zay

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.