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

CVS Export anomaly (OSCAR 1.1.0)
#1
CVS Export anomaly (OSCAR 1.1.0)
Hi team

I have some strange lines in the CSV output.


The summary line is shown as a separate session
   
   

I have this anomaly several times in my data.
It started happening right after i upgraded to OSCAR 1.1.0 (on April 20th)
and it seemed to happen for every session on my ResMed, unfortunately I don't have the SD card for that one anymore

I've dropped off my DreamStation GO SD card at the drop box a while back

I'll share the excel with the outputs of the CVS on the drop box as well
(can share "all OSCAR data" if needed)

Richard
Post Reply Post Reply






Donate to Apnea Board  
#2
RE: CVS Export anomaly (OSCAR 1.1.0)
Can you show a screenshot of the daily view for May 16 with the Details panel scrolled to the bottom? I'd like to see what sessions are getting reported there.
Post Reply Post Reply
#3
RE: CVS Export anomaly (OSCAR 1.1.0)
Note that the first line is the sum of the following two lines, and the two lower-numbered sessions are less than 5 minutes between ending of one and beginning of the next. And only the first line has a true session id (which is the start of the session in Unix epoch time).
Useful links
Download OSCAR
Best way to organize charts
How to attach charts to your post

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
#4
RE: CVS Export anomaly (OSCAR 1.1.0)
No, for PRS1 that's not a "true" session ID. But I want to see what's creating it given the two valid PRS1 session IDs that are getting exported.
Post Reply Post Reply






Donate to Apnea Board  
#5
RE: CVS Export anomaly (OSCAR 1.1.0)
attached the screenshot fro May 16

The summary line i fine and reported properly in OSCAR; I shared the whole download with Bonjour; file  RPDM_Sessions_export.xlsx
BTW the time between sessions in a b-break;
I realize i'm missing the (legacy) setting to combine settings close together and ignore short sessions.
I'm sure y'all ripped that out since it was hard to manage. I did like the feature though to ignore sessions shorter than x minutes; i now need to deselect them from the day to eliminate them from views

Happy hunting :-)
I am thinking though it has to do with the conversion of the OSCAR DB with V1.1.0; since that is first occurrence (I upgraded April 20th)

Richard

   
Post Reply Post Reply
#6
RE: CVS Export anomaly (OSCAR 1.1.0)
Very peculiar, I'm still not able to reproduce this behavior. Could you zip and upload your whole data folder? Help > Troubleshooting > Create zip of all OSCAR data.
Post Reply Post Reply
#7
RE: CVS Export anomaly (OSCAR 1.1.0)
Dropped it off at Fred's: OSCAR_Data.zip; sorry forgot to rename to more specific name

You'll likely have a tough time to reproduce it.
I created a new profile and loaded my full SD card, and no issue there; so i'm going back to my hypothesis that the upgrade did something to provoke this behavior. 

Does this qualify me for tester in the OSCAR program :-)

Richard
Post Reply Post Reply






Donate to Apnea Board  
#8
RE: CVS Export anomaly (OSCAR 1.1.0)
Thank you, I can now reproduce the issue! Tomorrow I'll see if I can figure out what's going on...
Post Reply Post Reply
#9
RE: CVS Export anomaly (OSCAR 1.1.0)
Aha! The CSV export is adding a row for every kind of session on that day. You have a journal entry for the day, so it's showing up on your CSV export, but it doesn't show up in the list of sessions at the bottom of the UI.

Will be fixed in 1.1.1.
Post Reply Post Reply
#10
RE: CVS Export anomaly (OSCAR 1.1.0)
Nice; thanks

On the topic of journal...
I'm trying to open the Journal XML in either a browser or Excel;
Browser IE gives a blank page; Excel only writes the data of the first comment  (don't have my xmlSpy anymore)

I've checked in notepad and all data is there; seems like the XML structure is incomplete.
- Is this a known issue
- Am I the only one hung up on exporting data

Is it worthwhile for y'all if i analyze the Journal backup output and see what it would take to make it "excel importab;e"

Richard
Post Reply Post Reply






Donate to Apnea Board  


Possibly Related Threads...
Thread Author Replies Views Last Post
  Customize Export Data from Oscar? SevereApnea 7 168 05-12-2020, 04:05 AM
Last Post: SevereApnea
  OSCAR Data Anomaly? Missing 1 day out of 30. St3veB 2 114 03-21-2020, 12:51 PM
Last Post: pholynyk
  OSCAR: Export leak rate in CSV multicast 1 119 02-20-2020, 10:30 AM
Last Post: pholynyk
Sad Oscar kills the Ubuntu VM it is running in [solved: bug in VirtualBox, not OSCAR] fredex 1 247 12-16-2019, 08:47 PM
Last Post: fredex
  OSCAR Export of Raw Per-Graph Data Nonsanity 4 273 11-25-2019, 07:49 PM
Last Post: Nonsanity
  Feedback on import anomaly encourage 1 191 10-02-2019, 01:29 PM
Last Post: sheepless
  OSCAR CSV Export Wizard RWS0022 4 641 06-05-2019, 05:26 PM
Last Post: RWS0022


New Posts   Today's Posts






About Apnea Board

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