Posted December 23, 200717 yr I don't have Excel and can't view the log. Lotus 123 (yes, there are some people that use this) chokes on the ISY XLS output. Wordpad sees the XLS code and shows nothing intelligible. Not having seen what the Excel presentation actually looks like, I'm at a loss as to why you would need to use a spreadsheet to list a log file. Is this to format the output in columns and rows or to produce a three-dimensional layered organization?
December 23, 200717 yr The xml file shows nicely in Word. There is also the "Getting a Network Typology Table" you can use to get a html table version of your network.
December 23, 200717 yr I can't view it in Excel either because the version on my home machine is too old (2000). There are macros in there to be able to sort the entries via drop-down, but my version chokes on them. My work laptop has 2003, works fine. It does show up also, when you generate the log, as an .rtf Word file. In my case, it is at the following path: C:\Documents and Settings\Owner\Local Settings\Temp\UDReport.rtf Not much on formatting, but the information is there.
December 23, 200717 yr Author So if I understand this correctly, the XML entries of the log are sent to Excel in a recent Excel format by having an XLS extension on the output. This all came up because I suddenly wondered if I had any errors in the log file and that I may have been flying blind with respect to that possibility. Mark, thanks for the Word suggestion, but how would someone get the XLS output to Word. By changing the program associated with the XLS extension? I don't have Word either (I have WordPerfect because I'm really old school) so it doesn't help me, but might help someone else. Jim, thanks for the location of that rtf file. At least, I found it and could read it with WordPad. I see the log file only logs Insteon activity. I've over a month of activity to review and check the error codes. Dave
December 23, 200717 yr d_l, I am so very sorry for the problems and issues. If you do not have Excel (and are running Windows), currently the only way to get to your logs is as jgraziano suggested. On MAC/Linux, you are given the log file as is. We do have a requirement to provide this function without Excel on Windows so, please do be kind enough to use jgraziano's suggestion as a workaround. With kind regards, So if I understand this correctly, the XML entries of the log are sent to Excel in a recent Excel format by having an XLS extension on the output. This all came up because I suddenly wondered if I had any errors in the log file and that I may have been flying blind with respect to that possibility. Mark, thanks for the Word suggestion, but how would someone get the XLS output to Word. By changing the program associated with the XLS extension? I don't have Word either (I have WordPerfect because I'm really old school) so it doesn't help me, but might help someone else. Jim, thanks for the location of that rtf file. At least, I found it and could read it with WordPad. I see the log file only logs Insteon activity. I've over a month of activity to review and check the error codes. Dave
December 23, 200717 yr How about the free Excel viewer: http://www.microsoft.com/downloads/deta ... laylang=EN
December 23, 200717 yr The trick here is Excel has to have the XLM filter to bring XML into Excel. Excel by its self would not view it without the built in filter which I think is "being" installed with the default install of the Office disk. So if the free viewer has the built in filter with it will work.
December 23, 200717 yr Mark, We do not use XML in the logs. With kind regards, The trick here is Excel has to have the XLM filter to bring XML into Excel. Excel by its self would not view it without the built in filter which I think is "being" installed with the default install of the Office disk. So if the free viewer has the built in filter with it will work.
December 23, 200717 yr Michel, Could you make the logs CSV (comma separated values)? Then any spreadsheet program could open it.
December 23, 200717 yr Mark, They are already Tab Delimited. With kind regards, Michel Michel, Could you make the logs CSV? Then any spreadsheet program could open it.
December 23, 200717 yr Author We do have a requirement to provide this function without Excel on Windows so, please do be kind enough to use jgraziano's suggestion as a workaround. Michel, thanks. It hasn't been that much of a problem. I'm all set now with a WordPad shortcut to UDReport.rtf as per jgraziano so all is golden.
December 23, 200717 yr They are already Tab Delimited. If you open it with Excel as a tab-delimited file, it displays very nicely.
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.