Author Topic: ELVira: Excel Log Viewer for Vera  (Read 5904 times)

Offline Brientim

  • Beta Testers
  • Sr. Hero Member
  • *****
  • Posts: 2491
  • Karma: +77/-7
Re: ELVira: Excel Log Viewer for Vera
« Reply #30 on: May 28, 2015, 06:30:16 pm »
Did not even notice the port error. I never said I would not call you that - lol.... Easy mistakes.

Offline tomtcom

  • Hero Member
  • *****
  • Posts: 822
  • Karma: +18/-30
Re: ELVira: Excel Log Viewer for Vera
« Reply #31 on: May 28, 2015, 06:42:03 pm »
Did not even notice the port error. I never said I would not call you that - lol.... Easy mistakes.
Lol, thanks. Sometimes I have limited tech play time so I was rushing too. Thanks again!

Offline Brientim

  • Beta Testers
  • Sr. Hero Member
  • *****
  • Posts: 2491
  • Karma: +77/-7
Re: ELVira: Excel Log Viewer for Vera
« Reply #32 on: May 28, 2015, 07:13:24 pm »
I must be dense.  I still don't see what you are trying to refer to.

If you can do the same as tomtcom when time permits and put screen grab of configuration and errors, we could hopefully work through your issues as well... Now that tomtcom has had his tech time and full bottle for the setup, no doubt he could assist you too...


Offline tomtcom

  • Hero Member
  • *****
  • Posts: 822
  • Karma: +18/-30
Re: ELVira: Excel Log Viewer for Vera
« Reply #33 on: May 28, 2015, 08:20:30 pm »
@JoeyD - A lot of times we forget our device id's and I know the excel can filter on those id's but what I pasted below is from a post on this forum that would convert the friendly name of the devices. Any way to insert/convert the device id using the information below into the excel or pre-populate the filter to pick devices rather than device ID's?

Full Device ID List
In the VERA UI go to the APPS tab
Click the Develop Apps tab
Then click 'Test LUUP code (LUA)' in the left-hand menu
Copy the LUA code (below) and paste it into the Code window
Click the blue 'GO' button to make the code run
View your device list at - http://"your Vera IP address"/devlist.txt

local file = io.open("/www/devlist.txt", "w")

file:write("[DeviceNo / id] device names on " .. os.date() .. "\n")

for deviceNo,d in pairs(luup.devices) do

if d.id ~= "" then

file:write(string.format('[%03d / %s] %s \n', deviceNo, d.id, d.description))

end

end

file:close()
« Last Edit: May 28, 2015, 08:25:18 pm by tomtcom »

Offline Brientim

  • Beta Testers
  • Sr. Hero Member
  • *****
  • Posts: 2491
  • Karma: +77/-7
Re: ELVira: Excel Log Viewer for Vera
« Reply #34 on: May 29, 2015, 02:05:36 am »
@JoeyD - A lot of times we forget our device id's and I know the excel can filter on those id's but what I pasted below is from a post on this forum that would convert the friendly name of the devices. Any way to insert/convert the device id using the information below into the excel or pre-populate the filter to pick devices rather than device ID's?


@JoeyD has not been on the forum for around 2 months now.
Create a scene and run a cyclic schedule or that will always be available or place it is start up lua.




Offline clippermiami

  • Hero Member
  • *****
  • Posts: 1381
  • Karma: +27/-5
Re: ELVira: Excel Log Viewer for Vera
« Reply #35 on: May 29, 2015, 07:55:54 am »
I finally got around to trying ELVira. Once I got the kinks out and the correct configuration it works just fine. Thanks for a useful log tool.
Two Vera Plus UI7 Linked via HTTP, 90+ Devices. PlugIns: PLEG, DSC, Blue Iris, MySensors,  AutoVera, ImperiHome, VeraAlerts, EventWatcher

Offline tomtcom

  • Hero Member
  • *****
  • Posts: 822
  • Karma: +18/-30
Re: ELVira: Excel Log Viewer for Vera
« Reply #36 on: May 29, 2015, 08:36:29 am »
@JoeyD - A lot of times we forget our device id's and I know the excel can filter on those id's but what I pasted below is from a post on this forum that would convert the friendly name of the devices. Any way to insert/convert the device id using the information below into the excel or pre-populate the filter to pick devices rather than device ID's?


@JoeyD has not been on the forum for around 2 months now.
Create a scene and run a cyclic schedule or that will always be available or place it is start up lua.
Yeah I noticed, we were last working on the MyQ project.

Ok, was just throwing out enhancement ideas, he was always game for that.

Offline fhreid

  • Sr. Newbie
  • *
  • Posts: 21
  • Karma: +0/-0
Re: ELVira: Excel Log Viewer for Vera
« Reply #37 on: August 01, 2015, 06:12:33 am »
JoeyD.  This is an awesome Tool.  So simple but a big time saver.

Props!

Offline rmroth

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: ELVira: Excel Log Viewer for Vera
« Reply #38 on: February 03, 2016, 06:50:11 pm »
Hello,
Is your UI still available. I can't seem to find and/or download the attachment, every time I click on it it just takes me back to original of your post..

Offline mrwildbob

  • Sr. Newbie
  • *
  • Posts: 43
  • Karma: +0/-1
Re: ELVira: Excel Log Viewer for Vera
« Reply #39 on: June 27, 2016, 11:31:19 pm »
Where can I download ELVira?  Can't seem to find it.

Offline korttoma

  • Hero Member
  • *****
  • Posts: 654
  • Karma: +21/-5
  • Keep it simple, stupid
Re: ELVira: Excel Log Viewer for Vera
« Reply #40 on: June 27, 2016, 11:54:48 pm »
The ELVira.zip is downloadable from the first post -> http://forum.micasaverde.com/index.php/topic,30265.0.html
- Tomas

Offline mrwildbob

  • Sr. Newbie
  • *
  • Posts: 43
  • Karma: +0/-1
Re: ELVira: Excel Log Viewer for Vera
« Reply #41 on: June 28, 2016, 12:47:41 am »
oops...I didn't see the file hiding there.  thanks

Offline pit

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
Re: ELVira: Excel Log Viewer for Vera
« Reply #42 on: February 23, 2017, 12:46:38 pm »
this tool is easy to install and super helpful !!!!
thank you!

Offline tomtcom

  • Hero Member
  • *****
  • Posts: 822
  • Karma: +18/-30
Re: ELVira: Excel Log Viewer for Vera
« Reply #43 on: February 23, 2017, 08:19:14 pm »
this tool is easy to install and super helpful !!!!
thank you!

LOL, I literally have it opened right now. :) Although JoeyD has left this forum, I try to steer others to this log viewer. It's definitely used a lot.