Export Channel Config to Excel

[chartrand]

Is there a way to export the channel config so i can open it in Excel. i wan to print the config, but i wan to do a custom print, one from roof, one for other areas, etc.

-Pat

[jerryb721]

http://www.t2lights.com/christmas/lorutility.html

This will build a spreadsheet off your configuration

[iresq]

Just navigate your excel to the config file (.LCC). You will need to change file type to all.

[ItsMeBobO]

chartrand wrote:

Is there a way to export the channel config so i can open it in Excel.  i wan to print the config, but i wan to do a custom print, one from roof, one for other areas, etc.

-Pat

There are several steps but I can get you there. You will have to edit the file a little.

Export your config file.
Open in notepad and remove all the tracks and animation leaving only the channels

The resulting file should look like this.



.... All the rest of your channels.



Save AS yourconfig.XML (Note the XML extension)
Now you can either open the file from Excel or right click and use OpenWith and select Excel

Excel doesn't know what to do unless you select "Open as a read only workbook" when the question pops up.

You will want to remove some columns and rearrange and sort them. Unfortunately the Color is not in a usable form. After formatting you must save AS again with a new name.

[ItsMeBobO]

I guess I was doing it the hard way!

[chartrand]

Thanks guys, I'm in and printed.

[PaulXmas]

I did it the long way....
retyped everything
Then printed each controller's list and taped it inside so I know what goes to what.

Taken a week just to run 32 extension cords.