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

OK, figured out why my weight file wouldn't import (only likes one weight per day in the file), but the timestamp is wrong.

I have several years of data from Fitbit, including weight/body fat, as well as activities. Per the help page, the import format should be CSV and look like this:

Body
weight,bmi,fat,date,time

So, it only allows one import per date at a time (so, if I have multiple weigh-ins on the same date, I have to import them one at a time. Ugh. Fine).

However, I imported this:

Body
weight,bmi,fat,date,time
190.8,25.3,16.1,2016-11-12,20:52:04

And this was the result:

Why does it say 7:00 PM when I imported 20:52:04? I deleted and re-imported with 08:52:04 PM with the same result. What format should I use to get the correct timestamp on the report?

0 trux 6 months ago

splorp! said:
it only allows one import per date at a time

No, you can put as many data lines as you want. Works fine, tested many times. You cannot import multiple entries for the same day, though. AFAIK, the time cannot be imported, only the date.

This is a sample CSV file:

Body
Date,Weight,BMI,Fat
"2022-11-03","71.6","22.6","14.4"
"2022-11-04","71.6","22.6","14.4"

There can be multiple lines of data, but the first 2 header lines appear just once. Use a plain-text editor such as Notepad for creating the file. Do not use any rich-text editors like Word or Wordpad. And avoid Excel.

0 splorp! 6 months ago in reply to trux

Those are two separate dates. If you have two weights for the same day, the upload fails.

0 trux 6 months ago in reply to splorp!

Exactly. That's what I wrote - you can only import one weight entry per day, and no time