Page 1 of 1
Cumulus database
Posted: Tue 03 Nov 2020 5:51 pm
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?
Re: Cumulus database
Posted: Tue 03 Nov 2020 9:04 pm
by TRB
How far back?
You could set your 'graph hours' to around 8650 and see a full year's worth.
Re: Cumulus database
Posted: Tue 03 Nov 2020 10:31 pm
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.
Re: Cumulus database
Posted: Wed 04 Nov 2020 7:22 pm
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?
Re: Cumulus database
Posted: Wed 04 Nov 2020 7:27 pm
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?
Re: Cumulus database
Posted: Wed 04 Nov 2020 7:53 pm
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.
Re: Cumulus database
Posted: Wed 04 Nov 2020 9:01 pm
by geoplr
outdated profile of mine
Re: Cumulus database
Posted: Wed 04 Nov 2020 9:15 pm
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
Re: Cumulus database
Posted: Thu 05 Nov 2020 6:32 pm
by geoplr
Re: Cumulus database
Posted: Fri 06 Nov 2020 4:55 pm
by geoplr
I don't have a webserver
I don't have MySQL
I'm free...
(paraphrase of Nick Kazantzakis' moto...)