v4.1.0

What's Changed

• Multi Importer for Sunny Explorer
• DB Performances improvement
• Trigger imports manually

Multi Importer for Sunny Explorer

Implementation of a multi inverter importer for sunny explorer
if the import file contains values from multiple inverters they will be imported at once

You can import data from multiple inverters as single inverters or cumulated as one
Single Inverter

Cumulative

example with 3 inverter data

sep=;
Version CSV1|Tool SE|Linebreaks CR/LF|Delimiter semicolon|Decimalpoint comma|Precision 3

;SN: 222;SN: 333;SN: 444;SN: 5555;SN: 666;SN: 777
;SB 2500HF-30;SB 2500HF-30;SB 2500HF-30;SB 2500HF-30;SB 2500HF-30;SB 2500HF-30
;222;222;333;333;444;444
;Gesamtertrag;Leistung;Gesamtertrag;Leistung;Gesamtertrag;Leistung
;Counter;Analog;Counter;Analog;Counter;Analog
dd.MM.yyyy HH:mm;kWh;kW;kWh;kW;kWh;kW
25.04.2012 08:05;631,414;0,060;676,160;0,060;660,898;0,048
25.04.2012 08:10;631,420;0,072;676,166;0,072;660,904;0,072
25.04.2012 08:15;631,430;0,120;676,175;0,108;660,913;0,108
25.04.2012 08:20;631,440;0,120;676,185;0,120;660,922;0,108
25.04.2012 08:25;631,456;0,192;676,201;0,192;660,938;0,192
25.04.2012 08:30;631,472;0,192;676,217;0,192;660,954;0,192
...

Configuration
select right importer
importer = sunny_explorer_multi
or
importer = sunny_explorer_multi_cumulative

single inverters

name = "ZonPHP Solar local (DEV)"
plantNames = WR1, WR2, WR3
importer = sunny_explorer_multi

[WR1]
capacity = 2500
expectedYield = 28, 47, 104, 139, 149, 152, 158, 141, 110, 73, 32, 24
importPrefix = MeinePV-Anlage1
importDateFormat = "d-m-Y H:i:s"
importDateFormat_fallback = "d/m/Y H:i"
description = "WR1<br>"

[WR2]
capacity = 2500
expectedYield = 28, 47, 104, 139, 149, 152, 158, 141, 110, 73, 32, 24
importPrefix = MeinePV-Anlage1
description = "WR2<br>"

[WR3]
capacity = 2500
expectedYield = 28, 47, 104, 139, 149, 152, 158, 141, 110, 73, 32, 24
importPrefix = MeinePV-Anlage1
description = "WR3<br>"

Cumulative variant

name = "ZonPHP Solar local (DEV)"
plantNames = WR1
importer = sunny_explorer_multi_cumulative

[WR1]
capacity = 7500
expectedYield = 28, 47, 104, 139, 149, 152, 158, 141, 110, 73, 32, 24
importPrefix = MeinePV-Anlage1
importDateFormat = "d-m-Y H:i:s"
importDateFormat_fallback = "d/m/Y H:i"
description = "WR1<br>"

DB Performances improvement

• Add DB index while creating tables
• check if index exists, if not create them
• enhanced DB Check

Trigger imports manually

new data is imported everytime a page loaded if a user visits the site
you can now trigger import in background e.g. with a cronjob

just add a cronjob to execute
<your site>/importer/trigger_import.php
and data will be imported

• Feature/sunny multi importer by @seehausen in #113

Full Changelog: v4.0.18...v4.1.0