Write to a groov Data Store table with Node-RED

[Beno]

In case you missed it, @torchard has written up a nice solution for writing to a groov DataStore table (string, floats or ints) from a single Node-RED groov Write Node.

This is a massive advantage if you are reading records from a database and displaying it on groov pages.
(ie, select * from db).

Writing a groov table with a single node

The simplest way to get an array from Node-RED to a groov data store table is to make a single write node for each of the tag’s indices, which is all good and well for small tables but for larger lists this quickly becomes ugly and cumbersome. One work around I have found is to use JavaScript in a function node to turn the list into a message payload array of specially constructed objects that gets separated by a split node to write many values, even an entire table, using only a single groov n…

[j.okekporo]

@Beno I am trying to move data from Modbus TCP tag into Groov Datastore. I have seen that this is not possible as each data source tag store is isolated from another. Are there ways to realize this as have tried using the Node-RED groov write node which i was able to do by manually testing msg.value but couldn’t write modbus tag to it.

[Beno]

We do it here at Opto for testing different devices and many customers also move modbus data to the groov data store tag.

Put a debug node on the output of the modbus node, double click it and set it to ‘complete msg object’.
Take a look at what the msg property path is and use that in the groov data store node.