+- 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: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR (/Thread-How-to-quickly-sync-Wellue-O2-Ring-Readings-from-Android-to-OSCAR)
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - famewolf - 01-13-2023
(01-13-2023, 04:02 PM)Crimson Nape Wrote: Please advise what database name your app is using.
- Red
I am on ViHealth app version 2.74.45
The android/data/.../ViHealth directory has PlusebitO2.db PlusebitO2.db-shm and PlusebitO2.db-wal
The sql was a copy/paste of the line you posted and it resulted in "Error: in prepare, no such table: sleepData" after copying the .db file to my linux machine.
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Crimson Nape - 01-13-2023
That app version is so new, they could have changed everything in it. I would perform an SQL "show tables" command to see what is under the hood.
- Red
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - famewolf - 01-13-2023
So what's the latest version known to work with the sql? I haven't dealth with SQL in over 20 years and would rather just hunt the apk down.
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Jeff8356 - 01-13-2023
famewolf,
I would be curious to see what changes they made to the *.db this time. If you wouldn't mind uploading a copy of PlusebitO2.db to my
DropBox: https://www.dropbox.com/request/PrfOjMGA11lZAkLTdxKM
What we find may help others with the same problem. It's your choice....
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - famewolf - 01-14-2023
I uploaded a copy of the .db to your dropbox. I'll still appreciate knowing what version to fall back to. THey have had SEVERAL recent releases around a week or two apart. So far the db only has one nights worth of data. It was copied as superuser with the app closed.
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Crimson Nape - 01-14-2023
I would try replacing the db name in the second code (db_o2.db) with the database name used in the first code (PlusebitO2.db).
I have a download link for version 2.63 here: https://www.dropbox.com/s/kptf2mtrgepbrmo/ViHealthPro_v2.63.0_06-02_release.apk?dl=0
You can run different versions of the same app. You will need to download an APK editor and change the package name prior to its install in order to do this.
- Red
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Jeff8356 - 01-14-2023
Unless I'm doing something wrong, the PlusebitO2.db file contains no oximetry data at all. The only piece of data in there is for "locale" under "android_metadata". And the file is only 12kb in size.
If you have imported Oxy data into the app it should have some type of entry, unless the data is stored somewhere else now. As Red mentioned the developers of the ViHealth app like to re-invent the wheel with every update.
Following Red's idea, see if you have a file named db_o2.db in the folders.
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Crimson Nape - 01-14-2023
It comes to mind that in that I posted this in another thread (http://www.apneaboard.com/forums/Thread-Latest-version-of-the-Vihealth-Android-app-doesn-t-produce-the-files-for-OSCAR?pid=462197#pid462197)
(12-21-2022, 06:37 PM)Crimson Nape Wrote: Here is what I've found. Latest ViHealth version on my phone, 2.74.14. The following is a listing of the binary files on my Android. The binaries now have a".dat" suffix. The newer ViHealth version doesn't offer anything but a PDF or CSV option.
Main data directory:
\Phone\Android\data\com.viatom.vihealth\files
Some binary files:
\Phone\Android\data\com.viatom.vihealth\files\17\host
Another binary folder:
\Phone\Android\data\com.viatom.vihealth\files\31\host
The Vihealth database is located here:
\Phone\Android\data\com.viatom.vihealth\files\ViHealth\PlusebitO2.db
Using a previously published SQL script will extract the original binary format files.
Android users can deselect apps from being updated. I still have the old ViHealth 2.63.apk version that can be manually installed. This is the old tried and true app. I don't know what options iOS users have.
- Red
Update; After uninstalling v2.74 and installing v2.63, the data is now located at, "\Phone\ViHealth". (If you are curious...)
Please note: The directory numbers will vary per user.
I hope this may be of some help.
- Red
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - famewolf - 01-14-2023
I can confirm I have a folder "59" and two date/time .dat files. 2.63 seems like a long way to go back but I'm willing to to get usable files unless someone has a suggestion for processing these? I don't have a win or mac pc..only linux so android seemed only possibility.
RE: How to quickly sync Wellue O2 Ring Readings from Android to OSCAR - Crimson Nape - 01-14-2023
All you have to do is remove the ".dat" from the file name and OSCAR will allow for their import.
- Red