That’s one of the reasons we discourage writing to the database directly, far better to let the WeeWX machinery take care of everything. In answer to your question, if you have inserted the missing data in the archive then just use the wee_database <http://weewx.com/docs/utilities.htm#Action_--rebuild-daily> utility to rebuild the daily summaries for the period concerned, that will take care of everything in the daily summary tables.
Gary On Friday, 15 January 2021 at 20:50:53 UTC+10 [email protected] wrote: > I have also discovered some columns sum REAL, count INTEGER, wsum REAL, > sumtime INTEGER > and have no idea what to put in them > > On Friday, January 15, 2021 at 9:51:59 AM UTC Mike Revitt wrote: > >> I am having some interesting challenges around updating my database with >> some missing data. >> >> Now that I have integrated my Caravan temperatures into WeeWX I am have >> extracted the data from the period that I was recording it but not updating >> WeeWX. >> >> I have created a css file with the data and wee_import runs perfectly >> with no errors, but no new data appears in the database. >> >> I suspect that this is because I am trying to do an update rather than an >> insert. So I have created an update script for. the archive table and this >> runs perfectly, I used python to generate the epoc dates, and I ran this on >> a copy of the database so I did not screw anything up. >> >> The challenge is updating the archive tables archive_day_extraHumid1 etc. >> I can relatively easily construct the min and max values for a time period >> but constructing the min time is a little more challenging. So before I do >> that is there some tool I can invoke that will populate these archive >> tables from the new data in the main archive table >> >> -- 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/484c426e-eadc-4601-a18f-d6fdafe24770n%40googlegroups.com.
