Importing from other Applications

Fitnotes

Import Exercise table

The exercise list from Fitnotes can be imported into Fast N Fitness, this will make it easier to import past workouts.

1. Export Fitnotes as a database

2. Use the following SQLite command to create a table of exercises that is compatible with Fast N Fitness:

   SELECT "EFmachines" AS "table",
   _id AS id,
   name,
   notes AS description,
   0 AS type,
   CASE
                                         /*Fitnotes  => Fast and Fitness */
       WHEN category_id = '1'  THEN 10   /*Shoulders => Shoulders    */
       WHEN category_id = '2'  THEN 13   /*Triceps   => Triceps      */
       WHEN category_id = '3'  THEN 2    /*Biceps    => Biceps       */
       WHEN category_id = '4'  THEN 4    /*Chest     => Chest        */
       WHEN category_id = '5'  THEN 1    /*Back      => Back         */
       WHEN category_id = '6'  THEN 11   /*Legs      => Thigh        */
       WHEN category_id = '7'  THEN 0    /*Abs       => Abdominals   */
   END AS bodyparts,
   "false" AS favorites
   FROM exercise;

3. Export that table as a csv

4. Import into Fast and Fitness

When the table is exported it should look something like this:

table,id,name,description,type,bodyparts,favorites
EFmachines,1,Overhead Press,,0,10,false
EFmachines,2,Seated Dumbbell Press,,0,10,false
EFmachines,3,Lateral Dumbbell Raise,,0,10,false
EFmachines,4,Front Dumbbell Raise,,0,10,false
EFmachines,5,Push Press,,0,10,false
EFmachines,6,Behind The Neck Barbell Press,,0,10,false
EFmachines,7,Hammer Strength Shoulder Press,,0,10,false
EFmachines,8,Seated Dumbbell Lateral Raise,,0,10,false
EFmachines,9,Lateral Machine Raise,,0,10,false
EFmachines,10,Rear Delt Dumbbell Raise,,0,10,false
EFmachines,11,Rear Delt Machine Fly,,0,10,false
EFmachines,12,Arnold Dumbbell Press,,0,10,false
EFmachines,13,One-Arm Standing Dumbbell Press,,0,10,false
EFmachines,14,Cable Face Pull,,0,10,false
EFmachines,15,Log Press,,0,10,false
EFmachines,16,Smith Machine Overhead Press,,0,10,false
EFmachines,17,Close Grip Barbell Bench Press,,0,13,false
EFmachines,18,V-Bar Push Down,,0,13,false
EFmachines,19,Parallel Bar Triceps Dip,,0,13,false
EFmachines,20,Lying Triceps Extension,,0,13,false
EFmachines,21,Rope Push Down,,0,13,false
EFmachines,22,Cable Overhead Triceps Extension,,0,13,false
EFmachines,23,EZ-Bar Skullcrusher,,0,13,false
EFmachines,24,Dumbbell Overhead Triceps Extension,,0,13,false
EFmachines,25,Ring Dip,,0,13,false
EFmachines,26,Smith Machine Close Grip Bench Press,,0,13,false
EFmachines,27,Barbell Curl,,0,2,false
EFmachines,28,EZ-Bar Curl,,0,2,false
EFmachines,29,Dumbbell Curl,,0,2,false
EFmachines,30,Seated Incline Dumbbell Curl,,0,2,false
EFmachines,31,Seated Machine Curl,,0,2,false
EFmachines,32,Dumbbell Hammer Curl,,0,2,false
EFmachines,33,Cable Curl,,0,2,false
EFmachines,34,EZ-Bar Preacher Curl,,0,2,false
EFmachines,35,Dumbbell Concentration Curl,,0,2,false
EFmachines,36,Dumbbell Preacher Curl,,0,2,false
EFmachines,37,Flat Barbell Bench Press,,0,4,false
EFmachines,38,Flat Dumbbell Bench Press,,0,4,false
EFmachines,39,Incline Barbell Bench Press,,0,4,false
EFmachines,40,Decline Barbell Bench Press,,0,4,false
EFmachines,41,Incline Dumbbell Bench Press,,0,4,false
EFmachines,42,Flat Dumbbell Fly,,0,4,false
EFmachines,43,Incline Dumbbell Fly,,0,4,false
EFmachines,44,Cable Crossover,,0,4,false
EFmachines,45,Incline Hammer Strength Chest Press,,0,4,false
EFmachines,46,Decline Hammer Strength Chest Press,,0,4,false
EFmachines,47,Seated Machine Fly,,0,4,false
EFmachines,48,Deadlift,,0,1,false
EFmachines,49,Pull Up,,0,1,false
EFmachines,50,Chin Up,,0,1,false
EFmachines,51,Neutral Chin Up,,0,1,false
EFmachines,52,Dumbbell Row,,0,1,false
EFmachines,53,Barbell Row,,0,1,false
EFmachines,54,Pendlay Row,,0,1,false
EFmachines,55,Lat Pulldown,,0,1,false
EFmachines,56,Hammer Strength Row,,0,1,false
EFmachines,57,Seated Cable Row,,0,1,false
EFmachines,58,T-Bar Row,,0,1,false
EFmachines,59,Barbell Shrug,,0,1,false
EFmachines,60,Machine Shrug,,0,1,false
EFmachines,61,Straight-Arm Cable Pushdown,,0,1,false
EFmachines,62,Rack Pull,,0,1,false
EFmachines,63,Good Morning,,0,1,false
EFmachines,64,Barbell Squat,,0,11,false
EFmachines,65,Barbell Front Squat,,0,11,false
EFmachines,66,Leg Press,,0,11,false
EFmachines,67,Leg Extension Machine,,0,11,false
EFmachines,68,Seated Leg Curl Machine,,0,11,false
EFmachines,69,Standing Calf Raise Machine,,0,11,false
EFmachines,70,Donkey Calf Raise,,0,11,false
EFmachines,71,Barbell Calf Raise,,0,11,false
EFmachines,72,Barbell Glute Bridge,,0,11,false
EFmachines,73,Glute-Ham Raise,,0,11,false
EFmachines,74,Lying Leg Curl Machine,,0,11,false
EFmachines,75,Romanian Deadlift,,0,11,false
EFmachines,76,Stiff-Legged Deadlift,,0,11,false
EFmachines,77,Sumo Deadlift,,0,11,false
EFmachines,78,Seated Calf Raise Machine,,0,11,false
EFmachines,79,Ab-Wheel Rollout,,0,0,false
EFmachines,80,Cable Crunch,,0,0,false
EFmachines,81,Crunch,,0,0,false
EFmachines,82,Crunch Machine,,0,0,false
EFmachines,83,Decline Crunch,,0,0,false
EFmachines,84,Dragon Flag,,0,0,false
EFmachines,85,Hanging Knee Raise,,0,0,false
EFmachines,86,Hanging Leg Raise,,0,0,false
EFmachines,87,Plank,,0,0,false
EFmachines,88,Side Plank,,0,0,false
EFmachines,89,Cycling,,0,,false
EFmachines,90,Walking,,0,,false
EFmachines,91,Rowing Machine,,0,,false
EFmachines,92,Stationary Bike,,0,,false
EFmachines,93,Swimming,,0,,false
EFmachines,94,Running (Treadmill),,0,,false
EFmachines,95,Running (Outdoor),,0,,false
EFmachines,96,Elliptical Trainer,,0,,false
EFmachines,97,Iso-Lateral Row (Hammer Strength),,0,1,false
EFmachines,98,Inner Thigh Machine,The Jujitsu Style Machine,0,11,false
EFmachines,99,Power Clean,,0,1,false
EFmachines,100,Upright Dumbbell Row,,0,10,false
EFmachines,101,Barbell Hack Squat,,0,11,false
EFmachines,102,Incline Cable Flye,,0,4,false
EFmachines,103,MTS Abdominal Crunch,,0,0,false
EFmachines,104,Tricep Cable Kickbacks,,0,13,false
EFmachines,105,Linear Hack Press (Hammer Strength),,0,11,false
EFmachines,106,Spider Curls,,0,2,false
EFmachines,107,Cable Tricep Extension Machine,,0,13,false
EFmachines,108,Cable Chest Press Machine,,0,4,false
EFmachines,109,Back Extension,The machines laying around at the gym,0,1,false
EFmachines,110,Hip abductor (Life Fitness),,0,11,false
EFmachines,111,Biceps Curl (Hammer Strength),,0,2,false
EFmachines,112,Cable Shoulder Press Machine,,0,10,false
EFmachines,113,Seated Cable Leg Press Machine,,0,11,false
EFmachines,114,Cable Upright Dumbbell Row,,0,10,false
EFmachines,115,Seated Machine Cable Row,,0,1,false
EFmachines,116,Flat Dumbbell Press,,0,4,false