[weewx-user] Re: how to add new data from MQTT and include it into db

2023-07-17 Thread IceNov
Thank you for the responses. I was able to get the MQTT data into the database by creating a new field in the database as advised. But still no success with importing the CSV. I suspect it is a datetime/interval issue as I noticed lots of these in the logs: Jul 18 13:51:00 newmqtt wee_import[17

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread michael.k...@gmx.at
So, either follow the instructions in the link I posted above or there: https://weewx.com/docs/latest/utilities.htm#Action_--add-column michael.k...@gmx.at schrieb am Dienstag, 18. Juli 2023 um 05:36:46 UTC+2: > If you are hungry and someone prepared lunch for you, served it, and > started feed

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread michael.k...@gmx.at
If you are hungry and someone prepared lunch for you, served it, and started feeding you, you'll stay hungry, unless you swallow. Yves Martin schrieb am Montag, 17. Juli 2023 um 23:11:25 UTC+2: > Hi Michael, > > It is empty as I use the same db from my old weewx to version 4.10.2 and > when I m

[weewx-user] Re: rmyro take #2

2023-07-17 Thread Kevin Schuchmann
Thank You Vince for taking the time to look into this.. The double post was at the begining of the stuff I posted Jul 17 10:10:03 Satcom python3[32727]: weewx-rm_young[32727] INFO weewx.restx: Wunderground-RF: Published record 2023-07-17 10:10:03 PDT (1689613803) Jul 17 10:10:03 Satcom python3[3

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread Yves Martin
Hi Michael, It is empty as I use the same db from my old weewx to version 4.10.2 and when I migrate to python 3.7.3. sqlite> .open weewx.sdb sqlite> sqlite> SELECT name FROM sqlite_master WHERE type = 'table'" ".exit" | grep pm2_5 ...> ...> SELECT name FROM sqlite_master WHERE type = 'tab

[weewx-user] Re: rmyro take #2

2023-07-17 Thread vince
Short answer is *'if you run unmainted code then you need to freeze to a setup that works forever, or you need to handle it yoursel*f'. Looks like you got 2to3 to get you python3 compatible (good) so you're most of the way there so I'd say keep going on your adventure since you're close l

Re: [weewx-user] MySQL query?

2023-07-17 Thread Tom Keffer
See $span in the Customization Guide. On Mon, Jul 17, 2023 at 11:21 AM Scott Hedberg wrote: > I would like to be able to run a query at any time that would provide the > high and low temperatures for the preceding 24 hours. > > Can anyo

Re: [weewx-user] Migration from wviewweather

2023-07-17 Thread Tom Keffer
Mine is 330MB+ and working fine. The bad data values could be an issue. There is a utility, wee_database , that will hunt down string values in the database, then fix them. Version 5, in beta now, is much more robust against bad

Re: [weewx-user] Migration from wviewweather

2023-07-17 Thread eric greenwade
Thanks Vince, I had seen this in the past but has lost it in the interim. I am curious as to those who have moved dbs, particularly 220+MB ones, and what their experiences were? Does it usually work, not work, tweaks are needed etc.? Thanks again folks! στάλθηκε από το iPhone μου > On Jul 17

[weewx-user] Re: Migration from wviewweather

2023-07-17 Thread vince
see if https://github.com/weewx/weewx/wiki/Moving-the-wview-database helps you any On Monday, July 17, 2023 at 11:33:13 AM UTC-7 eric greenwade wrote: > I'm hoping someone(s) has experience in migrating from wviewweather > (5.19.0) to weewx, and moving the database as well? I have 15 years of d

Re: [weewx-user] weewx can't update data from netatmo no more

2023-07-17 Thread 'neu...@bnjpro.dk' via weewx-user
Thank you Stefan, this looks like a good solution. I will try it out tomorrow. :-) mandag den 17. juli 2023 kl. 15.34.08 UTC+2 skrev Stefan Gliessmann: > a friend is using netatmo, too. > > take a look here: > > https://oe7drt.com/posts/2023-07-15-update-weewx-netatmo-extension/ > > On Monday,

[weewx-user] Migration from wviewweather

2023-07-17 Thread eric greenwade
I'm hoping someone(s) has experience in migrating from wviewweather (5.19.0) to weewx, and moving the database as well? I have 15 years of data that I would really like to preserve. The current host system lost one disk from the boot mirror, well over a year ago. No good excuse as to why its ta

[weewx-user] MySQL query?

2023-07-17 Thread Scott Hedberg
I would like to be able to run a query at any time that would provide the high and low temperatures for the preceding 24 hours. Can anyone point me in the right direction on how to do this? Thank you! -- You received this message because you are subscribed to the Google Groups "weewx-user" gr

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread michael.k...@gmx.at
What is sqlite3 weewx.sdb "SELECT name FROM sqlite_master WHERE type = 'table'" ".exit" | grep pm2_5 showing? What ist sqlite3 weewx.sdb "PRAGMA table_info(archive);" ".exit" | grep pm2_5 showing? If nothing, migrate to wview extended: https://weewx.com/docs/latest/customizing.htm#transfer_da

[weewx-user] rmyro take #2

2023-07-17 Thread Kevin Schuchmann
What does one do with a driver issue if the person that wrote it is not around? I reprogrammed my rm young 26800 to mimic a response one unit. Used 2to3 on rmyro.py to fix errors since it was python2 not 3 and got it to run, data was collected and reports generated. But there are some issues,

Re: [weewx-user] Re: Solar irradiance form ecowitt GW1100

2023-07-17 Thread 'Rainer Lang' via weewx-user
can you please post your syslog after restarting weewx with debug = 3 in weewx.conf from the weewx restart until at least the first archiving cycle and report generation (so it ever completes) is finished thanks On 17.07.2023 17:53, Stefan Gliessmann wrote: I have read the link above and made

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread Yves Martin
It seems the AQI works but not the other variable ... (not all the time). I was thinking ... because I'm using an old version of the sqlite database (from 2016), perhaps the new version did not integrate the new fields? How can I check this? Yves, YMartin.com/meteo Le lundi 17 juillet 2023 à 1

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread Yves Martin
I'm using the Bootstrap for my station with multi-language. Is there some incompatibility? wview_extended is set correctly here, the variables are well defined. Is there something I've missed? Yves, YMartin.com/meteo Le

Re: [weewx-user] weewx can't update data from netatmo no more

2023-07-17 Thread Stefan Gliessmann
a friend is using netatmo, too. take a look here: https://oe7drt.com/posts/2023-07-15-update-weewx-netatmo-extension/ On Monday, July 17, 2023 at 11:38:47 AM UTC+2 Rainer Lang wrote: > Maybe you send us a complete excerpt from your syslog covering the weewx > startup and at least one archiving

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread 'John Kline' via weewx-user
Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine:          no such column: pm2_5On Jul 17, 2023, at 6:12 AM, Yves Martin wrote:wview_extended is correct here.I'm able to show the data on my main page but I've still theses errors...YMLe lundi 17 juillet 2023 à 09 h 01 min 24

Re: [weewx-user] Re: Air Quality Sensor ?

2023-07-17 Thread Yves Martin
Just to let you know, Tom was right, my database was corrupted during the copy. I did it a second time then all was perfect. YM Le lundi 3 juillet 2023 à 16 h 23 min 20 s UTC-4, Yves Martin a écrit : > Hi Tom, > > I used the last version of aprx, this seems better, but now I have another > err

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread Yves Martin
wview_extended is correct here. I'm able to show the data on my main page but I've still theses errors... YM Le lundi 17 juillet 2023 à 09 h 01 min 24 s UTC-4, John Kline a écrit : > Please note in the description for

Re: [weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread 'John Kline' via weewx-user
Please note in the description for this extension:“weewx-airlink requires the wview_extended in WeeWX 4 that contains pm1_0, pm2_5 and pm10_0 columns.“On Jul 17, 2023, at 5:57 AM, michael.k...@gmx.at wrote:weedb.NoColumnError: no such column: pm2_5Yves Martin schrieb am Montag, 17. Juli 2023 um 1

[weewx-user] Re: Error with weewx-airlink

2023-07-17 Thread michael.k...@gmx.at
weedb.NoColumnError: no such column: pm2_5 Yves Martin schrieb am Montag, 17. Juli 2023 um 14:52:24 UTC+2: > Hi, > > I've installe the module weewx-airlink ( > https://github.com/chaunceygardiner/weewx-airlink) for the Davis Air > Quality, but I have this error : > > Jul 17 08:48:42 weewx4-raspi

[weewx-user] Error with weewx-airlink

2023-07-17 Thread Yves Martin
Hi, I've installe the module weewx-airlink (https://github.com/chaunceygardiner/weewx-airlink) for the Davis Air Quality, but I have this error : Jul 17 08:48:42 weewx4-raspi weewx[24741] INFO weewx.imagegenerator: Generated 18 images for report Bootstrap in 19.46 seconds Jul 17 08:48:42 weewx

Re: [weewx-user] weewx can't update data from netatmo no more

2023-07-17 Thread 'Rainer Lang' via weewx-user
Maybe you send us a complete excerpt from your syslog covering the weewx startup and at least one archiving period That would be more helpful than just a few snippets. Thanks On 17.07.2023 11:02, 'neu...@bnjpro.dk' via weewx-user wrote: I have been the happy user of weeWX for a very long time n

[weewx-user] weewx can't update data from netatmo no more

2023-07-17 Thread 'neu...@bnjpro.dk' via weewx-user
I have been the happy user of weeWX for a very long time now. And I'm still amazed that someone is able to write such a large and well functioning piece of software. I think when you are not able to program in python it is amazing when someone else can. :-) Friday last week (monday today) I mad