CMI PL-66 OE data import format

[HiTechHiTouch]

Here's a .cvs file (first few lines) produced by the CMI provided program Oximeter Data Manager. 5.5.0.0

Code:

# No.: 1, Name: Jared, Start: 5/2/2021 12:58:47 AM, End: 5/2/2021 1:02:33 AM, Interval : 1sec, Mode :(1)Adult
# Time, SpO2(%), PR(bpm)

05/02/2021 00:58:47  , 98 , 82
05/02/2021 00:58:48  , 97 , 80
05/02/2021 00:58:49  , 97 , 78

It should be trivial to turn this into something that the Oscar OE Wizard can accept.

If one of the Oscar programmers would step up the a file format, I'll gladly write a conversion program to output it into Oscar readable format.

This should pay off for almost every CMI device as they all seem to use same program to upload from the device/manage patients etc.

[Crimson Nape]

The CSV file layout looks very similar to some raw data files I've seen. Do you have the raw data file that produced the listing above?

[HiTechHiTouch]

Short Answer:
  That IS the raw data.

Long Answer:

* You want to go after the machine?  It has a virtual com interface that can be traced.

* You want to go against the program?  It has a very large and sparse data base that has all patients, all data, etc.  No obvious structure like MySQL, etc.

  There are some temporary files which might be captured with the program open, patient selected, record selected, fingers crossed.

* What's wrong with taking the easy way and not hacking so much? 

Back to the original question:

  I can point Oscar OX wizard at an MD300W1.dat file. 

  What does it look like, and what has to be present?

Sample Answer:

- GO to GITHUB or what ever Oscar uses,
- PULL project oscarox or what ever contains the import code,
- LOCATE the file(s) asdf and ghjk,
- LOOK at structures abc, xyz, and tuv for the data layout.
  Line 5678 of ghjk starts the read/parse of MD300W1.dat

[HiTechHiTouch]

OK, I've cracked the data base and record format.

Will a OSCAR developer PLEASE get in touch with me to talk about adding support?

[letitgoman]

OK, I've cracked the data base and record format.

Will a OSCAR developer PLEASE get in touch with me to talk about adding support?

Hi,


I am trying to do something similar, but I cannot find a sample .spo2, spr, or .dat file online. 

Did you manage to resolve this? Any help or tips that you can provide?

Thank you!

[lzmontana]

OK, I've cracked the data base and record format.

Will a OSCAR developer PLEASE get in touch with me to talk about adding support?

Hi,  I am also trying import data in a similar session file (data is from an EMAY device, which readily exports in CSV format.)
The CSV data is available to me on the same Win10 machine as OSCAR is installed on; no need to hook a cable to the SpO2 device, no need for a specific device driver, etc. 
If some special header for patient data is needed at the beginning of a file, that should be quite easy to add to the CSV file, but in my case there is only one patient.

Did you have any luck in this project?  I can see that several other users are having the same problem over that past several years.  
It would be extremely helpful to have a method to import this CSV data into OSCAR to view along with the APAP data.  Thanks in advance!

Example data from actual file:

Date,Time,SpO2(%),PR(bpm)
10/28/2023,12:08:29 AM,88,88
10/28/2023,12:08:30 AM,88,88
10/28/2023,12:08:31 AM,88,88
10/28/2023,12:08:32 AM,88,87
10/28/2023,12:08:33 AM,88,87
10/28/2023,12:08:34 AM,88,86
10/28/2023,12:08:35 AM,88,86
10/28/2023,12:08:36 AM,88,85
10/28/2023,12:08:37 AM,89,85