DataYours - store data on Windows server

Plugins & Plugin Development Unmaintained
1

I need to log some data from Vera (5-7 devices) Over time it will become a large amount of data. I also want to be able to analyse my data with MS Excel and Minitab.

[ol][li]Is it possible to configure/setup DataYours to store the database (log to) on a windows server share?[/li]
[li]Can the data from the database be read by MS Excel?[/li]
[li]Is it a better approach to write some luup code for logging data and ftp it to my sever?[/li][/ol]

2

I’m not familiar with windows servers, but I assume it runs a flavour of Windows and you can run other code on it?

Can the data from the database be read by MS Excel?
The files actually have a CSV format so should be relatively easy to import.
Is it a better approach to write some luup code for logging data and ftp it to my sever?
That, I couldn't say... but what I do know is that if you can run Lua on your server (Lua runs on almost every machine under the sun) then you can actually run most of the [tt]DataYours[/tt] daemons there and just capture the data on Vera with [tt]DataWatcher[/tt]. There are already other people doing this on Raspberry Pi, etc.

So a whole range of options really. I’d need to know a little more about your setup to suggest further.

3

Is it correct that the DataWatcher sends captured data in syslog format?
If so I will go for a solution with DataWatcher on Vera and a syslog server on my Windows Server. Preferably I want the the data to be stored on a MS SQL database.

Anyone know about any open source syslog server for windows or, even better, a syslog server storing data in MS SQL database?

4

It can do that, optionally, but it’s a mistake to think of a ‘syslog format’, since whilst certain fields of a syslog message are tightly defined, the actual message content is free-form.

If so I will go for a solution with DataWatcher on Vera and a syslog server on my Windows Server. Preferably I want the the data to be stored on a MS SQL database.
I don't do SQL, so someone else will have to help you there. I believe there are folk who have done something similar.