Yes, wee_import inserts and does not update. If you have a look back at the WeeWX log from when you did the import you will probably find a lot of error messages about ‘unique constraint failures’ on dateTime, this is because wee_import tried to add a record with a timestamp that already existed in the database. wee_import uses code used by StdArchive for adding records to the database and unfortunately wee_import is unable to tell if the insert was successful or not, that is why you if you look closely there is some oddly worded summary text after a wee_import run. It advises you of how many records were processed and not how many were saved, and you are directed to the log to check success or otherwise.
Gary On Friday, 15 January 2021 at 23:04:07 UTC+10 [email protected] wrote: > 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/d0de26be-0fd8-4dbc-9148-7fb308eb1e1fn%40googlegroups.com.
