Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Converting monthly log files to an sqlite database

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
Post Reply
seumas
Posts: 1
Joined: Mon 06 Feb 2012 4:37 pm
Weather Station: Davis Vantage Pro 2
Operating System: Windows XP SP3
Location: United Kingdom

Converting monthly log files to an sqlite database

Post by seumas »

Hi, for a project I'm working on I developed a simple Python module, that given the directory path to where your monthly log files are kept will write an sqlite3 database from the logs in the same directory.

It requires Python to be installed ( I'm running 2.7.2 ) and you can change the 'D:\data' to whatever your monthly log file path is, it creates a database file called 'weather_database' with a 'weather_log' table and parses Cumulus' date fields into a utc unix timestamp field called time_seconds. You can rerun the script after more data has been added to the log files and it will write the new records to the same database.

You can download the module at the link below.

https://bitbucket.org/jamesmorrison/cum ... er_data.py

Cheers
Post Reply