thanks for that explanation, I currently tried it with the sqlitebrowser, but when I want to open the database, I receive the following error:
*sudo sqlitebrowser /var/lib/weewx/weewx.sdbqt.qpa.xcb: could not connect to displayqt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem.Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vnc, xcb.Aborted* I copied the database on my windows machine and opened it with "DB Browser for SQLite" and checked the fields rain and rainRate in the table "archive" [image: sqlite_browser.PNG] [image: export_csv.PNG] here I can insert the values manually according to the exported csv. I think it takes me more then one intervall (5 Minutes) to insert all the values. I would think the best thing is to stop weewx after the latest intervall, insert all the values, copy the file back, start weewx again. after that I run weectl database rebuild-daily --date=2025-06-04 that the database is rebuild for yesterday. would that be the right thing to do? Rainer Lang schrieb am Donnerstag, 5. Juni 2025 um 12:07:41 UTC+2: > if it's only rain data from yesterday, you can look them up in your > dashboard at ecowitt.net - assuming you have your console post there > And then I would install sqlitebrowser (unless it's already part of your > Linux installation) and edit and save the data directly in the database > (make a safety copy of the database before 😉) > > try > > sudo sqlitebrowser /var/lib/weewx/weewx.sdb > > or whatever is your weewx database location > (you have to open it with root rights, otherwise you will not be able to > change fields) > > if it's not included, install it first > > sudo apt install sqlitebrowser (assuming apt is your package manager) > > find your time (it's EPOCH format - maybe ww.epochconverter.com would be > helpful) - locate the rain and rainrate fields and change then accordingly > - hint: for changed dsts to be accepted, you have to click with the mouse > into another field > > Make sure that you save your changes between weewx dabatase activities - > let's between minute 2 and 4 of your (assumed) 5 minute weewx archiving > cycle > e.g. weewx archives at xx:00, xx:05, xx:10 etc. - you save your sqlite > browser changes at xx:02 - xx:04 etc. - not to interfere with weewx > or > once you have done the changes, shutdown weewx after the archiving, save > your sqlitebrowser changes and restart weewx > > you will have to rebuild the database indexes for yesterday for the data > to become visible in your skin (--> weectl database) > > > On 05.06.2025 11:25, Markus Lösch wrote: > > Thanks Rainer, I disabled now the customized server also. At least, it > seems to run pretty good now with the GW1000 Driver, I also had some > entries in the database, so I wait for the next rain and see if it is > working properly. > > I will have a look at it, it is quite huge and a lot to read, but when I > do have some time in the evening, I will do it ;) > > > But if you can maybe answer me my question, if it is possible to import > the missing rain data of yesterday, and if there is any extension needed, > that would be appreciated :-) > > Rainer Lang schrieb am Donnerstag, 5. Juni 2025 um 09:25:41 UTC+2: > >> if you take the time to read the Ecowitt WiKi >> >> >> https://meshka.eu/Ecowitt/dokuwiki/doku.php?id=start#data_flow_between_sensors_consoles_application_software_and_internet_weather_services >> to understand how Ecowitt (clone) consoles communicate >> >> and also the weewx chapter in the Ecowitt WiKi >> >> https://meshka.eu/Ecowitt/dokuwiki/doku.php?id=dataloggers#weewx >> you will get a better understanding of what you are doing and what you >> have to do >> also where (and how) to store your rain data >> there are several ways/options how to do this >> >> in short >> 1. you don't need the customized server when using the local Ecowitt API >> driver (a.k.a. GW1000 driver) >> 2. there is also an extended version of the Interceptor driver which even >> provides data the local Ecowitt API driver does not (and cannot) provide. >> The "bare-metal" version of the Interceptor driver as available in >> Matthews repository is hopeless with a modern Ecowitt station and needs >> quite a few adaptations >> which a German developer has thankfully made and it works perfectly. >> 3. there are several advantages to using the GW1000 drivers, especially >> to catch correct data as the customized server posting is (downward) >> limited to 8 seconds, >> whereas the local Ecowitt API driver can theoretically poll data on a >> one-second basis if this is wanted and considered to provide added value. >> On 05.06.2025 09:09, Markus Lösch wrote: >> >> oh and another question I forgot to ask... >> I set the customizued server to enabled for the Interceptor Driver. Now, >> I assume, for the GW1000 driver it is not needed anymore, right ? >> >> Markus Lösch schrieb am Donnerstag, 5. Juni 2025 um 09:06:05 UTC+2: >> >>> Thanks guys, I switched now to GW1000 Driver. Test driver also seems to >>> be looking quite good. >>> >>> Is there any chance to add the rain data in the database? I had 15.3mm >>> rain yesterday, which is also the week, month and year totatl, since I >>> started the weather station on tuesday night. >>> [image: rain.PNG] >>> >>> >>> vince schrieb am Mittwoch, 4. Juni 2025 um 23:08:17 UTC+2: >>> >>> In case you switch to the nice gw1000 driver via Ian's link, here's my >>> old config for my WS85 which is similar to your WS90, as well as the >>> incantation to test the driver interactively. Be a little forewarned this >>> was quite a while ago and I decommissioned the ecowitt haptic sensor >>> because it wasn't too accurate, but the weewx setup did work as I recall. >>> Your paths vs. the example --test-driver below will vary if you did a dpkg >>> installation. >>> >>> [GW1000] >>> # This section is for the Ecowitt Gateway driver. >>> >>> # How often to poll the API, default is every 20 seconds: >>> poll_interval = 20 >>> >>> # The driver to use: >>> driver = user.gw1000 >>> ip_address = 192.168.2.87 # gw1200 >>> port = 45000 >>> [[field_map_extensions]] >>> outTempBatteryStatus = wh26_batt >>> batteryStatus1 = wh31_ch1__batt >>> batteryStatus2 = wh31_ch2__batt >>> batteryStatus3 = wh31_ch3__batt >>> batteryStatus4 = wh31_ch4__batt >>> batteryStatus5 = wh31_ch5__batt >>> batteryStatus8 = wh51_ch1__batt >>> soilTemp1 = temp9 # wh34 >>> ######batteryStatus8 = wh34_ch1__batt >>> rain = p_rain >>> stormRain = p_rainevent >>> rainRate = p_rainrate >>> dayRain = p_rainday >>> weekRain = p_rainweek >>> monthRain = p_rainmonth >>> yearRain = p_rainyear >>> >>> windBatteryStatus = ws85_batt >>> >>> # PYTHONPATH=~/weewx/src python3 ~/weewx-data/bin/user/gw1000.py >>> --test-driver --ip-address=192.168.2.87 >>> # 2024-08-30 11:01:19 PDT (1725040879): 'dateTime': >>> '1725040879', 'daymaxwind': '2.9', 'extraHumid1': '56', 'extraHumid2': >>> '54', 'extraHumid3': '56', 'extraHumid4': '59', 'extraHumid5': '70', >>> 'extraTemp1': '23.3', 'extraTemp2': '22.2', 'extraTemp3': '22.1', >>> 'extraTemp4': '22.0', 'extraTemp5': '21.8', 'extraTemp9': '17.8', >>> 'inHumidity': '53', 'inTemp': '22.5', 'outHumidity': '77', 'outTemp': >>> '19.5', 'p_dayRain': '0.0', 'p_monthRain': '34.3', 'p_rain': 'None', >>> 'p_rainRate': '0.0', 'p_stormRain': '0.0', 'p_weekRain': '1.0', >>> 'p_yearRain': '42.4', 'pressure': '1006.5', 'relbarometer': '1006.5', >>> 'soilMoist1': '41', 'usUnits': '17', 'wh31_ch1_batt': '0', 'wh31_ch1_sig': >>> '4', 'wh31_ch2_batt': '0', 'wh31_ch2_sig': '4', 'wh31_ch3_batt': '0', >>> 'wh31_ch3_sig': '4', 'wh31_ch4_batt': '0', 'wh31_ch4_sig': '4', >>> 'wh31_ch5_batt': '0', 'wh31_ch5_sig': '4', 'wh32_batt': '0', 'wh32_sig': >>> '4', 'wh51_ch1_batt': '1.4', 'wh51_ch1_sig': '4', 'windDir': '280', >>> 'windGust': '1.2', 'windSpeed': '1.1', 'wn34_ch1_batt': '1.5', >>> 'wn34_ch1_sig': '4', 'ws85_batt': '3.08', 'ws85_sig': '4' >>> >>> >>> On Wednesday, June 4, 2025 at 2:01:24 PM UTC-7 Steeple Ian wrote: >>> >>> There is a fork of the GW1000 driver here which was synced with Gary's >>> main branch just before he went 'off air'. It is a better bet than the >>> Interceptor driver. I have GW1000, GW2000 and GW3000 devices and they all >>> wrk perfectly. >>> >>> https://github.com/Millardiang/weewx-gw1000 >>> >>> On Wednesday, June 4, 2025 at 10:37:53 PM UTC+2 Markus Lösch wrote: >>> >>> Also after some rain now, nothing shows up at rain. There is also >>> nothing written down in the database… >>> Anyone that can help? >>> >>> chin0x schrieb am Mittwoch, 4. Juni 2025 um 14:47:06 UTC+2: >>> >>> Hey guys, >>> >>> I've been going through some discussions but not quite sure if I did >>> everything rigth. >>> >>> Due to the circumstances that the GW1000 Driver is all of a sudden not >>> available anymore, I decided to use the Interceptor driver when I changed >>> from "Simulation" to "Productive" mode yesterday evening. >>> >>> I found out that the rain is not available in the database and saw some >>> discussions about it. >>> What I now did was adding some values to the Interceptor Stanza in the >>> weewx.conf: >>> [Interceptor] >>> driver = user.interceptor >>> device_type = ecowitt-client >>> port = 8000 >>> [[sensor_map_extensions]] >>> rain = drain_piezo >>> rainRate = rrain_piezo >>> supplyVoltage = wh90batt >>> referenceVoltage = ws90cap_volt >>> >>> But it shows me no rain in my skins. Currently it is not raining, but >>> there was rain this morning. Is the data only filling the actuall rain into >>> the database or also the data from this morning? If not from this morning, >>> how can I insert that data afterwards ? >>> >>> in the log it shows me the following entries: >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter runtime=80319 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter heap=94012 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter vpd=0.071 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter rrain_piezo=0.000 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter erain_piezo=0.157 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter hrain_piezo=0.008 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter drain_piezo=0.157 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter wrain_piezo=0.157 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter mrain_piezo=0.157 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter yrain_piezo=0.157 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter srain_piezo=1 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter ws90cap_volt=2.5 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter ws90_ver=155 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter wh90batt=3.14 >>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>> parameter interval=16 >>> >>> so rain is showing some values here... >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion visit >> https://groups.google.com/d/msgid/weewx-user/032b665e-e83b-48dc-90c9-dff2c1f781aen%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/032b665e-e83b-48dc-90c9-dff2c1f781aen%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To view this discussion visit > https://groups.google.com/d/msgid/weewx-user/4bfbe008-6e49-4331-8d26-382520910d2dn%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/4bfbe008-6e49-4331-8d26-382520910d2dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/0ad9247f-b729-414b-9f91-859f981638acn%40googlegroups.com.
