Manually enter Tanita measures

Time to respond

I have been amongst the many people requesting the ability to add the other data fields in the health tab since it first appeared well over a year ago.

The number of posters in this forum asking for that feature to be activated, surely suggests that this feature should be unlocked. I for one am not going to by another set of Tanita scales or replace my Forerunner 110 or Edge 705 just to use this feature.

I am disappointed, but honsetly not surprised to see that there is not one comment/response from Garmin to these requests.

Come on Garmin - MAN UP and respond! :mad:

CSV File

You can manually copy the datas and correct them, delete measurements in "connect" (new feature), and upload a FIT file with the corrected points. A bit boring so ;)

The way to do the FIT file consist of editing a CSV file and convert it to FIT using the jar provided with FIT SDK, you just need Java to run the jar file. I can give you the CSV file to do that.
If you do not understand a word of this previous statement, you can wait I (or somebody else) write a tool, but I can't give you any deadline because I'm quite busy now (there no Thanksgiving in France :D).

Could you provide the CSV file? I would be interested in pursuing the method that you described with the FIT SDK.

FIT tool

You can manually copy the datas and correct them, delete measurements in "connect" (new feature), and upload a FIT file with the corrected points. A bit boring so ;)

The way to do the FIT file consist of editing a CSV file and convert it to FIT using the jar provided with FIT SDK, you just need Java to run the jar file. I can give you the CSV file to do that.
If you do not understand a word of this previous statement, you can wait I (or somebody else) write a tool, but I can't give you any deadline because I'm quite busy now (there no Thanksgiving in France :D).

I'm considering writing a tool to do this. Any more details on how exactly you did it would be great to help get me started. Could you also post that csv?

Thanks!

Here is how to do it.

I'm considering writing a tool to do this. Any more details on how exactly you did it would be great to help get me started. Could you also post that csv?

Thanks!

I figured it out. I would like to build a small app rather than using a spreadsheet but for now it works.

1. Go to http://www.thisisant.com/pages/ant/fit-license and download the FIT SDK.
2. Extract the contents to your hard drive (ex: C:\FITSDK\) *** Note - do not add spaces in your folder names or file names.
3. Place the attached csv file in folder on your desktop or a place that is convenient for you.
4. Place the attached txt file in the same folder and rename it with a .bat extention.
5. Edit the csv file with your health statistics.
6. You can removed fields if you do not want to update them - make sure to remove all references in the csv file.
7. The values in the csv file are in kg only. If your scale is set for lbs then convert the values when you enter into the csv file. The function CONVERT(C18,"lbm","g") in Excel works great to covert lbs to grams - then divide by 1000. Also you must enter a timestamp - which is the number of seconds since 12/30/1989. You can use the Excel function DateDiff("s", #12/30/1989#, dEntryDate) where dEntryDate is the date that you want the stats for.
8. Edit the CreateWeightFTFile.bat file and change the folder paths to match where you have the csv file, the FitCSVTool.jar file, and the path and name of the output fit file. The FitCSVTool.jar is located under the java folder where you extracted your FITSDK.zip. *** Note - do not add spaces in your folder names or file names.
9. Now run the CreateWeightFTFile.bat file. Check the output path location and you should see a newly created fit file.
10. Go to http://connect.garmin.com and click on the "Upload" button.
11. Select "Manual Upload" at the bottom.
12. Click "Choose File", browse to fit file and select.
13. Click "Upload Activities from File" - you should see a green check and you may see a message that says some activities could not be created. Ignore this.
14. Click on the "Health" tab and you should see your stats for today.
15. There is a good deal of documentation in the FITSDK which will give you record layouts and business rules.

Let me know if you have questions - this is a simple quick solution - nothing fancy. :)

Very nice! Worked perfectly, thanks. I have a Withings on the way and between this and their API I hope to be able to import Withings data with just a few clicks. Will keep you posted...

A few minor tweaks for anyone using these instructions:

Number of seconds should be from 12/31/1989 (not 12/30)
The Excel 2007 formula for timestamps is =DATEDIF("12/31/1989", H9, "d")*24*60*60
(where H9 is the cell that contains the date you want converted)

Very nice! Worked perfectly, thanks. I have a Withings on the way and between this and their API I hope to be able to import Withings data with just a few clicks. Will keep you posted...

A few minor tweaks for anyone using these instructions:

Number of seconds should be from 12/31/1989 (not 12/30)
The Excel 2007 formula for timestamps is =DATEDIF("12/31/1989", H9, "d")*24*60*60
(where H9 is the cell that contains the date you want converted)

I must of had my formula wrong because I kept coming up with yesterday's date when I imported - so that is why I changed it to 12/30. I tried the formula that you provided but I still get yesterday's date when I import the data. The value for 01/14/2011 is 663984000. 663897600 is the number I get if I use 12/31/1989. 663897600 displays the value of 1/13/2011 when I import. How are the dates for your import working?

I figured it out. I would like to build a small app rather than using a spreadsheet but for now it works.

1. Go to http://www.thisisant.com/pages/ant/fit-license and download the FIT SDK.
2. Extract the contents to your hard drive (ex: C:\FITSDK\) *** Note - do not add spaces in your folder names or file names.
3. Place the attached csv file in folder on your desktop or a place that is convenient for you.
4. Place the attached txt file in the same folder and rename it with a .bat extention.
5. Edit the csv file with your health statistics.
6. You can removed fields if you do not want to update them - make sure to remove all references in the csv file.
7. The values in the csv file are in kg only. If your scale is set for lbs then convert the values when you enter into the csv file. The function CONVERT(C18,"lbm","g") in Excel works great to covert lbs to grams - then divide by 1000. Also you must enter a timestamp - which is the number of seconds since 12/30/1989. You can use the Excel function DateDiff("s", #12/30/1989#, dEntryDate) where dEntryDate is the date that you want the stats for.
8. Edit the CreateWeightFTFile.bat file and change the folder paths to match where you have the csv file, the FitCSVTool.jar file, and the path and name of the output fit file. The FitCSVTool.jar is located under the java folder where you extracted your FITSDK.zip. *** Note - do not add spaces in your folder names or file names.
9. Now run the CreateWeightFTFile.bat file. Check the output path location and you should see a newly created fit file.
10. Go to http://connect.garmin.com and click on the "Upload" button.
11. Select "Manual Upload" at the bottom.
12. Click "Choose File", browse to fit file and select.
13. Click "Upload Activities from File" - you should see a green check and you may see a message that says some activities could not be created. Ignore this.
14. Click on the "Health" tab and you should see your stats for today.
15. There is a good deal of documentation in the FITSDK which will give you record layouts and business rules.

Let me know if you have questions - this is a simple quick solution - nothing fancy. :)

Excellent - This works perfectly and can now chuck away the pen and paper. Wonder how easy it would be to write an iPhone app to populate the excel spreadsheet

App in the works

Wonder how easy it would be to write an iPhone app to populate the excel spreadsheet

Actually I threw together in app Sunday night to do just that. Need to test a bit more then I'll post.

So I started a basic app and using it's datetime calculations it also shows 1/14/2011 as 663897600. As expected for me 663984000 shows as 1/15 when imported. What timezone are you in? Maybe it's taking that into consideration. I'm at -8. Maybe if your +X GMT you have to adjust.

If you're interested in connecting, could you ping me via this contact form so I can get your email address (it's my site, sent only to me)?

http://www.rpoint.com/Contact.aspx

I could use your feedback while I develop this thing.

Thanks-
Mike

Sounds good. I sent email to your site and would like to offer feedback on your app. Let me know if I can help.

- Mark