10-14-2024, 11:38 PM
Directly edit Oscar Data
I am using OSCAR with Resmed machine but I am also importing o2 information. One of my Spo2 files glitched as I was taking it off my finger and recorded a heart rate of 255. This is messing up my reports. I need to either edit the data in OSCARs database directly or perhaps find the offending Spo2 file and edit it and reimport Assuming that will clobber the glitch. I really don't want to nuke all the O2 data in OSCAR to correct this problem. I am reasonably tech savvy and in another life I did some sql although I am a little rusty now. If someone knows the best way to wack-a-mole this glitch it would be appreciated. I am not even opposed to using a hex editor if that is what is needed. I am unsure if the data is stored as XML or what. Nor do I know where it is stored. I am running on Windows 11 al be it in a VM on my MAC. If someone can point me in the right direction that would be great.
RE: Directly edit Oscar Data
Hi dgconder! -
Since you listed it as a "SpO2" file, I assume that you are using a Contec or its clone oximeter. It has been 10 years since I last looked at a SpO2 file. It is a binary file and will involve using a hex editor to modify it. As far as OSCAR, you can just delete the oximeter's data for that particular day (
Data > Advanced > Purge Oximetry Data > Current Day).
-
Red
10-15-2024, 09:23 PM
RE: Directly edit Oscar Data
You are correct about my Contec Oximeter. On closer inspection it appears that this 255 heart rate happens when the battery dies in the oximeter. It goes from pr of 44 instantly to 255 then stops. I wonder if I could put in an enhancement request for sp software or OSSCAR to toss out data like this. I saw an option in OSCAR that said cleanup oximetry data. But as near as I can tell it did not touch the pulse rate data that came with the oximeter data. Looks like I have several days to delete if I want to clean it up. I guess I was just trying to be frugal and use low batteries. I looked at the raw spo2 file a little bit without knowing more about the structure I am hesitant to tamper with it. Thanks for your response. I wonder if OSCAR has some database editing tools?
RE: Directly edit Oscar Data
OSCAR does not have any data editing tools. Having an option like that would destroy its reporting validity. Based on other data files I've reviewed, a 255 (ff hex) entry usually signifies an invalid observation/entry. I need to look at the Contec parser to see how it is written. Its code was from SleepyHead. As far as I am aware, its code has not been touched since OSCAR was first released.
If you want to try removing that 255 entry, copy the data file first and add an identifier as a filename prefix, then edit it.
- Red
