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??
#11
RE: How do I import CSV data to OSCAR from a .CSV file??
[attachment=38716 Wrote:Jeff8356 pid='429023' dateline='1641580461']
There should be a setting in the software to turn off that beep.  While your unit is connected to your computer and you are running the app, look under "Options".  

I have the older version of the CMS50F and it has settings in the oximeter itself to turn off the alarms and such too. You may have similar settings in your version.

The app is designed for a few different versions of oximeters.  One of the other versions will let you do a "Live" recording, but not the CMS50F.

They must have made some upgrades to the app and the newer oximeter.  I still use the older SpO2 Assistant and an older CMS50F and I don't recall having the option to merge two different SpO2 files.  That would come in handy....

Yes, my CMS-50F has the option in the "watch", and that is turned off.  The loud beeping is from the software and plays through my computer speakers at top volume, complaining that the watch's fingertip device is not connected.   Since there is only 1 port, it is logically impossible for the watch to be connected to both the computer and fingertip, so it's almost intentional to anger the user.


Attached Files Thumbnail(s)
   
Post Reply Post Reply
#12
RE: How do I import CSV data to OSCAR from a .CSV file??
The Zeo, Dreem, and Somnopose importers in OSCAR use a CSV file format. You could look at how their file structure is formatted and try it with your data. The OSCAR source code is available at, https://gitlab.com/pholy/OSCAR-code. I will try to look at these loaders within the next week. You are not the first wanting to import CSV data from various devices.
Crimson Nape
Apnea Board Moderator
www.ApneaBoard.com
___________________________________
Useful Links -or- When All Else Fails:
The Guide to Understanding OSCAR
OSCAR Chart Organization
Attaching Images and Files on Apnea Board
Apnea Helpful Tips

INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.
Post Reply Post Reply
#13
RE: How do I import CSV data to OSCAR from a .CSV file??
(01-07-2022, 02:11 PM)Crimson Nape Wrote: The Zeo, Dreem, and Somnopose importers in OSCAR use a CSV file format.    You could look at how their file structure is formatted and try it with your data.   The OSCAR source code is available at, https://gitlab.com/pholy/OSCAR-code.  I will try to look at these loaders within the next week.   You are not the first wanting to import CSV data from various devices.

Great!  I see those importers in OSCAR and I tried one, but it seemed to ignore the data and I was afraid I would corrupt my OSCAR dataset.  Do you know where I can find the file format for those other devices?  I would be quite happy if I could mimic those and load my data that way.
Post Reply Post Reply
#14
RE: How do I import CSV data to OSCAR from a .CSV file??
The source code for those loaders can be downloaded from the URL I provided in my previous post. Specifically, they are located here: https://gitlab.com/pholy/OSCAR-code/-/tr...er_plugins
Crimson Nape
Apnea Board Moderator
www.ApneaBoard.com
___________________________________
Useful Links -or- When All Else Fails:
The Guide to Understanding OSCAR
OSCAR Chart Organization
Attaching Images and Files on Apnea Board
Apnea Helpful Tips

INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.
Post Reply Post Reply
#15
RE: How do I import CSV data to OSCAR from a .CSV file??
(01-07-2022, 02:46 PM)Crimson Nape Wrote: The source code for those loaders can be downloaded from the URL I provided in my previous post.  Specifically, they are located here: https://gitlab.com/pholy/OSCAR-code/-/tr...er_plugins

Thanks!  Unfortunately, I don't know the language it's written in.   It looks like each file/field is hardcoded for each machine, instead of importing to a common format work file and processing from there.   I'll spend some time studying this when I can, and see if I can figure out how to derive format layout from the hardcoding, and I'll post it so others can use it.
Post Reply Post Reply
#16
RE: How do I import CSV data to OSCAR from a .CSV file??
OK, I looked at the code for the 3 loaders and none of them provide the required fields you need.   Basically (very), all 3 deal with either sleep stage, or body orientation.  So much for my idea. . .  Sad
Crimson Nape
Apnea Board Moderator
www.ApneaBoard.com
___________________________________
Useful Links -or- When All Else Fails:
The Guide to Understanding OSCAR
OSCAR Chart Organization
Attaching Images and Files on Apnea Board
Apnea Helpful Tips

INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.
Post Reply Post Reply
#17
RE: How do I import CSV data to OSCAR from a .CSV file??
(01-07-2022, 03:47 PM)Crimson Nape Wrote: OK, I looked at the code for the 3 loaders and none of them provide the required fields you need.   Basically (very), all 3 deal with either sleep stage, or body orientation.  So much for my idea. . .  Sad

But they still provide O2 and pulse, right?  So I could just open my .CSV file in Excel, add those fields with a default value or empty, export back to .csv, and tell OSCAR it's from one of those devices, right?

And if that works, I could probably put up a website that converts anyone's .CSV to a file that OSCAR likes.
Post Reply Post Reply
#18
RE: How do I import CSV data to OSCAR from a .CSV file??
My recollection of the .dat format used by the ChoiceMMedical pulseOx was fairly simple and allowed for multiple sessions.
The difficulty with saying 'import .csv files' is that they are almost entirely free form. There have to be constraints, and somebody will always want different ones.To mix metaphors, it's a can of worms, and it doesn't scratch my itch.
As CrimsonNape said the source is there, and we will look at useful additions.
Apnea Board Monitors are members who help oversee the smooth functioning of the Board. They are also members of the Advisory Committee which helps shape Apnea Board's rules & policies. Membership in the Advisory Members group does not imply medical expertise or qualification for advising Sleep Apnea patients concerning their treatment.
Post Reply Post Reply
#19
RE: How do I import CSV data to OSCAR from a .CSV file??
To use the Somnopose CSV import feature of Oscar I have long routinely used Excel and exact compliance with the following data structure (from one of my posts someone else here had informed):

http://www.apneaboard.com/forums/attachm...?aid=22115

I attach a snip from a  spread sheet I used again last night to put November 27-28, 2015 breathing duty cycles ("Inclination") and breath-by-breath tidal volume deviations ("Orientation) from a "norm" into Somnopose form for OSCAR zooming.

The full sheet having the snip area was built and used for "Somnoposing" 3-axis accelerometer data. I fiddled with a copy to use it as a tool, leaving some of its original rough form and debris. 

Ignore blue and green colored areas and upper right matter as well as columns of trash values  in P, Q and X columns.  As indicated in the yellow area I copy and paste the headings, time , orientation and inclination values into a separate clean CSV file for OSCAR import.

The two indicated data values had to be scaled up with a factor of 100 to comply with the allowed ranges for Somnopose import.

The 3672 value is the number of seconds for the local time, 01:01:12, of the Microsoft System date. 

My paste-in raw FR data (25 hz) time starts at zero-time in column A.  The importable time column at right simply takes the starting number of seconds shown and adds 0.04 seconds for each logged or calculated value. Only two non-zero values are shown in the snip. The result values were calculated at left of the  snip and duplicated, by formula, at right. 

   
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.



 
Post Reply Post Reply
#20
RE: How do I import CSV data to OSCAR from a .CSV file??
(01-08-2022, 04:49 AM)2SleepBetta Wrote: To use the Somnopose CSV import feature of Oscar I have long routinely used Excel and exact compliance with the following data structure (from one of my posts someone else here had informed):

http://www.apneaboard.com/forums/attachm...?aid=22115

I attach a snip from a  spread sheet I used again last night to put November 27-28, 2015 breathing duty cycles ("Inclination") and breath-by-breath tidal volume deviations ("Orientation) from a "norm" into Somnopose form for OSCAR zooming.

The full sheet having the snip area was built and used for "Somnoposing" 3-axis accelerometer data. I fiddled with a copy to use it as a tool, leaving some of its original rough form and debris. 

Ignore blue and green colored areas and upper right matter as well as columns of trash values  in P, Q and X columns.  As indicated in the yellow area I copy and paste the headings, time , orientation and inclination values into a separate clean CSV file for OSCAR import.

The two indicated data values had to be scaled up with a factor of 100 to comply with the allowed ranges for Somnopose import.

The 3672 value is the number of seconds for the local time, 01:01:12, of the Microsoft System date. 

My paste-in raw FR data (25 hz) time starts at zero-time in column A.  The importable time column at right simply takes the starting number of seconds shown and adds 0.04 seconds for each logged or calculated value. Only two non-zero values are shown in the snip. The result values were calculated at left of the  snip and duplicated, by formula, at right. 


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 spreadsheets.
Post Reply Post Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
Question OK TO IMPORT SLEEP DATA FROM OLD SD CARD INTO OSCAR W/O MESSING UP CURRENT DATA? Plmnb 1 72 8 hours ago
Last Post: Ibrumley
  Rescan app [doesn't see data import] kerm007 3 139 03-24-2024, 10:59 PM
Last Post: srlevine1
  Trouble importing data to Oscar bubbafoxus 2 87 03-22-2024, 05:40 PM
Last Post: bubbafoxus
  OSCAR Profiles and Combining Different Brand CPAP Data StratCat48 2 49 03-22-2024, 08:00 AM
Last Post: StratCat48
  Where Oscar put the data file? Rosacer24 0 59 03-22-2024, 12:16 AM
Last Post: Rosacer24
  There's 1.5 years of data in my OSCAR, but now there's a problem Snackers 8 217 03-19-2024, 03:36 AM
Last Post: Snackers
  OSCAR v1.5.2- error code 5, unable to write to data directory sleepynotion 2 106 03-18-2024, 12:09 PM
Last Post: sleepynotion


New Posts   Today's Posts


About Apnea Board

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