# Node-red to influxdb atlas scientific

**URL:** <https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114>\
**Category:** General\
**Created:** [3 May 2022 10:59 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114 "2022-05-03T10:59:30Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![btbr](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@btbr](https://discourse.nodered.org/u/btbr)\
**Post date:** [3 May 2022 10:59 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/1 "2022-05-03T10:59:30Z")

</div>

Hello everyone. I am a three week in noobs so please be patient if I'm a bit slow.

I have data from two Atlas Scientific sensors coming into node red through MQTT to go to Influxdb. The value field was a string, not a number. I have changed this in the Change Node to be a number. Changed the time to a timestamp, deleted the name and the address and kept the ModuleType as it was.

I did this as Influxdb wasn't seeing the value so couldn't get it to graph. Now its not seeing the value as a field so isn't there at all.

Any idea what I am doing wrong? Thank you very much.

@grant1 @Fishy

---

<div class="post-metadata">

**Author:** ![btbr](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@btbr](https://discourse.nodered.org/u/btbr)\
**Post date:** [3 May 2022 11:02 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/2 "2022-05-03T11:02:59Z")

</div>

![2022-05-03-114710_3840x2160_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/9/492c7702a5edf34bf3e93b88937fbd283910b451.png)  
 ![2022-05-03-114938_3840x2160_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/c/0cc4eeaf877bc640cb0cbb88c37aa56100d525b9.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [3 May 2022 12:07 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/3 "2022-05-03T12:07:06Z")

</div>

If you managed to pass through your value to InfluxDB as a string initially, it has now recorded it as a string so the numbers you are sending won't be right.

If that is the case, the easiest thing to do is drop and recreate the measure.

---

<div class="post-metadata">

**Author:** ![btbr](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@btbr](https://discourse.nodered.org/u/btbr)\
**Post date:** [3 May 2022 12:13 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/4 "2022-05-03T12:13:36Z")

</div>

Hello TI,

Thank you very much for your reply.

When I initially sent my message to Influx it didn't see the value as a number and wouldn't work. It seems from another post on here that I had to change it to a number so it would graph it - see picture.

I've only been doing this three weeks so sorry for being stupid, but I don't understand what 'drop and recreate the measure' means?

> [@NRD to Influxdb-strings](https://discourse.nodered.org/t/nrd-to-influxdb-strings/53315/2):
>
> 07/11/2021, 10:33:16node: 8127b9f1260f2605 Sys4/ORP/add98/ORPsys4 : msg.payload : string[2] "77" As I understand it, you just want the "77" from the above output, which as you noted is a string. I had a similar question and I learned you can use a change node, regex, or match to 'extract' the value you want. See [here](https://discourse.nodered.org/t/split-string-into-text-and-integers/49889/8).

 ![Screen Shot 2022-05-03 at 13.12.35](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/3/93ddd6cfe50e437ce9c170943915b89a57385369.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [3 May 2022 12:36 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/5 "2022-05-03T12:36:39Z")

</div>

> [@btbr](#):
>
> being stupid

Nope, not stupid at all. This is a very common issue with InfluxDB. It takes the data type from the first message you send it. It then will not change it.

> [@btbr](#):
>
> I don't understand what 'drop and recreate the measure' means?

To be honest, if you are just getting started, I would recommend dropping (deleting) the whole database and starting again.

Here is an article I posted ages back about terminology and recommended structure in InfluxDB in case it helps. [Need more detailed information on influxdb - General - Node-RED Forum (nodered.org)](https://discourse.nodered.org/t/need-more-detailed-information-on-influxdb/36885/5)

And don't worry, InfluxDB is mind-twisting to get started on but once you've set it up, it all "just works".

---

<div class="post-metadata">

**Author:** ![btbr](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@btbr](https://discourse.nodered.org/u/btbr)\
**Post date:** [3 May 2022 13:19 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/6 "2022-05-03T13:19:16Z")

</div>

Thank you so much. Deleted the bucket. made new bucket and it all works. Not sure if I would ever have worked that out. Finally, very happy indeed.

Both sensors don't seem to work in the same bucket. Maybe it is the way I'm sending the data or maybe I do need to use different buckets?

Thank you so much, have a great day!!!

---

<div class="post-metadata">

**Author:** ![Fishy](https://avatars.discourse-cdn.com/v4/letter/f/da6949/32.png) [@Fishy](https://discourse.nodered.org/u/Fishy)\
**Post date:** [5 May 2022 11:51 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/7 "2022-05-05T11:51:58Z")

</div>

Hi Mark, this is what i ended up doing.

 ![Screenshot 2022-05-05 214009](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/a/ba10cddad95266b60f73719826c3deae24d60f94.png)  
 ![Screenshot 2022-05-05 214329](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/7/87a63e2f62e8a951044fa09db2f93a227a95b87d.png)  
 ![Screenshot 2022-05-05 214432](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/b/9b200cb257a2981396fcb7c5883b168445aa1188.png)  
 ![Screenshot 2022-05-05 214522](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/9/09b9e21e8ae53f1af2ed2bf92991a783e333b6fe.png)  
 ![Screenshot 2022-05-05 214624](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/3/93e3a578c992c3a42df99db9d8dbc2a69b607147.png)  
PeterN

---

<div class="post-metadata">

**Author:** ![btbr](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@btbr](https://discourse.nodered.org/u/btbr)\
**Post date:** [5 May 2022 13:53 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/8 "2022-05-05T13:53:34Z")

</div>

Thank you very much for your reply.

I ended up doing it slightly differently, but with the same result.

Having to delete the influxdb bucket and remake before it would see the new data got me.

Thanks,

Mark

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [4 July 2022 13:54 UTC](https://discourse.nodered.org/t/node-red-to-influxdb-atlas-scientific/62114/9 "2022-07-04T13:54:02Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.