Light-O-Rama Forums Home 

 Moderated by: LightORamaDan, bob
New Topic Reply Print
Export Channel Config to Excel - LOR S2 Software Suite - Light-O-Rama Support Desk - Light-O-Rama Forums

 Not logged in  
 Login
 Register
 Home
 Calendar
 Members
 Help

Search
Search
Search by username

Light-O-Rama Links
Online Store
Support Site
Customer Videos
Tutorials/Manuals
The LOR Wiki

PlanetChristmas Links
Home Page
Forums


AuthorPost
chartrand
Member


Joined: Tue Jul 17th, 2007
Location: Coldwater, Michigan USA
Posts: 46
Picture: 
Status:  Offline
 Posted: Sat Nov 7th, 2009 02:42 am
QuoteReply
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



____________________

http://www.coldwaterlights.com
Back To Top QuoteReply

jerryb721
Member


Joined: Mon Apr 7th, 2008
Location: Granada Hills, California USA
Posts: 49
Picture: [Download]
Status:  Offline
 Posted: Sat Nov 7th, 2009 02:51 am
QuoteReply
http://www.t2lights.com/christmas/lorutility.html

This will build a spreadsheet off your configuration

Back To Top QuoteReply

iresq
Member


Joined: Wed Dec 5th, 2007
Location: Annapolis, MD
Posts: 822
Picture: 
Status:  Offline
 Posted: Sat Nov 7th, 2009 02:54 am
QuoteReply
Just navigate your excel to the config file (.LCC).  You will need to change file type to all.



____________________
Dave N

Back To Top QuoteReply

ItsMeBobO
LOR II Beta Testers


Joined: Fri Jun 6th, 2008
Location: St Louis, Missouri USA
Posts: 149
Picture: [Download]
Status:  Offline
 Posted: Sat Nov 7th, 2009 03:30 am
QuoteReply
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.

<channels>
<channel name="CCR 0A 03-R" color="255" deviceType="LOR" unit="10" circuit="7" savedIndex="0"/>
.... All the rest of your channels.
</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.



____________________


This CCR thing is great. I want a few more!

Back To Top QuoteReply

ItsMeBobO
LOR II Beta Testers


Joined: Fri Jun 6th, 2008
Location: St Louis, Missouri USA
Posts: 149
Picture: [Download]
Status:  Offline
 Posted: Sat Nov 7th, 2009 03:43 am
QuoteReply
I guess I was doing it the hard way!



____________________


This CCR thing is great. I want a few more!

Back To Top QuoteReply

chartrand
Member


Joined: Tue Jul 17th, 2007
Location: Coldwater, Michigan USA
Posts: 46
Picture: 
Status:  Offline
 Posted: Sat Nov 7th, 2009 03:52 am
QuoteReply
Thanks guys, I'm in and printed.



____________________

http://www.coldwaterlights.com
Back To Top QuoteReply

PaulXmas
Member
 

Joined: Fri Mar 27th, 2009
Location: Edmonton, Alberta Canada
Posts: 60
Picture: [Download]
Status:  Offline
 Posted: Sat Nov 7th, 2009 07:19 am
QuoteReply
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.




____________________
2009 LOR Newbie


Back To Top QuoteReply

Current time is 07:08 am
Light-O-Rama Forums > Light-O-Rama Support Desk > LOR S2 Software Suite > Export Channel Config to Excel


Slate theme designed by: The Cat Dragged Inn
Powered by WowBB 1.7 - Copyright © 2003-2006 Aycan Gulez
Page processed in 0.1018 seconds (12% database + 88% PHP). 21 queries executed.