Wattson Energy Monitor

 Hi Folks,

This is pretty much targeted at UK people or anyone who has bought a
Wattson Energy monitor. (http://www.diykyoto.com/ )

While the kit is a lovely thing, the software that came with it is
rubbish. I've taken it upon myself to write my own software. So far, I
have a pretty good version working. It totally replaces the Holmes
software.

I am kind of stuck though on getting at the data in the Holmes
database. Has anyone done anything with it? Anyone else written their
own software?

This might not be the best group but.....

Cheers,
Crispin
p.s.
If anyone wants the software, feel free to give me a shout.

  e5122ad62a48@b31g2000prb.googlegroups.com:


have you contacted them?  If yours is that much better maybe you can get
a little help developing and maybe sell it back to them?

I do some coding .. is this database part of their existing package?  
Maybe you could upload it somewhere and let us have a look at it.. might
known format you just have to figure out.

best

-zachary

 Zachary,

I have but they are rather unhelpful. Someone hinted at it being
sqlite. I have not yet tried.
I would appreciate it if you could have a look. See if you can
download the file from:
http://www.send-large-file.com/access.php?d=1&fV84dd3c7db91171a40bb466580cabce


As for selling it - I doubt it. It's a "I needed better software so I
will write it" thing. :)


Cheers,
Crispin

 

It won't load in sqlite v3

sqlite> .databases
Error: file is encrypted or is not a database

The first 48 bytes should contain the sqlite version and info, and your
file doesn't show that looking with a hex editor.  Or much else:

data.db                                                                        
                                                                      
shed 1.13
offset    asc hex dec oct bin
00000000:     CA  202 312 11001010
00000001:  i  69  105 151 01101001
00000002:     BE  190 276 10111110
00000003:     DD  221 335 11011101
00000004:     A9  169 251 10101001
00000005:     A9  169 251 10101001
00000006:     B2  178 262 10110010
00000007:  K  4B  075 113 01001011
00000008:     D5  213 325 11010101
00000009:     B0  176 260 10110000
00000010:  `  60  096 140 01100000
00000011:  [  5B  091 133 01011011
00000012:     17  023 027 00010111
00000013:     06  006 006 00000110
00000014:  /  2F  047 057 00101111
00000015:     B6  182 266 10110110
00000016:     04  004 004 00000100
00000017:     00  000 000 00000000
00000018:     01  001 001 00000001
00000019:     01  001 001 00000001
00000020:     04  004 004 00000100
00000021:  @  40  064 100 01000000
00000022:     20  032 040 00100000
00000023:     20  032 040 00100000
00000024:  a  61  097 141 01100001
00000025:  m  6D  109 155 01101101
00000026:  .  2E  046 056 00101110
00000027:     A8  168 250 10101000
00000028:  U  55  085 125 01010101
00000029:     00  000 000 00000000
00000030:     E5  229 345 11100101



I thought it might be v2 but sadly:

[root@server1 data_test]# ./sqlite-2.8.17.bin data.db
Unable to open database "data.db": file is encrypted or is not a database

so it looks like if it is an sqlite database its probably encrypted --
probably decrypts within their application.  Have to dig into their
program maybe :)

I'll keep playing around some, but doesn't look good :(

-zachary

 
                                     =
                                     

Thanks for the attempts. Really appreciate it...
The app is free to download and install should you wish to try. I
believe it is adobe director. but may be very wrong...

Cheers,
Crispin