Hello Guest, Welcome to Apnea Board !
As a guest, you are limited to certain areas of the board and there are some features you can't use.
To post a message, you must create a free account using a valid email address.

or Create an Account


New Posts   Today's Posts

How do I import CSV data to OSCAR from a .CSV file??
#21
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.  (Disclaimer use permitted by sheepless)

 
Post Reply Post Reply






Donate to Apnea Board  
#22
RE: How do I import CSV data to OSCAR from a .CSV file??
Going back to the beginning - when you say that you slept for a while, got up for a few hours, then went back to sleep - did you stop your Pulse ox while you were awake?

If so, how many sessions is your pulse ox set to store? If you set it to one (to use all of the space for a single recording) and you didn't get the data off after you stopped it, wouldn't it have overwritten the data? Perhaps?

Just a thought.
Post Reply Post Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  OSCAR: Couldn't Find Valid Machine Data Kyriosjon 7 81 Yesterday, 07:47 PM
Last Post: Crimson Nape
  ViHealth(2.65.0) App for Viatom/Wellue Oximeters Prevents Binary File Creation Crimson Nape 16 1,202 05-22-2022, 12:15 PM
Last Post: Crimson Nape
  Watchat One data to OSCAR? Quarky68 1 59 05-17-2022, 10:31 AM
Last Post: Crimson Nape
Angry BMC REsmart Software - Cannot import SD card zipperjones 6 1,699 05-14-2022, 02:03 AM
Last Post: return
  Wellue O2Ring - import data to Oscar? Steve320 44 1,447 05-10-2022, 04:29 PM
Last Post: Sleepy Willy
  OSCAR OXIMETER Import Question andrewb340 30 2,119 05-07-2022, 07:13 PM
Last Post: Crimson Nape
  Viatom CheckMe O2 Data Import to OSCAR MoreBeers 2 133 05-07-2022, 05:23 PM
Last Post: MoreBeers


New Posts   Today's Posts






About Apnea Board

Apnea Board is an educational web site designed to empower Sleep Apnea patients.