jovandeginste / workout-tracker

A workout tracking web application for personal use (or family, friends), geared towards running and other GPX-based activities
Other
887 stars 26 forks source link

Import from csv #134

Open DavidHenryThoreau opened 2 months ago

DavidHenryThoreau commented 2 months ago

I'm testing workout-tracker , I love that app which runs fast on Docker image :+1:

I'd like to import past workouts from csv file which is formatted like that (I don't have gpx files any more) :

id,uuid,user_id,sport_id,title,gpx,creation_date,modification_date,workout_date,duration,pauses,moving,distance,min_alt,max_alt,descent,ascent,max_speed,ave_speed,bounds,map,map_id,weather_start,weather_end,notes
39,3958a0ec-f780-4579-b7a4-28deffdd8fe5,3,14,Mont Mc,,2018-08-13,,2018-08-13,7:30:00,,7:30:00,20,,3169,,,,,,,,,,-Salomon

I've search database.db but it seems to only get stats on gpx source.

jovandeginste commented 2 months ago

Would it be reasonable to re-format as json with a specific structure?

DavidHenryThoreau commented 2 months ago

At the moment I only have that csv file , I mean in the database structure there's not km or elevation, It seems just to use GPX files in order to get stats. Could you add an interface to add workouts without gpx like fittrackee does ?

jovandeginste commented 2 months ago

There are already a number of supported file formats, gpx is just one. To add a generic one, I should think about a generic structure.