01-09-2022, 01:40 AM
RE: How do I import CSV data to OSCAR from a .CSV file??
(01-08-2022, 10:53 PM)Apnealicious Wrote: I'm a little confused by this - I get the impression that Somno is not an oximeter at all? If it is, I'm not sure where the spO2 and pulse reading are in your sprea
I am unfamiliar with Somnopose, either the device or its operational software. I take it that "Somno" and "pose" indicate it is a sleep position device--weird in that "Inclination" provides for a 180 degree data range to portray standing upright through inversion and "standing" on the hands.
I was informed, however, I could emulate the Somnopose CSV output and have OSCAR import data cast in that Somnopose CSV export format I sent you. It works well.
Long ago I believe I experimented once and used the tool to hand OSCAR PR and SpO2 data from a Contec CMS50I oximeter CSV file. The only rub is that once alien data is imported into OSCAR its curve viewing windows will present results as "Orientation" and "Inclination" curves.
If inclined, your task would be simple using the approach suggested. Paste your csv data, time, pulse rate, and SpO2 into columns A, B, and C of a spreadsheet. A rough guide from my first work spreadsheeting accelerometer data is here Might an accelerometer masquerade as an oximeter and be put into OSCAR? | Apnea Board. The first four columns from the device output CSV were pasted in in one step as you see. Calcs were done in other columns and results went into the Orientation and Inclination columns you saw. The prototype evolved into a versatile conversion template (which needs some house cleaning).
Then enter and compute the necessary time values for your file date and device startup time, as in the snip I sent. Then have the time column at right roll your start time forward, incrementing consistent with time column A. My template immediately displayed export ready data after paste-in of raw data--except for need to key in an entry in for Oximeter-VAuto clock-time drift discrepancies.
For the approach I sent --equivalent ways to synchronize data can work--convert whatever the native data time, in seconds, is into a column beginning with a zero time. Put formulas referring to your B and C data columns and rows in the Orientation and Inclination columns at right. (If your sample rate is constant, then the time column to be output can be copied down from start using the fixed time increment. But for irregular sampling time, your righthand column of cumulative (importable) times must update using column A data times.
Once done, as above, copy the headers and columns at right and paste them, as values (not formulas) into a blank Excel CSV spreadsheet. OSCAR will import it once you have it all in compliance with the format specified.
For PR and SpO2 there is no need to scale the values either way.
Hope this helps. Good luck. Questions are welcome.
I have no particular qualifications or expertise with respect to the apnea/cpap/sleep related content of my posts beyond my own user experiences and what I've learned from others on this site. Each of us bears the burden of evaluating the validity and applicability of what we read here before acting on it.
Of my 3 once-needed, helpful, and adjunctive devices I have listed, only the accelerometer remains operative (but now idle). My second CMS50I died, too, of old age and the so-so Dreem 2 needs head-positioning band repair--if, indeed, Dreem even supports use of it now.
Of my 3 once-needed, helpful, and adjunctive devices I have listed, only the accelerometer remains operative (but now idle). My second CMS50I died, too, of old age and the so-so Dreem 2 needs head-positioning band repair--if, indeed, Dreem even supports use of it now.
