Piko stats Files

Piko_xxx.pdf contain some documentation on how to use it
Piko.py is the communication module (mandatory)
Piko_db.py is the database management, stat and reporting tool (optional)

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!   Version up to 1.5.1 are designed for Python 2.7                                                 !!!
!!!   Version starting from 1.6.0 are designed for Python 3.4 and above (mostly tested on 3.6)        !!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


# File     : Piko_db.py
# Name     : Piko Inverter communication software
# Rel      : 1.6.0
# Author   : Romuald Dufour
# Contrib. : emoncms export code by Peter Hasse (peter.hasse@fokus.fraunhofer.de) - Not tested on Python3
# Licence  : GPL v3
# History  : 1.6.0 - 20200607 - Migrate to Python 3 and bug fixes
#          : 1.5.1 - 20160225 - Add MQTT support
#                               More robust parsing code
#                               Display running in days as well
#          : 1.4.1 - 20160218 - Add MySQL support
#          : 1.3.3 - 20140117 - Exception handling on emoncms
#                    20140110 - Added support for emoncms export (http://emoncms.org)
#                               json and requests modules depencies added
#                               ('easy_install requests' maybe needed)
#          : 1.3.2 - 20131115 - Bug fixes for some inverter software
#                               (old release not responding to some request)
#          : 1.3.1 - 20130731 - Bug fixes, temp by model, get FW version
#          : 1.3.0 - 20130730 - Csv export (WebSolarLog, ...), -a option
#                               Get additional data (timers, model, strings, phases, ...)
#          : 1.2.6 - 201303xx - Bug fix in comm error handling
#          : 1.2.5 - 20130227 - Add RS485 bus address parameter (--id=xxx)
#          : 1.2.4 - 20121026 - No change (keep rel nb in sync w. Pyko_db)
#          : 1.2.3 - 20110907 - Correct small bug in history import (F=-.-)
#          : 1.2.1 - 20110825 - Temp Decoding beter accuracy
#          : 1.2.0 - 20110824 - Realtime DB save + Status/Temp Decoding
#          : 1.1.0 - 20110817 - History DB save
#          : 1.0.0 - 20110816 - History data
#          : 0.5.0 - 20110812 - Realtime data
#          : 0.1.0 - 20110810 - Online protocol


# File     : Piko_db.py
# Name     : Piko Inverter communication software - DB manager
# Rel      : 1.6.0
# Author   : Romuald Dufour
# Licence  : GPL v3
# History  : 1.6.0 - 20200607 - Migrate to Python 3
#          : 1.5.1 - 20160223 - JSON export added
#          : 1.4.1 - 20160218 - MySQL support added
#          : 1.3.0            - 1.3.x skipped
#          : 1.2.5 - 20130227 - DC1/DC2 balancing added in realtime & Stat display
#          : 1.2.4 - 20121026 - Short term stats Efficiency added
#                               Correct small bug in DC_E calculation
#          : 1.2.3 - 20110908 - Short term stats update
#          : 1.2.2 - 20110906 - Short term stats (by 10m/15m/hour/day)
#          : 1.2.1 - 20110825 - Temp decoding better accuracy
#          : 1.2.0 - 20110824 - XML/CSV/TXT dump + Status/Temp decoding
#          : 1.1.0 - 20110818 - Realtime DB (create/TBL dump)
#          : 1.0.0 - 20110817 - History DB (create/TBL dump)
#          : 0.1.0 - 20110817 - DB Tests



# Modules  : pip3 install pymysql

# Optional module - If not installed, option will be disabled
#            pip3 install paho-mqtt (Only needed for mqtt export. If not option will not shown)
#            pip3 install simplejson (Only needed for emoncms export. If not, option will not shown)


# TODO     : graph export
#            more error handling
#            long term stats (month, year, ...)
#            archiving and cleaning