When exporting blood pressure data the resulting CSV file is incorrectly formatted.
As it is today the format is (header + example line):
Time,Reading,Heart Rate,Category,Notes,<LF>
" 2024 Oct 5",<LF>
23:19,130 Sys / 87 Dia,84 bpm,High-Normal,"This is high, not very high",<LF>
It should be:
"Time","Reading","Heart Rate","Category","Notes"<CR><LF>
" 2024-10-05T23:19:00","130 Sys / 87 Dia","84 bpm","High-Normal","This is high, not very high"<CR><LF>
Or, much better yet:
Time, Systolic, Diastolic, Heart Rate, "Category", "Notes"<CR><LF>
2024-10-05T23:19:00, 130, 87,84,"High-Normal","This is high, not very high"<CR><LF>
That is:
- headers in same format as lines
- text qualifier in all data except numbers or only in the Notes field (the only one that will allow commas, maybe also on the category one for future proofing), but in uniform way
- Line separator as CR LF and not only LF
- No line separator in the middle of the time field
- Time in ISO 8601
- Separating Sys and Dia in diffrent fields
