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

CSV Layout for Fitbit import

I'm trying to import data from both Huawei and Xiaomi(Zepp) into Garmin Connect.

I'm only really trying to get the acitvities over, all the regular tracking isn't all that important to me, however the import at stock CSV doesn't work (expected as much, both CSVs have different formatting)

Whats the standard CSV format, or the layout rather, and the correct headers for the fitbit import in Garmin Connect? Also is there an acitvity list, since the activities on both CSVs are just "type 24" for example?

Kind Regards

Stan

0 trux over 2 years ago

As for the Sport IDs, you can find them for example here: https://developer.garmin.com/connect-iq/api-docs/Toybox/ActivityRecording.html

As for the Fitbit file format for activities, I do not have any sample, but the best would be looking for it on Fitbit's website, or asking someone on their forum to export you a sample file. Please note though, that you cannot import a CSV file with an activity list! You can only import Fitbit, GPX, TCX, or FIT files of individual activities. It means a file per activity, no list!

0 9396184 over 2 years ago in reply to trux

Thanks, that clears the conversion from the zepp activity format to garmins activity numbers.

Do you happen to have the layout that a garmin .fit file must have to import it?

Currently my headers in the csv (that I will convert to .fit files) looks like this:

0 trux over 2 years ago in reply to 9396184

9396184 said:
Do you happen to have the layout that a garmin .fit file must have to import it?

The complete specification of the FIT protocol is available at https://developer.garmin.com/fit/protocol/

You can convert a sample activity to CSV with the FIT CSV tool and have a look what it contains. It is a rather complex format though, so I'd rather suggest using one of the other alternatives.

0 9396184 over 2 years ago in reply to trux

Well then quite frankly what would you suggest?

I'm starting to be so pissed off about this entire ordeal that I don't even want to get a garmin anymore.

My browser is filled with actual hundreds of tabs with ways to format my csv to different formats and layouts but nothing actually seems to work, at this point I'm wondering if anyone ever actually managed to import their sports activities from other providers to garmin.

How is it even possible that a company such as Garmin would actively try to make conversion TO THEIR SYSTEM as hard as humanly possible and turn potential customers away.

Its baffling. And stupid.

/End_rant

0 trux over 2 years ago in reply to 9396184

9396184 said:
I'm starting to be so pissed off about this entire ordeal that I don't even want to get a garmin anymore.

Frankly told Garmin Connect was designed for Garmin devices, not for Huawei or Xiaomi , and there is no need to import your old activities there. Just use it for your Garmin device, and use Huawei's and/or Xiaomi's interfaces for their devices.

If you really need your Huawei/Xiaomi activities in Garmin Connect for some reason, and they cannot be exported in any of the supported formats, then the easiest conversion would be probably the FitBit CSV format - find a sample file on the web, or on Fitbit's website / forum, and modify your CSV files accordingly. If not that, then the TCX file format is human-friendly too, and it should not be too difficult to find a suitable converter for it.

9396184 said:
How is it even possible that a company such as Garmin would actively try to make conversion TO THEIR SYSTEM as hard as humanly possible and turn potential customers away.

You can also ask why Huawei or Xiaomi made it so hard to export their activities in some of the formats that are accepted in Garmin Connect. And they are many.

0 9396184 over 2 years ago in reply to trux

trux said:
and there is no need to import your old activities there.

Are you serious? I don't know a single person who tracks their activites who would NOT want to bring their old data with them for comparison reasons.

Also I don't want to use garmin for my "other devices" I want to keep historic data for comparison reasons.

trux said:
You can also ask why Huawei or Xiaomi made it so hard to export their activities in some of the formats that are accepted in Garmin Connect. And they are many

Okay what the hell? No I would not ask that, the reason for not exporting data is as straight as can be since that would actually allow people to leave their system easier.

Importing on the other hand is an incentive for people to migrate INTO the system.

I'd write Garmin directly and ask whether they might enable further import options at some point, but its not like anything would come of it.

0 trux over 2 years ago in reply to 9396184

If you google the conversion from Huawei activity files to Garmin, then there are quite a few hits. I did not read any of them, but in your place, googling the topic would be the first thing I'd do if I had such need as you:

convert huawei smartwatch file to garmin - Google Search

Besides the converters, and the GPX export at Huawei, the syncing to Strava and then exporting the activity from there (or using Strava for your comparisons) sounds to be a decent solution too.