Troublemaker? Me?? Re: Encore Pro data discrepancy

[edro]

I like my Respironics BiPAP hardware but I'm having a little difficulty with their software.

First, it seems that they could have more varied reports. I mean, the data is there. I made a little spreadsheet using the exported patient XML data which told me the exact time that I have apnea events. There is some correlation that I see in just 4 days of data and it is useful to me. But getting this information in nowhere in their software application.

Now I'm having a bigger problem. Their data doesn't seem to line up. Between pages 3, 4, and 5 the same data is reported but with different values. (See image below.) What gives? I guess I'll do some research on this but I just wanted to share what I found and see what you all may already know about it.



Maybe I'm just being a troublemaker. But I used to design software and with the data that is on the smart card, I used to be able to write better software analysis than I see in the EncorePro. I can't think too clearly anymore-not enough to write software, and I am thankful for what EncorePro does report. But I think that it could do better. I'd love to talk with them and tell them (respectfully) what I think they ought to provide in their software. Maybe they read these forums.

Well, I'm still working on the MyEncore problem that I'm having. I'm beginning to think that I did install the wrong version, but neither version seems to work. Working on this is therapeutic in of itself-it keeps me from thinking about pain that won't go away. It's how I manage. Anyone up for a pity party? Let's order pizza and rent a funny movie. Laughter is good even when you hurt.

Edro

[guest motherall]

What a clever person you are. How did you manage to get that info into Excel. When I tired to export as XML I kept getting asked for file name but I had none and could not move it to Excel at that point, Would you mind at your leisure giving me point by point instructions. I would certainly appreciate it. I know you mentioned being in constant pain (I'm sorry) so if it would be a burden for you don't try.

[edro]

Sure. But I'm not clever. I’m just persistent.

Actually, I had to edit this post since re-reading your post, I see that you just wanted the basic "compliance" data. To do that, you only need to right-click on a download and select "Export to CSV file", save it somewhere, and then open it using Excel.

I still can't figure out why there are 3 different numbers for the same thing.

[brasshopper]

If you follow my instructions in the other area to get connections to the tables, you can create a query and then drag the query into the table, Maybe some queries will be helpful - if I am capable of making up some, I'll publish them.

[edro]

Wow, grasshopper! I hadn't seen your post on this site about this.

I tried getting a connection using MSAccess. OpenOffice must install the ODBC connection driver automatically, I presume. I don't think MSAccess installs the ODBC drivers unless you selected it during Office install time. You can always add them but probably need your CD to do it.

MSAccess asks for a "unique field identifier". Sometimes you can leave it blank and it doesn't complain. Othertimes leaving it blank comes up with an error. I tried to guess which tables required a unique identifier index and, if it needed one, which field(s) to select. Many cases it was obvious. DbId seems like a database ID index field for a table.

Problem is that I don't really know MSAccess and my knowledge of SQL is less than what one might read in a Dummies book. So once I had the connection and all the tables up I hardy knew what to do. I could click on some of the tables and see things that sort of made sense. But as you said in your post all the data is in one table and you have to know how to access it in order for it to be useful.

So I'd really love to see any queries that you have discovered that works.

Again, I really appreciated you post. I searched for it. As he says, it isn't for the fainthearted. You CAN mess up your database beyond repair if you are not very careful. See brasshoppers post at:
viewtopic.php?t=9591