ioBroker.sbfspot

This adapter uses Sentry libraries to automatically report exceptions and code errors to the developers. For more details and for information how to disable the error reporting see Sentry-Plugin Documentation! Sentry reporting is used starting with js-controller 3.0.

If you like it, please consider a donation:

This adapter reads data from SMA power inverters using sbfspot. Now both database types (mySQL and sqlite) are supported. Since version 0.2.3 there is a own vis widget based on flot available to show historical data.

Installation

please follow installation instructions for sbfspot under https://github.com/SBFspot/SBFspot/wiki

detailed installation on arm based systems

Hints

• use latest version from sbfspot from https://github.com/SBFspot/SBFspot
• adapter, sbfspot and databases (mySQL or sqlite) must run on the same system e.g. Raspberry PI
• installation manual for sbfspot on Raspberry Pi (or similar) can be found under https://github.com/SBFspot/SBFspot/wiki/Installation-Linux-SQLite or https://www.rg-engineering.eu/index.php/produkte/software/plugin-fuer-iobroker-sbfspot
• for Raspberry Pi there is a semi-automated configuration tool available under https://github.com/SBFspot/sbfspot-config

known issues

• sometimes installation of npm package sqlite3 fails. in that case reinstall all npm packages

cd /opt/iobroker/node_modules/iobroker.sbfspot sudo npm install

sometimes npm intall must be called more then one time to successfully install all necessray packages

• please create issues at github if you find bugs or whish new features

Changelog

WORK IN PROGRESS

• (René) see issue #417: test with nodejs@22

4.3.4 (2024-08-24)

• (René) update dependencies
• (René) bug fixes based on adapter checker recommendation

4.3.3 (2024-05-28)

• (René) change of dependencies
• (René) mySql dependency update

4.3.1 (2024-05-23)

• (René) bug fix for data history in VIS-2

4.3.0 (2024-05-22)

• (René) data history prepared for VIS-2: just a option here in the adapter and new widget (at this moment GeneralChart widget in vis-2-widgets-weather can be used)

4.2.4 (2024-01-13)

• (René) upgrade better-sqlite

4.2.3 (2024-01-12)

• (René) downgrade better-sqlite

4.2.2 (2024-01-12)

• (René) dependencies updated

4.2.1 (2023-12-11)

• (René) dependencies updated

4.2.0 (2023-12-11)

• (René) dependencies updated

4.1.6 (2023-07-30)

• (René) dependencies updated

4.1.4 (2023-04-07)

• (René) dependencies updated

4.1.3 (2023-01-31)

• (René) dependencies updated

4.1.2 (2022-08-20)

• (René) bug fix in AddObject

4.1.1 (2022-08-18)

• (René) tooltip in wizard added
• (René) flot and dependencies updated

4.0.8 (2021-07-11)

• (René) bug fix color of labels in widget

4.0.7 (2021-10-30)

• (René) see issue #62: avoid endless loop
• (René) update flot to 4.2.2

4.0.6 (2021-07-09)

• (René) bug fix data types

4.0.5 (2021-03-21)

• (René) dependencies updated

2.3.3 (2019-02-03)

• (René) due to install problems downgrade of sqlite3 package

2.3.1 (2019-02-02)

• (René) bug fix: with sqlite "today" data were not shown

2.3.0 (2019-01-20)

• (René) support of compact mode
• (René) add additional error information in log

2.2.5 (2018-11-26)

• (René) upgrade packages

2.2.5 (2018-11-04)

• (René) reset yield if no new value from today

2.2.4 (2018-08-19)

• (René) bugfix for ticks on X

2.2.3

• (René) the same as 2.2.2

2.2.2

• (René) add timestamp of last update

2.2.1

• (René) close of database connection after last query result is available (e.g. to support more than one inverter)

2.2.0

• (Nis) background color and border
• (René) bug fixes in admin3

2.1.0

• (René) Support MariaDB

2.0.1

• (René) Support of admin3

2.0.0

• (René) since we always use one graph per widget, only one is supported now Attention: widget is not compatible with version 1.x.x; just check settings in widget after installation!

1.1.0

• (René) autoscale of y axis
• (René) color for y axis
• (René) adjustable date format

1.0.1

• (René) bug fix for sqlite

1.0.0

• (René) first stable release

0.2.6

• (René) bug fix for android app > 1.0.6

0.2.5

• (René) use install date to calculate historical values

0.2.4

• (René) logo changed

0.2.3

• (René) adding historical data as datapoint (JSON)
• (René) new vis widget to show historical data

0.2.2

• (René) renamed to sbfspot

0.2.1

• (René) index.html updated

0.2.0

• (René) support of sqlite and license changed to MIT

0.1.1

• (René) UTF8 coding

0.1.0

• (René) first release

0.0.1

• (René) initial release

License

MIT License

Copyright (c) 2017-2024 René G. [email protected]

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.