# Reading Modbus and Writing to Database
**URL:** https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284
**Category:** General
**Tags:** modbus
**Created:** [16 February 2023 09:30 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284 "2023-02-16T09:30:20Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Seymi](https://discourse.nodered.org/u/Seymi)
#### Post date: [16 February 2023 09:30 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/1 "2023-02-16T09:30:20Z")
I am getting the data in this format but I can't write this data format to a database. I must split these datas for writing to database as 1 or 0 format. Which function code should i use to format data and write it to database.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [16 February 2023 10:37 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/2 "2023-02-16T10:37:57Z")
Welcome to the forum @Seymi
Is this a college assignment?
---
### Author:  [@Seymi](https://discourse.nodered.org/u/Seymi)
#### Post date: [16 February 2023 10:54 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/3 "2023-02-16T10:54:46Z")
No I am an intern in a factory this is my assignment.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [16 February 2023 11:09 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/4 "2023-02-16T11:09:08Z")
Are you sure that you just need to send a set of true/false values to the database?
If so, then what database type is it and what are the fields of the table it has to be written to?
---
### Author:  [@Seymi](https://discourse.nodered.org/u/Seymi)
#### Post date: [16 February 2023 11:11 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/5 "2023-02-16T11:11:47Z")
Those values are indicators for the machine status. If first bit is 1 then machine 1 is ON. If second bit is 0 then machine 2 is OFF.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [16 February 2023 11:13 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/6 "2023-02-16T11:13:38Z")
OK, so what is the answer to my other question?
> [@Colin](#):
>
> what database type is it and what are the fields of the table it has to be written to
---
### Author:  [@Seymi](https://discourse.nodered.org/u/Seymi)
#### Post date: [16 February 2023 11:24 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/7 "2023-02-16T11:24:45Z")
The table has DT (DateTime), SENSOR(Int) and SENSOR\_VALUE(Int) fields. The database is MariaDB.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [16 February 2023 13:23 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/8 "2023-02-16T13:23:44Z")
Is the sensor the index into the array?
So is that one row in the table for each element in the array?
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [17 April 2023 13:24 UTC](https://discourse.nodered.org/t/reading-modbus-and-writing-to-database/75284/9 "2023-04-17T13:24:34Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.