OSCAR SpO2 CSV import

[capman]

now it works :-)

as a filler, i wrote a script for converting
emay-csv's from eu into us time.

[ElectricalPaul]

still.

with "12/10/2021,11:32:14,98,85":
python3 ./emay2medview.py emay_us.csv
Converting emay_us.csv into emay_us.dat ...
ERROR:root:Invalid date/time '12/10/2021 11:32:14' on line 2

with "10/12/2021,11:32:14,98,85":
python3 ./emay2medview.py emay_us.csv
Converting emay_us.csv into emay_us.dat ...
ERROR:root:Invalid date/time '10/12/2021 11:32:14' on line 2

Hey capman, as joeblough said, I've adopted his code and made several improvements, but apparently not enough error checking or internationalization.

I get an error when I try to download the CSV file that ST Dog attached in https://www.apneaboard.com/forums/Thread...CSV-import, so I'm just working with the 4 lines of data that ST Dog included.

I'm looking into it. Meanwhile, if you want to file an issue on the github page, go to https://github.com/ElectricalPaul/emay2medview/issues

[ElectricalPaul]

still.

with "12/10/2021,11:32:14,98,85":
python3 ./emay2medview.py emay_us.csv
Converting emay_us.csv into emay_us.dat ...
ERROR:root:Invalid date/time '12/10/2021 11:32:14' on line 2

with "10/12/2021,11:32:14,98,85":
python3 ./emay2medview.py emay_us.csv
Converting emay_us.csv into emay_us.dat ...
ERROR:root:Invalid date/time '10/12/2021 11:32:14' on line 2

It's failing because the time doesn't have "AM" or "PM." I'll fix that when I have some time and post an update.

[ElectricalPaul]

It's failing because the time doesn't have "AM" or "PM." I'll fix that when I have some time and post an update.

I just pushed a fix, see https://github.com/ElectricalPaul/emay2medview

I updated the time and date parsing to allow the user to add D_FMT and/or T_FMT variables to the system environment to provide the `strptime` format strings. If those aren't available, I have several formats that I try to parse, and the first one that is successful gets promoted to the head of the line for the next time.

[Toolworker]

Is there a reason exporting the data as an .SPO2 file shouldn't work?

I am just starting with OSCAR, so please be gentle.

The EMAY website gives instructions for exporting .SPO2 files from the app and importing it into OSCAR using the Oximetry Wizard. I'm too new to post a URL but it's emaycare.com slash blogs slash knowledges slash how-to-export-spo2-data-to-oscar

It doesn't say which device to select, but the illustration shows CMS50D+/E/F etc. so I used that.

Following those instructions I was able to import some old data from my EMO-90 pulse oximeter, and it looks correct.

Edit: Is there a way to import multiple files at once with the Oximetry Wizard? I had to do them one at a time.

[ElectricalPaul]

Is there a reason exporting the data as an .SPO2 file shouldn't work?

I am just starting with OSCAR, so please be gentle.

The EMAY website gives instructions for exporting .SPO2 files from the app and importing it into OSCAR using the Oximetry Wizard. I'm too new to post a URL but it's emaycare.com slash blogs slash knowledges slash how-to-export-spo2-data-to-oscar

It doesn't say which device to select, but the illustration shows CMS50D+/E/F etc. so I used that.

Following those instructions I was able to import some old data from my EMO-90 pulse oximeter, and it looks correct.

Edit: Is there a way to import multiple files at once with the Oximetry Wizard? I had to do them one at a time.

Yes, exporting as SPO2 works, but that option wasn't in the EMAY app when Joe wrote his program, I based mine off his, and then someone else on GitHub (the name escapes me right now) contributed some clean-up and support for another program's CSV format.

I just use the SPO2 format now.

When importing into OSCAR, I don't bother to select the oximeter (it's still on ChoiceMMed MD300W1), and I just double-click the file.

If there is a way to import multiple files at once into Oximetry Wizard, I haven't found it yet. I usually import my CPAP data and then the SPO2 data once a week, so it's not too bad ...

[Crimson Nape]

The SpO2 files must be imported from a data file and not from the device. The device selection was for selecting the correct direct communication protocol for the device. They are all outdated and only support the very old devices.

To the best of my knowledge, multiple files can be selected. Just select the first file, then holding the Shift key, select the last one.
- Red

[Toolworker]

The SpO2 files must be imported from a data file and not from the device.  The device selection was for selecting the correct direct communication protocol for the device.  They are all outdated and only support the very old devices.

To the best of my knowledge, multiple files can be selected.  Just select the first file, then holding the Shift key, select the last one.
- Red

The Oximetry Wizard has three options: Import directly from device, Record from attached device, and Import from a datafile. I used Import from a datafile.

To select multiple files, I tried (1) Select first, Shift and select last; (2) Select multiple files holding Ctrl down; and (3) Ctrl-A. None worked.

[Crimson Nape]

Thanks for posting that. That code is a SleepyHead holdover, and none of the current OSCAR Team volunteers have the newer versions.

Also, there is no need to quote a previous post. In this case, it was close enough for someone to follow the thought pattern. This helps for our vision impaired members and avoids them having to hear the same thing repeatedly. Please see this thread for a better explanation, https://www.apneaboard.com/forums/Thread...-t-have-to

- Red

[Toolworker]

Re selecting multiple files: I am now importing data from the O2 Insight Pro program, using OSCAR's Data | Import Viacom/Wellvue Data command. That dialog does allow selecting multiple data files using Ctrl-click and also using click, Shift-click.