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/1fbe3022-78d0-4834-9c82-15f35895d1b9n%40googlegroups.com.
