04-09-2024, 01:28 PM
OSCAR import of Viatom/Wellue data - Unsupported O2s
For Oxymeters that are unsupported, I suggest you export the .CSV file and figure how to convert to a Somnopose .CSV format.
For example, I have a Wellue PO6B. With ViHealth I can get the data by BlueTooth and export the file in .CSV format.
Wellue format:
Time,Oxygen Level,Pulse Rate
03:23:26 09/04/2024,98,77
03:23:27 09/04/2024,98,77
The conversion consists in changing the timestamp format and the base time to seconds since Jan 1 2001. Correction for GMT also.
The Somnopose format should look like this:
Timestamp,Orientation,Inclination,Time_of_day
734322206,98,77,03:23:26 09/04/2024
734322207,98,77,03:23:27 09/04/2024
Open your Wellue .CSV with LibreCalc
Copy column A data to column D
Put this equation in all cells of column A starting at A2 to convert:
=((CONCATENATE(MID(D2,16,4),"-",MID(D2,13,2),"-",MID(D2,10,2)," ",MID(D2,1,8))-DATE(1,1,1))*86400)-3600
Copy this header: Timestamp Orientation Inclination Time_of_day Date
Save As .CSV
OSCAR Data - Import Somnopose Data
Scroll down to the graphs:
Orientation graph = O2
Inclination graph = Pulse rate
Enjoy
For example, I have a Wellue PO6B. With ViHealth I can get the data by BlueTooth and export the file in .CSV format.
Wellue format:
Time,Oxygen Level,Pulse Rate
03:23:26 09/04/2024,98,77
03:23:27 09/04/2024,98,77
The conversion consists in changing the timestamp format and the base time to seconds since Jan 1 2001. Correction for GMT also.
The Somnopose format should look like this:
Timestamp,Orientation,Inclination,Time_of_day
734322206,98,77,03:23:26 09/04/2024
734322207,98,77,03:23:27 09/04/2024
Open your Wellue .CSV with LibreCalc
Copy column A data to column D
Put this equation in all cells of column A starting at A2 to convert:
=((CONCATENATE(MID(D2,16,4),"-",MID(D2,13,2),"-",MID(D2,10,2)," ",MID(D2,1,8))-DATE(1,1,1))*86400)-3600
Copy this header: Timestamp Orientation Inclination Time_of_day Date
Save As .CSV
OSCAR Data - Import Somnopose Data
Scroll down to the graphs:
Orientation graph = O2
Inclination graph = Pulse rate
Enjoy