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

Wellue O2Ring - import data to Oscar?
#41
RE: Wellue O2Ring - import data to Oscar?
I get 92 files from that db, but I know I have a few small recordings. The files all have an asterisk at the end and they are all zero bytes. I renamed a few and tried to import them into Oscar. They seemed to crash Oscar and did not give me any data. ?

Any bright ideas?
Post Reply Post Reply






Donate to Apnea Board  
#42
RE: Wellue O2Ring - import data to Oscar?
They should be look like the mFileName column in the screenshot I posted.  Depending on your model and the ViHealth version, the date/time filename may be preceded by "SleepU_" "or O2Ring_".
- Red

EDIT:
I see they separate out the database in a directory named "ViHealth " and is separate from where they generate the binary session files.
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.
Post Reply Post Reply
#43
RE: Wellue O2Ring - import data to Oscar?
I just got a USB/USB-C cable for the phone.  It was my son's hand me down.  I just looked at the Android's file locations using my PC.

The binary files path:
\Phone\Android\data\com.viatom.vihealth\files

Path to the database file:
\Phone\Android\data\com.viatom.vihealth\files\ViHealth

The database stores the mFileName like the screenshot. It seems the oximeter type prefix is added when it generates the binary file.
- 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.
Post Reply Post Reply
#44
RE: Wellue O2Ring - import data to Oscar?
Yeah, I found a bunch of files in the parent directory, fewer than 92 though.
Post Reply Post Reply






Donate to Apnea Board  
#45
RE: Wellue O2Ring - import data to Oscar?
(09-19-2021, 03:29 PM)Crimson Nape Wrote: Here is sergio's file extraction script:
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

If you have a version that will create the file, then transfer them as described above.   Remember, in order for the app to generate the file, you must view the session while in the ViHealth app.

Good luck!

I couldn't get the above script to run on my PC after installing SQLite3 and Linux. It would echo the file names and produce 0 byte files, so I tried using the new writefile function in SQLite 3, but it did not produce any files or output the byte count from the writefile function.  If I hardcoded a single select statement in bash I got a byte count and a file.

Idea This means the original code is not actually processing the filenames (for me anyway). I found that removing the quotes from the filename variable solved my problem, as the variable is already a string.

This code works for me, YMMV as I'm running this in Windows.


Quote:for filename in `SQLite3.exe ./PlusebitO2.db 'select mFileName from sleepData'`; do echo $filename; (SQLite3.exe PlusebitO2.db "select writefile($filename,dataBuf) from sleepData where mFileName = $filename") ; done
Post Reply Post Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  How to quickly sync Wellue O2 Ring Readings from Android to OSCAR hoselife 16 1,706 08-05-2022, 08:27 AM
Last Post: jdavidstark
  ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation Crimson Nape 21 1,798 08-03-2022, 04:31 AM
Last Post: ak99
  Pulse Ox Import Into OSCAR boxofrain 5 195 07-16-2022, 06:10 PM
Last Post: Jeff8356
  Data Missing From Oscar? [solved - see post #4] CChamp 6 221 07-15-2022, 09:46 AM
Last Post: CChamp
  OSCAR not importing today's data happydreams 55 2,701 07-11-2022, 08:08 PM
Last Post: todivefor
Question What are the columns of the OSCAR data export? snevel 7 149 07-11-2022, 08:15 AM
Last Post: Crimson Nape
Question OSCAR NO LONGER READS MY DATA Dixo 1 367 06-26-2022, 12:10 AM
Last Post: Dixo


New Posts   Today's Posts






About Apnea Board

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