wordragon Posted October 18, 2020 Posted October 18, 2020 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)
MrBill Posted October 18, 2020 Posted October 18, 2020 (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 October 18, 2020 by MrBill 1
wordragon Posted October 18, 2020 Author Posted October 18, 2020 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!
Recommended Posts