Errors in Dayfile cant be restored from 'month' files.

[Warrandyte]

I am having an issue with the Daily Summary file that is showing blank records.

http://www.warrandytefarm.com/weather/daily.htm

I understand it is caused by errors in the dayfile.txt, do I rebuilt it from monthly files be deleting it and using the rebuild function. however I noticed there were still issues - even more in fact, so began investigating the month files.

I am sure that at some point I opened these with a third party ap and they may have saved when they were open and UPS caused a sgutdown on power failure and saved them

is there any way to validate the month files e.g. May14log.txt and write any "bad" values.
Ive tried exports to excel and using the =text(b2,"dd/mm/yyyy") format to correct the dates where month or day is less than 10 (as they write 1/1/14 rather than 01/01/2014 which is what cumulus requires)
I have noticed that in some areas it requires "0.0" rather than "0" and in others requires "0" rather than "0.0"

Is there a definition of the formats for these files?
has anyone written a "fixer" for them?

is there an easy fix for the dayfiles?

also, is there a way to just completely rebiuld the data set from the month files including all the various records (day, month year, alltime)

I have noticed the processor halt around certain dates but when processing it it is hard to tell which line it has failed on.

examples of data files have been posted at www.warrandytefarm.com/data

[steve]

The formats of the log files are in the help and in the wiki. The date format is important, and editing the files in Excel or similar is warned against as it is highly likely to break the date format. Deleting dayfile.txt and attempting to recreate it from scratch is a drastic move and will result in a file that is not as good (in terms of data accuracy) as the one you started with (as the monthly logs do not necessarily contain all of the highs and lows).

You can recreate all of the highs and lows using the built-in editors, but you will have to do each one manually - once you have corrected the date format.

Cumulus normally flashes the error light if there is a problem in dayfile.txt, and tell you exactly which line is at fault, but I think that when you talk about processing the file you're referring to something written by someone else, and I can't help with that.

01/01/2014 which is what cumulus requires

Cumulus requires dd/mm/yy, e.g. 01/01/14

I have noticed that in some areas it requires "0.0" rather than "0" and in others requires "0" rather than "0.0"

The two humidity values, the two wind bearing values, and the two solar radiation values have to be integers, the others are usually floating point but can be specified as integers.