ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation

[famewolf]

Hi,   I am trying to get the binary file from the vihealth app for my 02ring.  When I ran the suggested sql script against the database I received:   rror: in prepare, no such table: sleepData

Is there a new version of this script for current versions of the app?   I'm trying to get my info into OSCAR.


======>
If you have an SQL database engine (e.g. sqlite in this case).   If not, there are several free downloads available.

Code:

Code:

for filename in `sqlite3 ./PlusebitO2.db 'select mFileName from sleepData'`; do echo $filename; (sqlite3 PlusebitO2.db "select quote(dataBuf) from sleepData where mFileName = '$filename'" | cut -d\' -f2 | xxd -r -p > $filename); done

[url=http://www.apneaboard.com/forums/User-Crimson-Nape][/url]

[Crimson Nape]

Hi famewolf!  -  
It will depend on what version of ViHealth you are running.   Viatom seems to reinvent the wheel with each version release.  They did use the database name, db_o2.db in newer versions. You may ultimately may need to explore the Viatom directory to see the filename that ends with a ".db".

Here is the extraction script:

Code:

for filename in `sqlite3 ./db_o2.db 'select checktime from tb_check'`; do
echo $filename; (sqlite3 db_o2.db "select quote(checktime) from tb_check where checktime = '$filename'" | cut -d\' -f2 | xxd -r -p > $filename); done  

- Red

[Herqliz]

Just sharing my method for syncing data from O2ring to OSCAR:

My Limitation: I am using Android (V.13) on a Samsung (S23 Ultra). I've tried to access /Android/data/com.viatom.vihealth/files/ViHealth but, for an unknown reason, I cannot copy those db files to my PC. It shows the error "Error Copying File or Folder: Unspecified error." So, I gave up on using db/binary files from Android.

Then, I tried a second method:

Install O2 Insight Pro on Windows (10).
Connect my O2 Ring with USB (I've tried via Bluetooth, but it failed).
Click "Download" to transfer data to the PC; the binary file will be downloaded to the PC (as configured).
Use "OSCAR" to import data (Data -> Import Viatom/Wellue Data -> Select folder from step 3).
Done.

[Herqliz]

Update now i can sync O2 ring data from android to google drive

Application to sync: Drivesync
Folder to sync: /storage/emulated/0/android/data/com.viatom/vihealth/files/20

Then you can map google drive to your PC, then just Use "OSCAR" to import data (Data -> Import Viatom/Wellue Data -> Select folder).