| Author |
|
ginigma
Senior Member
Joined: June 18 2006
Location: United States
Online Status: Offline
Posts: 127
|
| Posted: October 10 2006 at 23:26 | IP Logged
|
|
|
Dave,
Is there a way to export a lot of the data (without writing the SQL statements) such as all the raw data behind the Insteon reports/charts? And the devices table?
On second thought, it's probably just as easy for me to do this by writing the sql commands if I hunt for the table info.
BTW, great job with the Insteon Explorer. It is so much better. I still don't understand everything, but I'm learning.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 12 2006 at 12:53 | IP Logged
|
|
|
Ginigma,
Nothing is built in. You could do the SQL like you say or you could connect to the PowerHome database using ODBC and Access or Excel (or other ODBC client) and get to the data that way.
The SQL isnt really that hard. For the tables that you're interested in, just type
select * from table_name
and you'll get the entire data from the table. You can then export the report as SQL, CSV, text, etc.
All of the data behind the Insteon communication reports is coming from the insteondevices table and the following four columns: ackcnt,nakcnt,event03cnt, and commcnt.
Glad to hear you like the new Explorer. I was really hoping it would be well received.
Let me know if you have any questions on the IE or other and I'll get them answered for you.
Dave.
|
| Back to Top |
|
| |
|
|
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Feature Requests
Topic: Export Data
