apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform
https://superset.apache.org/
Apache License 2.0
62.45k stars 13.73k forks source link

Auto email dashboard on predefined date and time, is this possible ? #3393

Closed aakulks closed 5 years ago

aakulks commented 7 years ago

Hi All

I am using superset version 19. I am new in Superset, Currently searching auto mail facility in superset. Any body have any idea, please let me know.

Aakulks

xrmx commented 7 years ago

You should be able to implement it if you need it.

jackpgao commented 6 years ago

We want the same feature.

kingo55 commented 6 years ago

Have thought about this myself - May not be the most practical, but would a headless browser initiated via crontab do the job? That would allow you to capture all charts and tables on a dashboard. Meanwhile crontab is very flexible with scheduling.

Any tools to regularly screenshot web pages would do too. e.g. https://www.stillio.com/

Don't see how else dashboards / graphics can be generated serverside since all the charts are rendered client-side in the browser.

On Mon, 25 Dec 2017 at 18:09 jackpgao notifications@github.com wrote:

We want the same feature.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/apache/incubator-superset/issues/3393#issuecomment-353839951, or mute the thread https://github.com/notifications/unsubscribe-auth/ACQILEOXFr6qlMy3ZzUq9wL3Fa1r4cBAks5tD0oPgaJpZM4PGw6s .

masterlittle commented 6 years ago

Maybe phantom.js could be of help? Though it would also be client side rendering I guess. Haven't taken much look at it

jackpgao commented 6 years ago

We use python to take a capture of the dashboard, and send it with HTML.

It seems not so good, but it works.

jimanvlad commented 6 years ago

I'm also interested in this, as it's one of the main features we use in Tableau currently.

SpyderRivera commented 6 years ago

@jackpgao I am looking at implementing this feature. What are the issues with python capture? Resolution?

jackpgao commented 6 years ago

@SpyderRivera

Hi, use phantomjs to capture the whole Dashboard to a picture, then put it to an HTTP server dir, and you can visit the pic via a browser. In the end, you send an email with HTML format and the receiver can view the pic via email.

But there are 2 things to concern:

One is to force refresh the dashboard, cause superset use cache.

The other one is that, if the height of the pic is very long, in some email client it may crash, such as outlook, but with the Mac email client, it's ok to show the big pic.

stale[bot] commented 5 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.