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] <mailto:[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] <mailto:[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] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > Im Auftrag von Günther Wrana Gesendet: Sonntag, 19. April 2020 08:32 An: weewx-user <[email protected] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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/002401d842ca%24bfe91460%243fbb3d20%24%40bluewin.ch.
