Search found 6 matches

by juanrpaz
Wed Apr 07, 2021 12:33 pm
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Re: Database correction

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 rain...
by juanrpaz
Tue Apr 06, 2021 9:38 am
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Re: Database correction

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... Wiki ...
by juanrpaz
Fri Apr 02, 2021 8:38 pm
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Re: Database correction

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" "2021...
by juanrpaz
Fri Apr 02, 2021 9:22 am
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Re: Database correction

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:0...
by juanrpaz
Thu Apr 01, 2021 11:31 pm
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Re: Database correction

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,1...
by juanrpaz
Wed Mar 31, 2021 9:30 pm
Forum: Meteobridge PRO/NANOSD/RPI Discussion
Topic: Database correction
Replies: 9
Views: 366

Database correction

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 lin...