Hi
Is there any easy way to receive statistical data from Vera Plus to my PC. I have seen there are a few plugins, but I can’t see how I can export this data from my Vera Plus to tools like Excel, or Access or other tools to create useful statistics.
Is there anyone that has good experience with how to export data from Vera Plus? Does it exist any good step by step documentation for how to do this?
Mainly I’m interested in power, temperature and humidity data from sensors and thermostats. I suppose they ought to be available for me.
Thank You. Sounds very interesting. I’m very familiar with such files. I just must learn how to read them and export them to my PC. DataYours and EventWatcher are both plugins, but I did not find out how to configure DataYours. Have you tried it? Where do I find the documentation for how to use them? I’m not familiar with Plugins so far.
I have now started and was ready to investigating menu buttons on the dashboard page.
I entered http://10.0.0.101:3480/data_request?id=lr_dashboard and got
No Handler. Probably something I have missed?
I need to check that I have done everything right!
Some more change in Vera Plus?
Trouble creating file:
Error creating: Vera-50108820.007.urn:upnp-org:serviceId:SwitchPower1.Status
Status messsage = [string “module (“L_DataWhisper”, package.seeall)…”]:658: Cannot create file ‘%s’
Vera - Apps - Install Apps and then select DataYours. Installation of the DataYTours plugin run OK.
Since then I followed the documentation. However, it said nothing about install the directory. I thought the app did so. I don’t know how to create a directory in Vera Plus. I suppose it is running LINUX, but I don’t know how to access and create the directory. Do I need to do that?
Also watch DisplayLine2: It looks like it is missing a file?
Yes, @Catman is correct. This value of LOCAL_DATA_DIR is an example from the documentation (again, probably my fault.)
Where do you want to store your data? Do you have a USB or NAS mounted with space for it? You can use local storage on Vera, but that is rather limited. One of the advantages of the Whisper database structure is that it is fixed size, and doesn’t grow as time goes by, so it is possible to have some variables stored locally.
You need to have created the physical directory, and then you need to be sure that the DataYours variable actually points to that directory.
No @Catman and @akbooer , I have not created any directories on Vera plus, USB or NAS. In fact, I’m not quite sure how to access the Vera to create a directory.
Yes, it sounds smart to use a USB or NAS. USB is easy, but I have a 1TB NAS device that I normally use on my PC. Is it possible to connect this both to a PC and to Vera. I have not thought about that. Since it probably is a Linux system on the Vera, I probably must mount it as a directory to the root or a directory. I do not work with Linux/Unix so I’m not sure how I practical do that on Vera. I must admit I have to learn a little more here on how to mount and to create the directory on USB or NAS. But the concept sounds very good for me.
If it was me, and assuming it’s possible on your NAS
Create another share on the NAS called data_your or similar
Set whatever access settings are your desire
SSH into the Vera
cd /
mkdir data_yours
then something like:
mount -t smbfs -o -d=777 //user:password@NASIPADDRESS/$sharename /data_yours
The syntax / options will probably be a bit different as it’s the Vera OS but I expect someone with more experience will be able to help define it better
Thank you @Catman. I will try to do that. I think it is smart to use the NAS drive if possible. Yes, why not. You gave me a challenge there, learning how to do that.
This it is a part of a new world for me.
A