Apnea Board Forum - CPAP | Sleep Apnea
O2InsightPro: How directly import local O2Ring binary file? - Printable Version

+- 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: O2InsightPro: How directly import local O2Ring binary file? (/Thread-O2InsightPro-How-directly-import-local-O2Ring-binary-file)



O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-03-2023

Not an OSCAR question, but just in case anyone knows the answer...

Is there a way to import a local computer file of O2Ring session data (binary not CSV) into O2Ring's associated application (in my case on a Mac), namely O2InsightPro?

Background to this request:

OSCAR reads it with no problems. But I'd like to get O2InsightPro to be able to read it too. Normally that happens automatically, but this morning I managed to foul up the "load into O2InsightPro" part of the "Download from O2Ring" process (somehow, unknown).

I tried simply copying such a file into O2InsightPro's main folder for such files, then restarting O2InsightPro, but it didn't get listed it (e.g. in its left-hand pane).

The location where I put the file was:
(~/Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2_Insight_Pro/DATA/<O2Ring Serial Number>


RE: O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-03-2023

A HACK-SOLUTION - In case it helps anyone else...

I just discovered that, on my mac, there is a database file: "db_o2.db", in an SQLite format.
I made a play-copy of that file and opened it (successfully) in mac-app: "DB Browser for SQLite".
In there I browsed (opened) the table: "tbl_check".
In that table I noticed field/column: "startDateTime".
From this I was able to locate the record (row) corresponding to my "failed import" session.
I deleted that row, saved the (play-copy) database, then substituted it for the real one (by renaming both copies of this database).
SUCCESS!:
Lastly, I opened O2InsightPro, Connected it to the O2Ring (which still had last night's data on it) and did a "Download".
This time it succeeded!


RE: O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-03-2023

BTW: On my Mac, the database in question was at:
~/Library/Containers/com.viatom.O2PCViewer-BLE/Data/Library/Application Support/O2_Insight_Pro/DATA/<My O2Ring Serial Number>


RE: O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-03-2023

In my case, it was also necessary to delete all rows from the database's Table: [tbl_deleted].
I had indeed earlier (at the beginning of the day), via O2InsightPro's user-interface, deleted what appeared (at that time) to be corrupted session-data instances.

Then, (after writing the database changes), after opening O2InsightPro and connecting to the O2Ring, the Download process also fetched those two files into O2InsightPro, appearing (as expected) in its left-hand pane.


RE: O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-03-2023

Oops, slight error in the table names, they should begin with:
"tb_" not "tbl_"
Hence "tb_check" and "tb_deleted"


RE: O2InsightPro: How directly import local O2Ring binary file? - DavidEsp - 02-09-2023

Advice I received from Wellue (makers of O2InsightPro - basically I got it (the above) right:

Regarding the question: How can I force-import (session data) from an existing local copy of a session-data file?
Currently we can only manually to add/delete the info in the "tb_check" and "tb_data" to change the database and then import from an existing local copy of a session-data file.
If we want to use another pc, a easy way to transfer all the data to the new pc is to copy the whole "data" folder with databse to replace the new pc's and all the data will be shown on the new pc.