Re: [weewx-user] Re: Merge database failed

I have a question. Is it possible to use the solar data to create the hours of sunshine retrospectively with weewx? Meteo Oberwallis schrieb am Dienstag, 3. Mai 2022 um 12:40:02 UTC+2: > Hello, everyone > > Maybe I can help the whole thing along a bit. I installed the Weewx system > on a

Re: [weewx-user] Re: Merge database failed

If you want to add something to the database, you have two choices: 1. Create a new database using a custom schema, then transfer over the contents of the old database to the new database using the tool wee_database with the --transfer

Re: [weewx-user] Re: Merge database failed

Hello, everyone Maybe I can help the whole thing along a bit. I installed the Weewx system on a Raspberry and also installed the Davis fine dust sensor extension. After that I made a backup of the whole system so I can use it for my other weather stations. Since the old database (weewx.sdb)

Re: [weewx-user] Re: Merge database failed

My apologies, but I'm just not following this. There is no "upgrading" of the database. They are all the same. You can take a database from wview 15 years ago, and run it on a modern WeeWX with no changes. Now it's true that the *default* schema for WeeWX changed in V4.0 from the "wview" schema

Re: [weewx-user] Re: Merge database failed

I've been a WeeWX user since late 2013. At first I ported it to a BeagleBone Black but I moved it to a Raspberry Pi somewhere around late 2018. The point of all this is that I have been running it for years--last version was 3.8.0, I think, but just this weekend I actually upgraded the

Re: [weewx-user] Re: Merge database failed

The old schema was "schema=user.radiationhours.schema_with_sunshine_hours". If I load my old weewx.sdb and then configure it with "wee_database weewx.conf --reconfigure" then this deletes the "sunshine_hours" column. All other data will be accepted. I'll try your instructions to see if it

Re: [weewx-user] Re: Merge database failed

I have no idea where sunshine_hours comes from. Did you add it to your old weewx schema ? If so you'd need to similarly add it to the new schema probably before doing your conversion and see if wee_database is smart enough to do the right thing. (untested - but give it a try. This is why

Re: [weewx-user] Re: Merge database failed

Hello Vince Many thanks for your response. I moved my old weewx.sdb to the new weewx version and then created it in the new format with "wee_database weewx.conf --reconfigure". Unfortunately, the "sunshine_hours" was deleted in the process. Can I somehow transfer these to the new scheme? Greeting

[weewx-user] Re: Merge database failed

v4 shipped with the wview_extended schema as the default, which has 114 fields. You need to convert your old db to the extended schema, then redo your dump and import commands (which look good). See if https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema helps