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

Convert SD Data
#1
Convert SD Data
Q. Any method available to convert the SD card data for ResMed AirSense 10 Elite device, into CSV files for use in Excel ?

Thanks
Post Reply Post Reply
#2
RE: Convert SD Data
The statistical data can be exported File->Export Data -> CSV Export Wizard

It's not practical to convert the detailed data to csv because the time and date fields would be larger than the data.
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
#3
RE: Convert SD Data
Thank you.
Post Reply Post Reply
#4
RE: Convert SD Data
(12-02-2022, 06:12 AM)pholynyk Wrote: It's not practical to convert the detailed data to csv because the time and date fields would be larger than the data.

Is there a database e.g.SQLite that the data from the SDcard is written to that can be accessed outside of OSCAR?  I see a lot of data in the Profile directory for a user.  Just wondering because I'm able to get data out of Wellue Checkme O2 Max into .csv that I can then assemble in an Excel spreadsheet and analyze how I did regarding O2. 

Example from Excel from Wellue Checkme O2 Max:
average 94
minimum 88
maximum 98
# samples 18382
>= 95 4870 26.49%
90-94 13491 73.39%
<= 89 21 0.11% 0.70 minutes
90 155 0.84%
89 17 0.09%
88 4 0.02% 0.02% <= 88
87 0 0.00% 0.00% < 88
86 0 0.00%
85 0 0.00%
12/1/2022

Thanks
Post Reply Post Reply
#5
RE: Convert SD Data
All of the detailed data is stored in the .001 files contained within the Events folder of each machine. The format is undocumented, but can be gleaned by reading the source code of loadSession.cpp. The file names are the hexadecimal representation of the session start time in milliseconds since 1970 Jan 01.

IIRC, there is a program called edf2ascii which takes an edf file and turns it into ascii, but I'm not sure if it creates a csv file. You can see how much the edf expands to create the ascii file.
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
#6
RE: Convert SD Data
Thanks.  That's a good start.

BTW, I've been developing software for almost 50 years.  Every size project, many languages, and many databases.  Most of my "C" has been with C# and Javascript, so looking forward to tinkering with OSCAR.
Post Reply Post Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  anyone convert CSV o2 data into Oscar? drgrimes 7 2,771 03-07-2024, 05:21 PM
Last Post: capman
  Does anyone know how to convert from mV/cm to % O2 in an EDF file? erouting 1 454 09-19-2023, 10:12 PM
Last Post: erouting
Idea Convert Airsense 11 into Air mini or vice versa? mltam 1 606 05-20-2023, 03:28 PM
Last Post: Lucid
  Doctor says perfect data, but extremely tired - OSCAR Data Auzzyrocks 13 2,651 12-04-2022, 11:25 AM
Last Post: Lucid
Question [Pressure] Doctor can't see detailed data - Can my OSCAR data save me from another sleep study? KidCharlamagne 5 895 09-28-2022, 08:20 AM
Last Post: Gideon
  [CPAP] Data showing clear airway apneas: central apnea or soft palate collapse? Data inc. JamesD0079 0 798 03-21-2022, 07:50 PM
Last Post: JamesD0079
  Trying to convert from F30i to P30i shockedCABG 7 1,028 03-14-2022, 12:33 PM
Last Post: xhwmikey


New Posts   Today's Posts


About Apnea Board

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