How To? - Email CSV Via Crontab - Help Me Please

Emoncms
1

On the 10th of every month, I want to email an address a CSV that goes back 45 days on two feeds.

Can I setup a graph, and run bla.php > email.csv and script it all to email?

Any ideas? I saw the email reports plugin, but I do not need a report. I need raw data.

2

Have you tried just piping stdout i.e. run bla.php | mail -s ‘Here you are’ [email protected] ?

3

You can use the Feed API to get the data (details top right of Feeds page)

http://x.x.x.x/emoncms/feed/csvexport.json?id=0&start=UNIXTIME&end=UNIXTIME&interval=60&timeformat=1

Probably a bit of python would do it.