Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export to csv - weight

Dokac77
over 4 years ago

Hi,

I am not sure I am doing this right way. I would like to export data behind chart weight. I am setting yearly view export data and ... out puts 2 rows for each measurement, in one I have date (kind of weird format) and empty figures in second i have exact time with weight, change, and BMI. Is it a bug or a feature  ?

Best Regards,

Dominik

  • 0 over 4 years ago

    Just checked on my side. It looks like a bug to me (though Garmin will probably claim the contrary) - the time should be included in the same field with the date, and there should be no new line after the date. Report it to the Customer Support.

  • 0 over 4 years ago

    Even I have the same problem. CSV export I think has a bug. It gets 2 entries for each entry. Date on one line and time and data on the next. 

    Would be really helpful, if Garmin can fix this. Even I export the entire data for my own analysis. 

  • 0 over 4 years ago in reply to galoi
    galoi said:
    Would be really helpful, if Garmin can fix this.

    Did you report it to Garmin? If no, then the chance is dim.

  • 0 over 4 years ago in reply to trux

    I don't think it's a bug, I think it's a deliberate design decision in order to allow for multiple weigh-ins per day, and to also "group" data by day. It just looks weird and pointless if you never have more than one data point per day.

    It would probably make more sense to put both the date and time in the time column, for every row, and to not have "blank" rows with no data, in order to normalize the data (so it's good for either human or machine consumption).

    If you use a tool such as csvtojson to convert the CSV data to JSON, then you can reshape it with jq and output it back to CSV.

  • 0 over 4 years ago in reply to WillNorthYork

    Agreed! I later realised the change would have been brought in for multiple weigh-ins. And like you said adding the date to the time field will help resolve this for machine consumption.