Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

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

Legacy Cumulus 1 release 1.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

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

Cumulus database

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Cumulus database

Post by geoplr »

I want to see my whole database log (the one that is downloaded from my station), in order to analyze it. (for example, how many times a year the 20min rain was over 30mm)
I mean the 10-min log file for every day.
I cant find such a file in cumulus folders, do I have to add all the monthly logs?
Top
TRB
Posts: 32
Joined: Wed 02 Sep 2020 6:52 am
Weather Station: WA1081
Operating System: Win 10
Location: Melbourne, Australia
Contact:
Contact TRB

Re: Cumulus database

Post by TRB »

How far back?

You could set your 'graph hours' to around 8650 and see a full year's worth.

You do not have the required permissions to view the files attached to this post.
Top
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:
Contact mcrossley

Re: Cumulus database

Post by mcrossley »

To get that sort data you will need to look at the monthly log files.

But to be honest, you would, be best putting the data into a database. That makes doing those sort of queries fairly easy.

Cumulus will insert new data for you, there is a script in the Wiki for adding all your historic data.

At least one user imports the files into MS Access and extracts all their personal stats from there.
Top
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Re: Cumulus database

Post by geoplr »

mcrossley wrote: ↑Tue 03 Nov 2020 10:31 pm To get that sort data you will need to look at the monthly log files.

But to be honest, you would, be best putting the data into a database. That makes doing those sort of queries fairly easy.

Cumulus will insert new data for you, there is a script in the Wiki for adding all your historic data.

At least one user imports the files into MS Access and extracts all their personal stats from there.
ok, please send me the link for the script, I cant find it.
If I dont get the script I will have to put my data of monthlylogs.txt to Ms Access, right?
Top
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Re: Cumulus database

Post by geoplr »

Also, I would like to analyze only the column of rain data. Is there a way to isolate it?
Can cumulusmx exctract data in one column?
Top
water01
Posts: 3670
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10/11 64bit Synology NAS
Location: Burnham-on-Sea
Contact:
Contact water01

Re: Cumulus database

Post by water01 »

I am not sure if this is relevant but your profile says you are running Windows XP SP3 and as CumulusMX will not run on Windows XP the question would be irrelevant.
David
Image
Top
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Re: Cumulus database

Post by geoplr »

outdated profile of mine
Top
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:
Contact mcrossley

Re: Cumulus database

Post by mcrossley »

geoplr wrote: ↑Wed 04 Nov 2020 7:22 pm ok, please send me the link for the script, I cant find it.
If I dont get the script I will have to put my data of monthlylogs.txt to Ms Access, right?
It's here: https://cumuluswiki.org/a/ImportCumulusFile
Top
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Re: Cumulus database

Post by geoplr »

mcrossley wrote: ↑Wed 04 Nov 2020 9:15 pm
geoplr wrote: ↑Wed 04 Nov 2020 7:22 pm ok, please send me the link for the script, I cant find it.
If I dont get the script I will have to put my data of monthlylogs.txt to Ms Access, right?
It's here: https://cumuluswiki.org/a/ImportCumulusFile
thank you. I ll try that
Top
geoplr
Posts: 14
Joined: Thu 21 Jan 2010 12:22 pm
Weather Station: national geographic 265
Operating System: win xp sp3, Mac OS

Re: Cumulus database

Post by geoplr »

I don't have a webserver
I don't have MySQL
I'm free...
(paraphrase of Nick Kazantzakis' moto...)
Top
Post Reply

Return to “Cumulus MX version 3 (since build 3043)”