Ah I think I understand now. After a poke around looking at the .py files, I think I need to update archive.rain for one row for that date, then run wee_database --rebuild_daily for the date range I've altered.
And I need to make sure I update just one row in Archive for the date, not all of them! I have a row every 5 minutes, so the one for 12:00:00 seems appropriate. I can check before I try the update to make sure they all exists. Still like the idea of using the Excel with the data from the other site to build the correct SQL. On Monday, 17 February 2020 16:42:29 UTC, Auchtermuchty Weather wrote: > > Thanks. > > I need to go back to late November. > > I've found out how to get the date & time from the dateTime column. :) > > But is it just archive_day_rain.sum I need to update? > > The weather station is one of the FineOffset ones, does this do rain > rate? I always assumed it was calculated. But if fixing the rain & > running weewx_database will fix it that will be great. > > Looks like I need to read up weewx_database. I can pick up the external > data and put it in Excel which will let me build the SQL statements. And > yes, I will stop weewx and take a copy of weewx.sdb before I start changing > data! > > > On Monday, 17 February 2020 15:18:49 UTC, Andrew Milner wrote: >> >> depends how completely you want to backfill!! >> in the archive table there are columns for rain and rainrate which is a) >> the rain fall in the arhive period and b) the rainrate in the archive >> period. For stations which do not provide rainrate this may well be a >> rainrate which decays over a period . >> >> If you can fill in all the archive periods with the rainfall data the >> summary data could be recreated from the archive using drop daily and >> rebuild daily options of weewx_database utility. >> >> alternatively you could fill in the columns in the rain daily summary >> table and the rainrate daily summary table for all the days you are missing >> >> >> >> >> On Monday, 17 February 2020 17:00:58 UTC+2, Auchtermuchty Weather wrote: >>> >>> I've finally sorted out my rain gauge, but now I need to backfill the >>> rainfall data. There is a station near enough to me to use their data, but >>> I could do with some guidance about what needs updating in my database, and >>> if I need to run anything afterwards. I used SQL for years in the day job >>> so no problems there. >>> >> -- 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/2cffd713-2a43-4497-918b-aed438d93cb7%40googlegroups.com.
