Thanks. Not causing an issue - just would clean up about 20,000 rows and keep things clean and consistent.
On Tuesday, October 15, 2019 at 11:02:45 PM UTC-4, gjr80 wrote: > > wee_import does not do any form of record aggregation, it just reads in > the records as they appear in the source and applies one of three methods > of determining the interval field for each record. Firstly it can derive > the interval field as the difference between successive record timestamps > (works well for complete sets of data ie no missing records but not good > for source data that is incomplete (eg WU)). Secondly, you can set the > interval field equal to the weewx.conf interval value (this suits if you > are importing your own records or if otherwise the weewx.conf interval is > the same as your source interval - this is better for handling sources with > some missing records). Finally, you can force the interval field to some > number (again suits the case where the source has a constant interval but > some records are missing). At the end of the day if you have 100 records in > your source you will end up with 100 records in your imported data. > > If you had source data that had one minute spaced timestamps and you > imported it with a five minute interval you would have an obvious > discrepancy between the timestamps and the interval field of your > imported data. I expect (not tested) that wee_import would not complain. > Subsequent use of the imported data by WeeWX might cause a problem, would > expect that aggregates would be fine but am sure something somewhere might > get upset. > > My advice, leave it as it is unless it is causing an issue. > > Gary > > On Wednesday, 16 October 2019 11:31:16 UTC+10, Pat wrote: >> >> OTOH, I'm not entirely sure how I'd merge these records successfully and >> accurately. I certainly could export this subset of records to a CSV and >> use wee_import - if wee_import's interval = conf is an optional way to >> accomplish this? >> >> >> On Tuesday, October 15, 2019 at 8:41:41 PM UTC-4, Tom Keffer wrote: >>> >>> Yes, it's certainly possible, but you would have to write a Python >>> script to do it. You could start with the transfer_db.py script, located in >>> the examples subdirectory. >>> >>> On Tue, Oct 15, 2019 at 3:10 PM Pat <[email protected]> wrote: >>> >>>> Back when I started with weewx in 2015 I had a 1 minute archive >>>> interval. I kept it that way for a few months until I realized more in how >>>> the archive interval works. >>>> >>>> I am performing some wee_import functions to get calc_missing on some >>>> records. wee_import warns about the mismatch in the intervals, which got >>>> me >>>> thinking: >>>> >>>> Is it possible to consolidate all my "1" interval to match the rest of >>>> my database at 5 minute intervals? >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "weewx-development" 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-development/99ddc189-5354-4c2f-88d0-27e0df50db5d%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-development/99ddc189-5354-4c2f-88d0-27e0df50db5d%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/758fdaf1-f9c4-466c-b908-cab3fce887f4%40googlegroups.com.
