Syncing data from Tanita RD-545 HR

I have solved getting this data into Garmin Connect! However this is a manual process you would have to do everytime you want import the data. You will also need a computer this isn't something you can do from your phone. The good news is it's not that crazy. You basically just need to be able to edit excel csv files and also be able to run 1 line of Java.

First off you need to download your Tanita data. You can either do it from the mobile phone app by going to results and the pressing the share button in the top right hand corner and exporting the file via email or you can go to https://mytanita.eu/ choose my measurements and then import/export - export list as csv. 

First thing to do with your tanita data is convert the Date to the Garmin Epoch timestamp. The Garmin Epoch timestamp is the number of seconds since 1989–12–31T00:00:00Z. To do this you need to insert a column in between Date and Weight in your tanita data then use this formula =(A2-DATE(1989,12,31))*86400. Excel might make this some weird date so make sure you right click and choose format then format the cells as a number with 0 decimal places. This will give you the right time stamp figures. 

From here put all your data into a format exactly like below. You can continue to add lines. I used this table to about 300 lines of weight data. The top 4 lines are the format you need and then from 5 down it's just your data. Just make sure you continue the same format.

Alright that is your CSV file done but we need to turn it into a FIT file to be able to import all the extra data into garmin. To be able to do that we need to be able to use the FIT CSV Tool which you need to download from Garmin's Developer tools here: https://developer.garmin.com/fit/download/ Once you have downloaded it extract the files. I put them on my desktop for ease of use later. The folder name will be similar to FitSDKRelease_21.126.00. Inside that there is a bunch of folders. I created a new one called "weight" so that I could keep it separate to everything there. You need to place your csv file into that new folder you create.

You will need Java to be able to utilise these tools. If you don't have Java you can download it here: https://www.oracle.com/java/technologies/downloads/ - Choose the right download for your operating system for example - If you are using an M chip Mac you need the ARM version if you are on an intel Mac you need the x64 version. 

Now lets convert that csv file to a FIT file. You need to right click on your FitSDKRelease_21.126.00 folder and choose: New Terminal at Folder (if you're on Mac) or Open in Terminal (if on windows).

In the terminal you will want to use this script: 

java -jar ./java/FitCSVTool.jar ./weight/nameofyourcsvfile.csv

Make sure you change "weight" to whatever you've named your new folder and change "nameofyourcsvfile" to whatever you have called your csv file. just make sure theres no spaces in the names.

Once you have run the script you will get some text advising it is encoding. That new FIT file will now be in your "weight" folder right next to your csv file but with the .fit file type.

That new FIT file is the one we will upload to garmin connect.

To do this you need to go to: https://connect.garmin.com/modern/import-data 

Click browse or drag and drop your new fit file into the upload area and press import data.

All the data you had in that csv file will now be added to garmin connect. 

My advice is if you are going to do this practice first with just a couple of dates because if you do a full import of all your data and you get something wrong. You have to individually delete the weight data and garmin reloads the entire screen each time you click delete. There is no bulk delete weight data option.

If anyone knows anyone that would be able to turn the above process into an app or even better yet a direct integration to garmin connect that would be great. I figure it should be able to be done with API's from Tanita and Garmin but i don't have the technical skills to be able to bring it to life.