Pull Highs & Lows From A Certain Date From Dayfile.txt

[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?

[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.

[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

[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.

[steve]

The nearest you can get directly from Cumulus currently is View -> This Period and limit it to the day you want.

[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