jefit

Data analysis stuff for the Jefit Android App backup database. See the Jefit Data Munging serie of posts at OpenSysBlog for more information.

Starting from version 5.0910 the database is encrypted (see [this post](see http://www.jefit.com/forum/showthread.php?35904-Accesing-backup-file-)) so this code works only with versions older than 5.0910

Tools available

jefit-data-analysis.R

R script for reading the Jefit backup database and create a PDF file with some training statistics graphs. It has the following dependencies:

* DBI
* RSQLite
* ggplot2
* scales
* grid

jefit-data-munging.pl

Perl script for migrating the Jefit backup database to a custom database. This script uses the DBIx::Class model libraries under lib/.

create-myjefit-db.sh

Shell script for creating the custom database. It uses the SQL statements contained in the file myjefit-boostrap.sql

References

• Jefit Data Munging Part I Part II Part III Part IV Part V Part VI Part VII Part VIII Part IX Part X Part XI Part X
• JEFIT Android Workout Tracker http://www.jefit.com/