I have found a way to export data from jefit.bak to excel(.csv) whilst rustling my jimmies after entering 2 hours of logs.
I found this out right after I opened .bak using notepad, and noticed “sqlite” throughout the document, which tingles my spidey senses to check out sqlite.
Sqlite is a database management system, which links to JEFIT’s data system. So I googled more and found a sqlite browser, a database viewer. There, I was able to export the data to excel (.csv)
What you will need:
- Computer skills
- Jefit.bak or jefit_pro.bak, pretty sure the steps will work for both
- Sqlite browser [url]http://sourceforge.net/projects/sqlitebrowser/[/url]
- .csv viewer (Microsoft Excel, apple excel, google docs, etc.)
This method work for Microsoft Excel.
Steps:
A. Acquire Jefit.bak or jefit_pro.bak
D. Extraction
Now the graphs, I am still experimenting with my data, I will probably post later. If you know how to show the data using graphs please share!
As stated this method work for Microsoft Excel. I haven't tried it on other software yet since I don't have the time.
Cheers!
I found this out right after I opened .bak using notepad, and noticed “sqlite” throughout the document, which tingles my spidey senses to check out sqlite.
Sqlite is a database management system, which links to JEFIT’s data system. So I googled more and found a sqlite browser, a database viewer. There, I was able to export the data to excel (.csv)
What you will need:
- Computer skills
- Jefit.bak or jefit_pro.bak, pretty sure the steps will work for both
- Sqlite browser [url]http://sourceforge.net/projects/sqlitebrowser/[/url]
- .csv viewer (Microsoft Excel, apple excel, google docs, etc.)
This method work for Microsoft Excel.
Steps:
A. Acquire Jefit.bak or jefit_pro.bak
1. Start JEFIT app on phone
2. Go to “Profile”
3. Click “Backup” to create .bak file
4. Connect phone to computer
5. Find .bak file, use the search tool and search for jefit.bak
6. Copy .bak file to desktop
B. Acquire sqlite browser2. Go to “Profile”
3. Click “Backup” to create .bak file
4. Connect phone to computer
5. Find .bak file, use the search tool and search for jefit.bak
6. Copy .bak file to desktop
1. Download sqlite browser
2. Unzip sqlite browser
C. Preparation2. Unzip sqlite browser
1. Start sqlite browser
2. Open jefit.bak or jefit_pro.bak file
3. Under “Edit” click “Modify Table”
4. Select “exerciseLogs”
5. Edit
6. Delete edit_time, belongSys, _id, eid, dat_item_id, record (forgot to delete mine in pic)
7. Close the small window
2. Open jefit.bak or jefit_pro.bak file
3. Under “Edit” click “Modify Table”
4. Select “exerciseLogs”
5. Edit
6. Delete edit_time, belongSys, _id, eid, dat_item_id, record (forgot to delete mine in pic)
7. Close the small window
D. Extraction
1. In sqlite browser, under “file”>”export”>”table as CSV file”
2. Select “exerciseLogs”
3. Export
4. Pick a name to save as, save
E. Excel format2. Select “exerciseLogs”
3. Export
4. Pick a name to save as, save
1. Open your exported file
2. Open with excel
3. “save as” filename and select .csv (Comma delimited)
F. Data format2. Open with excel
3. “save as” filename and select .csv (Comma delimited)
1. All your data might be in column A, select column A
2. Under “Data” tab, click “Text to Columns
3. Select “Delimited”
4. Check “Comma”
5. “Finish”
7. Repeat steps 2-5 for each weightxsets to split them into their own separate columns if you want to, however you must insert a column between each weightxsets to prevent overwriting.
i. You now have your exercise logs data listed in excel in columns
2. Under “Data” tab, click “Text to Columns
3. Select “Delimited”
4. Check “Comma”
5. “Finish”
i. Your data should now have their own respective columns
1. Mydate, ename, logs
6. Repeat steps 2-5 for the “logs” column, your weightxsets should now split into separate columns1. Mydate, ename, logs
7. Repeat steps 2-5 for each weightxsets to split them into their own separate columns if you want to, however you must insert a column between each weightxsets to prevent overwriting.
i. You now have your exercise logs data listed in excel in columns
Now the graphs, I am still experimenting with my data, I will probably post later. If you know how to show the data using graphs please share!
As stated this method work for Microsoft Excel. I haven't tried it on other software yet since I don't have the time.
Cheers!
Comment