I have now sorted it, needed to calculate the differences in the rain for each 5 min intervall, now I have the right total sum
thanks anyways for all your help, really appreciated Markus Lösch schrieb am Donnerstag, 5. Juni 2025 um 17:45:11 UTC+2: > I tried it and was not succesful, I mean I got it right with the rainRate, > but not with the rain. > it showed me much higher values as it was yesterday. > [image: Unbenannt3.PNG] > > I had 15.3mm total yesterday, here it shows me a total of 181,6mm. > I used the hourly column of the excel, since it has the lowest values... > > I used inch values for the database, since it is set to US in the > weewx.conf > > Markus Lösch schrieb am Donnerstag, 5. Juni 2025 um 15:13:38 UTC+2: > >> 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/55755c96-46ff-445e-876a-2c2457e13c3bn%40googlegroups.com.
