| Author |  | 
      
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          When the controller is the PLM we no longer have the SDM log screen. It would be nice if the Insteon Raw Log in the Insteon Explorer could be pulled out separately and have functions like Save Log and Clear.
           | Posted: April 28 2008 at 10:34 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          I think you could use some SQL to isolate the Insteon activity from the log and export it occasionally.
           | Posted: April 28 2008 at 13:34 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |       | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          Thks Tony that’s a good suggestion but I don’t speak SQL.
           | Posted: April 28 2008 at 15:02 | IP Logged |   |  
           | 
 |   I’m from the old Assembler days.   
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          Well, I could whip something up for ya tonight!
           | Posted: April 28 2008 at 17:23 | IP Logged |   |  
           | 
 |  
 | 
       
        | Back to Top |       | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          Hey, I'm also an old assembler guy!
           | Posted: April 28 2008 at 19:53 | IP Logged |   |  
           | 
 |    
 This should pull what you need...
 
 select * from eventlog where type=30 or type=31
 | 
       
        | Back to Top |       | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          Thanks Tony but where do I stick it since it doesn’t appear to be PH code? Multi-Editor in SQL ?
           | Posted: April 28 2008 at 20:37 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          Ah, yes. Sorry. Then click on the running man button.
           | Posted: April 28 2008 at 21:18 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |       | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          Thanks again, I’ll work on it in the morning. On another note old Assembler like 360 days… And Fortran, Cobol and PL/1. Ancient history… Lee remembers.
           | Posted: April 28 2008 at 21:27 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          That’s cool…
           | Posted: April 29 2008 at 08:24 | IP Logged |   |  
           | 
 |   I might get dangerous now.   BUT what I was really talking about is the Raw data like you see in the Insteon Explorer window. 
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          Ah. Maybe Dave knows of a back door to that, as it's just coming over the serial port.
           | Posted: April 29 2008 at 11:35 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |       | 
       
       
        |  | 
        | dhoward Admin Group
 
  
  
 Joined: June 29 2001
 Location: United States
 Online Status: Offline
 Posts: 4447
 | 
          I'll add the ability to save the PLM log (similar to the SDM lob).
           | Posted: May 06 2008 at 12:38 | IP Logged |   |  
           | 
 |  
 Currently the Insteon Explorer raw log is capped at 1000 entries.  Once it reaches 1000, when a new entry is added, the oldest 1 drops off.
 
 Just looking for some ideas on what everyone thinks is the best way to save.  A checkbox that enables writes for each entry to a file at the same time as the log or would you rather see a button that allows you to save what is currently in the log window.
 
 Let me know,
 
 Dave.
 
 | 
       
        | Back to Top |       | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          I like the file idea then I can edit it to my desire. We would only need to enable it when we are in problem determination mode.
           | Posted: May 06 2008 at 12:44 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  |