This project has moved and is read-only. For the latest updates, please go here.

Redirect inverter temperature logging

Topics: 3. Feature Requests
Jan 6, 2015 at 10:49 AM
First of all, I've been using SBFSpot for 3 months now, and I am very satisfied.
Lately, I've started logging weather info (wunderground.com) and I see that both wundergroud and SBFspot are logging to the same field on PVoutput.org.
in the old code for SMAspot there was an option to redirect the Inverter temperature to the extended data (V7... V12), but that option is disabled in the source code now.
Is there a way for me to redirect this value?
I would like to log the inverter temperature to V10 extended data...

Thanks in advance!
Jan 6, 2015 at 12:14 PM
This option is described in the documentation (See "downloads" section)
By default, Inverter Temperature (V5) and Uac1 (V6) are uploaded to PVoutput. This can be relatively easy changed by modifying the view used for PVoutput data upload.
Jan 6, 2015 at 1:51 PM
Edited Jan 6, 2015 at 1:51 PM
Clear, thanks!

It turns out to be a case of "RTFM".... Do'nt trust Google ;)
For reference, I fixed it with:

sqlite3 SBFspot.db

DROP VIEW IF EXISTS vwPvoData;

CREATE VIEW vwPvoData AS
SELECT dd.Timestamp,
dd.Name,
dd.Type,
dd.Serial,
dd.TotalYield AS V1,
dd.Power AS V2,
cons.EnergyUsed AS V3,
cons.PowerUsed AS V4,
NULL AS V5,
spot.Uac1 AS V6,
NULL AS V7,
NULL AS V8,
NULL AS V9,
spot.Temperature AS V10,
spot.Pdc1 AS V11,
spot.Pdc2 AS V12,
dd.PVoutput
FROM vwDayData AS dd
LEFT JOIN vwAvgSpotData AS spot
ON dd.Serial = spot.Serial AND dd.Timestamp = spot.Nearest5min
LEFT JOIN vwAvgConsumption AS cons
ON dd.Timestamp = cons.Nearest5min
ORDER BY dd.Timestamp DESC;
Mar 15, 2015 at 12:55 AM
Maybe a completely obvious statement, but I tried typing this in manually (direct screen and keyboard so no other easy way) and was not successful. Remote terminal session and copy and paste was the only way to do this.

May I suggest in the manual, it has one or two more commands - how to check this table once it is input....
Mar 16, 2015 at 5:46 PM
Edited Mar 16, 2015 at 6:07 PM
I tried the above but now the temp data is blank.

UPDATE takes a while but eventually updates from wunderground.