alexstocker / sensorlogger Goto Github PK

Hey

Nice project/plugin! Have you checked out volkszaehler.org before? Seems to me the two projects have similar goals. I wonder if the two projects could merge maybe?

https://github.com/alexstocker/SensorLogger/blob/devel/controller/sensorloggercontroller.php#L158

https://github.com/alexstocker/SensorLogger/blob/devel/lib/SensorGroups.php#L32

Rewrite JS and split it into smaler files

https://github.com/alexstocker/SensorLogger/blob/devel/templates/main.php#L17-18

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L417

The registration of devices via "register devices" works fine for me and the devices are shown in the device list.
Nevertheless I can see no data when I perform the extended API call.
Even when I try to perfom a simple API call I can see no data.

How can I unregister the devices shown in the list?

Expected Behavior

after excecuting the example script from https://github.com/alexstocker/sensorlogger/blob/master/tests/curl/post.php a new device should appear on the UI.

Actual Behavior

Nothin happens.
Script returns false
No log entry.
(Got sensorloger running with registering a device and generating the nesessary datatypes with the other example scripts)

Steps to Reproduce the Problem

1. Fresh installation of sensorlogger on nextcloud 12 (empty databaseentries for sensorlogger)
2. Generate app password and fill data to example script
3. Excecute https://github.com/alexstocker/sensorlogger/blob/master/tests/curl/post.php

Specifications

• Version: Nextcloud 12.04
• Platform: Ubunutu 16.04 LTS
• Subsystem: php 7

Hi all,

without provided data array value, the chart data remain empty.
In the Table oc_sensorlogger_logs, columns temperature and humidity are filled.
In column data there is a JSON array with "_route:" value starting.
for example: {"_route":"sensorlogger.apisensorlogger.createLog","deviceId":"28-000006a2e6ae","temperature":21.81,"humidity":0,"date":"2017-11-20 20:03:40"}

With multivalue posts, there are no issues.

Did i something wrong?

NC 12.0.3
Apache 2.4.27, PHP 7.0.21, MariaDB 10.0.31 on Synology DSM 6

https://github.com/alexstocker/SensorLogger/blob/devel/controller/sensorloggercontroller.php#L267

https://github.com/alexstocker/SensorLogger/blob/devel/lib/Widgets.php#L96

Hi Alex,
does sensorlogger works on webspace also?
I uploaded the file sensorlogger-0.0.5-nc.13 in the apps directory.
it is not possible for me to execute php post.php on command line.
Is there another way?

Expected Behavior

I do not manage to get a sensor running that does not meassure the standard values tempereature and humidity according to the documentation as it is now

Actual Behavior

have a documentation in a way where it is easy to see how to setup AND send data to sensorlogger that is non-standard. In my case I would like to have a 3rd value voltage to control the battery. I would like to have that in the data list but don't see how to do that.

From the docu I can learn how to register a device with whatever value but I do not see how to send data afterwards.

Hello Alex,

let me begin with a thank you for writing this app. It looks promising to me. What I would like to suggest as features are:

• Display accumulated data
  • E. g. in a widget were one can edit the title and the formular
  • This would be especially useful for measuring the rain amount were commonly 24h/12h/6h values are more interesting.
• Data downsampling
  • As the data is obviously stored in a RDBMS and not a TSDB I think it could be useful to have rules like in RRDtool to downsample data older than time x to prevent the DB from getting too heavy.

Greetings
Eike

Expected Behavior

I setup widgets on the dashboard - 2 sensors - charts on top, list on the bottom - looks nice, after reloading the page the view is cluttered

Actual Behavior

widgets are cluttered and do not stay in the same order after reload
first row shows: data list of second sensor - chart second sensor - data list first sensor
second row shows: chart of second sensor

Steps to Reproduce the Problem

1. setup 2 charts for 2 sensors, arrange them in the top row the charts, below a row with the data lists
2. reload page

Specifications

• Version: 0.0.6
• Browser: Firefox 52.5.0

https://github.com/alexstocker/SensorLogger/blob/master/lib/Widgets.php#L95

https://github.com/alexstocker/SensorLogger/blob/devel/controller/sensorloggercontroller.php#L116

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L355

Hello,

I created two devices which have the name "Default device". Is it possible to rename them into something more descriptive? If not from the UI, is it possible to change the name in the database?

I upgraded to nextcloud 12 and sensorlogger is just showing a white page now. I am on the latest release of sensorlogger.

heres a error messages found in error log:

Error	PHP	Argument 6 passed to OC\NavigationManager::__construct() must implement interface OCP\IConfig, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#67	2017-05-23T13:14:59+0200
Error	PHP	Argument 5 passed to OC\NavigationManager::__construct() must implement interface OCP\IGroupManager, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#66	2017-05-23T13:14:59+0200
Error	PHP	Argument 4 passed to OC\NavigationManager::__construct() must implement interface OCP\IUserSession, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#65	2017-05-23T13:14:59+0200
Error	PHP	Argument 3 passed to OC\NavigationManager::__construct() must implement interface OCP\L10N\IFactory, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#64	2017-05-23T13:14:59+0200
Error	PHP	Argument 2 passed to OC\NavigationManager::__construct() must implement interface OCP\IURLGenerator, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#63	2017-05-23T13:14:59+0200
Error	PHP	Argument 1 passed to OC\NavigationManager::__construct() must implement interface OCP\App\IAppManager, none given, called in /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined at /var/www/nextcloud/lib/private/NavigationManager.php#62	2017-05-23T13:14:59+0200

E.g. the weahter app also had an error. see how they fixed it: nextcloud/weather@8f41dd3

Error Log

Error | PHP | Undefined variable: config at /var/www/nextcloud/lib/private/NavigationManager.php#73 | 2017-11-14T02:22:01+0100
-- | -- | -- | --
Error | PHP | Undefined variable: groupManager at /var/www/nextcloud/lib/private/NavigationManager.php#72 | 2017-11-14T02:22:01+0100
Error | PHP | Undefined variable: userSession at /var/www/nextcloud/lib/private/NavigationManager.php#71 | 2017-11-14T02:22:01+0100
Error | PHP | Undefined variable: l10nFac at /var/www/nextcloud/lib/private/NavigationManager.php#70 | 2017-11-14T02:22:01+0100
Error | PHP | Undefined variable: urlGenerator at /var/www/nextcloud/lib/private/NavigationManager.php#69 | 2017-11-14T02:22:01+0100
Error | PHP | Undefined variable: appManager at /var/www/nextcloud/lib/private/NavigationManager.php#68 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  6 passed to OC\NavigationManager::__construct() must implement  interface OCP\IConfig, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#67 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  5 passed to OC\NavigationManager::__construct() must implement  interface OCP\IGroupManager, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#66 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  4 passed to OC\NavigationManager::__construct() must implement  interface OCP\IUserSession, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#65 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  3 passed to OC\NavigationManager::__construct() must implement  interface OCP\L10N\IFactory, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#64 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  2 passed to OC\NavigationManager::__construct() must implement  interface OCP\IURLGenerator, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#63 | 2017-11-14T02:22:01+0100
Error | PHP | Argument  1 passed to OC\NavigationManager::__construct() must implement  interface OCP\App\IAppManager, none given, called in  /var/www/nextcloud/apps/sensorlogger/lib/App.php on line 19 and defined  at /var/www/nextcloud/lib/private/NavigationManager.php#62 | 2017-11-14T02:22:01+0100

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L348

My Nextcloud (12 stable, Ubuntu 16.04) instance is set to UTC+2.

Expected behavior: sensorloger displays times in UTC+2.

Actual behavior: sensorloger displays times in UTC only.

I'm using v0.0.4 from the nextcloud appstore and current NC12 stable.

Is it possible to adjust the widget size to something like here?
And is it possible to adjust the scale of the x-axis somehow?

Currently it looks like this:

Hi, thanks for your effort to create such a nice app.

I'm currently writing an esp8266 library for interfacing with sensorlogger (I plan to opensource once it's ready, part of my frankenstein firmware for esp8266), and have run in a quite an issue. I'm able to register the device and post the data, and can even see all the data appearing in sensorlogger_logs database. But the UI is somehow messed up, as if the deviceDataTypes portion of 'register device' api request was not handled properly: e.g. in the chart for the device it shows humidity and temperature, although no such data types exist for this device. Same goes for the list of data values.

(The current device is right now just a dumb mockup, posting random numbers).

Expected Behavior

GUI should not show data registered for the device, same goes for data view.

Actual Behavior

GUI shows only temperature and humidity for every device.

Steps to Reproduce the Problem

Can be done by posting the following JSON to the server :

frankenstein > svclog register                                                                                                                                            
Registering device at https://cloud.ncrmnt.org/index.php/apps/sensorlogger/api/v1/registerdevice/                                                                         
{                                                                                                                                                                         
        "deviceId":     "dev-arven-001",                                                                                                                                  
        "deviceName":   "arven-green",                                                                                                                                    
        "deviceType":   "dummy",                                                                                                                                          
        "deviceGroup":  "development",                                                                                                                                    
        "deviceParentGroup":    "",                                                                                                                                       
        "deviceDataTypes":      {                                                                                                                                         
                "type": "mana",                                                                                                                                           
                "description":  "Mana regen rate",                                                                                                                        
                "unit": "pts/sec"                                                                                                                                         
        }                                                                                                                                                                 
}

frankenstein > svclog post                                                                                                                                                
Posting data to https://cloud.ncrmnt.org/index.php/apps/sensorlogger/api/v1/createlog/                                                                                    
{                                                                                                                                                                         
        "deviceId":     "dev-arven-001",                                                                                                                                  
        "mana": "39.52"                                                                                                                                                   
}

Specifications

• Version: 0.0.5 (from nextcloud appstore)
• Platform: nextcloud 12.0.4
• PHP 7.0.19-1 (debian stretch)

P.S. I've also noticed that if I omit deviceParentGroup from json query I'll get an exception with data partially(?) added to the db.

It would be great if there was a way to delete measurements from the list. Sometimes I do some test measurements to see if things are working and I have no way to remove them. They affect the graphs and other listings.

I am not sure if this is easy to implement, but I believe it will improve the testing of different sensors greatly.

Thanks!

Hello,

Nextcloud 13 will be released soon. Can you provide a new version to the app store that supports the new release as well?

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L364

Add an wipeout action on a device, deleting entire device depending data

Hello,

sorry for a newbie question - but I don't find how sensorlogger works with nextcloud. I'm running nextcloud 12 and don't find any menu item which would allow me to configure devices.

Any help would be appreciated. Maybe it would be good to describe this also in the README.

Thanks and cheers,
Georg

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L423

Hello,

Before I setup my sensor, I run couple post.php to see if it shows on the nextcloud as per the instructions. I setup the sensor and it is working fine.

I go to the Devices page, and try to remove the device that was posted with post.php tests. However it keeps telling me Device NOT deleted (as you can see from the image below as device #1). What is preventing me to delete this Device? Is there a reason for this, or this is a bug?

Thank you

TODO makeover Widgets::build

https://github.com/alexstocker/SensorLogger/blob/master/lib/Widgets.php#L63-64

Is Arduino (or NodeMCU) supported?

https://github.com/alexstocker/SensorLogger/blob/devel/lib/Widgets.php#L46

Hello,

is sensorlogger only available when manually installed?
it is not listed in the nextcloud app store in my cloud. (newest version)

https://github.com/alexstocker/SensorLogger/blob/devel/lib/Widgets.php#L94

On some systems, it may be cumbersome to create the correct timestamp for the json that is sent to the server.

For example under esp2866 with the arduino ide. There I have to fetch the time from an NTP server. Then, convert the time to the correct time zone and paying attention to daylight saving time. And then the time stamp has to be formatted. To do this I need several librarys and lines of code.

It would be easier if the server time is stored automatically if the json does not contain the date field. Or in the json it can be specified explicitly that the server time should be used (ex.: ["date"] = "server-time").

By the way: I like this application very much, even if it is not finished yet.

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L410

https://github.com/alexstocker/SensorLogger/blob/master/lib/Widgets.php#L64

I really would like to try the sensorlogger but my NC is running on postgres. Is support for postgres planned for the future?

I can't create my own dataTypes like fan speed.

My API call for 'registerdevice':

"_route":"sensorlogger.apisensorlogger.registerDevice",
"deviceId":"231d2508-786d-400d",
"deviceName":"PC Sensoren",
"deviceType": "CPU Temp u. Fan speed",
"deviceGroup": "Wohnzimmer",
"deviceParentGroup": "Server",
"deviceDataTypes": 
[
    {
	"type": "temp",
	"description": "Temperature",
	"unit": "°C"
    }
    ,
    {
	"type": "fan1",
	"description": "Fan1",
	"unit": "U/min"
    }
]

My API call for 'createlog':

$fan = 100;
$cpu = 1000;
$array = array("deviceId" => "231d2508-786d-400d",
	"temp" => $cpu,
	"fan1" => $fan,
	"date" => date('Y-m-d H:i:s'));
$data_json = json_encode($array);

But in NextCloud I only see at 'List':

#  UUID               °C     % r.F. Created
1  231d2508-786d-400d  0.00  0.00   2017-05-12 08:22:23

https://github.com/alexstocker/SensorLogger/blob/master/lib/SensorGroups.php#L32

https://github.com/alexstocker/SensorLogger/blob/devel/lib/Widgets.php#L65

Hello,
i got two enhancement ideas:

1. Add a option to enable automatic deletetion of values and a dropdown to select the timespan.
   example: you only want to store two years of data. Activate this option and chose 2 years. Data older than the selection will be deleted.

2. Add an option to select different displayed date formats. Sending the date in the date('Y-m-d H:i:s') format is ok. But showing other formats in the visualisation and log lists would be great.

https://github.com/alexstocker/SensorLogger/blob/master/lib/Widgets.php#L97

https://github.com/alexstocker/SensorLogger/blob/devel/controller/sensorloggercontroller.php#L137

I tried SensorLogger in combination with OwnTracks and constantly receiving timeouts.

With curl on the command line it needs 70secs to respond to the request:

$ time curl -H 'Content-Type: application/json' -d '{"deviceId":"test"}' --user USER:PASSWD https://example.com/index.php/apps/sensorlogger/api/v1/createlog/
{"message":"CORS requires basic auth"}
real	1m10,438s
user	0m0,032s
sys	0m0,012s

This is not happening on normal http requests.

We use an avtech temp monitor in our office. I can retrieve through the website to our temp monitor a Json file: https://avtech.com/articles/4639/find-room-alert-monitor-json-data/

To display the data from our avtech temp monitor.

Can sensor logger read this json file as an input?

Thank you in advance for any assistance you can provide.

https://github.com/alexstocker/SensorLogger/blob/devel/controller/apisensorloggercontroller.php#L390

Hi,

I really like this app and would highly appreciate further development.
Actually I use it with Nextcloud 13 which is unfortunately officially not supported but seems to work as good as Nextcloud 12. I think it just needs to be changed ...