Hello, i have now also a problem with my two weewx.sdb datebase how can i merge this two to one database?
Thank you for the help! Günther Wrana Meteo Oberwallis schrieb am Freitag, 5. August 2022 um 14:39:24 UTC+2: > Hallo. > > Ich möchte die Sonnenscheinzeit meiner Wetterstation vom Jahr 2006 ab > nachführen in weewx. In der weewx.sdb befindet sich die Spalte > "sunshine_time". Nun habe ich probiert, die Daten hoch zu laden über > folgenden Code: > [[FieldMap]] > dateTime = Zeit, unix_epoch > usUnits = > interval = > barometer = Luftdruck, hPa > pressure = > altimeter = > inTemp = > outTemp = Temp. A., degree_C > inHumidity = > outHumidity = Feuchte A., percent > windSpeed = Wind, km_per_hour > windDir = Richtung, degree_compass > windGust = Windboe, km_per_hour > windGustDir = > rainRate = > rain = Regen, mm > dewpoint = > windchill = > heatindex = > ET = > radiation = Solar, watt_per_meter_squared > UV = UV, uv_index > sunshine_time = Sonnenschein, hour > > Leider ergibt dies immer einen Fehler: > /home/technik# sudo wee_import --import-config=/var/tmp/csv.conf > Using WeeWX configuration file /etc/weewx/weewx.conf > Starting wee_import... > A CSV import from source file > '/home/technik/Schreibtisch/Grächen/EXP_2006.CSV' has been requested. > > Using database binding 'wx_binding', which is bound to database 'weewx.sdb' > Destination table 'archive' unit system is '0x01' (US). > Missing derived observations will be calculated. > All WeeWX UV fields will be set to None. > Starting import ... > Warning: Import field 'UV' is mapped to WeeWX field 'UV' but the > import field 'UV' could not be found in one or more records. > WeeWX field 'UV' will be set to 'None' in these records. > > Traceback (most recent call last): > File "/usr/share/weewx/wee_import", line 899, in <module> > main() > File "/usr/share/weewx/wee_import", line 829, in main > source_obj.run() > File "/usr/share/weewx/weeimport/weeimport.py", line 410, in run > _mapped_data = self.mapRawData(_raw_data, self.archive_unit_sys) > File "/usr/share/weewx/weeimport/weeimport.py", line 941, in mapRawData > weewx.units.obs_group_dict[_field]) > File "/usr/share/weewx/weeutil/weeutil.py", line 1501, in __getitem__ > return self.__missing__(key) > File "/usr/share/weewx/weeutil/weeutil.py", line 1493, in __missing__ > raise KeyError(key) > KeyError: u'sunshine_time' > > Woran könnte das liegen? > > Danke für eure Hilfe > Meteo Oberwallis schrieb am Montag, 18. April 2022 um 11:28:04 UTC+2: > >> Hallo zusammen. >> Ich probiere nun schon seit geraumer Zeit, die weewx.sdb der Version >> 3.9.0 mit der neuen weewx.sdb der aktuellen Version 4.7.0 zusammen zu >> legen. Dies klappte bis anhin leider nicht. Nun vermute ich aber, das dies >> daran liegt, das ab der Version 4.7 ein anderes Shema benutzt wird? >> Interessanterweise konnte ich die alte weewx.sdb mit wee_database >> weewx.conf --reconfigure in das richtige format bringen. Nun aber fehlen >> mit die "sunshine_hours". Die neuste Version von weewx hat ja ebenfalls ein >> neues "sunshine_time" format. Nun wollte die mittels "rename" einfach die >> Tabllenespalte anpassen. Dies blieb aber erfolglos. Kann ich die >> "sunshine_hours" über einen anderen weg ind die neue weewx.sdb in dessen >> "sunshine_time" spalte kopieren? >> Ich weiss wirklich nicht mehr weiter und würde mich über Hilfen freuen. >> Vielen Dank >> >> Der Fehler bei der Datenbank zusammenführung: >> Error: near line 333827: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333828: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333829: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333830: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333831: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333832: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333833: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333834: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333835: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333836: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333837: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333838: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333839: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333840: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333841: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333842: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333843: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333844: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333845: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333846: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333847: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333848: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333849: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333850: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333851: table archive has 114 columns but 53 values were >> supplied >> Error: near line 333852: table archive has 114 columns but 53 values were >> supplied >> >> >> 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 visit https://groups.google.com/d/msgid/weewx-user/7f227ff6-a181-496d-9b35-8d9ab6e04297n%40googlegroups.com.
