topic Import TCX files into Qlik Sense desktop? in Connectivity & Data Prep

Import TCX files into Qlik Sense desktop?

Tue, 06 Jan 2015 13:31:08 GMT

I would like to import TCX files from Garmin Connect into Qlik Sense Desptop application, in order to run more indepth analysis on the activity data. Does anyone know whether this is possible? If this is possible, will Qlik Sense allow me to import a zip file with multiple TCX files?

If this is not possible, is there an alternative way to import this data from Garmin connect to Qlik Sense?

Thanks in advance,

Martijn

Re: Import TCX files into Qlik Sense desktop?

Anonymous — Tue, 06 Jan 2015 14:25:59 GMT

Hi Martijn

You can export from Garmin Connect to csv and then use this file to import into Sense.

Re: Import TCX files into Qlik Sense desktop?

Tue, 06 Jan 2015 14:52:13 GMT

HI Tim,

Thx for your quick answer. I have looked into that as well, but this option has 2 main drawbacks:

1. I lose a lot of details (e.g information about splits)

2. I can only export activities page by page

However, if that's the only solution, I have to live with it...

Thanks again!

Martijn

Re: Import TCX files into Qlik Sense desktop?

Anonymous — Tue, 06 Jan 2015 15:07:46 GMT

Hi,

1) I have the options to export splits to csv - so I don't lose any data. Of course this may be how we're both using Garmin Connect, but I can get all my splits out OK using this.

2) Agreed - this is a pain however I don't use Garmin Connect directly.

There are a couple of other options which I've played with. If you use any other sports data programs, like Sports Tracks then the export from these are probably better than Garmin Connect. (EG I use Sports Tracks to import my .fit files, which I can then export out of)

If your raw files going into Garmin Connect are .fit files, you could also look at the Fit SDK and in particular FitCSVTool.jar.

Re: Import TCX files into Qlik Sense desktop?

Tue, 06 Jan 2015 15:19:44 GMT

Interesting. How do manage to export splits to csv in Garmin connect?

Re: Import TCX files into Qlik Sense desktop?

Anonymous — Tue, 06 Jan 2015 15:22:40 GMT

On the activity page, top right gear icon, then Export Splits to CSV.