Hi, Tom Thanks for the reply. But this is not what I really want to do.
I want to reduce the archive table dimension by 5. I have a corrupted database with more than 1,000,000 rows in archive tables (1 minute interval) and I have reduced the same by 5, to about 200,000 rows with excel. Now I miss the latest information I asked for. Then I'll rebuild the database with te command wee_database --rebuild-daily. Il giorno venerdì 29 settembre 2017 00:42:45 UTC+2, Tom Keffer ha scritto: > > Hi, Stefano > > Since you wrote your original post, V3.7 came out, which *does* allow the > archive interval to change within a database. All you have to do is update > your database using the tool wee_database with option --update. > > See the Upgrade Guide for details > <http://weewx.com/docs/upgrading.htm#From_V3.6_or_earlier>. > > Truth be told, if you do this, you would be the first to try it, so I'm > eager to hear about your experiences. Make a backup first! > > -tk > > On Thu, Sep 28, 2017 at 11:52 AM, stefano siega <[email protected] > <javascript:>> wrote: > >> Hi all. >> >> I'm finally working on the database to reduce it. >> >> I converted the archive table to CSV and I started creating the functions >> to make the values average. >> >> rain needs to be summed? >> rainRate needs to be summed? >> >> windDir needs to be averaged? >> windspeed needs to be averaged? >> >> >> The value interval must be changed to 5 >> usUnits value remain to 1? >> >> And finally ... The values that have been averaged have now more >> decimal numbers. Can you attach a small database (interval 5 minute) of a >> davis vantage 2 to figure out how many decimal places after the comma I >> have to leave for any value? >> >> thank you so much >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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]. For more options, visit https://groups.google.com/d/optout.
