Thanks Gary, will give that a go. And am I correct in my suspicion that wee_import didn't work because it only does inserts not updates
On Friday, January 15, 2021 at 1:01:20 PM UTC gjr80 wrote: > 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/8932ce56-5e25-4784-98a7-9e11e0d470f3n%40googlegroups.com.
