{"id":26,"date":"2015-12-11T12:18:28","date_gmt":"2015-12-11T12:18:28","guid":{"rendered":"http:\/\/www.sqldashboards.com\/b\/?p=26"},"modified":"2015-12-11T12:18:28","modified_gmt":"2015-12-11T12:18:28","slug":"send-email-with-graphs","status":"publish","type":"post","link":"https:\/\/www.sqldashboards.com\/b\/send-email-with-graphs\/","title":{"rendered":"Sending an email with pie charts and graphs"},"content":{"rendered":"

The following steps explain how to send an email with chart image attachments from the command line. First we must install the necessary email tools in linux:<\/p>\n

Install Email Sending on Linux<\/h4>\n


\napt-get install mutt
\nvi ~\/.muttrc
\n<\/code><\/p>\n

That last line, opens the configuration for editing. For gmail you will have details like this:
\n
\naccount-hook imap:\/\/gmail\/ \u201cset<\/p>\n

set imap_user = 'user@domain.com'
\nset imap_pass = 'PASSWORD'<\/p>\n

set smtp_url = 'smtp:\/\/user@domain.com@smtp.gmail.com:587\/'<\/p>\n

set smtp_pass = 'PASSWORD'
\nset from = 'user@domain.com'
\nset realname = 'John'<\/p>\n

set folder = 'imaps:\/\/imap.gmail.com:993'
\nset mbox= '+Inbox'
\nset spoolfile= '+Inbox'
\nset postponed= '+[Gmail]\/Drafts'
\nset trash = '+[Google Mail]\/Trash'<\/p>\n

set header_cache=~\/.mutt\/cache\/headers
\nset message_cachedir=~\/.mutt\/cache\/bodies
\nset certificate_file=~\/.mutt\/certificates<\/p>\n

set move = no
\nset timeout=15
\nauto_view text\/html
\n<\/code><\/p>\n

To test this, first run “mutt”, it should display your gmail inbox. Then send an email using the command:
\nmutt -s \"test\" receiver@domain.com <<< \"test message\"<\/code><\/p>\n

Install sqlChart and generate pie charts<\/h4>\n
    \n
  1. Download sqlDashboards.jar<\/a><\/li>\n
  2. Copy it to your \/usr\/local\/bin directory<\/li>\n
  3. Create an alias so we can run it with a shorter name<\/li>\n
  4. Run command to generate chart<\/li>\n<\/ol>\n


    \nwget http:\/\/www.sqldashboards.com\/files\/sqldashboards.jar
    \nmv sqldashboards.jar \/usr\/local\/bin\/
    \nalias sqlchart=\"java -cp \/usr\/local\/bin\/sqldashboards.jar com.timestored.sqldash.SqlChart\"<\/p>\n

    sqlchart --servertype mysql --chart piechart --user USERNAME --password PASSWORD --database DATABASENAME--out pie.png --execute \"select DATE(time),count(*) from qstudioreg group by DATE(time) ORDER BY DATE(time) DESC limit 9\"
    \n<\/code><\/p>\n

    Voila we have our chart:
    \n    \"database<\/a><\/p>\n

    Send email with attachments<\/h4>\n

    Use mutt to send the email, with -a to specify attachments like so:
    \n mutt -s \"sql pie chart reports\" ryan@timestored.com -a pie.png <<< \"Here is your database report\"<\/code><\/p>\n

    Done. So we successfully configured mutt for sending email, then generated our pie chart from mysql using sqlchart<\/a> then we emailed it as an attachment. If you have any problems please let me know and I'll try to help. Here's the email in my inbox:<\/p>\n

    \"mail\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    The following steps explain how to send an email with chart image attachments from the command line. First we must install the necessary email tools in linux: Install Email Sending on Linux apt-get install mutt vi ~\/.muttrc That last line, opens the configuration for editing. For gmail you will have details like this: account-hook imap:\/\/gmail\/ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/posts\/26"}],"collection":[{"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":9,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":37,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/posts\/26\/revisions\/37"}],"wp:attachment":[{"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqldashboards.com\/b\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}