Page 1 of 1
Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Sun 06 Jul 2014 1:11 am
by Buford T. Justice
Is there a way to get the highs and lows just like todayT.htm and yesterdayT.htm do for a certain date from the dayfile.txt file?
Re: Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Sun 06 Jul 2014 8:08 am
by steve
You can look at them in the dayfile.txt editor. But if you mean for use on a web site, not directly from Cumulus at the moment (because of the overhead of fetching them from the file when the web tag is processed). You could do what a number of people do, and feed your dayfile.txt into a database on the web server, and extract them from that.
Re: Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Sun 06 Jul 2014 8:26 am
by sfws
https://cumulus.hosiene.co.uk/viewtopic.php?f=14&t=8631 includes a routine for matching what appears on today/yesterday by taking the relevant fields from dayfile. EDIT - removed comment
Re: Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Sun 06 Jul 2014 1:06 pm
by Buford T. Justice
Not really for displaying on a website, but more for pulling a report formatted like todayT.htm. I report that data along with rain to CoCoRaHS and sometimes I get so busy it slips my mind so I don't notice I missed a day or two until after several days have passed.
Re: Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Sun 06 Jul 2014 2:37 pm
by steve
The nearest you can get directly from Cumulus currently is View -> This Period and limit it to the day you want.
Re: Pull Highs & Lows From A Certain Date From Dayfile.txt
Posted: Mon 07 Jul 2014 2:55 am
by Buford T. Justice
Well I grabbed the bull by the horns and made a spreadsheet to do the work. It is not a perfect format but it is very close and the extra spaces can be easily removed. It is attached if anyone wants it. It is in
OpenOffice.org Calc format.
To use it:
1) Open dayfile.txt with OpenOffice.org Calc.
2) Select the entire line for the date you need by clicking on the number to the left of the date. When it is highlighted in blue, right-click on the date and copy it. You will need all of the data on the entire line.
3) Open "BT's Cumulus Historic Data.ots" within the .zip file attached to this post.
4) At the bottom left, pick your data format from Metric, Imperial, Knots Metric, or Combined.
5) Paste the entire line of data you copied to cell A1
