dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: February 26 2006 at 10:17 | IP Logged
|
|
|
Mike,
Depending upon the information you want and presentation, there are several different ways.
The PowerHome Explorer doesnt have print capability, but you could print off the report "Device Link Records". This is probably not quite what you're looking for since it will have link information as well.
Since PowerHome uses a SQL database backend, you could use Microsoft Access or Excel to connect to the database and query the data and create nicely laid out reports.
You can also query the data directly within PowerHome. Open the Multi-Editor and press "Shift-F5". This will place you in SQL mode. To get a list of devices, type the following SQL:
Code:
| select id,key_desc,description,location,address,x10address from insteondevices,insteontypes where insteondevices.typeid = insteontypes.typeid order by location,id |
|
|
Select Edit->Execute Script from the menu and you'll get a new window with a report of your devices. You can rearrange the columms and resize them. From this window, you can print your data. You can also "Export" this data from the menu File->Export. You can export in a variety of formats including HTML, Excel, CSV, etc. and then bring the data into non-ODBC applications for further formatting.
If you'd like, I can start working on some basic reports that are structured and laid out to deliver this kind of information.
Dave.
|
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Best Way To Print Full Insteon List?
