Problem with data adquisition

[Mikhail]

When a device is disconnected, channel status = 0. You should also store status in the database, or use status to convert values to NULL if status is zero.

[feltduck]

And how can I check the data in a specific hour? E.g I got a NULL value because the devices get disconnected at 10:15 and I want to check at that hour and replace that NULL for the real value of the device at 10:15.

Sorry if I’m asking too much.

[Mikhail]

SQL functions should be used. First of all, get the correct raw data. Then try using SQL functions to add some processing.

[feltduck]

What do you mean with “Get the correct raw data”?

• This reply was modified 3 years ago by feltduck.

[Mikhail]

I mean get channel value and status in your database. After that play with SQL functions to set channel value to NULL if status = 0.

[feltduck]

Sorry for the confusion, I already fixed that problem. I was asking you how to check the historic of 15 days ago from now.

[Mikhail]

You can send a string command like

cmd=ExportArchive
startDT=2022-12-23 10:00:00
endDT=2022-12-23 11:00:00

to export historical data.
When DB Export module receives such command, it executes the historical data queries that exist in the module configuration.

[feltduck]

Hi,
I’ve been trying this one and I didn’t get any result. Maybe I’m not doing it well, how can I send a command to the DB export module?

[Mikhail]

Hi,
You need a channel of the Output type. Command code must match with the module. If you provide screenshots of the settings and sending command, I could check.

[Author]

Posts