Hello Guest, Welcome to Apnea Board !
As a guest, you are limited to certain areas of the board and there are some features you can't use.
To post a message, you must create a free account using a valid email address.

or Create an Account


New Posts   Today's Posts

ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation
#31
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation
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]
#32
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation
Hi famewolf!  -  Welcome
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
Crimson Nape
Apnea Board Moderator
www.ApneaBoard.com
___________________________________
Useful Links -or- When All Else Fails:
The Guide to Understanding OSCAR
OSCAR Chart Organization
Attaching Images and Files on Apnea Board
Apnea Helpful Tips

INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.
#33
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation
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.
#34
RE: ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation
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).


Possibly Related Threads...
Thread Author Replies Views Last Post
  Where to upload zip file for a new model Resmed? stevenospam 13 389 4 hours ago
Last Post: Crimson Nape
  Importing Data from EMAY Pulse Oximeters Toolworker 0 158 09-04-2024, 10:27 AM
Last Post: Toolworker
  Wellue data off since daylight savings change brainfoggysleeper 5 568 08-21-2024, 08:40 AM
Last Post: Crimson Nape
  Wellue/Viatom Checkme O2 connection problem AndyB 22 3,976 08-05-2024, 04:29 PM
Last Post: Cape67
  Wellue Viatom File Import Pogo007 3 358 08-05-2024, 07:11 AM
Last Post: since1984
  Oscar with Wellue O2 Ring GidgeMo 13 1,227 05-30-2024, 06:27 AM
Last Post: GidgeMo
  Imported Wellue O2 Data and Now CPAP Oscar Times Off awarren82 3 347 05-22-2024, 11:30 AM
Last Post: Crimson Nape


New Posts   Today's Posts


About Apnea Board

Apnea Board is an educational web site designed to empower Sleep Apnea patients.