Hi Chris, If you're happy to take all the data, and sort the chaff later, then the following may help.
https://github.com/weewx/weewx/wiki/csv That will output all the data as a csv formatted file. binding: It's default is every loop packet which I suspect will be more often than you want the data. archive would be the one that matches your archive_interval in weewx.conf Cheers Glenn rorpi - read only raspberry pi & various weewx addons https://github.com/glennmckechnie On 9 May 2018 at 17:09, Chris Schram <[email protected]> wrote: > Background: I am a weather spotter on the Oregon coast. When there is > excessive rain or wind, I am supposed to report it to the regional NWS > office. > > I recently attached my Vantage Vue to a spare Raspberry Pi 2B (after my old > iMac died), and after some initial headaches, got weewx working the way I > want it to. Except for one thing… > > I need a script that I can run as an hourly cron job, that can grab the last > few days of wind and rain data from weewx.sdb, and export it to CSV (or some > other format a spreadsheet can process). > > I have stared at much of the sqlite3 documentation until my eyes glazed > over, but what should seem to be a simple solution is way beyond what my > simple mind can comprehend. > > Can someone here help get me started? I have no experience whatsoever with > SQLite. > -- 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.
