Golden Cheetah .json import

Jan_Paduschek · 30 May 2022 09:47

Hi guys,
how do you import the GoldenCheetah .json activitie files into intervals.icu?
I have them save in Dropbox but it seems like they are not recognized as an activity.

thanks
Jan

david · 30 May 2022 14:36

I am not familiar with GC .json files. Intervals.icu looks for fit, tcx and gpx files as well as .gz versions and zips of the same.

Jan_Paduschek · 30 May 2022 18:15

ok understood, it actually is a zipped .json

looking something like this (shortend):


	"RIDE":{
		"STARTTIME":"2022\/05\/30 16:17:58 UTC ",
		"RECINTSECS":1,
		"DEVICETYPE":"GoldenCheetah ",
		"IDENTIFIER":" ",
		"TAGS":{
			"Athlete":"Jeti ",
			"Data":"TDSPHC--------- ",
			"Device":"GoldenCheetah ",
			"File Format":" ",
			"Filename":"2022_05_30_18_17_58.json ",
			"Month":"Mai ",
			"Route":"3x(10 x30 sec) ",
			"Source Filename":"2022_05_30_18_17_58_3x(10 x30 sec)_2022_05_30_18_17_58.csv ",
			"Weekday":"Mo ",
			"Year":"2022 "
		},
		"INTERVALS":[
			{ "NAME":"0 ", "START": 0, "STOP": 0, "COLOR":"#000000", "PTEST":"false" },
			{ "NAME":"1 ", "START": 1, "STOP": 3119, "COLOR":"#000000", "PTEST":"false" }
		],
		"SAMPLES":[
			{ "SECS":0, "KM":0, "WATTS":103, "CAD":77, "KPH":3.25002, "HR":95 },
			{ "SECS":1, "KM":0.00138051, "WATTS":110, "CAD":78, "KPH":6.3054, "HR":95 },
			{ "SECS":2, "KM":0.00347265, "WATTS":105, "CAD":78, "KPH":8.42638, "HR":96 },
			{ "SECS":3, "KM":0.00609024, "WATTS":102, "CAD":80, "KPH":10.0204, "HR":97 },
			{ "SECS":4, "KM":0.00910317, "WATTS":102, "CAD":83, "KPH":11.3142, "HR":97 },
			{ "SECS":5, "KM":0.0124541, "WATTS":116, "CAD":84, "KPH":12.5157, "HR":97 },
			{ "SECS":6, "KM":0.0161467, "WATTS":112, "CAD":84, "KPH":13.6205, "HR":98 },
			{ "SECS":7, "KM":0.0202787, "WATTS":110, "CAD":86, "KPH":14.5974, "HR":99 },
			{ "SECS":8, "KM":0.0243518, "WATTS":93, "CAD":84, "KPH":15.3347, "HR":99 },
			{ "SECS":9, "KM":0.0287701, "WATTS":77, "CAD":85, "KPH":15.8276, "HR":100 },
			{ "SECS":10, "KM":0.0332699, "WATTS":77, "CAD":85, "KPH":16.1961, "HR":100 },
			{ "SECS":11, "KM":0.0385362, "WATTS":83, "CAD":81, "KPH":16.6283, "HR":100 },
			{ "SECS":12, "KM":0.0430722, "WATTS":87, "CAD":79, "KPH":17.0072, "HR":101 },
			{ "SECS":13, "KM":0.0465425, "WATTS":92, "CAD":78, "KPH":17.2801, "HR":102 },
			{ "SECS":14, "KM":0.0514684, "WATTS":102, "CAD":78, "KPH":17.6821, "HR":103 },
			{ "SECS":15, "KM":0.056498, "WATTS":108, "CAD":77, "KPH":18.1343, "HR":104 },
			{ "SECS":16, "KM":0.0616664, "WATTS":107, "CAD":76, "KPH":18.5938, "HR":105 }
			]
		}
		]
	}
}```

should this be recognized?
thanks
Jan

technophobe · 31 May 2022 04:25

I’ll see if the JSON format is documented. In the meantime, I believe that Golden Cheetah can export into TCX format, as well:

technophobe · 31 May 2022 04:29

Kind of related…this seems interesting:

/<athlete>/activity/<filename>      
Fetch activity file

format=xxx where xxx is one of csv, tcx, json, pwx

Returns ride file data in the requested format

technophobe · 31 May 2022 04:35

This appears to be the source for the GC JSON file format:

github.com

GoldenCheetah/GoldenCheetah/blob/master/src/FileIO/JsonRideFile.y

%{
/*
 * Copyright (c) 2010 Mark Liversedge (liversedge@gmail.com)
 *
 * This program is free software; you can redistribute it and/or modify it
 * under the terms of the GNU General Public License as published by the Free
 * Software Foundation; either version 2 of the License, or (at your option)
 * any later version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for
 * more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc., 51
 * Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 */

// This grammar should work with yacc and bison, but has

This file has been truncated. show original

david · 31 May 2022 19:44

The best would be to get the original fit file for the actvity. 2nd best would be a fit file export from GC. 3rd best is tcx.

schpongo · 23 November 2024 09:48

Hey there,

I’m thinking of making the switch from Golden Cheetah (GC). But the data import and linked data loss is currently preventing me from switching.

Firstly, I don’t want to import the data from the original files, as I’ve modified them in GC with additional data. Secondly, I also can’t use the strava import as not all data is synced to strava.

I can export my GC data as .txc or .fit file which I can then import into intervals.icu. However, I lose the following data fields which I’ve tracked over years and which would be available from the .json export from GC:

RPE: Also available in intervals.icu
Objective: Not available, but could be mapped to Notes in intervals.icu
Notes: Also available in intervals.icu
Workout Code: Not available, but could be mapped to Tags in intervals.icu

I don’t know how large the group of users is that would like to make the switch from GC. Subsequently, I can not judge how import a robust .json import from GC would be and If a robust import can actually be implemented, as different users my use the fields differently and would like the data to be mapped to to dfferent fields in intervals.icu.

Here are my three suggestions to solve this issue:
S1: If I can download the intervals.icu file, I could implement a mapping in a small python script my self.
S2: The platform could implement a basic import, more like a quick fix
S3: The platform could think about a import tool with user specific custom mapping

Thanks for the help and great tool.
Once I’d make the switch, I’d love to support the tool.

Greetings from the trainer
Daniel