Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread storm...@gmail.com
Tom Added two columns via the schema: comfort_level and lightning_frequency; in which the data types are TEXT. Again the database gets populated with the correct data. Aug 17 00:35:26 raspberrypi weewx[1359] ERROR weewx.manager: Replace failed for database weewx.sdb: table

[weewx-user] Re: vueiss.py driver not writing to database (RPi)

2021-08-16 Thread gjr80
Can’t say I’ve ever seen a driver like this before. From a quick look at the code it appears the system is in two parts. First there is a ‘logger’ that runs independently of the driver, the logger intercepts the RF from the ISS and records data (including time stamps) in a separate table (table

Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread storm...@gmail.com
Tom I tried adding the column using the following command: wee_database --add-column=lightning_frequency --type=TEXT It does add the column and populates the data but generates an error during the archival cycle. I guess it looking for integers and real type values. Aug 16 22:00:22

Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread Tom Keffer
No rules about ordering. WeeWX reads the schema on startup, so it knows the ordering of types. An optional "daily summary" is also included in the database. Whether it is included or not, or used or not, is dependent on the type of "database manager" you use. This is specified by option

Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread Tom Keffer
Can't say that I've tried that, but I don't see why it wouldn't work. It's certainly simpler. Let me know how it goes. On Mon, Aug 16, 2021 at 9:11 AM storm...@gmail.com wrote: > Thanks Tom. > > I have another question before proceeding. Do I need to physically update > the schema to include

[weewx-user] Re: vueiss.py driver not writing to database (RPi)

2021-08-16 Thread 'Loden Hos' via weewx-user
thanks vince, you made me try all options of getting good time: disable all time services and reboot. i even installed a piface shim real time clock and rebooted, allways the same: simulator driver works with correct time. vueiss comes up with a clock error of ~51 years (1.1.1970??). if there

[weewx-user] Re: vueiss.py driver not writing to database (RPi)

2021-08-16 Thread vince
I would start by fixing the clock error. Make sure you install and enable ntp in your os and get the clock to match true time. You might also check the clock on your Vantage to verify it is correct. On Monday, August 16, 2021 at 3:41:47 AM UTC-7 Loden Hos wrote: > Good morning, > > I am

[weewx-user] Re: New Tempest owner, how to show Lightning output in weewx ?

2021-08-16 Thread vince
There are many threads here and in the WeatherFlow forums for how to do this. Please do a little searching there. WF has never published any units for energy that I've ever seen in their API documentation for UDP (link) and their example

Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread storm...@gmail.com
Thanks Tom. I have another question before proceeding. Do I need to physically update the schema to include column and type or could I just use the following command: wee_database --add-column=comments --type=TEXT Rich On Monday, August 16, 2021 at 8:29:16 AM UTC-4 tke...@gmail.com wrote:

Re: [weewx-user] Weewx DB Column Data Types

2021-08-16 Thread Tom Keffer
Good question. Yes, it is possible to store text. 1. Assuming you're using sqlite, make sure you read their documentation on data types: https://sqlite.org/datatype3.html 2. Create a new schema accordingly. For example, table = [('dateTime', 'INTEGER NOT NULL UNIQUE PRIMARY KEY'),

Re: [weewx-user] Has the latest WeeWx and Python3 changes made the github fileparse.py file not work?

2021-08-16 Thread Tom Keffer
Cool! Just to warn you, the "change log" is something we do, not GitHub. It's manually updated after every change. There are automated tools that can automatically update change logs, but we don't use any of them. Our development process is pretty stone age. One recommendation: a good

[weewx-user] New Tempest owner, how to show Lightning output in weewx ?

2021-08-16 Thread Julius Thijssen
Have weewx running showing most data from the tempest, except for - Illuminance/Brightness (in lux, which I would like to include as a plaintext and graph, just like UV) - Lightning, for which it seems they do it as follows in the UDP load (example nrs): Lightning Strike Event [type =

[weewx-user] vueiss.py driver not writing to database (RPi)

2021-08-16 Thread 'Loden Hos' via weewx-user
Good morning, I am trying to run weewx on a raspberry pi 2b (Rev 1.1) with a custom driver named vueiss.py. this driver can fetch data from davis vantage vue without the davis console. Its installation and use is not very good documented, see the authors ressources: