Monthly inject

David Caparrós

unread,

Jul 4, 2017, 2:06:33 PM7/4/17

to Node-RED

Good afternoon,

I'm trying to collect data for a power consumption on a easy way just to be shown on a chart on node red.

I try to get a report on the average per day, one per week an one per month.

Per day and week was easy just doing a inject a specific time a day to enable reading and inject to disable one minute later and at that time resetting the average however to get this done monthly I find the problem that inject longer period of time is once per week and I can not do it every 4 weeks or every specific day of the month (what should be great) and now I'm wonder if someone did already something like this and can bring me some idea.

The flow I did for day and week is:

Any sugegstion considering my knowledge is very limited is welcome.

Thanks in advance

Screen Shot 07-04-17 at 08.04 PM.PNG

David Caparrós

unread,

Jul 4, 2017, 2:12:40 PM7/4/17

to Node-RED

I just realized this is a bit stupid I have to move to a SQL or excel or will lose the data on every deploy.....I will have to study a bit to do something with more sense.

Thanks anyway

Mark Setrem

unread,

Jul 4, 2017, 2:47:38 PM7/4/17

to Node-RED

if you haven't already seen it, it might be worth taking a look at http://openenergymonitor.org their emoncms software works well with node-red

David Caparrós

unread,

Jul 4, 2017, 2:58:20 PM7/4/17

to Node-RED

Thanks Mark,

I read a lot about this but at the end I made my own power measurement module with a ESP module programmed with arduino and a clamp meter, total cost around 10$ including power supply and cable and I transmit the values trough MQTT, now I have only pending the part of storing and logging the data on long therms, I will have to study a bit about google spreadsheets or SQL.

I'm looking for some examples and tutorials now.

Regards

David Caparrós

unread,

Jul 4, 2017, 3:02:30 PM7/4/17

to Node-RED

Just some data management and integration with node-red I didn't know that, I'm going to investigate maybe I will save time for now and run away from SQL hahaha.

Thanks mate

El martes, 4 de julio de 2017, 20:47:38 (UTC+2), Mark Setrem escribió:

Colin Law

unread,

Jul 4, 2017, 3:07:54 PM7/4/17

to node...@googlegroups.com

If you want to record time series data and graph it then have a look
at influx db and grafana. They work very well using node red to put
the data into the db.

Colin

> --
> http://nodered.org
>
> Join us on Slack to continue the conversation: http://nodered.org/slack
> ---
> You received this message because you are subscribed to the Google Groups
> "Node-RED" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to node-red+u...@googlegroups.com.
> To post to this group, send email to node...@googlegroups.com.
> Visit this group at https://groups.google.com/group/node-red.
> To view this discussion on the web, visit
> https://groups.google.com/d/msgid/node-red/b5fb9272-0685-47ab-a5df-49977b0cd69c%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.

Petar Georgiev

unread,

Jul 5, 2017, 10:29:33 AM7/5/17

to Node-RED

Btw I'm currently logging all my feeds' data to MySql. I created a subflow that calculates SUM of all datapoints for "now() - 1 month". In my case I'm measuring watermeter's consumption. You can change it with AVG:

[{"id":"a4efb4b2.f8cd48","type":"function","z":"99c7790c.8a6f28","name":"Prepare SQL query","func":"\nvar d = new Date();\nvar m = d.getMonth();\nd.setMonth(d.getMonth() - 1);\n\n// If still in same month, set date to last day of \n// previous month\nif (d.getMonth() == m) d.setDate(0);\nd.setHours(0, 0, 0);\nd.setMilliseconds(0);\n\n\n\n\nmsg.key = msg.topic;\nmsg.topic = \"SELECT SUM(CAST(fd.`Value` as DECIMAL(10,2))) as value FROM `feeds` f INNER JOIN `feedsdata` fd on f.Id = fd.`FeedId` WHERE f.`Name` = '\" + msg.key + \"' AND fd.`DateTime` >= '\" + d.toISOString() + \"' \";\n//msg.payload = obj;\n\n\n\nreturn msg;","outputs":1,"noerr":0,"x":209,"y":192.60000944137573,"wires":[["c8554118.88a61"]]},{"id":"c8554118.88a61","type":"mysql","z":"99c7790c.8a6f28","mydb":"deb25814.dba388","name":"","x":200.0000762939453,"y":276.4000005722046,"wires":[["acf8e4cb.ed3ec8"]]},{"id":"acf8e4cb.ed3ec8","type":"function","z":"99c7790c.8a6f28","name":"Parse results","func":"msg.payload = msg.payload[0].value;\n\nreturn msg;","outputs":1,"noerr":0,"x":199.00006866455078,"y":359.2000513076782,"wires":[[]]},{"id":"deb25814.dba388","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"automation","tz":""}]

* The SQL tables and query need improvement: feed values are stored as string, and SQL query should use parameters.

David Caparrós

unread,

Jul 5, 2017, 1:52:07 PM7/5/17

to Node-RED

Thanks you guys I think I need to investigate a little bit more first, for the moment the question I have is.... how can I inject monthly? The standard inject module allow only per day of the week as max.

Regards

Mark Setrem

unread,

Jul 5, 2017, 3:15:51 PM7/5/17

to Node-RED

What do you mean by monthly? is it every 4 weeks i.e 13 months in a year which would allow you to compare usage more effectively, or a calendar month?
either way you could set the inject node to trigger daily and then have a function node to check if it's the first day of the "month" and only pass on a message if it is.

Max Hadley

unread,

Jul 5, 2017, 4:45:00 PM7/5/17

to Node-RED

Use an inject node to send a message once per day, followed by a function node that checks if the current day == 1, and only passes the message on if it is

Max

David Caparrós

unread,

Jul 5, 2017, 5:00:40 PM7/5/17

to Node-RED

Thank you guys, I found the what for me was the easiest solution, there is a node that uses "cron" from linux, with this is really simple to schedule any inject on demand.

Regards

Reply all

Reply to author

Forward