Did you submit an issue against the node?
Great! Starts working, Thank you very much Colin
Now how to get the daily & monthly report out of influxDB?
No I didn't think to do that because It's a limitation of that node and not an "issue" in terms of a bug. I only wanted to make Rsich aware of this and that there are other ways to write data to influxDB - that's all. With your assistance (and also from other forum members) he seems to have it working now.
What is the limitation?
Works well for writing floats and strings. Integers get written to influxDB too but only as floats or string fields too depending on how you set up the write in the node (as far as I can tell). Not being able to write integers as integers in influxDB can be an issue for some types of queries such as when you want to count the occurrence of a number of events over a period of time etc. I have found writing to the database using HTTP is easier and preserves data types. (just my personal preference).
Regardless of all of this, I only wanted to point out there are other ways to write to InfluxDB than just the influx node. I certainly did not want to create a sub thread or some sort of side issue on the forum so I won't be posting about this again in this thread.
OK, yes I understand. Thanks.
Hi Colin, the limitation mentioned was the the no of messages per day in the node-red forum is
max 7, need to wait for 24 hrs, that is why I couldn't reply you that day.
Pls advise how to generate periodic reports - daily & monthly, from InfluxDB logged data
Hi Micheal, could you pls send a sample, how to use HTTP to log all data types on InfluxDB
Unless you specifically need to have integer or Boolean type fields in the database then the influx nodes are fine. I believe all the examples you quoted would be float types.
Yes , all are float types, working well, thanks
Interested to know how to include integer & binary fields, in the influxdb.
Integers from DHT11sensors , DS18B20 sensors through I2C bus & binary signals are coming from Raspberry pi3 B+
An integer value can be be stored in a Float type. A non-integer float value cannot be stored in an Int type. If you have a value that is always an integer then I assume there is a small saving to be had by using Int field type but unless you are storing massive amounts of data I would not worry about it. I don't think there is a binary field type.
To use a non-float type I think you will have to use the direct http API rather than using the influx nodes.
Having said that I don't know whether it is possible to pre-define a field type and whether, if you did, then you could use the influx nodes and influx would convert the values for you.
[Edit] Oops, that is for influx v2 which is not supported yet. No doubt google will find the ones for 1.8
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
