Error in dayfile

[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

[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

[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

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

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