Jump to content

Download ISY data into a spreadsheet?


Recommended Posts

Posted (edited)
3 hours ago, wordragon said:

I can see the list of devices when I click ISY - is there any way to easily download this information into a spreadsheet? (using 4.6.2 currently)

Depends what information you need.   in the admin console, Tools -> Generate Topology will generate an HTML file.  Depending on the number of nodes in your ISY it may take several minutes to complete, when it's finished it will open the HTML file in a browser, just close that.  Open Excel and navigate to the folder that you directed Generate Topology to place the file in.  Depending on how some excel options are set you may see the .html file listed or you may have to change a dropdown to "all files".  Once you find it, open it in excel and excel should import the file correctly then you can save it as Excel.   Depends on what you're looking for tho as to whether it will be included.  I used this method to generate a list of Insteon addresses for "Just in case" or "disaster recovery" so that I'd never have to remove wallplates or sort thru a folder of pictures I took looking for the correct location (I snap a pic after the device is installed so i can find the address and Ver info later without removing the wallplate.)

Edited by MrBill
  • Like 1
Posted
Quote

in the admin console, Tools -> Generate Topology will generate an HTML file.

 

Thanks MrBill - that was good enough - editing the HTML down to a CSV with what I wanted (name, network address, device type) took about 5 minutes.  Had over 100 devices and it would have been awfully tiring to type all that in!

Guest
This topic is now closed to further replies.

×
×
  • Create New...