Oxylink Data File Import Question

[princeofdirkness]

Cool, Jeff.

BTW, I sorta misread the data storage stuff in the quasi-documentation for the Oxylink. The device only holds 4 data files but happily and smartly appends new ones to that O2Data folder on the phone, where they accumulate as you described.

A note on the Oxylink export options. I only have PDF as an option which should be noted as a limitation compared to the SleepU.

Dirk

[Crimson Nape]

In order to overcome the 4 session oximeter limit is to download the sessions already recorded each time you wake up during the night.

- Red

[Jeff8356]

... I only have PDF as an option which should be noted as a limitation compared to the SleepU. ...

Dirk

Thanks Dirk. Thats good to know.

As Red mentioned, I typically grab the data every day, sometimes every 2 days. A habit from using and older Contec device which only stored one session...

[princeofdirkness]

This might be relevant for some folks:

Adjacent to the O2Data folder in the app data folder for ViHealth, there is a folder called "JKBD" containing a sqlite file called "jkbd.sqlite" that might make things easier for folks who are getting their data that way.

I just haven't bothered to get sqlite running on this mac yet.

[Jeff8356]

I just haven't bothered to get sqlite running on this mac yet.

You should have sqlite3 native on your Mac. look in /usr/bin

Another option is "DB Browser for SQLite" here: https://sqlitebrowser.org/
It's free and comes in handy. macOS M1 and Intel available

[Crimson Nape]

Another thought is, unlike previous versions, you have to specify "sqlite3" instead of the old "sqlite" or "sql" when issuing commands.

- Red

[Jeff8356]

Another interesting quirk...

The JKBD folder mentioned above (which has the jkbd.sqlite DB) has not had an entry for my SleepU since Dec 19 2022. Although the sqlite3 code in the wiki still extracts the data from the file, it's the older data from last year.
Seems that ALL of my binary files are now stored in the O2Data folder which is current as of today. I will have to poke around in the DB file. There are a lot of tables (48) to go through.

[princeofdirkness]

I poked around a little and I'm guessing (really guessing) that the db just provides a framework for the app to distribute data from the static files in the O2Data folder, like a super complex prefs file.