-
Notifications
You must be signed in to change notification settings - Fork 346
CVS export details
Charles Combes edited this page Jul 4, 2022
·
18 revisions
- Exercise type are now exported in text (0 => strength, 1 => cardio, 2 => isometric)
- Units are now exported in text
- Changes column name "poids" by "weight" in Record csv
- Changes column name "mesure" by "measure" in Body measure csv
- Programs and Program templates are now exported
- Weight and Distance in the Record and Program Templates are now output in accordance with their unit and not anymore in a normalized Kg or Km value
- Changes column titles to english words and all capital letters
- Table header renamed for more clarity. Example: EFFontes => RECORD
On Database export, files are exported to the Download folder: /sdcard/Download/FastnFitness/export/2022_01_15_21_5_13/export_<type>_<profil>.csv
-
export_Records_<profile>.csv : Contains all the records from free workout or from program workout for a specific <profile>
-
export_BodyMeasures_<profile>.csv : Contains all the body measures for a specific <profile>
-
export_BodyParts.csv : Contains all the custom body parts of the app.
-
export_Exercises.csv : Contains all the exercises and machines of the app.
-
export_Programs.csv : Contains all the programs of the app.
-
export_ProgramTemplates.csv : Contains all the templates of the programs of the app.
| Field | Mandatory | Type | Description |
|---|---|---|---|
| TABLE | mandatory | string | Has to be "EFfontes" or "RECORD" for records and has to be "TEMPLATE" for program templates |
| DATE | mandatory | date | Date of the record in YYYY-MM-DD |
| TIME | mandatory | time | Time of the record in HH:MM:SS |
| EXERCISE | mandatory | string | Name of the exercise |
| EXERCISE_TYPE | mandatory | string enum: "strength", "cardio", "isometric" | Type of Exercise |
| SETS | mandatory | integer | Nb of sets |
| REPS | optional | integer | Nb of repetitions |
| WEIGHT | optional | float | Weight of strength exercises with the WEIGHT_UNIT unit |
| WEIGHT_UNIT | optional | string enum : "kg", "lb", "st" | Weight unit |
| SECONDS | optional | integer | Duration of isometric exercises |
| DISTANCE | optional | float | Distance for cardio exercises |
| DISTANCE_UNIT | optional | string enum : "km", "miles" | Distance unit |
| DURATION | optional | integer | Time length for cardio exercises |
| NOTES | optional | string | Stored but not displayed in app |
| RECORD_TYPE | mandatory | string enum : "free_record", "program_record", "program_template" | "free_record" is a record that has been created from a free workout. "program_record" is a record that has been created from a program workout. "program_template" is a record created from the program editor to tell which exercise needs to be done. |
| PROGRAM_NAME | optional | string | Name of the program for "program_record" and "program_template". If no program with this name exists then it is created automatically. If there is already a program with this name, then it is added to the program. |
| TEMPLATE_REST_TIME | optional | integer | How much time to rest after this exercise |
| TEMPLATE_ORDER | optional | integer | Order in the program |
| TEMPLATE_SETS | optional | integer | Nb of sets |
| TEMPLATE_REPS | optional | integer | Nb of repetitions |
| TEMPLATE_WEIGHT | optional | float | Weight for strenght template exercises with the TEMPLATE_WEIGHT_UNIT unit |
| TEMPLATE_WEIGHT_UNIT | optional | string enum : "kg", "lb", "st" | Weight unit |
| TEMPLATE_SECONDS | optional | integer | Time length for cardio template exercises |
| TEMPLATE_DISTANCE | optional | float | Distance for cardio template exercises |
| TEMPLATE_DISTANCE_UNIT | optional | string enum : "km", "miles" | Distance unit |
| TEMPLATE_DURATION | optional | integer | Time length for cardio exercises |
| TEMPLATE_RECORD_STATUS | optional | string enum : "success", "failed", "none" | Status of the record |
TABLE,DATE,TIME,EXERCISE,EXERCISE_TYPE,SETS,REPS,WEIGHT,WEIGHT_UNIT,SECONDS,DISTANCE,DISTANCE_UNIT,DURATION,NOTES,RECORD_TYPE,PROGRAM_NAME,TEMPLATE_REST_TIME,TEMPLATE_ORDER,TEMPLATE_SETS,TEMPLATE_REPS,TEMPLATE_WEIGHT,TEMPLATE_WEIGHT_UNIT,TEMPLATE_SECONDS,TEMPLATE_DISTANCE,TEMPLATE_DISTANCE_UNIT,TEMPLATE_DURATION,TEMPLATE_RECORD_STATUS
RECORD,2022-02-06,09:17:39,Example 2,strength,1,10,60.0,lb,0,0.0,km,0,,program_record,Program 1,60,2,1,10,60.0,lb,0,0.0,km,0,success
RECORD,2022-02-06,09:17:38,Example 1,strength,1,10,99.0,kg,0,0.0,km,0,,program_record,Program 1,60,1,1,10,99.0,kg,0,0.0,km,0,success
RECORD,2022-02-06,09:17:36,Example 0,strength,1,10,60.0,lb,0,0.0,km,0,,program_record,Program 1,60,0,1,10,60.0,lb,0,0.0,km,0,success
RECORD,2022-01-16,16:52:29,Example 1,strength,1,10,50.0,lb,0,0.0,km,0,,program_record,Program 1,60,1,1,10,50.0,lb,0,0.0,km,0,success
RECORD,2022-01-16,16:52:27,Example 0,strength,1,10,60.0,lb,0,0.0,km,0,,program_record,Program 1,60,0,1,10,60.0,lb,0,0.0,km,0,success
RECORD,2022-01-16,16:44:23,Example 2,strength,1,10,60.0,lb,0,0.0,km,0,,free_record
RECORD,2022-01-16,08:05:19,Iso Machine,isometric,1,0,60.0,lb,60,0.0,km,0,,free_record
| Field | Mandatory | Type | Description |
|---|---|---|---|
| TABLE | mandatory | string | Has to be "EFbodyparts" or "BODYPART" |
| CUSTOM_NAME | mandatory | string | Name of the body part |
| CUSTOM_PICTURE | optional | string | NOT SUPPORTED YET |
Note: A body part and a muscle is different even is both could be linked.
- A body part is something that you can measure in "cm" or "in" (size of the right biceps for example or size of hips).
- A muscle is something that you can use like quadriceps. The muscle list cannot be edited in the app.
TABLE,CUSTOM_NAME,CUSTOM_PICTURE
BODYPART,Left small finger,
| Field | Mandatory | Type | Description |
|---|---|---|---|
| TABLE | mandatory | string | Has to be "EFbodymeasures" or "BODYMEASURE" |
| DATE | mandatory | date | Date when the measure has been taken. Format YYYY-MM-DD. |
| BODYPART_NAME | mandatory | string | Name of the bodypart in your local language |
| MEASURE | mandatory | float | Type of exercise |
| UNIT | mandatory | string emum: "cm", "in", "kg", "in" | unit of the measure |
TABLE,DATE,BODYPART_LABEL,MEASURE,UNIT
BODYMEASURE,2022-01-16,Petit doigt,9.0,cm
BODYMEASURE,2022-01-10,Petit doigt,5.0,cm
BODYMEASURE,2021-12-08,Poids,24.0,kg
BODYMEASURE,2021-12-08,Graisse,77.0,%
BODYMEASURE,2021-12-08,Muscles,41.666664,%
BODYMEASURE,2021-12-08,Eau,8.333334,%
BODYMEASURE,2021-12-07,Muscles,173.75,%
| Field | Mandatory | Type | Description |
|---|---|---|---|
| TABLE | mandatory | string | Has to be "EFmachines" or "EXERCISE" |
| NAME | mandatory | string | Name of the exercise |
| DESCRIPTION | optional | string | Description of the exercise |
| TYPE | mandatory | string enum: "strengh", "cardio", "isometric" | Type of exercise |
| BODYPARTS | optional | integer list | List of muscles separated by ";". See table below. |
| FAVORITE | optional | boolean: "true" or "false" | Is this exercise part of favorite exercises |
| Muscles | Number |
|---|---|
| ABDOMINAUX | 0 |
| ADDUCTEURS | 1 |
| BICEPS | 2 |
| TRICEPS | 3 |
| DELTOIDS | 4 |
| MOLLETS | 5 |
| PECTORAUX | 6 |
| DORSEAUX | 7 |
| QUADRICEPS | 8 |
| ISCHIOJAMBIERS | 9 |
| LEFTBICEPS | 10 |
| RIGHTBICEPS | 11 |
| LEFTTHIGH | 12 |
| RIGHTTHIGH | 13 |
| LEFTCALVES | 14 |
| RIGHTCALVES | 15 |
| WAIST | 16 |
| NECK | 17 |
| BEHIND | 18 |
| WEIGHT | 19 |
| FAT | 20 |
| BONES | 21 |
| WATER | 22 |
| MUSCLES | 23 |
| TRAPEZIUS | 24 |
| OBLIQUES | 25 |
| SHOULDERS | 26 |
| SIZE | 27 |
| GLUTES | 28 |
TABLE,NAME,DESCRIPTION,TYPE,BODYPARTS,FAVORITE
EXERCISE,Example 1,,strength,9;10;12;13,false
EXERCISE,Example 2,,strength,2;5;6;7;11,false
EXERCISE,Iso Machine,,isometric,,false
EXERCISE,NewRecord,,cardio,,false
| Field | Mandatory | Type | Description |
|---|---|---|---|
| TABLE | mandatory | string | Has to be "EFworkout" or "PROGRAM" |
| NAME | mandatory | string | Name of the program |
| DESCRIPTION | optional | string | Description of the program |
TABLE,NAME,DESCRIPTION
PROGRAM,Program 1,Description 1
PROGRAM,Program 2,Description 2
TABLE,DATE,TIME,EXERCISE,EXERCISE_TYPE,SETS,REPS,WEIGHT,WEIGHT_UNIT,SECONDS,DISTANCE,DISTANCE_UNIT,DURATION,NOTES,RECORD_TYPE,PROGRAM_NAME,TEMPLATE_REST_TIME,TEMPLATE_ORDER
TEMPLATE,2022-02-06,09:20:25,Example 3,strength,3,10,33.0,lb,0,0.0,km,0,,program_template,Program 1,60,3
TEMPLATE,2022-01-10,21:39:53,Example 0,strength,1,10,60.0,lb,0,0.0,km,0,,program_template,Program 3,60,1
TEMPLATE,2022-01-10,21:39:56,Example 1,strength,1,10,50.0,lb,0,0.0,km,0,,program_template,Program 3,60,2
TEMPLATE,2022-01-15,21:04:50,NewRecord 4,cardio,0,0,0.0,kg,0,10.0,km,600000,,program_template,Program 3,60,5
TEMPLATE,2022-01-15,21:04:50,NewRecord 9,cardio,0,0,0.0,kg,0,10.0,km,600000,,program_template,Program 3,60,0
TEMPLATE,2022-01-10,21:39:58,Example 6,strength,1,10,60.0,lb,0,0.0,km,0,,program_template,Program 3,60,4
TEMPLATE,2022-01-10,21:39:58,Example 5,strength,1,79,20.0,lb,0,0.0,km,0,,program_template,Program 3,60,3
TEMPLATE,2022-01-16,16:30:53,Example 2,strength,1,10,60.0,lb,0,0.0,km,0,,program_template,Program 1,60,2
TEMPLATE,2022-01-16,16:30:49,Example 1,strength,1,10,99.0,kg,0,0.0,km,0,,program_template,Program 1,60,1
TEMPLATE,2022-01-16,16:30:28,Example 0,strength,1,10,60.0,lb,0,0.0,km,0,,program_template,Program 1,60,0