Explore Encore Pro database

General Discussion on any topic relating to CPAP and/or Sleep Apnea.
raymart43
Posts: 13
Joined: Thu May 01, 2008 2:29 pm

Explore Encore Pro database

Post by raymart43 » Tue Feb 03, 2009 12:31 pm

Would anyone be willing to describe a method for accessing the Encore Pro database via Access or something similar? I know it's probably kind of messy and all, but I'd like to poke around. Mainly for curiosity's sake. I'm pretty decent with computers, but not a pro. I can't seem to figure it out.

Thanks in advance for any help.

User avatar
OldLincoln
Posts: 779
Joined: Wed Mar 26, 2008 7:01 pm
Location: West Coast

Re: Explore Encore Pro database

Post by OldLincoln » Tue Feb 03, 2009 2:40 pm

It is quite involved for a first timer at these things. If you have manually installed SQL, set up ODBC connections and are a serious user of Access, PM me and I'll try to give you some steps to try and get you connected.

For folks new to all that, please understand you can easily screw stuff up and wish you hadn't tried it. I'm not open posting it because I don't want to start something and be defending myself all day.

So you know, once you have all the links set up and access the data, you still have a lot of work to do before making sense of it. I started and "paused" about half way through asking myself why am I doing this? My treatment is working so why should I care about how many seconds this happened or the correlation between things. It's one of those things where you have to ask yourself what are you going to do differently once you get the information.
ResMed AirSense 10 AutoSet / F&P Simplex / DME: VA
It's going to be okay in the end; if it's not okay, it's not the end.

morezees
Posts: 9
Joined: Thu Jan 08, 2009 9:49 pm
Location: NE Pa

Re: Explore Encore Pro database

Post by morezees » Tue Feb 03, 2009 6:00 pm

Happened to have been tinkering in the db in the last few days to get encore pro working. Be aware--there are about 120 tables. Many look obviously irrelevant, but there isn't one called "PatientDataInHere" either. Enjoy

User avatar
Mikosiko
Posts: 112
Joined: Tue Sep 09, 2008 1:19 pm

Re: Explore Encore Pro database

Post by Mikosiko » Tue Feb 03, 2009 6:32 pm

raymart43 wrote:Would anyone be willing to describe a method for accessing the Encore Pro database via Access or something similar? I know it's probably kind of messy and all, but I'd like to poke around. Mainly for curiosity's sake. I'm pretty decent with computers, but not a pro. I can't seem to figure it out.

Thanks in advance for any help.
As someone said before... Using access could be dangerous if people doesn't know well what they are doing (probably not your case)... it is more safe to use Excel ... just must create the right connector (ODBC) and you can query any table.

Miko

User avatar
Mikosiko
Posts: 112
Joined: Tue Sep 09, 2008 1:19 pm

Re: Explore Encore Pro database

Post by Mikosiko » Tue Feb 03, 2009 6:36 pm

OldLincoln wrote:........ I started and "paused" about half way through asking myself why am I doing this? My treatment is working so why should I care about how many seconds this happened or the correlation between things. It's one of those things where you have to ask yourself what are you going to do differently once you get the information.
kind of deja vu.... you are talking like my own mind

Miko

User avatar
Goofproof
Posts: 16087
Joined: Mon Dec 05, 2005 3:16 pm
Location: Central Indiana, USA

Re: Explore Encore Pro database

Post by Goofproof » Tue Feb 03, 2009 9:17 pm

I get all my treatment from the Encore Pro program, I don't need a dartboard and a dark room. Jim
Use data to optimize your xPAP treatment!

"The art of medicine consists in amusing the patient while nature cures the disease." Voltaire

User avatar
Wulfman
Posts: 12317
Joined: Thu Jul 07, 2005 3:43 pm
Location: Nearest fishing spot

Re: Explore Encore Pro database

Post by Wulfman » Tue Feb 03, 2009 10:22 pm

Mikosiko wrote:
OldLincoln wrote:........ I started and "paused" about half way through asking myself why am I doing this? My treatment is working so why should I care about how many seconds this happened or the correlation between things. It's one of those things where you have to ask yourself what are you going to do differently once you get the information.
kind of deja vu.... you are talking like my own mind

Miko
Same here. I looked in there and went EeeeeWWW.....no thanks......I'm good with what I'm seeing in my reports. At some point, the data becomes Ho-Hum.


Den
(5) REMstar Autos w/C-Flex & (6) REMstar Pro 2 CPAPs w/C-Flex - Pressure Setting = 14 cm.
"Passover" Humidification - ResMed Ultra Mirage FF - Encore Pro w/Card Reader & MyEncore software - Chiroflow pillow
User since 05/14/05

raymart43
Posts: 13
Joined: Thu May 01, 2008 2:29 pm

Re: Explore Encore Pro database

Post by raymart43 » Wed Feb 04, 2009 4:18 pm

I guess I'd just like to look in there and do the same thing for myself. I don't really expect to improve my treatment by doing this, just for the fun of taking it apart.

User avatar
DreamDiver
Posts: 3082
Joined: Thu Oct 04, 2007 11:19 am

Re: Explore Encore Pro database

Post by DreamDiver » Wed Feb 04, 2009 4:50 pm

If you just want to look at data, you could install MSSQL server management express free from our friends at Microsoft. (Back up your hard drive first.) Or if you install it on a different box, you can access your Encore Pro database from another computer on your network.

I'd make a copy of the entire DB and just play with the your new 'development' copy. That way, you won't mess up your existing database.

I'd be more interested in knowing the exact steps used to transfer the data from the card to the database. If you get that figured out, let me know.

_________________
Mask: ResMed AirFit™ F20 Mask with Headgear + 2 Replacement Cushions
Additional Comments: Pressure: APAP 10.4 | 11.8 | Also Quattro FX FF, Simplus FF
Image
Most members of this forum are wonderful.
However, if you are the target of bullying on this forum, please consider these excellent alternative forums:
Apnea Board
Sleep Apnea Talk Forum
Free CPAP Advice

Be well,
Chris

User avatar
Babette
Posts: 4231
Joined: Mon Apr 30, 2007 5:25 pm

Re: Explore Encore Pro database

Post by Babette » Wed Feb 04, 2009 5:01 pm

Well, now that I have all the best computer geeks here corralled in one thread... Which one of you can rent me the knowledge I need to uninstall the stupid new version of Office that came with Vista, and re-install the version I want - 2003.

Is there a live forum where you meet regularly?

Is there a 1-800 number I can call to get the "Computer Talk Guys"?

I can read my work email. I can read my personal email. I can surf Ebay. I can't do bloody much else with my zippy new laptop, and I'm PISSED!!!

LOL,
B.

_________________
Machine: PR System One REMStar 60 Series Auto CPAP Machine
Additional Comments: Started XPAP 04/20/07. APAP currently wide open 10-20. Consistent AHI 2.1. No flex. HH 3. Deluxe Chinstrap.
I currently have a stash of Nasal Aire II cannulas in Small or Extra Small. Please PM me if you would like them. I'm interested in bartering for something strange and wonderful that I don't currently own. Or a Large size NAII cannula. :)

User avatar
Wulfman
Posts: 12317
Joined: Thu Jul 07, 2005 3:43 pm
Location: Nearest fishing spot

Re: Explore Encore Pro database

Post by Wulfman » Wed Feb 04, 2009 5:18 pm

Babette wrote:Well, now that I have all the best computer geeks here corralled in one thread... Which one of you can rent me the knowledge I need to uninstall the stupid new version of Office that came with Vista, and re-install the version I want - 2003.

Is there a live forum where you meet regularly?

Is there a 1-800 number I can call to get the "Computer Talk Guys"?

I can read my work email. I can read my personal email. I can surf Ebay. I can't do bloody much else with my zippy new laptop, and I'm PISSED!!!

LOL,
B.
Have you tried to go to the Add/Remove Programs in the Control Panel and uninstall it from there?

Den
(5) REMstar Autos w/C-Flex & (6) REMstar Pro 2 CPAPs w/C-Flex - Pressure Setting = 14 cm.
"Passover" Humidification - ResMed Ultra Mirage FF - Encore Pro w/Card Reader & MyEncore software - Chiroflow pillow
User since 05/14/05

User avatar
Babette
Posts: 4231
Joined: Mon Apr 30, 2007 5:25 pm

Re: Explore Encore Pro database

Post by Babette » Wed Feb 04, 2009 5:20 pm

Nah, I haven't done a blasted thing yet. I'm just mulling over what I'm gonna do if this doesn't work. I'm debating between sh*tting and going blind.

LOL,
B.

_________________
Machine: PR System One REMStar 60 Series Auto CPAP Machine
Additional Comments: Started XPAP 04/20/07. APAP currently wide open 10-20. Consistent AHI 2.1. No flex. HH 3. Deluxe Chinstrap.
I currently have a stash of Nasal Aire II cannulas in Small or Extra Small. Please PM me if you would like them. I'm interested in bartering for something strange and wonderful that I don't currently own. Or a Large size NAII cannula. :)

SharkBait
Posts: 593
Joined: Sun Jan 25, 2009 5:41 pm
Location: Texas -- the ugly part... El Paso? No, not quite THAT ugly...

Re: Explore Encore Pro database

Post by SharkBait » Wed Feb 04, 2009 5:53 pm

morezees wrote:Happened to have been tinkering in the db in the last few days to get encore pro working. Be aware--there are about 120 tables. Many look obviously irrelevant, but there isn't one called "PatientDataInHere" either. Enjoy
Yeah, I've got tons of "work" tables in my DB's that wouldn't make any sense at all to the end user...
Encore Pro 1.8.49; Encore Pro Analyzer 0.8.9 by James Skinner
SnuggleHose - Got the 8 foot and cut it down to 6, used the rest for mask hoses.
Memory Foam Pillow - Cut my own out of my Tempur-pedic pillow. (works great!)
Hose Mgmt - Velcro Tie Strap

User avatar
GumbyCT
Posts: 5778
Joined: Fri Sep 14, 2007 6:22 pm
Location: CT
Contact:

Re: Explore Encore Pro database

Post by GumbyCT » Wed Feb 04, 2009 6:17 pm

Wulfman wrote:Have you tried to go to the Add/Remove Programs in the Control Panel and uninstall it from there?
That too but on mine there was an uninstall right in the Office folder.

So it's Start > Programs > MS Office > Uninstall

Yea those "Trial" programs will own your PC until you pay the ransom amount requested or uninstall it.

_________________
Humidifier: HC150 Heated Humidifier With Hose, 2 Chambers and Stand
Additional Comments: New users can't remember they can't remember YET!
BeganCPAP31Jan2007;AHI<0.5
I have no doubt, how I sleep affects every waking moment.
I am making progress-NOW I remember that I can't remember
;)
If this isn’t rocket science why are there so many spaceshots?
Be your own healthcare advocate!

User avatar
jskinner
Posts: 1475
Joined: Sat Aug 26, 2006 9:21 pm
Location: Greenwich, Nova Scotia, Canada
Contact:

Re: Explore Encore Pro database

Post by jskinner » Wed Feb 04, 2009 11:46 pm

raymart43 wrote:Would anyone be willing to describe a method for accessing the Encore Pro database via Access or something similar?
The tool I use is Microsoft SQL Server Management Studio. You can get it my downloading MS SQL sever trial and only installing the tools.

If you don't like Microsoft you can probably use Toad for SQL server
Encore Pro Analyzer Author
Facebook Apnea Group