Rob Taylor robtaylor82
letsjump
/ librelink.sql
Last active
March 20, 2023 02:55
Export Librelink android app data to excel (no need to root your phone)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 1. Install ADB on your computer | |
| -- 2. adb backup -noapk com.freestylelibre.app.it | |
| -- 3. Decompress data with zlib support: | |
| -- printf "\x1f\x8b\x08\x00\x00\x00\x00\x00" |cat - /tmp/data |gzip -dc >/tmp/out | |
| -- 4. go to apps/com.freestylelibre.app.it/f/ | |
| -- 5. open apollo.db and sas.db in a sqlite editor | |
| -- 6. copy notes.data into sas.db | |
| -- 7. run this query to have a diary with sensor scans and notes: | |
| SELECT strftime('%d/%m/%Y %H:%M:%S', datetime(timestampLocal/1000, 'unixepoch')), comment, glucoseValue, fastInsulinDose, slowInsulinDose, foodCarbs, foodType |