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 02 Ring - data suddenly missing
#1
WELLUE 02 Ring - data suddenly missing
All my recordings prior to Jan. 5 are suddenly missing though are showing on the phone app. Anyone have this issue and how to restore?

[Image: agT9vod.png]
Post Reply Post Reply






Donate to Apnea Board  
#2
RE: WELLUE 02 Ring - data suddenly missing
It says the device is not connected. Given that, it can't import data from the device.

How does the O2Ring connect to the computer? I have a Wellue SleepU, and the cable failed. I could neither import data nor charge the device.
Useful links
Download OSCAR (current version is 1.4.0)
Best way to organize charts
How to attach charts to your post

Apnea Board Monitors are members who help oversee the smooth functioning of the Board. They are also members of the Advisory Committee which helps shape Apnea Board's rules & policies. Membership in the Advisory Members group does not imply medical expertise or qualification for advising Sleep Apnea patients concerning their treatment.
Post Reply Post Reply
#3
RE: WELLUE 02 Ring - data suddenly missing
(01-07-2022, 11:21 PM)GuyScharf Wrote: It says the device is not connected. Given that, it can't import data from the device.

How does the O2Ring connect to the computer? I have a Wellue SleepU, and the cable failed. I could neither import data nor charge the device.

It sends the data via bluetooth and I update it every morning. 

Guess I'll have to wait till I hear back from the Wellue reps that barely can write English.  Perturbed
Post Reply Post Reply
#4
RE: WELLUE 02 Ring - data suddenly missing
Check to see if the actual files are still there.  @MCS2014, I'm Not sure if you are using your Mac or Windows VM, but here is the file location on Mac:

/Users/your-username/Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2_Insight_Pro/DATA/SerialNumber

The bold parts will be different for you.

The software keeps some type of info on the files it imports in a database (db_o2.db) and that may have somehow been corrupted.  Not sure how that could be fixed or what is used for the db (sqlite or similar???).

If one of the devs wants to look at it I can dropbox it to them, it's only 61kb.
MacBook Air (2017, Intel) | macOS Monterey (12.5) | OSCAR v1.4.0 | VM = Win10 (19043.1446) |
An Apnea Board Monitor (ABM) is a member of the Apnea Board Forum who volunteers to help watch the forum, and keep things running smoothly.
Membership in the Advisory Members group does not imply medical expertise or qualification for advising Sleep Apnea patients concerning their treatment.

Installing OSCAR on a Mac
Organizing your OSCAR charts
Attaching images and files for the forum
OSCAR Help
OSCAR Data Interpretation
Post Reply Post Reply






Donate to Apnea Board  
#5
RE: WELLUE 02 Ring - data suddenly missing
(01-08-2022, 02:06 AM)Jeff8356 Wrote: Check to see if the actual files are still there.  @MCS2014, I'm Not sure if you are using your Mac or Windows VM, but here is the file location on Mac:

/Users/your-username/Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2_Insight_Pro/DATA/SerialNumber

The bold parts will be different for you.

The software keeps some type of info on the files it imports in a database (db_o2.db) and that may have somehow been corrupted.  Not sure how that could be fixed or what is used for the db (sqlite or similar???).

If one of the devs wants to look at it I can dropbox it to them, it's only 61kb.

All the data with the dates are still there. Why it's not reflecting on the 02 Insight Pro app is a mystery. I am using Mac.

[Image: f7zBH05.png]
Post Reply Post Reply
#6
RE: WELLUE 02 Ring - data suddenly missing
Then it would be my guess that something happened to that db_o2.db file.  I had a peek inside mine and it does store all the data from import of your oximeter.

Databases are above my pay grade so you may have to wait to see what type of response you get from Wellue.  Hopefully they will be able to tell you how to rebuild/repair it.
MacBook Air (2017, Intel) | macOS Monterey (12.5) | OSCAR v1.4.0 | VM = Win10 (19043.1446) |
An Apnea Board Monitor (ABM) is a member of the Apnea Board Forum who volunteers to help watch the forum, and keep things running smoothly.
Membership in the Advisory Members group does not imply medical expertise or qualification for advising Sleep Apnea patients concerning their treatment.

Installing OSCAR on a Mac
Organizing your OSCAR charts
Attaching images and files for the forum
OSCAR Help
OSCAR Data Interpretation
Post Reply Post Reply
#7
RE: WELLUE 02 Ring - data suddenly missing
Oddly, your database name is different from mine. Mine is named, "PlusebitO2.db". Here is a SQL script that can extract all the sessions within the database.
Code:
#!/bin/bash

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

To use this, copy the code above into a text editor and save it in the directory that has the database. Make this file executable and run it from a terminal prompt. Of course, this is assuming that you have an SQL database engine on your computer. If not, I would recommend, "SQLite".

- 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






Donate to Apnea Board  
#8
RE: WELLUE 02 Ring - data suddenly missing
Thanks Red, you made me learn something new!

My Mac does have sqlite3, but I can't say if it is native or something else installed it.  it's under /usr/bin

The table and columns  names are different for mine (Wellue SleepU).  (I used a DB browser app for sqlite initially).  But a little editing to the table and column names and the script works for the SleepU:

Code:
#!/bin/bash

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



A small output sample:
Code:
jeff@Jeff-MBA DBtest % ./dbtest.sh  
20201020003828
20201021002120
20201021230825
20201022234302
20201024002520

But I'm not sure if the O2 ring would be the same as the PulseBit or the SleepU???  The OP's db is the same name as mine, but that doesn't necessarily mean it's the same structure (as either of them).  Either way, there are now two different versions to try.  Would be interesting to see the results......
MacBook Air (2017, Intel) | macOS Monterey (12.5) | OSCAR v1.4.0 | VM = Win10 (19043.1446) |
An Apnea Board Monitor (ABM) is a member of the Apnea Board Forum who volunteers to help watch the forum, and keep things running smoothly.
Membership in the Advisory Members group does not imply medical expertise or qualification for advising Sleep Apnea patients concerning their treatment.

Installing OSCAR on a Mac
Organizing your OSCAR charts
Attaching images and files for the forum
OSCAR Help
OSCAR Data Interpretation
Post Reply Post Reply
#9
RE: WELLUE 02 Ring - data suddenly missing
Thanks!!!  I had that sinking feeling they may be different when I saw a different database name. I'm using a SleepU as well. My apps are, Android - ViHealth and Windows - O2Insight Pro.
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
#10
RE: WELLUE 02 Ring - data suddenly missing
I discovered this earlier today, too, and I started panicking! Don't worry, your original data files are still there.

Here's what I found. Note that I use a Macintosh, so the following paths are for the Mac; if you are on a PC, your data will be in a different location.

Previous folder (my data dates are 21 Aug 2020 to 05 Jan 2022)

/Users/[user_name]/Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2_Insight_Pro
 
New folder (folder created 08 Jan 2022 with data files 05 Jan 2022 - 07 Jan 2022)
/Users/[user_name] /Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2 Insight Pro

The O2_Insight_Pro.app application file on the Mac has a Modified Date of Jan 7, 2022 at 10:45 47AM. It looks like the app did an automatic update on my Mac and, when I launched it this morning, created the new data folder and started writing the data there. So the O2 Insight Pro app is no longer showing the data from the old data folder.

Note that the data folder no longer uses underscore characters but now uses space characters. See red file names in the paths above.
 
I found that two data files that were previously written to the old folder and were also written to the new folder today:
1. 20220105001341
2. 20220105231229

It is a major annoyance that the developer did this and did not notify their users in advance.

I wrote to Wellue this morning and asked them if they made this change.

I suspect the fix will be to simply move (or copy) the earlier data folders and files from the old location to the new location. I will post Wellue's answer when I get it.
Post Reply Post Reply






Donate to Apnea Board  


Possibly Related Threads...
Thread Author Replies Views Last Post
  How to quickly sync Wellue O2 Ring Readings from Android to OSCAR hoselife 16 1,627 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,724 08-03-2022, 04:31 AM
Last Post: ak99
  New O2 Ring owner and OSCAR tcc13 3 112 08-01-2022, 06:14 PM
Last Post: Crimson Nape
  Data Missing From Oscar? [solved - see post #4] CChamp 6 198 07-15-2022, 09:46 AM
Last Post: CChamp
  Missing statistics after updating OSCAR? breathestopbreathe 13 287 06-28-2022, 04:42 PM
Last Post: angiessa
  Missing Text in OSCAR StratCat48 3 132 06-22-2022, 09:57 AM
Last Post: StratCat48
  RamboAB - Wellue Import Problems RamboAB 29 530 06-12-2022, 12:19 PM
Last Post: RamboAB


New Posts   Today's Posts






About Apnea Board

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