Actually, thinking some more, WU has shown some peculiar behaviour when querying their API for the current day. Why not try importing from an earlier day.
Gary On Tuesday, 7 January 2020 16:52:15 UTC+10, gjr80 wrote: > > Hang on, I'm a little confused with what you have posted about. You > performed a WU import on 6 January with no --date option: > > *PYTHONPATH=/var/tmp/weewx4_src/weewx/bin > /var/tmp/weewx4_src/weewx/bin/wee_import --import-config=/var/tmp/wu.conf* > > so wee_import will have imported data for the current day and that is > what is confirmed in the wee_import console output: > > *Unique records processed: 250; Last timestamp: 2020-01-06 20:49:52 PST > (15783725Unique records processed: 256; Last timestamp: 2020-01-06 21:19:48 > PST (1578374388)* > > yet the log extract you presented shows records being imported from 5 > January. Maybe there is an error in wee_import or maybe we are looking at > the log from another import? Also, wee_import reports it took 30 odd > seconds to execute yet the log indicates somewhere around 15 seconds. Noit > trying to be smart but want to make sure that we are actually looking at > log output from the same wee_import sessison, the answers are in the log > but you need to be looking at the answer to your question not some other > question. > > No need to check the database to confirm what was added, the line > > Jan 6 21:37:18 www2 journal: wee_import[32763] INFO weewx.manager: Added > record 2020-01-05 23:59:48 PST (1578297588) to database 'weewx.sdb' > > tells you that a record stamped 2020-01-05 23:59:48 PST was added to your > database, if you imported 6 January and the only such entries are for 5 > January then something is wrong. > > Gary > > On Tuesday, 7 January 2020 16:04:27 UTC+10, KnC Mc wrote: >> >> I added my 'api_key' and it acts like it is working, but the web pages >> are not getting updated... >> >> *PYTHONPATH=/var/tmp/weewx4_src/weewx/bin >> /var/tmp/weewx4_src/weewx/bin/wee_import --import-config=/var/tmp/wu.conf* >> >> *Using WeeWX configuration file /var/tmp/weewx4_src/weewx/weewx.conf* >> *Starting wee_import...* >> *Observation history for Weather Underground station 'KCAANAHE97' will be >> imported.* >> *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.* >> *Starting import ...* >> *Records covering multiple periods have been identified for import.* >> *256 records identified for import.* >> *Proceeding will save all imported records in the WeeWX archive.* >> >> *Are you sure you want to proceed (y/n)? y* >> >> *Unique records processed: 250; Last timestamp: 2020-01-06 20:49:52 PST >> (15783725Unique records processed: 256; Last timestamp: 2020-01-06 21:19:48 >> PST (1578374388)* >> *Calculating missing derived observations ...* >> *Processing record: 256; Last record: 2020-01-07 00:00:00 PST >> (1578384000)* >> *Recalculating daily summaries...* >> >> *Finished recalculating daily summaries* >> *Finished calculating missing derived observations* >> *Finished import* >> *256 records were processed and 256 unique records imported in 30.47 >> seconds.* >> *Those records with a timestamp already in the archive will not have been* >> *imported. Confirm successful import in the WeeWX log file.* >> >> >> */var/tmp/weewx4_src/weewx/bin # ./wee_database --check* >> >> *Using configuration file /var/tmp/weewx4_src/weewx/weewx.conf* >> *Using database binding 'wx_binding', which is bound to database >> 'archive_sqlite'* >> *Checking daily summary tables version...* >> *Daily summary tables are at version 2.0* >> *Interval Weighting Fix is not required.* >> *Daily summary tables version check completed in 0.01 seconds.* >> *Preparing Null String Fix, this may take a while...* >> * Checking record: 1408; Timestamp: 2020-01-06 21:19:48 PST (1578374388)* >> *No null strings found.* >> *Completed Null String Check in 0.09 seconds.* >> >> >> */var/tmp/weewx4_src/weewx/bin # ./wee_reports * >> >> *Using configuration file /var/tmp/weewx4_src/weewx/weewx.conf* >> *Generating for all time* >> >> >> */var/log/messages...* >> >> *Jan 6 21:37:14 www2 journal: wee_import[32763] INFO weeimport.wuimport: >> Using database binding 'wx_binding', which is bound to database 'weewx.sdb'* >> *Jan 6 21:37:15 www2 journal: wee_import[32763] INFO weewx.manager: >> Added record 2020-01-05 00:04:50 PST (1578211490) to database 'weewx.sdb'* >> *Jan 6 21:37:15 www2 journal: wee_import[32763] INFO weewx.manager: >> Added record 2020-01-05 00:04:50 PST (1578211490) to daily summary in >> 'weewx.sdb'* >> >> **** Multiple lines nipped for conciseness **** >> >> *Jan 6 21:37:18 www2 journal: wee_import[32763] INFO weewx.manager: >> Added record 2020-01-05 23:59:48 PST (1578297588) to database 'weewx.sdb'* >> *Jan 6 21:37:18 www2 journal: wee_import[32763] INFO weewx.manager: >> Added record 2020-01-05 23:59:48 PST (1578297588) to daily summary in >> 'weewx.sdb'* >> *Jan 6 21:37:18 www2 journal: wee_import[32763] INFO weewx.wxservices: >> The following values will be calculated: altimeter=prefer_hardware, >> appTemp=prefer_hardware, barometer=prefer_hardware, >> beaufort=prefer_hardware, cloudbase=prefer_hardware, >> dewpoint=prefer_hardware, ET=prefer_hardware, heatindex=prefer_hardware, >> humidex=prefer_hardware, inDewpoint=prefer_hardware, >> maxSolarRad=prefer_hardware, pressure=prefer_hardware, >> rainRate=prefer_hardware, windchill=prefer_hardware, >> windrun=prefer_hardware* >> *Jan 6 21:37:18 www2 journal: wee_import[32763] INFO weewx.wxservices: >> The following algorithms will be used for calculations: altimeter=aaASOS, >> maxSolarRad=RS* >> *Jan 6 21:37:20 www2 journal: wee_import[32763] INFO weewx.manager: >> Starting backfill of daily summaries* >> *Jan 6 21:37:20 www2 journal: wee_import[32763] INFO weewx.manager: >> Processed 288 records to backfill 1 day summaries in 0.51 seconds* >> *Jan 6 21:37:30 www2 wee_reports[300]: copygenerator: copied 9 files to >> /www/html/weewx* >> >> >> I verified the .htm files were updated in my weewx directory with the >> import date, but the data is still from 5/20/2019. >> >> I am not familiar with getting a Select out of the sql database for >> weewx. Is there a simple command I can use to see if the data from >> 1/5/2020 or 1/6/2020 actually exists in the database? Thanks. >> > -- 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/ceb4a0e7-0d90-4c5a-82bf-e95f26eb05ed%40googlegroups.com.
