Page 1 of 1
Error in dayfile
Posted: Sat 01 Jan 2022 10:29 pm
by access-mdb
I'm trying to fix the dayfile and it keeps coming with an error but I can't see what's wrong. Attached is a file with the error line from the MXdiags and the line specified in the error - with the two lines before and after. I can't see why the line is wrong - can anyone see what I can't
please?
cmxerror.txt
Re: Error in dayfile
Posted: Sat 01 Jan 2022 11:52 pm
by PaulMy
I presume line 561 in your dayfile.txt is for date 07/01/2017 is that correct?
Looking at the 5 days data you have shown that looks ok, however, and I may be wrong, I had thought dayfile.txt always is format with 2 digits for year like dd/mm/yy Are all your years in 4 digits?
Does the Dayfile data display correctly for that date in your Dashboard Data Logs > Dayfile tab?
Can you highlight, copy those lines gain and add within the </> code display like this as that will be much easier to look at
Code: Select all
2997 05/01/17 40.7 270 08:43 -12.2 23:42 -6.8 13:01 1010.3 00:06 1016.9 23:55 0.0 00:00 0.0 -9.2 190.2 17.2 00:42 72 00:00 88 16:16 0.00 0.5 -6.8 13:01 -10.8 14:27 -16.4 23:53 0.0 00:00 -18.8 04:02 -8.8 13:44 -15.9 23:42 276 27.5 0.0 0 00:00 0.0 00:00 -7.1 14:30 -16.3 03:40 -6.8 13:10
2998 06/01/17 29.9 269 11:57 -15.2 08:27 -8.5 12:45 1016.6 00:54 1028.1 23:47 0.0 00:00 0.0 -12.3 49.8 12.9 13:15 62 12:52 100 23:25 0.00 4.6 -8.5 12:45 -12.9 14:33 -18.7 08:27 0.0 00:00 -20.2 10:06 -13.0 15:43 -17.7 08:27 275 30.6 0.0 0 00:00 0.0 00:00 -9.2 14:30 -17.0 10:40 -8.5 12:50
2999 07/01/17 40.7 272 19:09 -14.7 07:46 -9.3 13:51 1027.6 01:05 1030.4 10:29 0.0 00:00 0.0 -11.6 136.6 17.2 18:44 72 14:10 96 00:00 0.00 3.1 -9.3 13:51 -13.9 11:06 -18.1 07:46 0.0 00:00 -19.8 20:42 -12.5 19:00 -16.4 07:46 272 29.9 0.0 0 00:00 0.0 00:00 -10.3 17:20 -17.5 18:50 -9.5 11:50
3000 08/01/17 49.2 315 14:32 -10.6 00:00 -7.8 14:22 1027.4 00:49 1038.2 20:56 0.0 00:00 0.0 -9.6 245.6 19.3 09:37 78 15:26 97 10:02 0.00 0.8 -7.8 14:22 -12.0 21:12 -17.0 07:20 0.0 00:00 -20.2 03:10 -10.6 12:21 -13.6 07:36 289 27.9 0.0 0 00:00 0.0 00:00 -8.9 18:30 -17.3 09:40 -7.9 14:20
Enjoy,
Paul
Re: Error in dayfile
Posted: Sun 02 Jan 2022 9:53 am
by access-mdb
Thanks Paul, yes it's 2017 from my Fine Offset I had then. Interesting about the year format. I see that the dayfile's data for yesterday is formatted with yy, not yyyy, but the column heading says dd/mm/yyy, which is why I changed the years. I suspect it copes with both formats.
I've looked at the dayfile in the dashboard and that date is definitely wrong. I've tested the line but putting into Excel and converting text to commas - that converts it perfectly. I then typed that data by hand, and still the error persisted. This led me to believe that the conversion of the year from yy to yyyy might be the culprit, so I manually changed the year to 17 and now it works. So I was misled by the header in the dayfile viewer to change the year format and one date value caused a problem. What is it about 07/01/2017,0 that screws the data, but 07/01/17,0 doesn't? And no other date has the problem!
I won't change any of the year formats back as they all (bar one) seem to work. Unless, of course, someone says they have to be yy. But if I have to manually insert any days, they will be yy.
Cheers
Malcolm
Re: Error in dayfile
Posted: Sun 02 Jan 2022 11:56 am
by access-mdb
OK, I found another example of the problem after all, so I've changed the years to yy format - now no error and I can now see January's NOAA report, well its start anyway.
Thanks again Paul, you may not have found the error but you pointed me in the right direction.
Re: Error in dayfile
Posted: Sun 02 Jan 2022 3:54 pm
by mcrossley
The year format is two digits in the dayfile.
To find the original error I think you would have to post the whole file for examination rather than extracting parts of it.
I'll get the editor text fixed for the next release.