email set up of workbook and visulization

3 followers
0
Avatar

 

Hello,

Thanks for the response.

I have created the new post as required.

I am able to create the workbook with my import job . Now I want to send this report/workbook to multiple people via email. How can I send. ( data is small cab be send over email). This is a job which run every hour and email should go every hour.

Below is the answer of your query.

  • What exactly do you need to send - final sheet with calculation's results or workbook configuration?

Ans - I want to send the final sheet with calculation results to group of peoples.

  • What exactly problems do you face when trying to create an infographic

Ans - I am able to create visualization of the calculated results from workbook. But will it be possible that visualization should also change as data changes in my workbook. ?

Also, Can we send visualization as well via email to the group of peoples

 

Saurabh Jain

12 comments

  • Avatar
    Joel Stewart

    Hi Saurabh, there are a few features that Datameer includes which allow you to accomplish this. 

    First of all, there is a Notification feature in Datameer that allows you to automatically trigger an email when a workbook completes successfully. This can be sent to one or more team members. As a prerequisite, an administrator needs to configure an SMTP connection (see "Set up email notification" from the documentation) for the Datameer server. 

    Of note, this approach notifies users that the workbook is completed and shares a link to the data. The actual data result is not included in the body of the email. It will also link to any Infographics that are built from this data.

    For your second question about Infographics, be sure that when selecting data from a workbook result ensure that you include data from the "Latest Result" folder (not the "History" folder). This will ensure that the infographic updates automatically. whenever the underlying data is refreshed.

     

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    Hello,

    Thanks for the information.

    I am able to set up email notification of job completion and getting the link as well. Email exchange settings has been configured on datameer server.

    But as per my requirement, I want to send my visualisation result to multiple people in email body.

    Can it be possible via datameer ??

    If not, then can workbook be send as attachment in email to the same group of people.

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    Hello,

    In continuation of previous questions...

    Email alert of notification has link as well but when I click on the link to see the data. It is giving error "IP refused to connect.." Page cannot be displayed.

    Any suggestions ..? 

    0
    Comment actions Permalink
  • Avatar
    Gido

    Hello Saurabh,

    > Email alert of notification has link as well but when I click on the link to see the data.

    Depending on how your Datameer instance is configured it will be necessary to configure the address linked within the default.properties or live.properties file, i.e.: 

    [datameer@<host> current]$ grep -i "server.address" conf/live.properties
    system.property.server.address=https://<host>:8443

    For more information see our Installation Guide and documentation Configuring Email Servers

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    Hello,

    Thanks for the information.

    I am able to set up email notification of job completion and getting the link as well. Email exchange settings has been configured on datameer server.

    But as per my requirement, I want to send my visualization result to multiple people in email body.

    Can it be possible via datameer ??

    If not, then can workbook be send as attachment in email to the same group of people.

    0
    Comment actions Permalink
  • Avatar
    Gido

    Hello Saurabh, 

    > But as per my requirement, I want to send my visualisation result to multiple people in email body.

    We have already feature request open which is PDF export and automated messaging. Please understand that this is not fully finished yet. 

    Meanwhile you may use the functionality of your browser to print a page into PDF. This could be send via afterwards. 

    > If not, then can workbook be send as attachment in email to the same group of people.

    You may consider that the Workbook view is often a small section of a huge dataset. A final report can vary from a few records only up to TB with billions of records. Because of this there is no possibility to send the a Workbook via email directly. 

    However, it would be possible to Export the Data into a file and setup script or other functionality which monitor, pack and send it automatically to an email distribution. 

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    >If not, then can workbook be send as attachment in email to the same group of people.

    How can we do the same. ?

    My workbook is small enough that can be send as attachment over email and it is a fixed size. we replace the previous data from workbook.

     

    >However, it would be possible to Export the Data into a file

    How can I save my workbook into my local disk. Once it will come my local then I can write script for email and monitor.

     

     

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    >You can create Export Jobs to export data from Datameer. By doing this it would be possible to Export the Data into a file.

    I would like to go with this option where my workbook should download automatically whenever workbook execution complete.

    To create the job. how shall I go forward to create the connection. "Shall I select "datameer server file system" or something else.?

    Please help in detail. 

    0
    Comment actions Permalink
  • Avatar
    Konsta Danyliuk

     

    Hello Saurabh,

    As per our documentation for Export the Data, you could export Workbook's sheet into a file or Database / Hive table.

    To import/export data into/from Datameer, you need an artefact called Connection, which is simply data source configuration. Configuring a Connection has more details on how to create a Connection.

    If we would consider your particular use-case, you could export result sheet of your Workbook into a CSV file. This file could be exported into any location, which is convenient for you and supported by Datameer, e.g. HDFS folder, FTP folder, remote folder available via SSH - please double check appropriate documentation for more details.

    It is also available to configure folder for export in Datameer Server Filesystem, but please note that this option sin't available to Enterprise environments.

    I hope provided documentations help you to setup your artefacts.

    0
    Comment actions Permalink
  • Avatar
    Saurabh Jain

    Hello,

    I am creating FTP/SFTP connection and getting below error -

    java.lang.RuntimeException: Cannot create connection. 
    Reason is awstasks.com.jcraft.jsch.JSchException: Session.connect: java.net.ConnectException: Connection refused

    Could you please assist on the same.
    0
    Comment actions Permalink
  • Avatar
    Konsta Danyliuk

    Hello Saurabh,

    Connection refused

    This message usually points to communication problems. I would recommend to ensure that:

    • FTP server is accessible and corresponding ports are open.
    • Connections are allowed from Datameer host to FTP server.
    • Credentials are correct.

    It would be also useful to check FTP server logs to get more details on the reason of refused connection.

    0
    Comment actions Permalink
Please sign in to leave a comment.