I actually expected an answer like this. I'm not trying to be an ass, but if you don't have the answer to my dilemma, you could just scroll on down to the next post. But yes, I did use Google. Found some things about "joining" databases. I'm just worried about compromising the integrity of the database by doing that. Of course, I'd make a backup first. I didn't find anything specific about copying certain time ranges.
I figured someone here would have already been in the same boat I am and have already gone through the process. Thanks anyway. On Sat, May 8, 2021 at 11:10 AM p q <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/CAA1SM22%2BL2zPhtr205-aO5RmZ%3DSr-LheKcSsw6vP%2Bm3gw-uOnA%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/CAC5oUmO-U_0z3rH8tSD%3DVw%2B6VhA5gN2MPcCwHi781x-%3DqW9caQ%40mail.gmail.com.
