DeviceLogger Continuous for HomeSeer [NEW]

[Pete]

Hello Joost,

Thank you. Yup already playing with that mostly to see the difference in speeds reading multiple DB's on one box rather than multiple boxes.

[webrod]

Hi,

I used the HS updater feature to install the plugin from HS.
The installation happened, this was visible from HS UI (and log).

However, the plug in is not visible in HS.
When I start HS I don't see what is shown here:
http://www.devicelogger.com/product-...ggercontinuous
There is nothing about the plugin

When I access setup->interface, I don't see the plugin.
When I go this time to the updater screen, showing all plugins available for download from HS server, it shows your plugin as already installed.
But that's the only place showing it is installed.

Note that I tried first to configure the plugin with MySQL, but it didn't work.
When I launched your admin tool, i got an error saying it was not able to check the version of the datasource (or something like that).
I had to change to MSACCESS.
I got an error with this file:
C:\Program Files\HomeSeer HSPRO\data\DL-Continuous-V1\DL-Continuous-V1.mdb
It says it can't find the table.
So the process is not creating the table....

I was able to run the admin with the SAMPLE one
C:\Program Files\HomeSeer HSPRO\data\DL-Continuous-V1\DL-Continuous-V1-Sample.mdb

This one is OK from the admin tool
But still nothing available in HS.

i think the first time your script is run, it is supposed to create the table, but the first time it was using MySQL and it failed.
The next time I used msacess, but I think your script is trying to configure the table only the first time, so nothing happened since it's not the first time anymore.

Do you have any idea how to fix this?
Why is your plugin not shown in the "setup->interface" and not launch when HS startup?

thanks
Rod

[webrod]

BTW I have uninstalled the plugin, but the updater keeps saying it is installed!
I did a manual removal of all folder or file from data, config, etc
It still says it is install, and a reinstall does not fix the issue.

thanks,
Rod
PS: I use HS2.5.0.80 PRO
Win 7

[drlove]

I'm using this plugin and now I have allot off data in my MySQL db I want to display on a website. Using Google charts and Drupal I have managed to set up a site w/ some nice charts. Next step would be to combine data from different devices in the same chart.

Does anyone know how to make requests to the db for multiple devicecodes w/ logdate as common field? For a single devices I use something like this:

SELECT logdate as 'Time', devicevalue as 'Data'
FROM deviceslog
WHERE devicecode = 'S30' AND logdate >= DATE_SUB(NOW(), INTERVAL 1 DAY)
ORDER BY logdate

This gives me something like this:

Time_______________Data
2013-12-16 14:35____123
2013-12-16 14:36____124
2013-12-16 14:37____145
2013-12-16 14:38____154
.....


Byt I don't know how to get multiple devices in an array like this

logdate_____________device1_______device2
2013-12-16 14:35____123__________456
2013-12-16 14:36____124__________454
2013-12-16 14:37____145__________477
2013-12-16 14:38____154__________456

Anyone have an idea?

Best regards, L

[joaster]

Dear Rod,

Did you follow the instructions from the flow chart?
http://www.devicelogger.com/dlc-inst...n-instructions
DeviceLogger Continuous is called by a HomeSeer Event (step 7), then you will see the screens you reference.

The file "C:\Program Files\HomeSeer HSPRO\data\DL-Continuous-V1\DL-Continuous-V1-Sample.mdb" is an empty database file. You can copy it to create a new database file to write to (e.g. c:\new.mdb). Then from the config file in "C:\Program Files\HomeSeer HSPRO\Config\" you reference this new database (Database=c:\new.mdb) and run the event.

I am running HS PRO version 2.5.079 and it thould be showing under "setup-interface".

Kind regards,
Joost.