Date stamps incorrect when using Save Data on Monitor Visualizer
Posted: Mon Jun 12, 2023 1:32 pm
When you export data from the monitor log using Save Data, the dates and times are reformatted by the software, and all values from midnight to 1 am are incorrect. When you save data using Log to File, the dates and times are correctly saved. Below is some sample data illustrating the problem:
These are CSV strings sent by the Arduino Mega 2560.
These are the CSV strings as shown on the monitor log - the dates and times are correct
2023/06/08 23:59:16,Thursday,40.8,49.5,12.84,0.00,-0.12,-0.19,-0.44,0.28,0,4,0,1,1,3648.9
2023/06/08 24:00:19,Thursday,40.4,49.4,12.84,0.00,-0.22,-0.19,-0.44,0.38,0,nan,0,1,1,3648.9
2023/06/08 24:59:54,Thursday,39.5,44.8,12.82,0.00,-0.12,-0.24,-0.44,0.28,0,nan,0,1,1,3648.9
2023/06/09 01:00:56,Friday,39.3,44.7,12.82,0.00,-0.12,-0.14,-0.44,0.28,0,nan,0,1,1,149.9
These are the same records exported from the monitor log using the Save Data button on the Monitor display
Note the date/time stamp has been reformatted and errors occur during hour = 24
6/8/2023 23:59 Thursday 40.8 49.5 12.84 0 -0.12 -0.19 -0.44 0.28 0 4 0 1 1 3648.9
45086.00022 Thursday 40.4 49.4 12.84 0 -0.22 -0.19 -0.44 0.38 0 nan 0 1 1 3648.9
45086.0416 Thursday 39.5 44.8 12.82 0 -0.12 -0.24 -0.44 0.28 0 nan 0 1 1 3648.9
6/9/2023 1:00 Friday 39.3 44.7 12.82 0 -0.12 -0.14 -0.44 0.28 0 nan 0 1 1 149.9
These are the same 4 records saved automatically by the MegunoLink Log to File (with it's own date/time stamp added)
Note the original CSV date/time stamp formatting is correct
2023-06-09 00:03:10 2023/06/08 23:59:16,Thursday,40.8,49.5,12.84,0.00,-0.12,-0.19,-0.44,0.28,0,4,0,1,1,3648.9
2023-06-09 00:04:13 2023/06/08 24:00:19,Thursday,40.4,49.4,12.84,0.00,-0.22,-0.19,-0.44,0.38,0,nan,0,1,1,3648.9
2023-06-09 01:03:47 2023/06/08 24:59:54,Thursday,39.5,44.8,12.82,0.00,-0.12,-0.24,-0.44,0.28,0,nan,0,1,1,3648.9
2023-06-09 01:04:50 2023/06/09 01:00:56,Friday,39.3,44.7,12.82,0.00,-0.12,-0.14,-0.44,0.28,0,nan,0,1,1,149.9
Conclusion: The Log to File function correctly saves the Arduino date/time stamps, but the Save Data function from the monitor screen scrambles the date/time formats from midnight to 1 am.
These are CSV strings sent by the Arduino Mega 2560.
These are the CSV strings as shown on the monitor log - the dates and times are correct
2023/06/08 23:59:16,Thursday,40.8,49.5,12.84,0.00,-0.12,-0.19,-0.44,0.28,0,4,0,1,1,3648.9
2023/06/08 24:00:19,Thursday,40.4,49.4,12.84,0.00,-0.22,-0.19,-0.44,0.38,0,nan,0,1,1,3648.9
2023/06/08 24:59:54,Thursday,39.5,44.8,12.82,0.00,-0.12,-0.24,-0.44,0.28,0,nan,0,1,1,3648.9
2023/06/09 01:00:56,Friday,39.3,44.7,12.82,0.00,-0.12,-0.14,-0.44,0.28,0,nan,0,1,1,149.9
These are the same records exported from the monitor log using the Save Data button on the Monitor display
Note the date/time stamp has been reformatted and errors occur during hour = 24
6/8/2023 23:59 Thursday 40.8 49.5 12.84 0 -0.12 -0.19 -0.44 0.28 0 4 0 1 1 3648.9
45086.00022 Thursday 40.4 49.4 12.84 0 -0.22 -0.19 -0.44 0.38 0 nan 0 1 1 3648.9
45086.0416 Thursday 39.5 44.8 12.82 0 -0.12 -0.24 -0.44 0.28 0 nan 0 1 1 3648.9
6/9/2023 1:00 Friday 39.3 44.7 12.82 0 -0.12 -0.14 -0.44 0.28 0 nan 0 1 1 149.9
These are the same 4 records saved automatically by the MegunoLink Log to File (with it's own date/time stamp added)
Note the original CSV date/time stamp formatting is correct
2023-06-09 00:03:10 2023/06/08 23:59:16,Thursday,40.8,49.5,12.84,0.00,-0.12,-0.19,-0.44,0.28,0,4,0,1,1,3648.9
2023-06-09 00:04:13 2023/06/08 24:00:19,Thursday,40.4,49.4,12.84,0.00,-0.22,-0.19,-0.44,0.38,0,nan,0,1,1,3648.9
2023-06-09 01:03:47 2023/06/08 24:59:54,Thursday,39.5,44.8,12.82,0.00,-0.12,-0.24,-0.44,0.28,0,nan,0,1,1,3648.9
2023-06-09 01:04:50 2023/06/09 01:00:56,Friday,39.3,44.7,12.82,0.00,-0.12,-0.14,-0.44,0.28,0,nan,0,1,1,149.9
Conclusion: The Log to File function correctly saves the Arduino date/time stamps, but the Save Data function from the monitor screen scrambles the date/time formats from midnight to 1 am.