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

Importing data from fitbit to Garmin Connect - Format for importing csv?

Mikael Jenkler
over 3 years ago

I am trying to import data from fitbit cvs files. Problem is that sleep data is not imported correctly (No data).

Is there anyone here that have a spec of import data format. Maybe I can write a convert script. Is there any devs from garmin on this forum?

SAMPLE:

--------------

Body
Date,Weight,BMI,Fat
"01-08-2021","79.23","23.4","0"

Activities
Date,Calories Burned,Steps,Distance,Floors,Minutes Sedentary,Minutes Lightly Active,Minutes Fairly Active,Minutes Very Active,Activity Calories
"01-08-2021","5,383","45,726","36.04","0","583","225","33","337","4,170"

Sleep
Start Time,End Time,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed,Minutes REM Sleep,Minutes Light Sleep,Minutes Deep Sleep
"01-08-2021 5:40 am","01-08-2021 10:02 am","231","31","15","262","45","171","15"

--------------

1. Weight and the step data gets imported but not the sleep. It feels like its something wrong with the dateformat "01-08-2021 5:40 am". 

2. Another strange thing is that i can delete data from a day but the weight data is still there. 

3. Any spec on format structures for us devs ? 

  • 0 over 3 years ago

    Thanks BunBun! but I have checked the forum and web for solutions without luck!

    1. If i set fitbit to (english US) then the date is 

    2021-08-01 And then it works with default settings for garmin import indeed. But it also work to change date format and use 01-08-2021 setting in the importer.


    2. But this is not the issue, the issue is that sleep data does not get imported. It would be nice if there existed any type of spec for importing data. The garmin devs must surely have this right?
    Note! There are no errors when I import the data, only the issue that no sleepdata gets imported.

    3. Found a solution for the weight issue. It does not get deleted when deleted from 

    https://connect.garmin.com/modern/daily-summary/2021-08-01

    but if you visit 

    https://connect.garmin.com/modern/weight/2021-08-01/3

    Then you can delete them. Every time you import data you gets dubs of weight (Feels like a bug). And You cant remove it from daily-summery.

    I hope there is a way to import sleep data. Any advice is appreciated ;)

  • 0 over 3 years ago

    Trying to figure this out, it seems that it skips sleep completely. If I enter some errors in the sleepdata it does not complain at all.

    Does someone know if sleepdata has ever worked?

    A few notes!

    We can import Body, Activities and Sleep manually and the order does not matter.
    (The name of input matters and count)

    Activities
    Date,Calories Burned,Steps,Distance,Floors,Minutes Sedentary,Minutes Lightly Active,Minutes Fairly Active,Minutes Very Active,Activity Calories
    "2021-08-01","5,383","45,726","36.04","0","583","225","33","337","4,170"

    Mapping
    Date => Date <-- Format YYYY-MM-DD
    Total Calories => Calories Burned

    Body
    Date,Weight,BMI,Fat
    "2021-08-01","79.23","23.4","0"

    Mapping
    Date => Date <-- Format YYYY-MM-DD
    Weight => Weight
    BMI => BMI
    Fat => Body Fat <-- Format NN.N

    Sleep
    Start Time,End Time,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed,Minutes REM Sleep,Minutes Light Sleep,Minutes Deep Sleep
    "01-08-2021 5:40 am","01-08-2021 10:02 am","231","31","15","262","45","171","15"


    Sleep
    Date,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed
    "2021-08-01","231","31","15","262"


    BUGS:
    Only take date format YYYY-MM-DD no support for hour and minuters


    Body
    Date,Weight,BMI,Fat
    "01-08-2021","79.23","23.4","0"

    Activities
    Date,Calories Burned,Steps,Distance,Floors,Minutes Sedentary,Minutes Lightly Active,Minutes Fairly Active,Minutes Very Active,Activity Calories
    "01-08-2021","5,383","45,726","36.04","0","583","225","33","337","4,170"

    Sleep
    Start Time,End Time,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed,Minutes REM Sleep,Minutes Light Sleep,Minutes Deep Sleep
    "01-08-2021 5:40 am","01-08-2021 10:02 am","231","31","15","262","45","171","15"