Hello, everyone. For some time now I've been trying to merge the weewx.sdb of version 3.9.0 with the new weewx.sdb of the current version 4.7.0. Unfortunately, this has not worked so far. But now I assume that this is due to the fact that a different shema is used from version 4.7 onwards? Interestingly, I was able to get the old weewx.sdb into the right format with wee_database weewx.conf --reconfigure. But now I'm missing the "sunshine_hours". The latest version of weewx also has a new "sunshine_time" format. Now she just wanted to adjust the table column using "rename". But this was unsuccessful. Can I use another way to copy the "sunshine_hours" into the new weewx.sdb in its "sunshine_time" column? I really don't know what to do and would appreciate any help. Thanks very much
Meteo Oberwallis schrieb am Donnerstag, 31. März 2022 um 11:35:55 UTC+2: > Hello, everyone. > > The error really seems to be with the database, i.e. SQLite, since the > "user.sunduration.schema_with_sunshine_time" will have a different > structure. But what can I do now so that I can use my old database from the > previous weewx version again with the latest version and thus overwrite the > sunshine hours (old name in the old weewx.sdb) in the new one? > > Many thanks for your help > > Meteo Oberwallis schrieb am Montag, 28. März 2022 um 19:39:22 UTC+2: > >> Hey Tom. >> >> >> >> Thx for your Help. >> >> In the new weewx version, "schema = schemas.wview_extended.schema" is >> used with the table. In the previous version of weewx, however, this was >> "schema = user.radiationhours.schema_with_sunshine_hours". What exactly do >> I have to do if I transfer my old weewx.sdb to the program? Do I then have >> to adapt these with sudo wee_database weewx.conf --reconfigure to the >> ""schema = schemas.wview_extended.schema"? I think that's where my problem >> lies. >> >> >> >> Currently I did the following: Old weewx.sdb in the /var/lib/weewx/ >> folder. Then adjust the column names with "wee_database >> --rename-column=sunshine_hours --to-name=sunshine_time" and finally adjust >> the new Shmea from weewx with sudo wee_database weewx.conf --reconfigure. >> After I did that, the "sunshine_time" column was gone. Only after "sudo >> wee_database --add-column=sunshine_time" is it back, but unfortunately >> without all the data from the last few years. >> >> >> >> Where is my mistake? >> >> >> >> *Von:* [email protected] <[email protected]> *Im Auftrag >> von *Tom Keffer >> *Gesendet:* Montag, 28. März 2022 13:51 >> *An:* weewx-user <[email protected]> >> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >> >> >> >> If I understand correctly, you're trying to rename a database type from >> sunshine_hours to sunshine_time. >> >> >> >> If so, use the utility wee_database with the --rename-column >> <http://www.weewx.com/docs/utilities.htm#Action_--rename-column> option: >> >> >> >> *wee_database --rename-column=sunshine_hours --to-name=sunshine_time* >> >> >> >> Make a backup first. >> >> >> >> On Mon, Mar 28, 2022 at 12:14 AM Meteo Oberwallis <[email protected]> >> wrote: >> >> Good Morning >> >> >> >> I have a question regarding the SQLite database. I updated weewx and now >> use sunshine_time instead of sunshine_hours. Now of course the problem is >> that the old sunshine times are in the sunshine_hours column and not in the >> sunshine_time. How can I fix the fact that the old sunshine_hours data is >> now being sent to the sunshine_time splate? >> >> Thanks and Greetings >> >> [email protected] schrieb am Sonntag, 19. April 2020 um 19:30:30 UTC+2: >> >> Hallo >> >> >> >> wenn du die Standard Installation hast ist das >> /home/weewx/public_html/NOAA oder /var/www/html/weewx/NOAA so wie es >> Gary geschrieben hat. >> >> >> >> Grüße >> >> >> >> >> >> Hello >> >> >> >> if you have the standard installation this is >> /home/weewx/public_html/NOAA or /var/www/html/weewx/NOAA as Gary wrote it. >> >> >> >> greetings >> >> >> >> >> >> >> >> >> Am Sonntag, 19. April 2020 13:58:05 UTC+2 schrieb Meteo Oberwallis: >> >> Hallo Günther >> >> >> >> Nun. Das finde ich so nirgends in meinem weewx Ordner. Ist das der >> Ordner, bevor es via FTP hochgeladen wird? >> >> >> >> Gruss >> >> >> >> *Von:* [email protected] <[email protected]> *Im Auftrag >> von *Günther Wrana >> *Gesendet:* Sonntag, 19. April 2020 08:32 >> *An:* weewx-user <[email protected]> >> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >> >> >> >> Hallo >> >> >> >> Ich habe die Dateien im /var/weewx/reports/NOAA gelöscht aber ich habe >> diesen Pfad bei mir vorher so geändert damit diese Dateien nicht auf die >> SD-Karte sondern in den RAM Speicher geschrieben werden. >> >> >> >> Grüße Günther >> >> Hello >> >> >> >> I deleted the files in /var/weewx/reports/NOAA but I changed this path >> for me beforehand so that these files are not written to the SD card but to >> the RAM memory. >> >> >> >> Regards Günther >> >> >> >> >> >> Am Samstag, 18. April 2020 17:45:24 UTC+2 schrieb Meteo Oberwallis: >> >> Hallo Günther >> >> >> >> In welchem Ordner hast du das gelöscht? >> >> >> >> >> >> On Sat, Apr 18, 2020 at 5:34 PM +0200, "Günther Wrana" <[email protected]> >> wrote: >> >> Hello >> >> I deleted the file NOAA-2019-05.txt, NOAA-2019.txt and it worked >> perfectly. For me is now the 01.05.2015 that I imported. The fact that >> there is nothing inside has happened to me even though I have only deleted >> the NOAA.txt. Maybe you have to restart or reload weewx. >> >> >> >> Günther >> >> >> Am Samstag, 18. April 2020 14:56:21 UTC+2 schrieb Meteo Oberwallis: >> >> Hello. >> >> I have now deleted the data in the folder "/var/www/html/weewx/NOAA/". These >> came again after the next interval. Unfortunately without data. Do I have to >> delete it anywhere else? >> >> Thank you for your top help >> >> >> >> Am Freitag, 17. April 2020 23:42:39 UTC+2 schrieb gjr80: >> >> Hallo Günther, >> >> Good to hear you have imported your data and WeeWX is running without >> error. You need WeeWX to recreate all of your NOAA format reports, to do >> this just delete the reports on your WeeWX machine and they will be >> recreated (including your earlier ones) on the next report cycle. >> >> Gary >> >> -- >> 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 on the web visit >> https://groups.google.com/d/msgid/weewx-user/8fc609f0-224a-4205-98d4-410a7acc759f%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/8fc609f0-224a-4205-98d4-410a7acc759f%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 on the web visit >> https://groups.google.com/d/msgid/weewx-user/f02b56bc-8550-45f7-95ae-3e58054284d5%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f02b56bc-8550-45f7-95ae-3e58054284d5%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 on the web visit >> https://groups.google.com/d/msgid/weewx-user/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/86KPd-dyvD4/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.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 on the web visit https://groups.google.com/d/msgid/weewx-user/c699c4fb-fa90-4663-af26-f27b10d2461bn%40googlegroups.com.
