meteohub.de

Hi Gyvate,

Yes rain database update was trickier due to various reasons. I wanted to check today with a testrain.txt direct file, wihich contained in two different ocassions the following data, to check for proper input data into sensor time slot...

1617706800 rain0total 1.0 (to check for total ...

Thanks Gyvate for the follow up and help

Database is properly updated now via direct files, which I find the best solution. It is 'native' to MB, and goes direct to the 'sensor data value square' the data are to be corrected/updated.

A bit of my own feedback may lead to better understanding ...

Thanks for noticing, changed single quotes for doubles, like

"2021-01-01 04:30:00","10.3","10.3","10.2","75.0","6.0","20.0","31.5","335.0","0.000","0.000","1016.500","0.0","5.5"
"2021-01-01 04:35:00","10.4","10.4","10.3","76.0","6.3","19.6","35.4","336.0","0.000","0.200","1016.700","0.0","5.7 ...

Tried again, respecting ordering and formatting of the data, these are the system logging messages,

import (01.04.2021 23:45:36): import of file "MTENE2021.txt" (960 kb) started: type 3, mode 1
import (01.04.2021 23:45:36): completed 8216 lines, performing 0 database updates.
import (02.04.2021 00 ...

Honestly, I didn't.

I downloaded the database from MT, which comes in a format like below,

2021-01-01 00:00:00,10.9,10.9,10.9,73.0,6.2,21.8,37.0,335.0,0.000,0.000,1016.800,0.0,5.8
2021-01-01 00:05:00,11.1,11.1,10.9,74.0,6.6,23.6,43.4,339.0,0.000,0.000,1016.700,0.0,5.7
2021-01-01 00:10:00,11.1,11.2 ...

Good evening, here is UTC+1...

I am trying to correct the data in the RPI as I know some are not correct.

I exported 'standard-iso-202101-hour' edited for corrections in Excel and saved back as a text file, csv.

When trying to import the file with the correct data, MB says

' invalid timestamp in ...