Reason for MyEncore Missing Charts with M Series Determined

jskinner · Post by **jskinner** » Mon Oct 30, 2006 9:31 am

I just thought that I would let everyone know that I have determined the exact cause of the missing charts in MyEncore when used with a M Series.

MyEncore looks for certain data to be found in a database table called SleepTrendEventLog. However with the M Series this data is found in a similar table called SleepTrendEventLog2.

I have been able to hack my SQL server tables to make MyEncore work and pull the M Series data. However its not usable solution since it requires one to reverse the hack before downloading new data.

I'm currently thinking about possible solutions for this problem. Some possible ideas are:

1. A small program that one has two run before running MyEncore that copies the data from one table to the other. (Not particularly elegant)

2. Find out if there is a way to virtually link the two table names so that they both actually point to the same table.

3. Rewriting MyEncore from scratch. (A lot of work but I' considering it)

If there are any SQL experts out there in the group I would like to chat with them.

Anyway I just thought I would update everyone on my progress on trying to come up with a solution for this issue.

Cheers, -James

SelfSeeker · Post by **SelfSeeker** » Mon Oct 30, 2006 9:51 am

James,

If you can figure out how to solve the problem with EncorePro 1.6i and the M series, I think you should contact Respironics, maybe they can hire you as a contract for this problem.

greyhound · Post by **greyhound** » Mon Oct 30, 2006 9:52 am

That's great news, Jim! Please keep us informed on your progress with possible solutions.

Goofproof · Post by **Goofproof** » Mon Oct 30, 2006 10:16 am

[quote="SelfSeeker"]James,

If you can figure out how to solve the problem with EncorePro 1.6i and the M series, I think you should contact Respironics, maybe they can hire you as a contract for this problem.

SelfSeeker · Post by **SelfSeeker** » Mon Oct 30, 2006 10:34 am

Jim,

The problem with missing Saturday data that I have encountered with the M Series, is also an issue with EncorePro 1.6i.

I do not know if the data is recorded and not shown in EncorePro, or not recorded at all.

[quote="Goofproof"][quote="SelfSeeker"]James,

If you can figure out how to solve the problem with EncorePro 1.6i and the M series, I think you should contact Respironics, maybe they can hire you as a contract for this problem.

Goofproof · Post by **Goofproof** » Mon Oct 30, 2006 10:42 am

If the data isn't in EncorePro 1.6i and it's server, it can never be in MyEncore. As MyEncore, gets it's data from EncorePro 1.6i's server.

It would be like getting the egg out of a chicken's nest before she laid it. Jim The Rooster's out of luck, so's Breakfast.

ozij · Post by **ozij** » Mon Oct 30, 2006 11:03 am

James, (Jskinner)
Check your PMs.
O.

jskinner · Post by **jskinner** » Mon Oct 30, 2006 11:06 am

Goofproof wrote:Respironics, does not have anything to do about "MyEncore". what the post is about.

Agreed. (Although I am a bit puzzled why Respironics have chosen duplicate so many tables in the new version. It appears to be a naming convention cleanup but if that is the case I don't know why they chose to keep the old tables around too. (other than lazyiness, cost, or some unknown factor to us)

Goofproof wrote: I know nothing about modern programing, but it looks like if you could decompile MyEncore

Not technically possible, we would need the original source code to fix the problem. Compiling code is a one way street. You can go from source to executable but not the other way. Java and C# are a bit better in that respect but you still really need the source.

Goofproof wrote: rename what's it's looking for in the Server, the problem would be solved and we'd have another version to use with the "M". Jim

Its a bit more complicated than that. Since EncorePro uses one table for older machines and a different (but identical) table for newer machines logic would have to be added to select the right take based on machine used. Just switching the table name would fix things for M Series users but break MyEncore for everyone else.

Bottom line to really fix MyEncore we need the source code, which we don't have.

jskinner · Post by **jskinner** » Mon Oct 30, 2006 11:23 am

SelfSeeker wrote:The problem with missing Saturday data that I have encountered with the M Series, is also an issue with EncorePro 1.6i.

Opps I think you posted in the wrong thread? I think you ment to post this over here viewtopic/t14729/More-Missing-data-from-SmartCard.html

SelfSeeker wrote:I do not know if the data is recorded and not shown in EncorePro, or not recorded at all.

From what I can tell its not record at all, a look in the underlying SQL database showed it missing as well.

adam5532 · Post by **adam5532** » Thu Nov 02, 2006 1:19 am

jskinner wrote: Bottom line to really fix MyEncore we need the source code, which we don't have.

Could you please fill me in? Is Derek unreachable? Is he no longer developing the software? If he isn't, would he not be willing to turn over the source code to someone else?

Thanks,
Adam

jskinner · Post by **jskinner** » Thu Nov 02, 2006 10:04 pm

adam5532 wrote:Could you please fill me in? Is Derek unreachable?

Yes he hasn't posted to the group in a while and is not responding to PMs. Last word was that he was having a bad health crisis... a bit worrying.

adam5532 wrote:Is he no longer developing the software?

He does not appear to be. Since no one can reach him we don't know.

adam5532 wrote:If he isn't, would he not be willing to turn over the source code to someone else?

No one has been able to contact him to find out ...