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/b9ab25ea-4cc1-48f2-8831-f7875230574f%40googlegroups.com.
