+- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums)
+-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area)
+--- Forum: Software Support Forum (https://www.apneaboard.com/forums/Forum-Software-Support-Forum)
+--- Thread: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation (/Thread-ViHealth-2-65-0-App-for-Viatom-Wellue-Oximeters-Prevents-Binary-File-Creation)
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation - famewolf - 01-13-2023
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); doneRE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation - Crimson Nape - 01-13-2023
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
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation - Herqliz - 10-06-2023
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.
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation - Herqliz - 10-10-2023
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).