Have you tried googling for inserting into a sqlite db from another? I'm not trying to be an ass, but if I had the problem you describe thats what I'd do. I'm sure there's sql you could use but I don't do it all the time and would have to look it up.
On Sat, May 8, 2021, 7:46 AM Ernest Jillson <[email protected]> wrote: > I imported years of data from wunderground into my weewx db. There was a > period of very bad rain data due to a malfunctioning tipping bucket. Also > had a day where a small grasshopper managed to get into the little hole, > then proceeded to rack up about 15 inches of rain for me that day while > trying to escape. > > I stopped weewx, made a copy of my db, then used sqlite browser to remove > all of the bad rain data, day by day, week by week. When I was satisfied, I > restarted weewx and life was good. > > It wasn't until a month later, while flipping through some of my past data > that I realized I had somehow managed to remove much more data than I > wanted to. I mean, we're talking like a year's worth of rain data. > > I don't want to import those days all over again, but I can if that's the > only way. I'd much rather like to find a way to "bring over" the rain from > the saved database for a range of dates, then start the fixing process > again. When I brought the data over from wunderground, there were lots of > dew point/humidity and temperature anomolies I had to fix as well. > > My question: Is there a way (perhaps using the sqlite browser) to import > a column (rain) from one database (the saved one) to the new database for > just a range of dates? > > Thanks in advance! > > -- > 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/CAC5oUmN6qQVrx0YTCLHhkKRdxJAg7%3DEjtcwDkudBO8bzJm956A%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAC5oUmN6qQVrx0YTCLHhkKRdxJAg7%3DEjtcwDkudBO8bzJm956A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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/CAA1SM22%2BL2zPhtr205-aO5RmZ%3DSr-LheKcSsw6vP%2Bm3gw-uOnA%40mail.gmail.com.
