Problems after manual data import to Garmin Connect Web

I learned a really cool method to import body fat percentage recently:

https://www.reddit.com/r/Garmin/comments/1cotdqs/manually_add_body_fat_numbers_to_weight_is_it/

I've been adding my weight to MacroFactor, letting it compute my trend weight, then adding that to Garmin Connect (GC) via this import (along with body fat estimates via calipers).

The reason I went down this path is because my fitness age was grossly inaccurate because of my inaccurate BMI. I'm 48, weigh 175, and am pretty lean (15-20% body fat). I weight train and do cardio 4-6 days per week. BMI alone is a garbage metric as we all know (I'm far from overweight), so I wanted to fine tune my fitness age with body fat percentage. This manual import allowed me to do this without purchasing a scale.

The problem: I used the basic format of that CSV linked to above and I notice two things (format attached as image below).

First, the time always shows as 5pm in Garmin Connect, despite including it in the weight.csv. This leads me to believe I'm not formatting the time correctly (I'm using 00:00:00) and GC is using a default. This in itself is not a big deal, but I'd like to know what the CSV import expects for time format. When you map the fields in the data import UI, there is not a time component so I'm not sure. Docs?

The second thing is that the data are not showing up in the Garmin Connect Web (GCW) app; it is showing up in Garmin Connect on my phone. When I look at the weight widget online, I see the below for all dates since I started doing this manual data import.

You have no data for this time period.

I should note that when viewing the 7 day trend of the weight data online in the GCW app, I do see the weight and body fat data. It appears that only the 1 day data is missing.

  • Only one weight record per day can be imported, and the time cannot be specified.

  • Thanks

    Weird, okay... I can accept the time issue. Maybe they'll expose that field via the import API some time so users can specify the time like the mobile app does.

    But I'm not sure your comment on one per day explains why the 1 day widget doesn't show my data in the GCW app. I do already only add one weight record per day. Before May 5th, I did this via the GC mobile app, from May 6 thru today I've done this via the manual import in the GCW app.

    To clarify, I use that weight CSV daily to add weight data to GC. Each day I edit the date, add the weight and other data and upload it via the GCW import data widget. Once per day.

  • But I'm not sure your comment on one per day explains why the 1 day widget doesn't show my data in the GCW app.

    I do not know why that happens to you, since in my case it works as expected, and the value is visible on the one-day page instantly after reloading the page. There could be perhaps some relation with the time zone, since my imported weight-ins are timed at 2:00. I am in the TZ UTC+2 (actually GMT+1 + 1hr DST). So if you are in negative TZ (-5), the weight-in may land in tomorrow's data (it looks like the import adds the TZ value to UTC 0:00).

    You could try playing with the parameter Upload Time Zone at https://connect.garmin.com/modern/settings/displayPreferences and see whether it has any impact, but I rather suspect that this parameter is not used in this case in fact, and that's the root of the problem. EDIT: I just tested it, and the Upload TZ setting indeed has no impact.

  • This is good. Thank you very much. I will play around with that parameter.

  • I edited the post in the meantime - already tested, and the weight-in time stays unaffected. It indeed imports always with the time 0:00 UTC, so if you are in TZ GMT-5, then you probably won't see it until tomorrow

  • You may consider reporting it to the Support, and make sure they file it properly as a bug

  • This is good information, thanks for investigating this. I'd like to point out that we are talking about these data appearing in several different areas of GC mobile app and GCW app.

    1. In GCW app, in the main dashboard, the little rectangular widget is in fact one day behind. Looks like your claim is correct

    2. In GCW app, If I click into the weight dashboard, the 1 day weigh ins are "absent" all the way back to May 5, the last time I added weight data in the GC mobile app. The 7 day, 4 week, etc all show the correct data

    3. In GC mobile app, in the main dashboard, the little rectangular widget is in fact one day behind (same as GCW app)

    4. In GC mobile app, If I click into the weight dashboard, the weigh ins are "not absent" and they appear for all, eg, 1 day, 7 day, etc...

    I will reach out and report this as a bug to Garmin.