Apnea Board Forum - CPAP | Sleep Apnea
Convert SD Data - Printable Version

+- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums)
+-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area)
+--- Forum: Main Apnea Board Forum (https://www.apneaboard.com/forums/Forum-Main-Apnea-Board-Forum)
+--- Thread: Convert SD Data (/Thread-Convert-SD-Data)



Convert SD Data - swfcowls - 12-02-2022

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

Thanks


RE: Convert SD Data - pholynyk - 12-02-2022

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.


RE: Convert SD Data - swfcowls - 12-02-2022

Thank you.


RE: Convert SD Data - withtao - 12-02-2022

(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


RE: Convert SD Data - pholynyk - 12-02-2022

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.


RE: Convert SD Data - withtao - 12-02-2022

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.