Techdasboard not updating

[elhenriq]

the techdasboard is not updating the water sensor data!

I am looking at the water data for INN. the data on the graphs has not been updated for the last 7 hours. but when I look at the device status, I see the data is coming in even though the card says it has not connected for 7 hours!.

[brianwdavis]

I'll check the DB and see what's going on

[brianwdavis]

Parsing, DB, and API all seem to be working as expected. Next up is to investigate the charting functions on the Tech Dashboard.

Good behavior in DB:

and API:

{
        "uid": "50773568",
        "node_serial_no": "18000641",
        "timestamp": "2023-05-09 14:00:00",
        "ts_up": "2023-05-09T14:04:52.606Z",
        "tdr_sensor_id": "13Acclima TR310S2.114000385",
        "center_depth": -80,
        "tdr_address": "C",
        "vwc": 10.8,
        "soil_temp": 24,
        "permittivity": 6.2,
        "ec_bulk": 19,
        "ec_pore_water": 690,
        "travel_time": "1555",
        "is_vwc_outlier": false,
        "vwc_outlier_who_decided": "-999",
        "vwc_outlier_comment": "-999",
        "code": "INN",
        "subplot": 2,
        "serial": "18000641",
        "trt": "b",
        "treatment": "b",
        "time_begin": "2023-05-08 00:00:00",
        "time_end": "2023-11-04 00:00:00"
    },

Bad behavior on TD:

[brianwdavis]

I think this is a bug in the time zone conversion. While investigating this, the time ticked over the hour, and now this node shows a point at 07:00. So there's data flowing in at the right rate. Looking at the data in the Network tab, it looks right with the DB, with a Unix timestamp of 1683644400, which is Tue May 09 2023 15:00:00 GMT+0000, which should be showing up as Tue May 09 2023 11:00:00 GMT-0400 (Eastern Daylight Time). But instead of subtracting 4 to get to EDT, it's subtracting 8, so it's doing the conversion twice. I'm going to move this issue.