Announcement

Collapse
No announcement yet.

How to export data from jefit.bak file to excel(.csv)

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to export data from jefit.bak file to excel(.csv)

    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
    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 browser
    1. Download sqlite browser
    2. Unzip sqlite browser
    C. Preparation
    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)
    Click image for larger version

Name:	1.jpg
Views:	1
Size:	21.0 KB
ID:	64330
    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 format
    1. Open your exported file
    2. Open with excel
    3. “save as” filename and select .csv (Comma delimited)
    F. Data format
    1. All your data might be in column A, select column A
    Click image for larger version

Name:	2.jpg
Views:	1
Size:	20.6 KB
ID:	64331
    2. Under “Data” tab, click “Text to Columns”
    Click image for larger version

Name:	3.jpg
Views:	1
Size:	20.3 KB
ID:	64332
    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 columns
    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
    a. Mydate, ename, logsClick image for larger version

Name:	4.jpg
Views:	1
Size:	20.1 KB
ID:	64333


    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!

  • #2
    Hi, thanks for the tutorial. I was able to get the same results from my iPhone!
    I was wondering if you have any updates on the graphs? Do you have anything you can share with me?

    Thanks!

    Comment


    • #3
      Lol I actually just posted this question to support and then found your thread ... its a bit of a work around but thank you man ! your a wiz ! .... Now i can do some comparison in the format that suits me ... Cheers

      Comment


      • #4
        You lost me at Step A.2. In JEFIT Pro for iPhone, there is no button anywhere that says "Profile". I also scanned the menus and found no ability to export a backup file.

        Comment


        • #5
          I would like to include the 1RM in my data. I would think in step C6, there would be an item I would not delete to achieve this, I just do not know which item that would be. Any suggestions?

          Comment


          • #6
            Nice work, now need this in graph form.

            Comment


            • #7
              SQLite error

              when I try to open the .bak file the program say that "File is not a SQLite 3 database

              How i fix it

              thanks!!

              Comment


              • #8
                I don't think this method will work with the latest version of JEFit. It appears that the .Bak file is now encrypted, which is why you can't open it.

                see: [url]http://www.jefit.com/forum/showthread.php?35904-Accesing-backup-file-[/url]...

                Comment


                • #9
                  Would getting an older version of the apk and then syncing with the server and then exporting help?

                  Comment


                  • #10
                    Hey guys. I made a Jar file that will decrypt a jefit.bak file.

                    Jar file is here: [url]http://tiny.cc/uyrewx[/url]

                    To use it just run "java -jar JefitDecryptor.ja /path/to/jefit.bak"


                    proof: [url]http://i.imgur.com/lmgrO30.png[/url]
                    Last edited by josama; 04-01-2015, 10:34 AM.

                    Comment


                    • #11
                      Hey guys. I made a Jar file that will decrypt a jefit.bak file.

                      Jar file is here: [url]http://www62.zippyshare.com/v/Jte6RPiF/file.html[/url]

                      To use it just run "java -jar JefitDecryptor.jar /path/to/jefit.bak"

                      Comment


                      • #12
                        I am interested in doing this same thing, but I have a Moto X, and there is no sdcard, so when I run the backup it appears to run, but no backup can be found anywhere on the phone? Any ideas?

                        Comment


                        • #13
                          The backup goes into the 'jefit' folder on your phone. Its at the same depth as DCIM and Download folders.If you're having trouble with your file explorer try ES file explorer.

                          I have a Nexus, so no SDcard either.

                          Comment


                          • #14
                            Latest update has broken this app. 9.02 works just fine but the newest 9.03. Can you update the jar to work with the 9.03 bak -files?

                            Comment


                            • #15
                              App and Website Questions Forum - Export data, Integrate with other Apps and Devices

                              Looking at the JEFIT App and Website Questions Forum, and sorting by number of views;

                              [URL]https://www.jefit.com/forum/forumdisplay.php?14-JEFIT-App-and-Website-Questions&sort=views&order=desc[/URL]

                              You can see that some of the most popular discussions are regarding the export feature, access to the database, integration with other applications (API) and wearable tech. And some of these threads were started years ago. This issue remains unresolved in 2015.

                              [URL="https://www.jefit.com/forum/showthread.php?37061-Myfitnesspal-sync"]Myfitnesspal sync[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?1695082-wkel24"]wkel24[/URL], 10-29-2013 09:32 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=37061"]85[/URL]
                              • Views: 25,197


                              [URL="https://www.jefit.com/forum/showthread.php?19739-integration-with-other-exercise-apps"]integration with other exercise apps[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?747608-brandonbee42"]brandonbee42[/URL], 08-26-2012 05:17 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=19739"]30[/URL]
                              • Views: 19,708


                              [URL="https://www.jefit.com/forum/showthread.php?33349-How-to-export-data-from-jefit-bak-file-to-excel%28-csv%29"]How to export data from jefit.bak file to excel(.csv)[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?1120877-supermanmud"]supermanmud[/URL], 05-29-2013 05:53 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=33349"]13[/URL]
                              • Views: 8,654


                              [URL="https://www.jefit.com/forum/showthread.php?40265-Where-is-Export-Import-of-workout-data-logs-history-promised-4-yrs-ago"]Where is Export/Import of workout data/logs/history , promised 4 yrs ago ?[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?0-rbpresgrp"]rbpresgrp[/URL], 08-07-2014 08:23 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=40265"]39[/URL]
                              • Views: 5,338


                              [URL="https://www.jefit.com/forum/showthread.php?35904-Accesing-backup-file"]Accesing backup file ...[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?197793-cjones8"]cjones8[/URL], 09-16-2013 09:28 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=35904"]16[/URL]
                              • Views: 4,115


                              [URL="https://www.jefit.com/forum/showthread.php?12034-export-sync-to-fitocracy-option"]export / sync to fitocracy option[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?439276-Twistedtwig"]Twistedtwig[/URL], 02-02-2012 12:59 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=12034"]3[/URL]
                              • Views: 3,575


                              [URL="https://www.jefit.com/forum/showthread.php?22424-Data-export-please-please-please"]Data export please please please[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?10759-graffeoc"]graffeoc[/URL], 11-10-2012 03:41 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=22424"]27[/URL]
                              • Views: 3,133


                              [URL="https://www.jefit.com/forum/showthread.php?36436-Jefit-API"]Jefit API[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?80709-philter"]philter[/URL], 10-05-2013 05:19 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=36436"]6[/URL]
                              • Views: 3,096


                              [URL="https://www.jefit.com/forum/showthread.php?41567-Apple-Watch"]Apple Watch[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?2592972-asergioam"]asergioam[/URL], 03-04-2015 05:49 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=41567"]21[/URL]
                              • Views: 2,840


                              [URL="https://www.jefit.com/forum/showthread.php?33685-Export-Jefit-Data-to-Excel-or-CSV"]Export Jefit Data to Excel or CSV[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?774129-nerkidner"]nerkidner[/URL], 06-13-2013 04:05 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=33685"]8[/URL]
                              • Views: 2,760


                              [URL="https://www.jefit.com/forum/showthread.php?40809-Google-Fit"]Google Fit[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?2607159-darrenkitchens"]darrenkitchens[/URL], 10-29-2014 02:46 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=40809"]3[/URL]
                              • Views: 2,349


                              [URL="https://www.jefit.com/forum/showthread.php?40800-Google-fit"]Google fit[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?2188-fraubo"]fraubo[/URL], 10-28-2014 07:42 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=40800"]5[/URL]
                              • Views: 2,145


                              [URL="https://www.jefit.com/forum/showthread.php?36814-Reports"]Reports[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?1728241-bobbylowe"]bobbylowe[/URL], 10-20-2013 11:09 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=36814"]2[/URL]
                              • Views: 2,058


                              [URL="https://www.jefit.com/forum/showthread.php?23903-Wifi-Weight-Scales"]Wifi Weight Scales[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?921612-crash025"]crash025[/URL], 12-19-2012 10:12 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=23903"]8[/URL]
                              • Views: 2,038


                              [URL="https://www.jefit.com/forum/showthread.php?6098-Print-all-logs"]Print all logs[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?208256-rpilgrim"]rpilgrim[/URL], 06-05-2011 05:11 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=6098"]3[/URL]
                              • Views: 1,885


                              [URL="https://www.jefit.com/forum/showthread.php?40844-Android-Wear-Support"]Android Wear Support[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?988005-jpcarreiro"]jpcarreiro[/URL], 11-06-2014 09:09 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=40844"]6[/URL]
                              • Views: 1,784


                              [URL="https://www.jefit.com/forum/showthread.php?34443-Linking-Jefit-workout-calendar-log-to-Google-Calendar"]Linking Jefit workout calendar log to Google Calendar?[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?23018-DanG1580"]DanG1580[/URL], 07-17-2013 02:31 PM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=34443"]4[/URL]
                              • Views: 1,773


                              [URL="https://www.jefit.com/forum/showthread.php?37453-Export-logs-to-file-needed-%28urgent%29"]Export logs to file needed (urgent)[/URL]
                              Started by [URL="https://www.jefit.com/forum/member.php?1538212-Freejin"]Freejin[/URL], 11-19-2013 10:42 AM
                              • Replies: [URL="https://www.jefit.com/forum/misc.php?do=whoposted&t=37453"]2[/URL]
                              • Views: 1,728

                              Comment

                              Working...
                              X