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.
Date stamps incorrect when using Save Data on Monitor Visualizer
Hi John,
Sorry for the trouble you're having with MegunoLink. I'm a bit unclear where the problem lies; would you mind clarifying a couple of things for me please:
* are you seeing the incorrect date stamps when using the "Monitor" or "Message Monitor" visualizer?
* do the incorrect date stamps show up next to the line numbers in blue or with the text (in black)?
* what version of MegunoLink are you using (Help->About)? What you described shouldn't be possible in recent versions, unless I've misunderstood what the problem is. The latest version is 1.36.22351.1217.
* could you send a screenshot showing the problem? I realize this may be difficult if the problem only occurs at midnight.
* could you send the section of Arduino code sending the time and csv values please?
Have a good day
Paul.
Sorry for the trouble you're having with MegunoLink. I'm a bit unclear where the problem lies; would you mind clarifying a couple of things for me please:
* are you seeing the incorrect date stamps when using the "Monitor" or "Message Monitor" visualizer?
* do the incorrect date stamps show up next to the line numbers in blue or with the text (in black)?
* what version of MegunoLink are you using (Help->About)? What you described shouldn't be possible in recent versions, unless I've misunderstood what the problem is. The latest version is 1.36.22351.1217.
* could you send a screenshot showing the problem? I realize this may be difficult if the problem only occurs at midnight.
* could you send the section of Arduino code sending the time and csv values please?
Have a good day
Paul.