How to record data in csv and excel file

[Steve-Mcl]

@aminulhaq

I meant to say when i connect to point then csv file is getting data and saving to file
but when i connect csv node to point 2 then it is not getting data and save to file

And that is because of what I said in my previous post...

@Steve-Mcl

Since you set the CSV node columns as ...

it is expecting you to feed it with data that looks like {"frequency": 49.29, "Hz": 50}

The fact it works by connecting to the modbus node is because that data is an array of 2 values and you have 2 entries in the column field.

SO - your options are depenedant on what you are trying to achieve. Do you want 1 value in the file or 2 values in the file?

If you simply want the value of item2 - set the column field to item2

The better solution...

A better solution is to do what I suggested in the previous thread...

@Steve-Mcl

If you are reading registers 240-241 AND registers 256-257 then I strongly recommend you read all registers from 240~257 in one MODBUS node and use the parser to pick out the values of interest. This has the following advantages....

1. values are read at the same scan of the device (and are therefore consistent)
2. reading 1 modbus poll of 28 items is faster than 2 modbus polls. This will only get worse with each additional single read/poll.
3. Individual modbus comms lead to contention on the wire (and eventually timeouts - search the forum - covered many times)

@Steve-Mcl

Use the offset to access other bytes,

MB address	Returns	offset byte
240	16 bit integer (2 bytes)	0
241	16 bit integer (2 bytes)	2
242	16 bit integer (2 bytes)	4
243	16 bit integer (2 bytes)	6
244	16 bit integer (2 bytes)	8
245	16 bit integer (2 bytes)	10
246	16 bit integer (2 bytes)	12
247	16 bit integer (2 bytes)	14
248	16 bit integer (2 bytes)	16
249	16 bit integer (2 bytes)	18
250	16 bit integer (2 bytes)	20
251	16 bit integer (2 bytes)	22
252	16 bit integer (2 bytes)	24
253	16 bit integer (2 bytes)	26
254	16 bit integer (2 bytes)	28
255	16 bit integer (2 bytes)	30
256	16 bit integer (2 bytes)	32
257	16 bit integer (2 bytes)	34

e.g...

If you do this and set the CSV column to energy,voltage then it will log both fields together with consistency (i.e. values read at the same point in time)